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; 46SELECT @@global.innodb_api_bk_commit_interval; 47@@global.innodb_api_bk_commit_interval 481 49SET global innodb_api_bk_commit_interval=100000; 50SELECT @@global.innodb_api_bk_commit_interval; 51@@global.innodb_api_bk_commit_interval 52100000 53SET global innodb_api_bk_commit_interval=1073741824; 54SELECT @@global.innodb_api_bk_commit_interval; 55@@global.innodb_api_bk_commit_interval 561073741824 57SET global innodb_api_bk_commit_interval=0; 58Warnings: 59Warning 1292 Truncated incorrect innodb_api_bk_commit_interval value: '0' 60SELECT @@global.innodb_api_bk_commit_interval; 61@@global.innodb_api_bk_commit_interval 621 63SET global innodb_api_bk_commit_interval=-1024; 64Warnings: 65Warning 1292 Truncated incorrect innodb_api_bk_commit_interval value: '-1024' 66SELECT @@global.innodb_api_bk_commit_interval; 67@@global.innodb_api_bk_commit_interval 681 69SET global innodb_api_bk_commit_interval=1073741825; 70Warnings: 71Warning 1292 Truncated incorrect innodb_api_bk_commit_interval value: '1073741825' 72SELECT @@global.innodb_api_bk_commit_interval; 73@@global.innodb_api_bk_commit_interval 741073741824 75SET global innodb_api_bk_commit_interval=4294967295; 76Warnings: 77Warning 1292 Truncated incorrect innodb_api_bk_commit_interval value: '4294967295' 78SELECT @@global.innodb_api_bk_commit_interval; 79@@global.innodb_api_bk_commit_interval 801073741824 81SET global innodb_api_bk_commit_interval=1.1; 82ERROR 42000: Incorrect argument type to variable 'innodb_api_bk_commit_interval' 83SET global innodb_api_bk_commit_interval=1e1; 84ERROR 42000: Incorrect argument type to variable 'innodb_api_bk_commit_interval' 85SET global innodb_api_bk_commit_interval="foo"; 86ERROR 42000: Incorrect argument type to variable 'innodb_api_bk_commit_interval' 87SET global innodb_api_bk_commit_interval=-7; 88Warnings: 89Warning 1292 Truncated incorrect innodb_api_bk_commit_interval value: '-7' 90SELECT @@global.innodb_api_bk_commit_interval; 91@@global.innodb_api_bk_commit_interval 921 93SELECT * FROM information_schema.global_variables 94WHERE variable_name='innodb_api_bk_commit_interval'; 95VARIABLE_NAME VARIABLE_VALUE 96INNODB_API_BK_COMMIT_INTERVAL 1 97SET @@global.innodb_api_bk_commit_interval = @start_global_value; 98SELECT @@global.innodb_api_bk_commit_interval; 99@@global.innodb_api_bk_commit_interval 1005 101