469,089 Members | 1,227 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,089 developers. It's quick & easy.

FLUSH TABLES hangs if table is locked

Using FLUSH TABLES via the C query API mysql_query() hangs if the table is
locked already. That is to say, nothing prevents me from running a LOCK
TABLES twice; it won't tell me "it's already locked, don't try to run a
FLUSH".

Anyone know how to find out if a table is already locked? And don't say
"call the DBA" :)

TIA

The Bunny
Jul 23 '05 #1
0 1360

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Jeff Roughgarden | last post: by
2 posts views Thread by Bardolator | last post: by
4 posts views Thread by Stefan Kowalski | last post: by
9 posts views Thread by a | last post: by
3 posts views Thread by David Cartwright | last post: by
5 posts views Thread by breal | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.