Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_io_capacity_basic.result

raw
1 SET @start_io_capacity = @@global.innodb_io_capacity;
2 SELECT @start_io_capacity;
3 @start_io_capacity
4 200
5 SET @start_max_io_capacity = @@global.innodb_io_capacity_max;
6 SELECT @start_max_io_capacity;
7 @start_max_io_capacity
8 2000
9 Valid value 100 or more
10 select @@global.innodb_io_capacity > 99;
11 @@global.innodb_io_capacity > 99
12 1
13 select @@global.innodb_io_capacity;
14 @@global.innodb_io_capacity
15 200
16 select @@session.innodb_io_capacity;
17 ERROR HY000: Variable 'innodb_io_capacity' is a GLOBAL variable
18 show global variables like 'innodb_io_capacity';
19 Variable_name Value
20 innodb_io_capacity 200
21 show session variables like 'innodb_io_capacity';
22 Variable_name Value
23 innodb_io_capacity 200
24 select * from performance_schema.global_variables where variable_name='innodb_io_capacity';
25 VARIABLE_NAME VARIABLE_VALUE
26 innodb_io_capacity 200
27 select * from performance_schema.session_variables where variable_name='innodb_io_capacity';
28 VARIABLE_NAME VARIABLE_VALUE
29 innodb_io_capacity 200
30 set global innodb_io_capacity=123;
31 select @@global.innodb_io_capacity;
32 @@global.innodb_io_capacity
33 123
34 select * from performance_schema.global_variables where variable_name='innodb_io_capacity';
35 VARIABLE_NAME VARIABLE_VALUE
36 innodb_io_capacity 123
37 select * from performance_schema.session_variables where variable_name='innodb_io_capacity';
38 VARIABLE_NAME VARIABLE_VALUE
39 innodb_io_capacity 123
40 set session innodb_io_capacity=233;
41 ERROR HY000: Variable 'innodb_io_capacity' is a GLOBAL variable and should be set with SET GLOBAL
42 set @@global.innodb_io_capacity=100;
43 set @@global.innodb_io_capacity=DEFAULT;
44 select @@global.innodb_io_capacity;
45 @@global.innodb_io_capacity
46 200
47 set global innodb_io_capacity=1.1;
48 ERROR 42000: Incorrect argument type to variable 'innodb_io_capacity'
49 set global innodb_io_capacity=1e1;
50 ERROR 42000: Incorrect argument type to variable 'innodb_io_capacity'
51 set global innodb_io_capacity="foo";
52 ERROR 42000: Incorrect argument type to variable 'innodb_io_capacity'
53 set global innodb_io_capacity=7;
54 Warnings:
55 Warning 1292 Truncated incorrect innodb_io_capacity value: '7'
56 select @@global.innodb_io_capacity;
57 @@global.innodb_io_capacity
58 100
59 select * from performance_schema.global_variables where variable_name='innodb_io_capacity';
60 VARIABLE_NAME VARIABLE_VALUE
61 innodb_io_capacity 100
62 set global innodb_io_capacity=-7;
63 Warnings:
64 Warning 1292 Truncated incorrect innodb_io_capacity value: '-7'
65 select @@global.innodb_io_capacity;
66 @@global.innodb_io_capacity
67 100
68 select * from performance_schema.global_variables where variable_name='innodb_io_capacity';
69 VARIABLE_NAME VARIABLE_VALUE
70 innodb_io_capacity 100
71 set global innodb_io_capacity=100;
72 select @@global.innodb_io_capacity;
73 @@global.innodb_io_capacity
74 100
75 set global innodb_io_capacity=@start_max_io_capacity;
76 select @@global.innodb_io_capacity;
77 @@global.innodb_io_capacity
78 2000
79 set global innodb_io_capacity=@start_max_io_capacity + 1;
80 Warnings:
81 Warning 1210 innodb_io_capacity cannot be set higher than innodb_io_capacity_max.
82 Warning 1210 Setting innodb_io_capacity to 2000
83 select @@global.innodb_io_capacity;
84 @@global.innodb_io_capacity
85 2000
86 SET @@global.innodb_io_capacity = @start_io_capacity;
87 SELECT @@global.innodb_io_capacity;
88 @@global.innodb_io_capacity
89 200
90 SET @@global.innodb_io_capacity_max = @start_max_io_capacity;
91 SELECT @@global.innodb_io_capacity_max;
92 @@global.innodb_io_capacity_max
93 2000