New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
mysql process has high CPU load (300%+) when website has 400+ users online
KenobisVPS
Member
SOLVED
Comments
enable slow query log to see what queries are causing issue
check connection limits on apache/mysql/etc.
disable keepalive/persistent connections or make sure that the timeouts are very low.
PS: check wordpress plugins for something which is using frequent ajax calls (something that has the visitors browser send requests every few seconds invoking a php/mysql lookup... for instance this could be a messaging or news plugin etc.)
It could be a certain function running a single call that is taking time to run as well. Reports are generally a good example of this.
Alright guys thank you very much.
It's because of a stupid plugin. I am so dumb.
It's the top commentators plugin If you are curious. Thank you guys again for the huge help!
Not that it solves the actual issue, but I suggest hosting your database on a seperate server so it won't block up any other processes.
You should probably implement Varnish or nginx cache (if you're using nginx).
Id suggest taking a look at centminmod .
Community is great and @eva2000 is always there to help !
I am using Centminmod.
Problem is solved. I mentioned it in the comment above.
Thank you!
what plugin?
>
https://wordpress.org/plugins/top-commentators-widget/
It loads all comment counts every single time when the page loads