Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Extremely slow forum loads
Fastkarate
New
I'm having an issue with my site (http://www.daveandjoel.com/forum). The forum's loading extremely slow, often taken five or six seconds for every page. I've been talking to my webhost and they're convinced it's nothing on their end. I haven't changed any plug-ins (I barely use any anyway). Is there some hidden update or problem I'm somehow missing?
Thanks!
Thanks!
0
Best Answer
-
Enable mysql slow query logs, vanillas activity table is really slow due to a lot of queries lacking indexes. See the bug report.0
Answers
I'm not seeing this as an option in the settings. Is it in there, or is it something I have to edit a config to apply?
Here's a google search result for "enable slow query log"
http://www.google.com/search?q=enable+slow+query+log&hl=en&newwindow=1&num=100&lr=&ft=i&cr=&safe=images&tbs=
and here are some urls to read:
http://dev.mysql.com/doc/refman/5.6/en/slow-query-log.html (watch your mysql 5 version)
http://forums.hostsearch.com/showthread.php?3048-To-enable-slow-query-logging-of-mysql
http://forums.cpanel.net/f189/enable-slow-query-log-193111.html
http://stackoverflow.com/questions/3135017/slow-query-log-in-mysql
There was an error rendering this rich post.
There are many things that can slow down the site once it starts getting a reasonable amount of traffic which is why we've put a lot of work into optimizing things on our hosted service. This includes caching, multiple webheads, the cdns and other tweaks.
One of the bottlenecks that we've seen is the use of myisam as a table storage engine. What happens is the entire table is locked whenever anyone is trying to update it. When you have several users trying to access your site at once this can cause waiting.
We put this the comments and discussion tables to support full text searching. We have an option coming up in a future release to force innodb which helps concurrency, but slows down search. You could also force innodb with a bit of code. This may help performance a bit, but performance optimization is a dark art.
and Page completed in 1.1535s for the forum ( main page )
That seems ok with me ? is it about right .. or should we be tweaking mysql
Initiated Minify:
Main forum now: Page completed in 0.6158s
Discussions: Page completed in 0.9577s
Not sure how much of that is inherited because of cache. But looks ok
However if I view src and check this:
<link rel="stylesheet" type="text/css" href="/forums/plugins/Minify/min/?token=our-token-was-herecd&v=2.0.17.10" media="screen" />
I get a 404 bad request
There was an error rendering this rich post.
Each thing should be a separate topic to discuss in the developers forum.
First we need to get 2.0.18 (final) out and then we can work on the topics one by one.
I have a feeling they will be addressed soon.
There was an error rendering this rich post.