1SET @start_innodb_max_capacity = @@global.innodb_io_capacity_max; 2SELECT @start_innodb_max_capacity; 3@start_innodb_max_capacity 42000 5SET @start_innodb_capacity = @@global.innodb_io_capacity; 6SELECT @start_innodb_capacity; 7@start_innodb_capacity 8200 9Valid value 100 or more 10select @@global.innodb_io_capacity_max > 99; 11@@global.innodb_io_capacity_max > 99 121 13select @@global.innodb_io_capacity_max; 14@@global.innodb_io_capacity_max 152000 16select @@session.innodb_io_capacity_max; 17ERROR HY000: Variable 'innodb_io_capacity_max' is a GLOBAL variable 18show global variables like 'innodb_io_capacity_max'; 19Variable_name Value 20innodb_io_capacity_max 2000 21show session variables like 'innodb_io_capacity_max'; 22Variable_name Value 23innodb_io_capacity_max 2000 24select * from information_schema.global_variables where variable_name='innodb_io_capacity_max'; 25VARIABLE_NAME VARIABLE_VALUE 26INNODB_IO_CAPACITY_MAX 2000 27select * from information_schema.session_variables where variable_name='innodb_io_capacity_max'; 28VARIABLE_NAME VARIABLE_VALUE 29INNODB_IO_CAPACITY_MAX 2000 30set global innodb_io_capacity_max=@start_innodb_capacity + 1; 31select @@global.innodb_io_capacity_max; 32@@global.innodb_io_capacity_max 33201 34select * from information_schema.global_variables where variable_name='innodb_io_capacity_max'; 35VARIABLE_NAME VARIABLE_VALUE 36INNODB_IO_CAPACITY_MAX 201 37select * from information_schema.session_variables where variable_name='innodb_io_capacity_max'; 38VARIABLE_NAME VARIABLE_VALUE 39INNODB_IO_CAPACITY_MAX 201 40set session innodb_io_capacity_max=444; 41ERROR HY000: Variable 'innodb_io_capacity_max' is a GLOBAL variable and should be set with SET GLOBAL 42set global innodb_io_capacity_max=1.1; 43ERROR 42000: Incorrect argument type to variable 'innodb_io_capacity_max' 44set global innodb_io_capacity_max=1e1; 45ERROR 42000: Incorrect argument type to variable 'innodb_io_capacity_max' 46set global innodb_io_capacity_max="foo"; 47ERROR 42000: Incorrect argument type to variable 'innodb_io_capacity_max' 48set global innodb_io_capacity_max=" "; 49ERROR 42000: Incorrect argument type to variable 'innodb_io_capacity_max' 50SET @@global.innodb_io_capacity_max = DEFAULT; 51select @@global.innodb_io_capacity_max IN (18446744073709551615,4294967295); 52@@global.innodb_io_capacity_max IN (18446744073709551615,4294967295) 531 54set global innodb_io_capacity_max=@start_innodb_capacity - 1; 55Warnings: 56Warning 1210 innodb_io_capacity_max cannot be set lower than innodb_io_capacity. 57Warning 1210 Setting innodb_io_capacity_max to 200 58select @@global.innodb_io_capacity_max; 59@@global.innodb_io_capacity_max 60200 61select * from information_schema.global_variables where variable_name='innodb_io_capacity_max'; 62VARIABLE_NAME VARIABLE_VALUE 63INNODB_IO_CAPACITY_MAX 200 64set global innodb_io_capacity_max=-7; 65Warnings: 66Warning 1292 Truncated incorrect innodb_io_capacity_max value: '-7' 67Warning 1210 innodb_io_capacity_max cannot be set lower than innodb_io_capacity. 68Warning 1210 Setting innodb_io_capacity_max to 200 69select @@global.innodb_io_capacity_max; 70@@global.innodb_io_capacity_max 71200 72select * from information_schema.global_variables where variable_name='innodb_io_capacity_max'; 73VARIABLE_NAME VARIABLE_VALUE 74INNODB_IO_CAPACITY_MAX 200 75set global innodb_io_capacity=100; 76set global innodb_io_capacity_max=100; 77select @@global.innodb_io_capacity_max; 78@@global.innodb_io_capacity_max 79100 80SET @@global.innodb_io_capacity_max = @start_innodb_max_capacity; 81SELECT @@global.innodb_io_capacity_max; 82@@global.innodb_io_capacity_max 832000 84SET @@global.innodb_io_capacity = @start_innodb_capacity; 85SELECT @@global.innodb_io_capacity; 86@@global.innodb_io_capacity 87200 88