1'#--------------------FN_DYNVARS_048_01-------------------------#' 2SET @start_value= @@global.innodb_table_locks; 3SELECT @start_value; 4@start_value 51 6SET @@global.innodb_table_locks = OFF; 7'connect (con1,localhost,root,,,,)' 8connect con1,localhost,root,,,,; 9'connection con1' 10connection con1; 11SELECT @@global.innodb_table_locks; 12@@global.innodb_table_locks 130 14SELECT @@session.innodb_table_locks; 15@@session.innodb_table_locks 160 17disconnect con1; 18'#--------------------FN_DYNVARS_048_02-------------------------#' 19'----check when innodb_table_locks = ON and autocommit = OFF---' 20'connect (con2,localhost,root,,,,)' 21connect con2,localhost,root,,,,; 22'connection default' 23connection default; 24DROP TABLE IF EXISTS t1; 25CREATE TABLE t1 (a INT) ENGINE=INNODB; 26SET @@autocommit = OFF; 27SET @@innodb_table_locks = ON; 28BEGIN; 29INSERT INTO t1 VALUES(1); 30SELECT * FROM t1 FOR UPDATE; 31a 321 33'CONNECTION con2' 34connection con2; 35SET @@innodb_table_locks = ON; 36SET @@autocommit = OFF; 37LOCK TABLES t1 WRITE; 38'CONNECTION default' 39connection default; 40COMMIT; 41'CONNECTION con2' 42connection con2; 43UNLOCK tables; 44DROP TABLE t1; 45disconnect con2; 46connection default; 47SET @@global.innodb_table_locks= @start_value; 48SELECT @@global.innodb_table_locks; 49@@global.innodb_table_locks 501 51