RELEASE_ALL_LOCKS

Release all named locks held by the session. This function frees all user-level locks acquired with GET_LOCK() in the current connection.

RELEASE_ALL_LOCKS is available from MariaDB 10.5.2.

Syntax

RELEASE_ALL_LOCKS()

Description

Releases all named locks held by the current session. Returns the number of locks released, or 0 if none were held.

Statements using the RELEASE_ALL_LOCKS function are not safe for statement-based replication.

Examples

SELECT RELEASE_ALL_LOCKS();
+---------------------+
| RELEASE_ALL_LOCKS() | 
+---------------------+
|                   0 |
+---------------------+

SELECT GET_LOCK('lock1',10);
+----------------------+
| GET_LOCK('lock1',10) |
+----------------------+
|                    1 |
+----------------------+

SELECT RELEASE_ALL_LOCKS();
+---------------------+
| RELEASE_ALL_LOCKS() | 
+---------------------+
|                   1 |
+---------------------+

See Also

• GET_LOCK

• IS_FREE_LOCK

• IS_USED_LOCK

• RELEASE_LOCK

_{This page is licensed: CC BY-SA / Gnu FDL}