I'm stuck trying to solve a MySQL issue. A few times an hour, for about 60s, MyuSQL becomes unresponsive, causing our site to be inaccessible during that period. I enabled the slow query log and found nothing amiss (all the queries during the outage are very slow, naturally, but no one query seems to be causing the issue).
I disabled all (my) cron jobs, and the issue still persists.
I ran top during the outage and MySQL is pretty much not even running - which makes me feel that it's not a load/bad query issue.
top screenshot is here : Some stats on my vps :
1.8GB RAM, 2.2Ghz proc. mysql 5.1.56. My site runs blindingly fast except during these periods when it locks up. Average cpu usage is 40%.
Here is my my.cnf :
safe-show-database tmp_table_size = 24M
max_heap_table_size = 32M
Any advice on how to track down this issue highly appreciated.