Welcome to dbFreaks.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

FLUSH TABLES hangs if table is locked

 
   Database Help (Home) -> mySQL RSS
Next:  FK versus PK  
Author Message
CaptainMcBunnyTickle

External


Since: Feb 13, 2005
Posts: 3



(Msg. 1) Posted: Tue Feb 22, 2005 7:40 pm
Post subject: FLUSH TABLES hangs if table is locked
Archived from groups: mailing>database>mysql (more info?)

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" Smile

TIA

The Bunny

 >> Stay informed about: FLUSH TABLES hangs if table is locked 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> mySQL All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]