mysql cpu usage high, and crashes vps

nhadsall

• January 22, 2016 14:49

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

  • January 23, 2016 10:40

  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

  0
• 

  cPanelMichael

  • January 25, 2016 16:44

  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.

  0

Please sign in to leave a comment.