I logged on to the site tonight, and watched in phpMyAdmin periodically refreshing the "processes" option which I believe is just a SHOW FULL PROCESSLIST and the problem occurs severely at midnight, and then slowly gets better and better. By a little after 12:35 or so the problem is non-existant.
The process list pretty early on looked like this:
Code: Select all
ID User Host Database Command Time Status SQL-query
636320 web_user my.server.com:1424 my_database Sleep 115 --- ---
636361 web_user my.server.com:1500 my_database Sleep 143 --- ---
636384 web_user my.server.com:1544 my_database Sleep 128 --- ---
636414 web_user my.server.com:1602 my_database Sleep 88 --- ---
636441 web_user my.server.com:1654 my_database Sleep 30 --- ---
636459 web_user my.server.com:1689 my_database Sleep 48 --- ---
636467 web_user my.server.com:1702 my_database Sleep 38 --- ---
636473 web_user my.server.com:1715 my_database Sleep 18 --- ---
636479 web_user my.server.com:1724 my_database Sleep 27 --- ---
636485 web_user my.server.com:1735 my_database Sleep 20 --- ---
636498 web_user my.server.com:1760 my_database Sleep 14 --- ---
636503 web_user my.server.com:1771 my_database Sleep 11 --- ---
636510 web_user my.server.com:1784 None Query 0 --- SHOW PROCESSLISTAnybody have any suggestions for how I can track this down?