MySQL: Get locked tables

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 …