Re: How to check if table is locked
There is no simple method to determine if tables are locked. There are plans to one day add a SHOW LOCKS table, but not yet. If you enter a SHOW PROCESSLIST statement, you'll get a list of information on tables in a database. Tables that aren't locked will mention something about not being locked in the Comment field of the results set: "Table 'test' was not locked with LOCK TABLES" Ones that are locked won't say anything in this field because the table is locked and therefore no information is available.
Russell Dyer
Author of "MySQL in a Nutshell" (O'Reilly 2005).
Subject
Written By
Posted
Re: How to check if table is locked
June 26, 2005 09:21PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.