Skip navigation links
About Worklog
The MySQL Worklog are design specifications for some of the items that may be considered for future development.

WL#1159: Allow multiple locks in GET_LOCK()

Affects: Server-7.1   —   Status: Un-Assigned   —   Priority: High 

We shall allow one to request multiple of locks Via serie of GET_LOCK statements, 
it would be even nice to allow several locks in signgle function call:

GET_LOCK("lock1","lock2",0);
GET_LOCK("lock3",0)

Implementing this option one shall take care of possible deadlocks.

Also in such case we shall allow RELEASE_LOCK to release all locks which thread has.

It would be also convenient to be able to get list of locks which current thread
owns for debugging purposes.


Copyright (c) 2000, 2013, Oracle Corporation and/or its affiliates. All rights reserved.