1SET @saved_kill_idle_transaction= @@GLOBAL.kill_idle_transaction; 2SELECT @@kill_idle_transaction; 3@@kill_idle_transaction 40 5SELECT @@innodb_kill_idle_transaction; 6@@innodb_kill_idle_transaction 70 8SELECT @@SESSION.kill_idle_transaction; 9ERROR HY000: Variable 'kill_idle_transaction' is a GLOBAL variable 10SHOW GLOBAL VARIABLES LIKE 'kill_idle_transaction'; 11Variable_name Value 12kill_idle_transaction 0 13SHOW SESSION VARIABLES LIKE 'kill_idle_transaction'; 14Variable_name Value 15kill_idle_transaction 0 16SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE variable_name='kill_idle_transaction'; 17VARIABLE_NAME VARIABLE_VALUE 18KILL_IDLE_TRANSACTION 0 19SELECT * FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE variable_name='kill_idle_transaction'; 20VARIABLE_NAME VARIABLE_VALUE 21KILL_IDLE_TRANSACTION 0 22SET GLOBAL kill_idle_transaction= 1.1; 23ERROR 42000: Incorrect argument type to variable 'kill_idle_transaction' 24SET GLOBAL kill_idle_transaction= 1e1; 25ERROR 42000: Incorrect argument type to variable 'kill_idle_transaction' 26SET GLOBAL kill_idle_transaction= "foo"; 27ERROR 42000: Incorrect argument type to variable 'kill_idle_transaction' 28SET GLOBAL kill_idle_transaction= 0; 29SHOW GLOBAL VARIABLES LIKE 'kill_idle_transaction'; 30Variable_name Value 31kill_idle_transaction 0 32SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE variable_name='kill_idle_transaction'; 33VARIABLE_NAME VARIABLE_VALUE 34KILL_IDLE_TRANSACTION 0 35SELECT @@innodb_kill_idle_transaction; 36@@innodb_kill_idle_transaction 370 38SET GLOBAL kill_idle_transaction= 12345; 39SHOW GLOBAL VARIABLES LIKE 'kill_idle_transaction'; 40Variable_name Value 41kill_idle_transaction 12345 42SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE variable_name='kill_idle_transaction'; 43VARIABLE_NAME VARIABLE_VALUE 44KILL_IDLE_TRANSACTION 12345 45SELECT @@innodb_kill_idle_transaction; 46@@innodb_kill_idle_transaction 4712345 48SET GLOBAL kill_idle_transaction= 4294967295; 49Warnings: 50Warning 1292 Truncated incorrect kill_idle_transaction value: '4294967295' 51SHOW GLOBAL VARIABLES LIKE 'kill_idle_transaction'; 52Variable_name Value 53kill_idle_transaction 31536000 54SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE variable_name='kill_idle_transaction'; 55VARIABLE_NAME VARIABLE_VALUE 56KILL_IDLE_TRANSACTION 31536000 57SELECT @@innodb_kill_idle_transaction; 58@@innodb_kill_idle_transaction 5931536000 60SET GLOBAL kill_idle_transaction= 31536000; 61SHOW GLOBAL VARIABLES LIKE 'kill_idle_transaction'; 62Variable_name Value 63kill_idle_transaction 31536000 64SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE variable_name='kill_idle_transaction'; 65VARIABLE_NAME VARIABLE_VALUE 66KILL_IDLE_TRANSACTION 31536000 67SELECT @@innodb_kill_idle_transaction; 68@@innodb_kill_idle_transaction 6931536000 70SET GLOBAL kill_idle_transaction= @saved_kill_idle_transaction; 71