MySQL Forums
Forum List  »  Docs

GET_LOCK/RELEASE_LOCK - Active Lock Holders
Posted by: Karl Bunch
Date: September 05, 2007 10:36AM

Ok I've been a user of MySql for eons and recently I've ran into a real nice use of GET_LOCK/RELEASE lock for some application scheduling. The problem is I can't find anything in the manual that tells how to 'list active locks' like maybe a "SHOW APPLICATION LOCKS".. I want to be able to see what locks are out there and what thread has them etc.. Short of GET_LOCK on every possible string known to man kind how can I get this info? Or is this a "feature" request.. lol

Dream:
Client A: SELECT GET_LOCK('SomeUnknownKey', 10);
Client B: SHOW APPLICATION LOCKS
+----------+------------------------+
| ThreadId | Key                    |
+----------+------------------------+
| 1234     | SomeUnknownKey         |
+----------+------------------------+

Am I dreaming or is this out there and I'm just not seeing it in the docs?

Options: ReplyQuote


Subject
Views
Written By
Posted
GET_LOCK/RELEASE_LOCK - Active Lock Holders
22301
September 05, 2007 10:36AM


Sorry, you can't reply to this topic. It has been closed.

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.