Collections:
IS_USED_LOCK() - Checking Lock Owner
How to check the owner of a user defined lock using the IS_USED_LOCK() function?
✍: FYIcenter.com
IS_USED_LOCK(lock) is a MySQL built-in function that
returns the connection id the lock associated with if the lock is in use,
NULL otherwise.
For example:
SELECT GET_LOCK('MyLock', 60), IS_USED_LOCK('MyLock');
-- +------------------------+------------------------+
-- | GET_LOCK('MyLock', 60) | IS_USED_LOCK('MyLock') |
-- +------------------------+------------------------+
-- | 1 | 307 |
-- +------------------------+------------------------+
SELECT RELEASE_LOCK('MyLock'), IS_USED_LOCK('MyLock');
-- +------------------------+------------------------+
-- | RELEASE_LOCK('MyLock') | IS_USED_LOCK('MyLock') |
-- +------------------------+------------------------+
-- | 1 | NULL |
-- +------------------------+------------------------+
Reference information of the IS_USED_LOCK() function:
IS_USED_LOCK(lock): boolean
Returns the connection id the lock associated with if the lock is in use,
NULL otherwise.
Arguments, return value and availability:
lock: Required. The lock name to be examined.
boolean: Return value. Connection id the lock associated with
if the lock is in use, NULL otherwise.
Available since MySQL 4.
⇒ ISNULL() - Detecting NULL Value
⇐ IS_IPV6() - Detecting IPv6 Address
2023-12-20, 1130🔥, 0💬
Popular Posts:
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...