MySQL high CPU usage


#1

I have a cloud server with Plesk where I have over 20 Wordpress websites. Randomly, my server keeping going down due to MySql exceeding the CPU limits.

I’m presuming the issue is due to a database table connected to one of the domain that is overloading the server when it is triggered. However, I’m not quite sure how to pinpoint which domain and which database table is causing the issue. Is there a particular log file I should be checking?

Any help or advice on this would be greatly appreciated!


#2

What output do you get from mysqldumpslow ? Immediate suspicion has to be bad queries taking too long to process causing a buildup of CPU usage… next suspicion would be one of the sites is too popular to be using the shared hosting.

Is the server running a high CPU constantly? or only spiking?