Bug #84259 Need to display the list of currently locked tables
Submitted: 19 Dec 2016 10:17 Modified: 19 Dec 2016 10:18
Reporter: Victor Porton Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server: Locking Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[19 Dec 2016 10:17] Victor Porton
Description:
How to determine which tables are currently locked (by LOCK TABLES)? It seems that current MySQL version does not provide a command to query this.

How to repeat:
It seems that MySQL has no command to display this.
[19 Dec 2016 10:18] Victor Porton
We also need to see which tables are locked READ and which ones WRITE.