1SET @start_global_value = @@global.innodb_api_bk_commit_interval; 2SELECT @start_global_value; 3@start_global_value 45 5Valid values are positive number 6SELECT @@global.innodb_api_bk_commit_interval > 0; 7@@global.innodb_api_bk_commit_interval > 0 81 9SELECT @@global.innodb_api_bk_commit_interval <= 1024*1024*1024; 10@@global.innodb_api_bk_commit_interval <= 1024*1024*1024 111 12SELECT @@global.innodb_api_bk_commit_interval; 13@@global.innodb_api_bk_commit_interval 145 15SELECT @@session.innodb_api_bk_commit_interval; 16ERROR HY000: Variable 'innodb_api_bk_commit_interval' is a GLOBAL variable 17SHOW global variables LIKE 'innodb_api_bk_commit_interval'; 18Variable_name Value 19innodb_api_bk_commit_interval 5 20SHOW session variables LIKE 'innodb_api_bk_commit_interval'; 21Variable_name Value 22innodb_api_bk_commit_interval 5 23SELECT * FROM information_schema.global_variables 24WHERE variable_name='innodb_api_bk_commit_interval'; 25VARIABLE_NAME VARIABLE_VALUE 26INNODB_API_BK_COMMIT_INTERVAL 5 27SELECT * FROM information_schema.session_variables 28WHERE variable_name='innodb_api_bk_commit_interval'; 29VARIABLE_NAME VARIABLE_VALUE 30INNODB_API_BK_COMMIT_INTERVAL 5 31SET global innodb_api_bk_commit_interval=100; 32SELECT @@global.innodb_api_bk_commit_interval; 33@@global.innodb_api_bk_commit_interval 34100 35SELECT * FROM information_schema.global_variables 36WHERE variable_name='innodb_api_bk_commit_interval'; 37VARIABLE_NAME VARIABLE_VALUE 38INNODB_API_BK_COMMIT_INTERVAL 100 39SELECT * FROM information_schema.session_variables 40WHERE variable_name='innodb_api_bk_commit_interval'; 41VARIABLE_NAME VARIABLE_VALUE 42INNODB_API_BK_COMMIT_INTERVAL 100 43SET session innodb_api_bk_commit_interval=1; 44ERROR HY000: Variable 'innodb_api_bk_commit_interval' is a GLOBAL variable and should be set with SET GLOBAL 45SET global innodb_api_bk_commit_interval=1.1; 46ERROR 42000: Incorrect argument type to variable 'innodb_api_bk_commit_interval' 47SET global innodb_api_bk_commit_interval=1e1; 48ERROR 42000: Incorrect argument type to variable 'innodb_api_bk_commit_interval' 49SET global innodb_api_bk_commit_interval="foo"; 50ERROR 42000: Incorrect argument type to variable 'innodb_api_bk_commit_interval' 51SET global innodb_api_bk_commit_interval=-7; 52Warnings: 53Warning 1292 Truncated incorrect innodb_api_bk_commit_interval value: '-7' 54SELECT @@global.innodb_api_bk_commit_interval; 55@@global.innodb_api_bk_commit_interval 561 57SELECT * FROM information_schema.global_variables 58WHERE variable_name='innodb_api_bk_commit_interval'; 59VARIABLE_NAME VARIABLE_VALUE 60INNODB_API_BK_COMMIT_INTERVAL 1 61SET @@global.innodb_api_bk_commit_interval = @start_global_value; 62SELECT @@global.innodb_api_bk_commit_interval; 63@@global.innodb_api_bk_commit_interval 645 65