I currently have this issue where my website keeps on crashing due to some mysql error. My server topology is two servers: a mysql server and a http server. PHP connects to the mysql server via a mysql_pconnect() remote connection.
The mysql server constantly overloads and I can't seem to figure which query or queries are causing it. I have tried using SHOW FULL PROCESSLIST, but I can't seem to find anything useful.
Is there another way to solve why exactly the server is overloading?