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

[26 Jul 2009 22:04] Jonathon Coombes 
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
[19 Apr 2017 7:33] Marc ALFF 
Implemented in the performance_schema in 5.7, see

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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.