1SET @global_start_value = @@global.innodb_flushing_avg_loops;
2SELECT @global_start_value;
3@global_start_value
430
5'#--------------------FN_DYNVARS_046_01------------------------#'
6SET @@global.innodb_flushing_avg_loops = 1;
7SET @@global.innodb_flushing_avg_loops = DEFAULT;
8SELECT @@global.innodb_flushing_avg_loops;
9@@global.innodb_flushing_avg_loops
1030
11'#---------------------FN_DYNVARS_046_02-------------------------#'
12SET innodb_flushing_avg_loops = 1;
13ERROR HY000: Variable 'innodb_flushing_avg_loops' is a GLOBAL variable and should be set with SET GLOBAL
14SELECT @@innodb_flushing_avg_loops;
15@@innodb_flushing_avg_loops
1630
17SELECT local.innodb_flushing_avg_loops;
18ERROR 42S02: Unknown table 'local' in field list
19SET global innodb_flushing_avg_loops = 1;
20SELECT @@global.innodb_flushing_avg_loops;
21@@global.innodb_flushing_avg_loops
221
23'#--------------------FN_DYNVARS_046_03------------------------#'
24SET @@global.innodb_flushing_avg_loops = 1;
25SELECT @@global.innodb_flushing_avg_loops;
26@@global.innodb_flushing_avg_loops
271
28SET @@global.innodb_flushing_avg_loops = 60;
29SELECT @@global.innodb_flushing_avg_loops;
30@@global.innodb_flushing_avg_loops
3160
32SET @@global.innodb_flushing_avg_loops = 1000;
33SELECT @@global.innodb_flushing_avg_loops;
34@@global.innodb_flushing_avg_loops
351000
36'#--------------------FN_DYNVARS_046_04-------------------------#'
37SET @@global.innodb_flushing_avg_loops = -1;
38Warnings:
39Warning	1292	Truncated incorrect innodb_flushing_avg_loops value: '-1'
40SELECT @@global.innodb_flushing_avg_loops;
41@@global.innodb_flushing_avg_loops
421
43SET @@global.innodb_flushing_avg_loops = "T";
44ERROR 42000: Incorrect argument type to variable 'innodb_flushing_avg_loops'
45SELECT @@global.innodb_flushing_avg_loops;
46@@global.innodb_flushing_avg_loops
471
48SET @@global.innodb_flushing_avg_loops = "Y";
49ERROR 42000: Incorrect argument type to variable 'innodb_flushing_avg_loops'
50SELECT @@global.innodb_flushing_avg_loops;
51@@global.innodb_flushing_avg_loops
521
53SET @@global.innodb_flushing_avg_loops = 1001;
54Warnings:
55Warning	1292	Truncated incorrect innodb_flushing_avg_loops value: '1001'
56SELECT @@global.innodb_flushing_avg_loops;
57@@global.innodb_flushing_avg_loops
581000
59SET @@global.innodb_flushing_avg_loops = ' ';
60ERROR 42000: Incorrect argument type to variable 'innodb_flushing_avg_loops'
61SELECT @@global.innodb_flushing_avg_loops;
62@@global.innodb_flushing_avg_loops
631000
64SET @@global.innodb_flushing_avg_loops = " ";
65ERROR 42000: Incorrect argument type to variable 'innodb_flushing_avg_loops'
66SELECT @@global.innodb_flushing_avg_loops;
67@@global.innodb_flushing_avg_loops
681000
69'#----------------------FN_DYNVARS_046_05------------------------#'
70SELECT @@global.innodb_flushing_avg_loops =
71VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
72WHERE VARIABLE_NAME='innodb_flushing_avg_loops';
73@@global.innodb_flushing_avg_loops =
74VARIABLE_VALUE
751
76SELECT @@global.innodb_flushing_avg_loops;
77@@global.innodb_flushing_avg_loops
781000
79SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
80WHERE VARIABLE_NAME='innodb_flushing_avg_loops';
81VARIABLE_VALUE
821000
83'#---------------------FN_DYNVARS_046_06-------------------------#'
84SET @@global.innodb_flushing_avg_loops = OFF;
85ERROR 42000: Incorrect argument type to variable 'innodb_flushing_avg_loops'
86SELECT @@global.innodb_flushing_avg_loops;
87@@global.innodb_flushing_avg_loops
881000
89SET @@global.innodb_flushing_avg_loops = ON;
90ERROR 42000: Incorrect argument type to variable 'innodb_flushing_avg_loops'
91SELECT @@global.innodb_flushing_avg_loops;
92@@global.innodb_flushing_avg_loops
931000
94'#---------------------FN_DYNVARS_046_07----------------------#'
95SET @@global.innodb_flushing_avg_loops = TRUE;
96SELECT @@global.innodb_flushing_avg_loops;
97@@global.innodb_flushing_avg_loops
981
99SET @@global.innodb_flushing_avg_loops = FALSE;
100Warnings:
101Warning	1292	Truncated incorrect innodb_flushing_avg_loops value: '0'
102SELECT @@global.innodb_flushing_avg_loops;
103@@global.innodb_flushing_avg_loops
1041
105SET @@global.innodb_flushing_avg_loops = @global_start_value;
106SELECT @@global.innodb_flushing_avg_loops;
107@@global.innodb_flushing_avg_loops
10830
109