Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_flush_sync;
2 Valid values are 'ON' and 'OFF'
3 select @@global.innodb_flush_sync in (0, 1);
4 @@global.innodb_flush_sync in (0, 1)
5 1
6 select @@session.innodb_flush_sync;
7 ERROR HY000: Variable 'innodb_flush_sync' is a GLOBAL variable
8 SET GLOBAL innodb_flush_sync = ON;
9 show global variables like 'innodb_flush_sync';
10 Variable_name Value
11 innodb_flush_sync ON
12 show session variables like 'innodb_flush_sync';
13 Variable_name Value
14 innodb_flush_sync ON
15 select * from information_schema.global_variables where variable_name='innodb_flush_sync';
16 VARIABLE_NAME VARIABLE_VALUE
17 INNODB_FLUSH_SYNC ON
18 select * from information_schema.session_variables where variable_name='innodb_flush_sync';
19 VARIABLE_NAME VARIABLE_VALUE
20 INNODB_FLUSH_SYNC ON
21 set global innodb_flush_sync='OFF';
22 select @@global.innodb_flush_sync;
23 @@global.innodb_flush_sync
24 0
25 select * from information_schema.global_variables where variable_name='innodb_flush_sync';
26 VARIABLE_NAME VARIABLE_VALUE
27 INNODB_FLUSH_SYNC OFF
28 select * from information_schema.session_variables where variable_name='innodb_flush_sync';
29 VARIABLE_NAME VARIABLE_VALUE
30 INNODB_FLUSH_SYNC OFF
31 set @@global.innodb_flush_sync=1;
32 select @@global.innodb_flush_sync;
33 @@global.innodb_flush_sync
34 1
35 select * from information_schema.global_variables where variable_name='innodb_flush_sync';
36 VARIABLE_NAME VARIABLE_VALUE
37 INNODB_FLUSH_SYNC ON
38 select * from information_schema.session_variables where variable_name='innodb_flush_sync';
39 VARIABLE_NAME VARIABLE_VALUE
40 INNODB_FLUSH_SYNC ON
41 set global innodb_flush_sync=0;
42 select @@global.innodb_flush_sync;
43 @@global.innodb_flush_sync
44 0
45 select * from information_schema.global_variables where variable_name='innodb_flush_sync';
46 VARIABLE_NAME VARIABLE_VALUE
47 INNODB_FLUSH_SYNC OFF
48 select * from information_schema.session_variables where variable_name='innodb_flush_sync';
49 VARIABLE_NAME VARIABLE_VALUE
50 INNODB_FLUSH_SYNC OFF
51 set @@global.innodb_flush_sync='ON';
52 select @@global.innodb_flush_sync;
53 @@global.innodb_flush_sync
54 1
55 select * from information_schema.global_variables where variable_name='innodb_flush_sync';
56 VARIABLE_NAME VARIABLE_VALUE
57 INNODB_FLUSH_SYNC ON
58 select * from information_schema.session_variables where variable_name='innodb_flush_sync';
59 VARIABLE_NAME VARIABLE_VALUE
60 INNODB_FLUSH_SYNC ON
61 set session innodb_flush_sync='OFF';
62 ERROR HY000: Variable 'innodb_flush_sync' is a GLOBAL variable and should be set with SET GLOBAL
63 set @@session.innodb_flush_sync='ON';
64 ERROR HY000: Variable 'innodb_flush_sync' is a GLOBAL variable and should be set with SET GLOBAL
65 set global innodb_flush_sync=1.1;
66 ERROR 42000: Incorrect argument type to variable 'innodb_flush_sync'
67 set global innodb_flush_sync=1e1;
68 ERROR 42000: Incorrect argument type to variable 'innodb_flush_sync'
69 set global innodb_flush_sync=2;
70 ERROR 42000: Variable 'innodb_flush_sync' can't be set to the value of '2'
71 set global innodb_flush_sync=-3;
72 ERROR 42000: Variable 'innodb_flush_sync' can't be set to the value of '-3'
73 select @@global.innodb_flush_sync;
74 @@global.innodb_flush_sync
75 1
76 select * from information_schema.global_variables where variable_name='innodb_flush_sync';
77 VARIABLE_NAME VARIABLE_VALUE
78 INNODB_FLUSH_SYNC ON
79 select * from information_schema.session_variables where variable_name='innodb_flush_sync';
80 VARIABLE_NAME VARIABLE_VALUE
81 INNODB_FLUSH_SYNC ON
82 set global innodb_flush_sync='AUTO';
83 ERROR 42000: Variable 'innodb_flush_sync' can't be set to the value of 'AUTO'
84 SET @@global.innodb_flush_sync = @start_global_value;