Multiple user level locks per connection

Percona Server supports multiple user level locks per connection as of version 5.6.19-67.0. The GET_LOCK() function in upstream MySQL allows a connection to hold at most one user level lock. Taking a new lock automatically releases the old lock, if any.

The limit of one lock per session existed since early versions of MySQL didn’t have a deadlock detector for SQL locks. Metadata Locking introduced in MySQL 5.5 added a deadlock detector, so starting from 5.5 it became possible to take multiple locks in any order. Deadlock would be detected when occurred, and an error would returned to the client which closed the wait chain.

Version Specific Information

  • 5.6.19-67.0 - Feature implemented in Percona Server 5.6

Other Information

  • Author / Origin: Kostja Osipov
Percona Server
Call Us
+1-888-316-9775 (USA - Sales)
+1-208-473-2904 (USA - Sales)
+44-208-133-0309 (UK - Sales)
0-800-051-8984 (UK - Sales)
0-800-181-0665 (GER - Sales)
+1-877-862-4316 (Emergency)
+1-855-55TRAIN (Training)
+1-925-271-5054 (Training)

Table Of Contents

Previous topic

Multiple Adaptive Hash Search Partitions

Next topic

Atomic write support for Fusion-io devices

This Page



© Copyright Percona LLC and/or its affiliates 2009-2014.
Except where otherwise noted, this documentation is licensed under the following license:
CC Attribution-ShareAlike 2.0 Generic
Created using Sphinx 1.1.3.
This documentation is developed in Launchpad as part of the Percona Server source code.
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.
]]>