MySQL Bugs: #33752: All dbs "freeze" and no queries are processed

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:	None
Category:	MySQL Server: General	Severity:	S2 (Serious)
Version:	5.0.45	OS:	Linux (RHEL4)
Assigned to:		CPU Architecture:	Any

Description:
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)

mysql> 

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.

Meant to type that there does *not* seem to be a time pattern to
when this happens.

Thank you for a problem report. Please, send your my.cnf and SHOW PROCESSLIST results when you see this problem.

Here is the my.cnf that is being used

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

Please, try to repeat with a newer version, 5.0.67, and inform about the results.

turns out it was this http://bugs.mysql.com/bug.php?id=21074