Bug #33752 All dbs "freeze" and no queries are processed
Submitted: 8 Jan 2008 21:35 Modified: 10 Aug 2008 6:16
Reporter: Gary Barrueto Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: General Severity:S2 (Serious)
Version:5.0.45 OS:Linux (RHEL4)
Assigned to: CPU Architecture:Any

[8 Jan 2008 21:35] Gary Barrueto
Our db is getting into a state where it continues to accept and queue connections/sql. But none of the queries execute for 5 to 30 seconds (maybe more) for any of the dbs.  During that time period mysql stops any disk activity. There does seem to be a time pattern to when this happens. Even simple sql like the ones below pause for the same amount of time from either a remote or local mysql client.

mysql> select 1;
| 1 |
| 1 | 
1 row in set (12.11 sec)

mysql> select 1+1;
| 1+1 |
|   2 | 
1 row in set (22.27 sec)


I would expect this to return with no delay.

How to repeat:
Using mysql administrator to view Health, when SQL graph drops to 0 and Thread count starts climbing, then all queries stop working.
[8 Jan 2008 21:55] Gary Barrueto
Meant to type that there does *not* seem to be a time pattern to
when this happens.
[9 Jan 2008 4:40] Valeriy Kravchuk
Thank you for a problem report. Please, send your my.cnf and SHOW PROCESSLIST results when you see this problem.
[9 Jan 2008 20:06] Gary Barrueto
Here is the my.cnf that is being used

Attachment: my.txt (text/plain), 1.17 KiB.

[9 Aug 2008 7:07] Valeriy Kravchuk
Please, try to repeat with a newer version, 5.0.67, and inform about the results.
[9 Aug 2008 7:51] Gary Barrueto
turns out it was this http://bugs.mysql.com/bug.php?id=21074