Server issue The page is responding too slow after adding "New Threads Widget" in sidebar.

[rakeshmali]

Affected version

2.2

I have just upgraded my website from xf1 to xf2, all things are good but just noticed that as I have added the "New Threads" widget into sidebar, the page is responding bit slow. I have visited all other pages on website, even the thread where this widget is not enabled and all other pages are loading instantly.

Right now I have disabled this widget so please suggest any solution, So I can re-enable it.

 

[Chris D]

I've temporarily enabled a new threads widget here and it seems to work fine.

Are you able to re-enable it on your own site, temporarily and also enable debug mode by adding the following to src/config.php:

$config['debug'] = true;

We'll be able to use the debug output to figure out if we can optimise anything here.

 

[rakeshmali]

Are you able to re-enable it on your own site, temporarily and also enable debug mode by adding the following to src/config.php:

I have tested it again and set the debug = true as you suggested, but there is nothing showing on frontend as output of this.

 

[Chris D]

After further investigation, this appears to be related to a MySQL bug:

https://bugs.mysql.com/bug.php?id=69721

The recommendation is to disable the mentioned optimizer switch until such a time that MySQL resolves the outstanding bug.

 

[rakeshmali]

@Chris D Disabled the optimizer and it seems, it is working fine now. Thanks

SET GLOBAL optimizer_switch='block_nested_loop=off'

Note: The above solution is only work if mysql server is minimum to v 5.7