I have noticed over the last few days my server has been running slow and the CPU has being running high. I ran the TOP command in ssh and found mysql was overloading the server. So I killed the process, the server load came back down to the normal level (0.10-0.40). Within 10 minutes the CPU was running high again, looked at the top command, again it was mysql. So I have shutdown chkservd & mysql (server running fine)
How can I find out which user is overloading mysql?
Server running cPanel/WHM with CentOs