The Ultimate Guide to High Availability with MariaDB

Comments - LOCK TABLES

3 years, 10 months ago juerg oehler
missing information

please consider to improve documentation. personaly i'm using LOCK TABLES for batch inserts. i'm locking tables in order to no one else can exclusively lock tables while process is running.

i'm missing two informations:

- where are locks stored, in order to verify my and others locks
- how long are locks holded (something alike user session closed or an other LOCK TABLES and UNLOCK TABLES)

i figured it out in a day long process. why am i not posting it? it still might be wrong and it might change with db versions.

i so hope, these two questions are answered and maintained by a mariadb crew member.

 
3 years, 1 month ago Anel Husakovic
Re: missing information

I guess you can use (in 10.0+ https://mariadb.com/kb/en/metadata-lock-info-plugin/) metadata_lock_info plugin.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.