summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sys_vars/t/innodb_io_capacity_max_basic.test
diff options
context:
space:
mode:
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.test21
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
#