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 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='kill_idle_transaction'; 22VARIABLE_NAME VARIABLE_VALUE 23KILL_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 kill_idle_transaction= 1.1; 27ERROR 42000: Incorrect argument type to variable 'kill_idle_transaction' 28SET GLOBAL kill_idle_transaction= 1e1; 29ERROR 42000: Incorrect argument type to variable 'kill_idle_transaction' 30SET GLOBAL kill_idle_transaction= "foo"; 31ERROR 42000: Incorrect argument type to variable 'kill_idle_transaction' 32SET GLOBAL kill_idle_transaction= 0; 33SHOW GLOBAL VARIABLES LIKE 'kill_idle_transaction'; 34Variable_name Value 35kill_idle_transaction 0 36SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE variable_name='kill_idle_transaction'; 37VARIABLE_NAME VARIABLE_VALUE 38KILL_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 @@innodb_kill_idle_transaction; 42@@innodb_kill_idle_transaction 430 44SET GLOBAL kill_idle_transaction= 12345; 45SHOW GLOBAL VARIABLES LIKE 'kill_idle_transaction'; 46Variable_name Value 47kill_idle_transaction 12345 48SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE variable_name='kill_idle_transaction'; 49VARIABLE_NAME VARIABLE_VALUE 50KILL_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 @@innodb_kill_idle_transaction; 54@@innodb_kill_idle_transaction 5512345 56SET GLOBAL kill_idle_transaction= 4294967295; 57Warnings: 58Warning 1292 Truncated incorrect kill_idle_transaction value: '4294967295' 59SHOW GLOBAL VARIABLES LIKE 'kill_idle_transaction'; 60Variable_name Value 61kill_idle_transaction 31536000 62SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE variable_name='kill_idle_transaction'; 63VARIABLE_NAME VARIABLE_VALUE 64KILL_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 @@innodb_kill_idle_transaction; 68@@innodb_kill_idle_transaction 6931536000 70SET GLOBAL kill_idle_transaction= 31536000; 71SHOW GLOBAL VARIABLES LIKE 'kill_idle_transaction'; 72Variable_name Value 73kill_idle_transaction 31536000 74SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE variable_name='kill_idle_transaction'; 75VARIABLE_NAME VARIABLE_VALUE 76KILL_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 @@innodb_kill_idle_transaction; 80@@innodb_kill_idle_transaction 8131536000 82SET GLOBAL kill_idle_transaction= @saved_kill_idle_transaction; 83