FLUSH TABLES hangs if table is locked

FAQ

Profile

FLUSH TABLES hangs if table is locked

Database Help (Home) -> mySQL

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" TIA The Bunny >> Stay informed about: FLUSH TABLES hangs if table is locked

Display posts from previous:

Related Topics:

Document MySQL Tables - I googled and found a number of tools that claim to document MySQL schema, both at the column level and the table level. If you have found any that worked well for you please let me know. Thanks, Joe

PLS HELP! - show databases and tables and columns - Hi, I just wonder if someone can help me with this: I need to create a sql script which will run when user installs/upgrades my app. User may already have the database and tables tructure setup on the server, or may not. The script needs to..

Restoring select databases/tables from an --all-databases .. - I use the --all-databases switch to backup my entire database. Sometimes there's a need to restore individual databases or tables form the backup file. What command should I use for this? Thanks, Raffi

preventing direct access to tables - how does one prevent someone from directly inserting into a table such that any inserts should be passed to a stored procedure e.g insert_data(....) i have read the manual on revoke, grant but couldn't grasp the idea.

Multiple Inserts across multiple tables - Hi Guys, After a bit of advice really. We have a number of tables in our database, that when a new account is created it should insert into all of them (different information) get the insert ids from all and the update the first table with all the ids....

	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