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
7 SET @start_innodb_max_capacity = @@global.innodb_io_capacity_max;
8 SELECT @start_innodb_max_capacity;
9
10 SET @start_innodb_capacity = @@global.innodb_io_capacity;
11 SELECT @start_innodb_capacity;
12
13 #
14 # exists as global only
15 #
16 --echo Valid value 100 or more
17 select @@global.innodb_io_capacity_max > 99;
18 select @@global.innodb_io_capacity_max;
19 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
20 select @@session.innodb_io_capacity_max;
21 show global variables like 'innodb_io_capacity_max';
22 show session variables like 'innodb_io_capacity_max';
23 --disable_warnings
24 select * from performance_schema.global_variables where variable_name='innodb_io_capacity_max';
25 select * from performance_schema.session_variables where variable_name='innodb_io_capacity_max';
26 --enable_warnings
27
28 #
29 # show that it's writable. Allowed value cannot be lower than innodb_io_capacity
30 #
31 set global innodb_io_capacity_max=@start_innodb_capacity + 1;
32 select @@global.innodb_io_capacity_max;
33 --disable_warnings
34 select * from performance_schema.global_variables where variable_name='innodb_io_capacity_max';
35 select * from performance_schema.session_variables where variable_name='innodb_io_capacity_max';
36 --enable_warnings
37 --error ER_GLOBAL_VARIABLE
38 set session innodb_io_capacity_max=444;
39
40 #
41 # incorrect types
42 #
43 --error ER_WRONG_TYPE_FOR_VAR
44 set global innodb_io_capacity_max=1.1;
45 --error ER_WRONG_TYPE_FOR_VAR
46 set global innodb_io_capacity_max=1e1;
47 --error ER_WRONG_TYPE_FOR_VAR
48 set global innodb_io_capacity_max="foo";
49 --error ER_WRONG_TYPE_FOR_VAR
50 set global innodb_io_capacity_max=" ";
51
52 #
53 # check the default value
54 #
55
56 SET @@global.innodb_io_capacity_max = DEFAULT;
57 select @@global.innodb_io_capacity_max IN (18446744073709551615,4294967295);
58
59 #
60 # can't set it below innodb_io_capacity
61 #
62 set global innodb_io_capacity_max=@start_innodb_capacity - 1;
63 select @@global.innodb_io_capacity_max;
64 --disable_warnings
65 select * from performance_schema.global_variables where variable_name='innodb_io_capacity_max';
66 --enable_warnings
67 set global innodb_io_capacity_max=-7;
68 select @@global.innodb_io_capacity_max;
69 --disable_warnings
70 select * from performance_schema.global_variables where variable_name='innodb_io_capacity_max';
71 --enable_warnings
72
73 #
74 # min/max values
75 #
76 # first set innodb_io_cpaacity lower
77 set global innodb_io_capacity=100;
78 set global innodb_io_capacity_max=100;
79 select @@global.innodb_io_capacity_max;
80
81 #
82 # cleanup
83 #
84
85 SET @@global.innodb_io_capacity_max = @start_innodb_max_capacity;
86 SELECT @@global.innodb_io_capacity_max;
87
88 SET @@global.innodb_io_capacity = @start_innodb_capacity;
89 SELECT @@global.innodb_io_capacity;
90