mysql cpu usage high, and crashes vps

[nhadsall]

Hello,
I have a smaller VPS. So far things have been fine. I host a dozen low traffic sites. I just brought on one more site (again, fairly low traffic). Now mysql usage got so high that no other site could connect to the DB. I had to restart the VPS twice. Any suggestions about how to go about tracking down the problem?

Thank you!

 

[SysSachin]

Hi,

You can check the Mysql process using below command so that you will get idea which database process causing high load on the server

mysqladmin proc

 

[cPanelMichael]

Hello

Yes, as mentioned, use the "mysqladmin processlist" command when MySQL usage is high to see if you can get a better idea about which databases are the culprit. Also, you may find this thread helpful:

Troubleshooting high server loads on Linux servers

Thank you.