"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/docs/locks.rst" (6 May 2012, 758 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format (assuming markdown format). Alternatively you can here view or download the uninterpreted source code file. A member file download can also be achieved by clicking within a package contents listing on the according byte size field.

User Defined Locks

A user can create a "lock" which is scoped to their user space. Multiple session of the user can see the lock.

SELECT GET_LOCK();

SELECT GET_LOCKS();

SELECT RELEASE_LOCK();

SELECT RELEASE_LOCK();

SELECT RELEASE_LOCKS();

SELECT is_free_lock();

SELECT is_used_lock();

If a session should exit, whatever locks it was holding will be released.

are locks recursive?

Please note, get_lock() was designed to be compatible with MySQL. If you hold any locks when calling get_lock() they will be released. For this reason you may want to consider calling get_locks() instead.

Information on all barriers can be found in the DATA_DICTIONARY.USER_LOCKS table;