MySQL Bugs: #46391: No statistics are displayed for named locks from GET

Bug #46391	No statistics are displayed for named locks from GET_LOCK() etc.
Submitted:	26 Jul 2009 22:04	Modified:	19 Apr 2017 7:40
Reporter:	Jonathon Coombes	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Locking	Severity:	S4 (Feature request)
Version:	all	OS:	Any
Assigned to:	Marc ALFF	CPU Architecture:	Any
Tags:	locking, locks, named locks, reporting, statistics

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
There is currently no way to track the use of named locks within MySQL initiated by the functions GET_LOCK(), RELEASE_LOCK(), IS_LOCK_SET() etc.

Feature request is to implement some statistics either in the status variables and/or in the information_schema to enable a user to get statistical reports on how the named locks are working.

How to repeat:
N/A

Suggested fix:
N/A

Implemented in the performance_schema in 5.7, see

https://dev.mysql.com/doc/refman/5.7/en/metadata-locks-table.html