Default Value ON InnoDB System Variables 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 Command-Line Format --innodb-temp-data-file- path=file_name System Variable innodb_temp_data_file_path Scope Global Dynamic No SET_VAR  Hint Applies No Type String 3289