Debian Codegraph @

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

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