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?
Subject
Views
Written By
Posted
GET_LOCK/RELEASE_LOCK - Active Lock Holders
22301
September 05, 2007 10:36AM
9309
April 24, 2008 12:54AM
8148
March 01, 2009 01:25AM
9485
March 17, 2009 02:13AM
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.