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}