diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/t/innodb_io_capacity_max_basic.test')
-rw-r--r-- | mysql-test/suite/sys_vars/t/innodb_io_capacity_max_basic.test | 21 |
1 files changed, 16 insertions, 5 deletions
diff --git a/mysql-test/suite/sys_vars/t/innodb_io_capacity_max_basic.test b/mysql-test/suite/sys_vars/t/innodb_io_capacity_max_basic.test index 125ceaa1c30..cedc6c0c45e 100644 --- a/mysql-test/suite/sys_vars/t/innodb_io_capacity_max_basic.test +++ b/mysql-test/suite/sys_vars/t/innodb_io_capacity_max_basic.test @@ -25,7 +25,7 @@ select * from information_schema.global_variables where variable_name='innodb_io select * from information_schema.session_variables where variable_name='innodb_io_capacity_max'; # -# show that it's writable. Allowed value cannot be lower than innodb_io_capacity +# show that it's writable. # set global innodb_io_capacity_max=@start_innodb_capacity + 1; select @@global.innodb_io_capacity_max; @@ -45,15 +45,26 @@ set global innodb_io_capacity_max=1e1; set global innodb_io_capacity_max="foo"; # -# can't set it below innodb_io_capacity +# Setting io_capacity_max lower than io_capacity affects also io_capacity # -set global innodb_io_capacity_max=@start_innodb_capacity - 1; +set global innodb_io_capacity_max=1000; +set global innodb_io_capacity=500; +set global innodb_io_capacity_max=400; select @@global.innodb_io_capacity_max; +select @@global.innodb_io_capacity; select * from information_schema.global_variables where variable_name='innodb_io_capacity_max'; -set global innodb_io_capacity_max=-7; +select * from information_schema.global_variables where variable_name='innodb_io_capacity'; + +# +# Setting io_capacity higher than io_capacity_max affects also io_capacity_max +# +set global innodb_io_capacity_max=1000; +set global innodb_io_capacity=500; +set global innodb_io_capacity=1400; select @@global.innodb_io_capacity_max; +select @@global.innodb_io_capacity; select * from information_schema.global_variables where variable_name='innodb_io_capacity_max'; - +select * from information_schema.global_variables where variable_name='innodb_io_capacity'; # # min/max values # |