MySQL Bugs: #84259: Need to display the list of currently locked tables

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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.

We also need to see which tables are locked READ and which ones WRITE.