1SET @start_global_value = @@global.innodb_change_buffer_max_size; 2SELECT @start_global_value; 3@start_global_value 425 5Valid values are between 0 and 50 6select @@global.innodb_change_buffer_max_size between 0 and 50; 7@@global.innodb_change_buffer_max_size between 0 and 50 81 9select @@global.innodb_change_buffer_max_size; 10@@global.innodb_change_buffer_max_size 1125 12select @@session.innodb_change_buffer_max_size; 13ERROR HY000: Variable 'innodb_change_buffer_max_size' is a GLOBAL variable 14show global variables like 'innodb_change_buffer_max_size'; 15Variable_name Value 16innodb_change_buffer_max_size 25 17show session variables like 'innodb_change_buffer_max_size'; 18Variable_name Value 19innodb_change_buffer_max_size 25 20select * from information_schema.global_variables where variable_name='innodb_change_buffer_max_size'; 21VARIABLE_NAME VARIABLE_VALUE 22INNODB_CHANGE_BUFFER_MAX_SIZE 25 23select * from information_schema.session_variables where variable_name='innodb_change_buffer_max_size'; 24VARIABLE_NAME VARIABLE_VALUE 25INNODB_CHANGE_BUFFER_MAX_SIZE 25 26set global innodb_change_buffer_max_size=10; 27select @@global.innodb_change_buffer_max_size; 28@@global.innodb_change_buffer_max_size 2910 30select * from information_schema.global_variables where variable_name='innodb_change_buffer_max_size'; 31VARIABLE_NAME VARIABLE_VALUE 32INNODB_CHANGE_BUFFER_MAX_SIZE 10 33select * from information_schema.session_variables where variable_name='innodb_change_buffer_max_size'; 34VARIABLE_NAME VARIABLE_VALUE 35INNODB_CHANGE_BUFFER_MAX_SIZE 10 36set session innodb_change_buffer_max_size=1; 37ERROR HY000: Variable 'innodb_change_buffer_max_size' is a GLOBAL variable and should be set with SET GLOBAL 38set global innodb_change_buffer_max_size=1.1; 39ERROR 42000: Incorrect argument type to variable 'innodb_change_buffer_max_size' 40set global innodb_change_buffer_max_size=1e1; 41ERROR 42000: Incorrect argument type to variable 'innodb_change_buffer_max_size' 42set global innodb_change_buffer_max_size="foo"; 43ERROR 42000: Incorrect argument type to variable 'innodb_change_buffer_max_size' 44set global innodb_change_buffer_max_size=-7; 45Warnings: 46Warning 1292 Truncated incorrect innodb_change_buffer_max_size value: '-7' 47select @@global.innodb_change_buffer_max_size; 48@@global.innodb_change_buffer_max_size 490 50select * from information_schema.global_variables where variable_name='innodb_change_buffer_max_size'; 51VARIABLE_NAME VARIABLE_VALUE 52INNODB_CHANGE_BUFFER_MAX_SIZE 0 53set global innodb_change_buffer_max_size=56; 54Warnings: 55Warning 1292 Truncated incorrect innodb_change_buffer_max_size value: '56' 56select @@global.innodb_change_buffer_max_size; 57@@global.innodb_change_buffer_max_size 5850 59select * from information_schema.global_variables where variable_name='innodb_change_buffer_max_size'; 60VARIABLE_NAME VARIABLE_VALUE 61INNODB_CHANGE_BUFFER_MAX_SIZE 50 62set global innodb_change_buffer_max_size=0; 63select @@global.innodb_change_buffer_max_size; 64@@global.innodb_change_buffer_max_size 650 66set global innodb_change_buffer_max_size=50; 67select @@global.innodb_change_buffer_max_size; 68@@global.innodb_change_buffer_max_size 6950 70set global innodb_change_buffer_max_size=DEFAULT; 71select @@global.innodb_change_buffer_max_size; 72@@global.innodb_change_buffer_max_size 7325 74SET @@global.innodb_change_buffer_max_size = @start_global_value; 75SELECT @@global.innodb_change_buffer_max_size; 76@@global.innodb_change_buffer_max_size 7725 78