The Ultimate Guide to High Availability with MariaDB

Comments - LOCK TABLES

5 years, 4 months ago Andrew Forbes
Re: LOCK TABLES and UNLOCK TABLES

I think there may be a typo on this documentation page:

"LOCK TABLES works on XtraDB/InnoDB tables only if the innodb_table_locks system variable is set to 1 and autocommit is set to 0 (the default in both cases). Please note that no error message will be returned on LOCK TABLES with innodb_table_locks = 0."

However, the documentation for autocommit (https://mariadb.com/kb/en/library/server-system-variables/#autocommit) lists the Default Value of autocommit as 1, not 0.

 
5 years, 4 months ago Ian Gilfillan
Re: LOCK TABLES and UNLOCK TABLES

Thanks, fixed.

 
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.