The Ultimate Guide to High Availability with MariaDB

Comments - LOCK TABLES

5 years ago Niels Robin-Aubertin
LOCK TABLES limitations

Hi, It's written that "LOCK TABLES works on XtraDB/InnoDB tables only if the innodb_table_locks system variable is set to 1 (the default) and autocommit is set to 0 (1 is default)". I tested on mariadb 10.1, 10.2 and 10.3 and was able to LOCK TABLES even with the default autocommit set to ON. Is there something that I missed or does LOCK TABLES bypass the autocommit value ?

 
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.