MySQL Forums
Forum List  »  Newbie

Re: How to check if table is locked
Posted by: Russell Dyer
Date: June 26, 2005 09:21PM

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).

Options: ReplyQuote


Subject
Written By
Posted
June 23, 2005 02:25AM
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.