/* Display all locked / unlocked tables */ SHOW OPEN TABLES; /* Display table locks in specific DB */ SHOW OPEN TABLES FROM databaseName WHERE In_use <> 0;