Is there a way to detect locked tables in MySQL? I mean the table locked by the LOCK TABLE table WRITE/READ command.
(Please note that readers interested in detecting named locks acquired using GET_LOCK should read Show all current locks from get_lock .)
Display OPEN TABLES to show the status of each table and its lock.
For named locks, please see Show all current locks from get_lock
Is there a way to detect lock tables in MySQL? I mean the table locked by the LOCK TABLE table WRITE/READ command.
(Please note that readers interested in detecting named locks acquired using GET_LOCK should read Show all current locks from get_lock .)
Display OPEN TABLES to show the status of each table and its lock.
For named locks, please see Show all current locks from get_lock