Detecting locked tables (locked by LOCK TABLE)

by

Use SHOW OPEN TABLES:
http://dev.mysql.com/doc/refman/5.1/en/show-open-tables.html

You can do something like this

SHOW OPEN TABLES WHERE `Table` LIKE '%[TABLE_NAME]%' AND `Database` LIKE '[DBNAME]' AND In_use > 0;

to check any locked tables in a database.

More Related Contents:

  1. Any way to select without causing locking in MySQL?
  2. How to lock a single row
  3. How do I lock on an InnoDB row that doesn’t exist yet?
  4. MySQL ‘select for update’ behaviour
  5. Optimistic locking in MySQL
  6. i have an error which i dont understand. can you help me? [closed]
  7. mysql error 1364 Field doesn’t have a default values
  8. SQL: What is the default Order By of queries?
  9. How to group by week in MySQL?
  10. Can I use a function for a default value in MySql?
  11. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  12. Mysql order by specific ID values
  13. How do I check if a column is empty or null in MySQL?
  14. MySQL versus PDO [duplicate]
  15. Mysql string split [duplicate]
  16. Increment a database field by 1
  17. Measuring actual MySQL query time
  18. MySQL VARCHAR Lengths and UTF-8
  19. Row number per group in mysql
  20. Find and replace entire MySQL database
  21. Resetting ROOT password in MySQL 5.6
  22. How do I refer to capture groups in a MySQL regex?
  23. What is the default MySQL JOIN behaviour, INNER or OUTER?
  24. How to get the mysql table columns data type?
  25. Escaping the colon character ‘:’ in JPA queries
  26. How to export / dump a MySql table into a text file including the field names (aka headers or column names)
  27. MySQL throws Incorrect string value error
  28. ORDER BY alphabet first then follow by number
  29. mysql create table dynamically
  30. Errno 121, duplicate key on write or update?

Leave a Comment