All pages
Powered by GitBook
1 of 1

Loading...

IS_FREE_LOCK

Check if a named lock is free. This function returns 1 if the specified lock is available (not currently held), and 0 if it is in use.

Syntax

IS_FREE_LOCK(str)

Description

Checks whether the lock named str is free to use (that is, not locked). Returns 1 if the lock is free (no one is using the lock),0 if the lock is in use, and NULL if an error occurs (such as an incorrect argument, like an empty string or 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_FREE_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_USED_LOCK
RELEASE_ALL_LOCKS
fill_help_tables.sql