Optimization/Performance suggestions for High Mysql Load
Hi,
My cpanel server specs are :
[QUOTE]2x Intel" Xeon" E5-2690 v2
64 GB Ram
Nginx with Cloudflare
I will appreciate some suggestions to optimize my server to handle wordpress sites with more than 5000 people online at peak. My server used to handle 3000 people online at a time with no problems, but for last couple of days my traffic has doubled and it is sometimes slowing down the sites as mysql load exceeds 600 to 700 %. So should i opt for a webserver like litespeed or an OS like cloudlinux with plugins like Varnish? Or should i just simply increase the RAM on my server from 64 GB to 128 GB? What is the best stack or best plugin or software combination for a cpanel server hosting wodpress website with more than 5000 users online at a time. Thanks.
I will appreciate some suggestions to optimize my server to handle wordpress sites with more than 5000 people online at peak. My server used to handle 3000 people online at a time with no problems, but for last couple of days my traffic has doubled and it is sometimes slowing down the sites as mysql load exceeds 600 to 700 %. So should i opt for a webserver like litespeed or an OS like cloudlinux with plugins like Varnish? Or should i just simply increase the RAM on my server from 64 GB to 128 GB? What is the best stack or best plugin or software combination for a cpanel server hosting wodpress website with more than 5000 users online at a time. Thanks.
-
Hey! Both CloudLinux and Litespeed can be helpful in this situation. CloudLinux also provides MySQL Governor, which can help prevent users from abusing the server resources via MySQL. I believe you can obtain a trial license directly from each vendor for both CloudLinux and Litespeed if you want to try them out. Regarding increasing the RAM on your server, it isn't easy to know if this will help. If the overall server load and memory usage is high, then increasing the RAM can help. You can use the sar logs to confirm what the load and memory usage is like on the server. Lastly, I wouldn't say there is an optimal plugin combination for hosting 5000+ users/WordPress sites. It will likely take trial and error to see what type of setup works best for your situation. 0 -
A caching plugin like W3 Total Cache, WP-Rocket, etc might reduce the load on MySQL heavily by caching the built pages. 0 -
Litespeed would be the Solution for this issue. Also increase the max connection in sql 0
Please sign in to leave a comment.
Comments
3 comments