nhadsall

Member
Nov 7, 2015
7
0
1
San Antonio, TX
cPanel Access Level
Root Administrator
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

Well-Known Member
Aug 23, 2015
604
46
28
India
cPanel Access Level
Root Administrator
Twitter
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

Administrator
Staff member
Apr 11, 2011
47,917
2,248
363
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.