1SET @saved_innodb_kill_idle_transaction= @@GLOBAL.innodb_kill_idle_transaction; 2SELECT @@innodb_kill_idle_transaction; 3@@innodb_kill_idle_transaction 40 5SELECT @@kill_idle_transaction; 6@@kill_idle_transaction 70 8SELECT @@SESSION.innodb_kill_idle_transaction; 9ERROR HY000: Variable 'innodb_kill_idle_transaction' is a GLOBAL variable 10SHOW GLOBAL VARIABLES LIKE 'innodb_kill_idle_transaction'; 11Variable_name Value 12innodb_kill_idle_transaction 0 13SHOW SESSION VARIABLES LIKE 'innodb_kill_idle_transaction'; 14Variable_name Value 15innodb_kill_idle_transaction 0 16SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE variable_name='innodb_kill_idle_transaction'; 17VARIABLE_NAME VARIABLE_VALUE 18INNODB_KILL_IDLE_TRANSACTION 0 19Warnings: 20Warning 1287 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead 21SELECT * FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE variable_name='innodb_kill_idle_transaction'; 22VARIABLE_NAME VARIABLE_VALUE 23INNODB_KILL_IDLE_TRANSACTION 0 24Warnings: 25Warning 1287 'INFORMATION_SCHEMA.SESSION_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.session_variables instead 26SET GLOBAL innodb_kill_idle_transaction= 1.1; 27ERROR 42000: Incorrect argument type to variable 'innodb_kill_idle_transaction' 28SET GLOBAL innodb_kill_idle_transaction= 1e1; 29ERROR 42000: Incorrect argument type to variable 'innodb_kill_idle_transaction' 30SET GLOBAL innodb_kill_idle_transaction= "foo"; 31ERROR 42000: Incorrect argument type to variable 'innodb_kill_idle_transaction' 32SET GLOBAL innodb_kill_idle_transaction= 0; 33SHOW GLOBAL VARIABLES LIKE 'innodb_kill_idle_transaction'; 34Variable_name Value 35innodb_kill_idle_transaction 0 36SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE variable_name='innodb_kill_idle_transaction'; 37VARIABLE_NAME VARIABLE_VALUE 38INNODB_KILL_IDLE_TRANSACTION 0 39Warnings: 40Warning 1287 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead 41SELECT @@kill_idle_transaction; 42@@kill_idle_transaction 430 44SET GLOBAL innodb_kill_idle_transaction= 12345; 45SHOW GLOBAL VARIABLES LIKE 'innodb_kill_idle_transaction'; 46Variable_name Value 47innodb_kill_idle_transaction 12345 48SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE variable_name='innodb_kill_idle_transaction'; 49VARIABLE_NAME VARIABLE_VALUE 50INNODB_KILL_IDLE_TRANSACTION 12345 51Warnings: 52Warning 1287 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead 53SELECT @@kill_idle_transaction; 54@@kill_idle_transaction 5512345 56SET GLOBAL innodb_kill_idle_transaction= 4294967295; 57Warnings: 58Warning 1292 Truncated incorrect innodb_kill_idle_transaction value: '4294967295' 59SHOW GLOBAL VARIABLES LIKE 'innodb_kill_idle_transaction'; 60Variable_name Value 61innodb_kill_idle_transaction 31536000 62SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE variable_name='innodb_kill_idle_transaction'; 63VARIABLE_NAME VARIABLE_VALUE 64INNODB_KILL_IDLE_TRANSACTION 31536000 65Warnings: 66Warning 1287 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead 67SELECT @@kill_idle_transaction; 68@@kill_idle_transaction 6931536000 70SET GLOBAL innodb_kill_idle_transaction= 31536000; 71SHOW GLOBAL VARIABLES LIKE 'innodb_kill_idle_transaction'; 72Variable_name Value 73innodb_kill_idle_transaction 31536000 74SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE variable_name='innodb_kill_idle_transaction'; 75VARIABLE_NAME VARIABLE_VALUE 76INNODB_KILL_IDLE_TRANSACTION 31536000 77Warnings: 78Warning 1287 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead 79SELECT @@kill_idle_transaction; 80@@kill_idle_transaction 8131536000 82SET GLOBAL innodb_kill_idle_transaction= @saved_innodb_kill_idle_transaction; 83