MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0

29.3.1 The Locking Service

MySQL distributions provide a locking interface that is available at two levels:

For general information about plugin services, see Section 29.3, “MySQL Services for Plugins”. For general information about user-defined functions, see Section 29.4.2, “Adding a New User-Defined Function”.

The locking interface has these characteristics:

The interface provided by the locking service is distinct from that provided by GET_LOCK() and related SQL functions (see Section 12.14, “Locking Functions”). For example, GET_LOCK() does not implement namespaces and provides only exclusive locks, not distinct read and write locks.