I have a dedicated server which sells shared server space and its running WHM/Cpanel and maybe a couple of times a day the load shoots up to 25+ and I have a script which stops httpd and then restarts when load is back down to 8. The httpd service is only down for 60 seconds or so, not much more but its a bit annoying when it happens.
The server has quite a few sites on it, maybe 250 or so, varying from wordpress, static etc. The sites are delivered very fast but whilst running TOP - C in SSH I can see mysql user at 6% then 25% then 80% then 33% etc so its fluctuating all over the place.
Its very difficult to establish exactly which user is causing loads but I am wondering if I should move the mysql databases over to a separate Cpanel server.
Would this reduce the load significantly? I am assuming that some of the load is from users using the mysql service.
Thoughts anyone?
The server has quite a few sites on it, maybe 250 or so, varying from wordpress, static etc. The sites are delivered very fast but whilst running TOP - C in SSH I can see mysql user at 6% then 25% then 80% then 33% etc so its fluctuating all over the place.
Its very difficult to establish exactly which user is causing loads but I am wondering if I should move the mysql databases over to a separate Cpanel server.
Would this reduce the load significantly? I am assuming that some of the load is from users using the mysql service.
Thoughts anyone?