Hi The MySQL on my vps has got stuck twice in the last couple of days, both times it was about 9pm (GMT) that I noticed. My host states it is because "Mysql process on your VPS is using high resources". Most of the sites on the vps run on a couple of scripts. Having been on the script's forums and spoken with the authors as well (who use it on their own sites), nobody else seems to have such a problem and they have sites that are way, way busier with traffic than mine. Also, I never had this problem with my previous host (changed last November and only because their servers were slow). My question is, is there anywhere that I can find out about resources used and when, which site etc., or any other way I can try to track down this problem? My vps is linux with WHM and Cpanel. TIA Jill ps, don't know if it helps or is relevant, but the main script reports for the home page.. 28 total queries This page was created in 0.34 seconds Memory used: 6076004 bytes
Im assuming its cPanel backups running at the same time as logs, and its creating high load / cpu usage. Try running cPanel logs longer, instead of earlier ( e.g every 2 days instead of every day ) - check out your statistics configuration within your WHM. Check your CPU/mem usage in the server status area of your WHM, may give you an idea of what user/process is sucking up resources. Whats the specs of your VPS? how many accounts on your VPS?
You can check current MySQL connections from WHM - > Show MySQL Processes You can also check the connections from SSH: watch -n 0.5 mysqladmin proc Kailash