From The Blog

MySQL: Get locked tables

29 May 2014, in MySQL

To get locked table you can use:

show open tables WHERE In_use > 0

 

To get locked table in database (for ex.: database name: test_db)

show open tables FROM test_db WHERE In_use > 0

 

To check whether or not a table is locked

show open tables FROM test_db WHERE Table LIKE 'tb_employees' AND In_use > 0



Post a Comment