1
SET @start_global_value = @@global.innodb_change_buffering_debug;
2
SELECT @start_global_value;
5
select @@global.innodb_change_buffering_debug in (0, 1);
6
@@global.innodb_change_buffering_debug in (0, 1)
8
select @@global.innodb_change_buffering_debug;
9
@@global.innodb_change_buffering_debug
11
select @@session.innodb_change_buffering_debug;
12
ERROR HY000: Variable 'innodb_change_buffering_debug' is a GLOBAL variable
13
show global variables like 'innodb_change_buffering_debug';
15
innodb_change_buffering_debug 0
16
show session variables like 'innodb_change_buffering_debug';
18
innodb_change_buffering_debug 0
19
select * from information_schema.global_variables where variable_name='innodb_change_buffering_debug';
20
VARIABLE_NAME VARIABLE_VALUE
21
INNODB_CHANGE_BUFFERING_DEBUG 0
22
select * from information_schema.session_variables where variable_name='innodb_change_buffering_debug';
23
VARIABLE_NAME VARIABLE_VALUE
24
INNODB_CHANGE_BUFFERING_DEBUG 0
25
set global innodb_change_buffering_debug=1;
26
select @@global.innodb_change_buffering_debug;
27
@@global.innodb_change_buffering_debug
29
select * from information_schema.global_variables where variable_name='innodb_change_buffering_debug';
30
VARIABLE_NAME VARIABLE_VALUE
31
INNODB_CHANGE_BUFFERING_DEBUG 1
32
select * from information_schema.session_variables where variable_name='innodb_change_buffering_debug';
33
VARIABLE_NAME VARIABLE_VALUE
34
INNODB_CHANGE_BUFFERING_DEBUG 1
35
set @@global.innodb_change_buffering_debug=0;
36
select @@global.innodb_change_buffering_debug;
37
@@global.innodb_change_buffering_debug
39
select * from information_schema.global_variables where variable_name='innodb_change_buffering_debug';
40
VARIABLE_NAME VARIABLE_VALUE
41
INNODB_CHANGE_BUFFERING_DEBUG 0
42
select * from information_schema.session_variables where variable_name='innodb_change_buffering_debug';
43
VARIABLE_NAME VARIABLE_VALUE
44
INNODB_CHANGE_BUFFERING_DEBUG 0
45
set session innodb_change_buffering_debug='some';
46
ERROR HY000: Variable 'innodb_change_buffering_debug' is a GLOBAL variable and should be set with SET GLOBAL
47
set @@session.innodb_change_buffering_debug='some';
48
ERROR HY000: Variable 'innodb_change_buffering_debug' is a GLOBAL variable and should be set with SET GLOBAL
49
set global innodb_change_buffering_debug=1.1;
50
ERROR 42000: Incorrect argument type to variable 'innodb_change_buffering_debug'
51
set global innodb_change_buffering_debug='foo';
52
ERROR 42000: Incorrect argument type to variable 'innodb_change_buffering_debug'
53
set global innodb_change_buffering_debug=-2;
55
Warning 1292 Truncated incorrect innodb_change_buffering_debug value: '-2'
56
set global innodb_change_buffering_debug=1e1;
57
ERROR 42000: Incorrect argument type to variable 'innodb_change_buffering_debug'
58
SET @@global.innodb_change_buffering_debug = @start_global_value;
59
SELECT @@global.innodb_change_buffering_debug;
60
@@global.innodb_change_buffering_debug