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!