content_image/846277.jpg content_image/846284.jpg
<img src='content_image/846277.jpg'>

If autocommit = 0 , InnoDB  honors LOCK TABLES ; MySQL does not return from LOCK TABLES ... WRITE  until all other threads have released all their locks to the table. The default value of innodb_table_locks  is 1, which means that LOCK TABLES  causes InnoDB to lock a table internally if autocommit = 0 . 

innodb_table_locks = 0  has no effect for tables locked explicitly with LOCK TABLES ... WRITE . It does have an effect for tables locked for read or write by LOCK TABLES ... WRITE  implicitly (for example, through triggers) or by LOCK TABLES ... READ . 

For related information, see Section 15.7, “InnoDB Locking and Transaction Model” . 

As of MySQL 8.0.26, setting the session value of this system variable is a restricted operation. The session user must have privileges sufficient to set restricted session variables. See Section 5.1.9.1, “System Variable Privileges” . 

• innodb_temp_data_file_path 

<img src='content_image/846284.jpg'>

