All pages
Powered by GitBook
1 of 1

Loading...

IS_USED_LOCK

Check who holds a named lock. This function returns the connection identifier of the client holding the lock, or NULL if the lock is free.

Syntax

IS_USED_LOCK(str)

Description

Checks whether the lock named str is in use (that is, locked). If so, it returns the connection identifier of the client that holds the lock. Otherwise, it returns NULL. str is case insensitive.

If the plugin is installed, the table contains information about locks of this kind (as well as ).

Statements using the IS_USED_LOCK function are .

See Also

This page is licensed: GPLv2, originally from

metadata_lock_info
Information Schema
metadata_lock_info
metadata locks
not safe for statement-based replication
GET_LOCK
RELEASE_LOCK
IS_FREE_LOCK
RELEASE_ALL_LOCKS
fill_help_tables.sql