Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_io_capacity;
2 SELECT @start_global_value;
3 @start_global_value
4 200
5 Valid value 100 or more
6 select @@global.innodb_io_capacity > 99;
7 @@global.innodb_io_capacity > 99
8 1
9 select @@global.innodb_io_capacity;
10 @@global.innodb_io_capacity
11 200
12 select @@session.innodb_io_capacity;
13 ERROR HY000: Variable 'innodb_io_capacity' is a GLOBAL variable
14 show global variables like 'innodb_io_capacity';
15 Variable_name Value
16 innodb_io_capacity 200
17 show session variables like 'innodb_io_capacity';
18 Variable_name Value
19 innodb_io_capacity 200
20 select * from information_schema.global_variables where variable_name='innodb_io_capacity';
21 VARIABLE_NAME VARIABLE_VALUE
22 INNODB_IO_CAPACITY 200
23 select * from information_schema.session_variables where variable_name='innodb_io_capacity';
24 VARIABLE_NAME VARIABLE_VALUE
25 INNODB_IO_CAPACITY 200
26 set global innodb_io_capacity=123;
27 select @@global.innodb_io_capacity;
28 @@global.innodb_io_capacity
29 123
30 select * from information_schema.global_variables where variable_name='innodb_io_capacity';
31 VARIABLE_NAME VARIABLE_VALUE
32 INNODB_IO_CAPACITY 123
33 select * from information_schema.session_variables where variable_name='innodb_io_capacity';
34 VARIABLE_NAME VARIABLE_VALUE
35 INNODB_IO_CAPACITY 123
36 set session innodb_io_capacity=444;
37 ERROR HY000: Variable 'innodb_io_capacity' is a GLOBAL variable and should be set with SET GLOBAL
38 set global innodb_io_capacity=1.1;
39 ERROR 42000: Incorrect argument type to variable 'innodb_io_capacity'
40 set global innodb_io_capacity=1e1;
41 ERROR 42000: Incorrect argument type to variable 'innodb_io_capacity'
42 set global innodb_io_capacity="foo";
43 ERROR 42000: Incorrect argument type to variable 'innodb_io_capacity'
44 set global innodb_io_capacity=7;
45 Warnings:
46 Warning 1292 Truncated incorrect innodb_io_capacity value: '7'
47 select @@global.innodb_io_capacity;
48 @@global.innodb_io_capacity
49 100
50 select * from information_schema.global_variables where variable_name='innodb_io_capacity';
51 VARIABLE_NAME VARIABLE_VALUE
52 INNODB_IO_CAPACITY 100
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 information_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=100;
63 select @@global.innodb_io_capacity;
64 @@global.innodb_io_capacity
65 100
66 SET @@global.innodb_io_capacity = @start_global_value;
67 SELECT @@global.innodb_io_capacity;
68 @@global.innodb_io_capacity
69 200