MySQL Bugs: #16116: MySQL freezes on SHOW TABLE STATUS on Win 2003

Bug #16116	MySQL freezes on SHOW TABLE STATUS on Win 2003
Submitted:	1 Jan 2006 11:54	Modified:	1 Jan 2006 14:29
Reporter:	alon s	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	4.1.15-nt-max	OS:	Windows (windows server 2003 web edition)
Assigned to:		CPU Architecture:	Any

Description:
MySQL freezes (builds up connection requests without returning results or cleaning them up until finally we get too many connections error. also we are unable to restart it. only windows 2003 restart solves it)

This problem accours when using the following query:
SHOW TABLE STATUS from ________

I so that another user reported the same problem just a week ago.
http://lists.mysql.com/win32/17918

We are a hosting company and whenever someone runs this query it effects all of our customers.
please advise asap.

How to repeat:
run the query on the specified mysql version

Hi!

This is a duplicate of:
http://bugs.mysql.com/bug.php?id=12071

A workaround appeared on Dec 30, 2005 in MySQL-5.0.18, and will also appear in MySQL-4.1.17.

Best regards,

Heikki
Oracle/Innobase