XF 2.2 Forum slow and crashes

[interforo]

Note I use the default template (no customizations)
My users are reporting slowness and the forum crashes often.
I now It's quite heavy on advertising

Interfans

Entra nel forum dell'Inter per parlare con i tifosi neroazzurri

interfans.org

Speed check test: https://gtmetrix.com/reports/interfans.org/Yi4BJ1X4/

Can you help me to identify the major errors?
Thank you

 

[interforo]

Hi,

my users are complaining because the forum is slow.
I have created a txt file containing the list of slow queries

Could you please have a look at it here and comment it?

Many thanks

 

[interforo]

Also adding this

Stack trace
#0 src/XF/Db/Mysqli/Statement.php(110): SV\SlowQueryLogger\Db\Mysqli\SlowQueryLogAdapter->logQueryCompletion()
#1 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#2 src/XF/Db/AbstractAdapter.php(157): XF\Db\AbstractAdapter->query('
            SE...', Array)
#3 src/addons/AwesomeForo/TopUser/Repository/TopUser.php(708): XF\Db\AbstractAdapter->fetchAll('
            SE...')
#4 src/addons/AwesomeForo/TopUser/Widget/TopXUser.php(23): AwesomeForo\TopUser\Repository\TopUser->getYearlyTopPosters(10)
#5 internal_data/code_cache/widgets/_44_top_user_side.php(5): AwesomeForo\TopUser\Widget\TopXUser->render()
#6 src/XF/Template/Templater.php(7509): XF\SubContainer\Widget->{closure}(Object(SV\StandardLib\XF\Template\Templater), Array, Array)
#7 src/XF/SubContainer/Widget.php(168): XF\Template\Templater->renderWidgetClosure(Object(Closure), Array)
#8 src/XF/Template/Templater.php(1928): XF\SubContainer\Widget->getCompiledWidget(Array, Array)
#9 internal_data/code_cache/templates/l5/s9/public/forum_list.php(216): XF\Template\Templater->widgetPosition('forum_list_side...', Array)
#10 src/XF/Template/Templater.php(1651): XF\Template\Templater->{closure}(Object(SV\StandardLib\XF\Template\Templater), Array, NULL)
#11 src/XF/Template/Template.php(24): XF\Template\Templater->renderTemplate('forum_list', Array)
#12 src/XF/Mvc/Renderer/Html.php(50): XF\Template\Template->render()
#13 src/XF/Mvc/Dispatcher.php(460): XF\Mvc\Renderer\Html->renderView('XF:Forum\\Listin...', 'public:forum_li...', Array)
#14 src/XF/Mvc/Dispatcher.php(442): XF\Mvc\Dispatcher->renderView(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#15 src/XF/Mvc/Dispatcher.php(402): XF\Mvc\Dispatcher->renderReply(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#16 src/XF/Mvc/Dispatcher.php(60): XF\Mvc\Dispatcher->render(Object(XF\Mvc\Reply\View), 'html')
#17 src/XF/App.php(2345): XF\Mvc\Dispatcher->run()
#18 src/XF.php(512): XF\App->run()
#19 index.php(20): XF::runApp('XF\\Pub\\App')
#20 {main}
Request state
array(4) {
  ["url"] => string(7) "/forum/"
  ["referrer"] => bool(false)
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

please help debugging

 

[bzcomputers]

Disable your Awesomeforo addon(s) and I think you will see the issues go away.

 

[interforo]

Disable your Awesomeforo addon(s) and I think you will see the issues go away.

done, is it only that causing the issue?

 

[bzcomputers]

It appears likely.

The slow queries all had to do with recounting every single post of your site from between every 10 seconds to every couple minutes (likely on every page load with a Top User widget). When this query runs it requires counting 5+ million rows in the database, taking 3.5 seconds each time. This could be the result of it trying to continually recalculate your Top User widget data.

 

[interforo]

Can anyone help me with the debug?

 

[interforo]

It appears likely.

The slow queries all had to do with recounting every single post of your site from between every 10 seconds to every couple minutes (likely on every page load with a Top User widget). When this query runs it requires counting 5+ million rows in the database, taking 3.5 seconds each time. This could be the result of it trying to continually recalculate your Top User widget data.

My users still complain after I deleted the “awesome plugin”

Can you help me to debug more?

 

[bzcomputers]

Check your Google Pagespeed Insights, there is a ton of free information there.

With just a quick look on your forum page, you have a lot on unused javascript loading (appears to be from multiple ad networks that aren't currently displaying ads). You should really look at consolidating your Ad serving through a single network multiple networks means a lot of extra code and third-party render blocking scripts typically. These multiple ad networks are also loading multiple tagging scripts (Google, Quantcast Choice, and Tribomedia), this is also a lot of additional code.

You are loading two different versions of jquery (3.51 - used by XenForo, and 1.83 being loaded by something else). You should typically only need to use one version, this can cause issues.

You're caching is not efficient. Some items like javascript and css are not caching at all, others resources like images are set to 30 days which is quite short.

Fix the issues above and you'll be off to a good start.

 

[interforo]

You're caching is not efficient. Some items like javascript and css are not caching at all, others resources like images are set to 30 days which is quite short.

How can I cache better? Thank you

 

[beerForo]

Yeah your site took 10 seconds to load from the link you posted. Just posting my experience, hope you get it fixed.

 

[beerForo]

NOW it's fast did you just change something?

 

[interforo]

NOW it's fast did you just change something?

No simply no users right now as it’s night