Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_io_capacity_max_basic.test

raw
1
2
3 # 2012-04-02 - Added
4 #
5
6 --source include/have_innodb.inc
7
8 SET @start_innodb_max_capacity = @@global.innodb_io_capacity_max;
9 SELECT @start_innodb_max_capacity;
10
11 SET @start_innodb_capacity = @@global.innodb_io_capacity;
12 SELECT @start_innodb_capacity;
13
14 #
15 # exists as global only
16 #
17 --echo Valid value 100 or more
18 select @@global.innodb_io_capacity_max > 99;
19 select @@global.innodb_io_capacity_max;
20 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
21 select @@session.innodb_io_capacity_max;
22 show global variables like 'innodb_io_capacity_max';
23 show session variables like 'innodb_io_capacity_max';
24 select * from information_schema.global_variables where variable_name='innodb_io_capacity_max';
25 select * from information_schema.session_variables where variable_name='innodb_io_capacity_max';
26
27 #
28 # show that it's writable.
29 #
30 set global innodb_io_capacity_max=@start_innodb_capacity + 1;
31 select @@global.innodb_io_capacity_max;
32 select * from information_schema.global_variables where variable_name='innodb_io_capacity_max';
33 select * from information_schema.session_variables where variable_name='innodb_io_capacity_max';
34 --error ER_GLOBAL_VARIABLE
35 set session innodb_io_capacity_max=444;
36
37 #
38 # incorrect types
39 #
40 --error ER_WRONG_TYPE_FOR_VAR
41 set global innodb_io_capacity_max=1.1;
42 --error ER_WRONG_TYPE_FOR_VAR
43 set global innodb_io_capacity_max=1e1;
44 --error ER_WRONG_TYPE_FOR_VAR
45 set global innodb_io_capacity_max="foo";
46
47 #
48 # Setting io_capacity_max lower than io_capacity affects also io_capacity
49 #
50 set global innodb_io_capacity_max=1000;
51 set global innodb_io_capacity=500;
52 set global innodb_io_capacity_max=400;
53 select @@global.innodb_io_capacity_max;
54 select @@global.innodb_io_capacity;
55 select * from information_schema.global_variables where variable_name='innodb_io_capacity_max';
56 select * from information_schema.global_variables where variable_name='innodb_io_capacity';
57
58 #
59 # Setting io_capacity higher than io_capacity_max affects also io_capacity_max
60 #
61 set global innodb_io_capacity_max=1000;
62 set global innodb_io_capacity=500;
63 set global innodb_io_capacity=1400;
64 select @@global.innodb_io_capacity_max;
65 select @@global.innodb_io_capacity;
66 select * from information_schema.global_variables where variable_name='innodb_io_capacity_max';
67 select * from information_schema.global_variables where variable_name='innodb_io_capacity';
68 #
69 # min/max values
70 #
71 # first set innodb_io_cpaacity lower
72 set global innodb_io_capacity=100;
73 set global innodb_io_capacity_max=100;
74 select @@global.innodb_io_capacity_max;
75
76 #
77 # cleanup
78 #
79
80 SET @@global.innodb_io_capacity_max = @start_innodb_max_capacity;
81 SELECT @@global.innodb_io_capacity_max;
82
83 SET @@global.innodb_io_capacity = @start_innodb_capacity;
84 SELECT @@global.innodb_io_capacity;
85