Debian Codegraph @

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

raw
1 SET @global_start_value = @@global.innodb_flushing_avg_loops;
2 SELECT @global_start_value;
3 @global_start_value
4 30
5 '#--------------------FN_DYNVARS_046_01------------------------#'
6 SET @@global.innodb_flushing_avg_loops = 1;
7 SET @@global.innodb_flushing_avg_loops = DEFAULT;
8 SELECT @@global.innodb_flushing_avg_loops;
9 @@global.innodb_flushing_avg_loops
10 30
11 '#---------------------FN_DYNVARS_046_02-------------------------#'
12 SET innodb_flushing_avg_loops = 1;
13 ERROR HY000: Variable 'innodb_flushing_avg_loops' is a GLOBAL variable and should be set with SET GLOBAL
14 SELECT @@innodb_flushing_avg_loops;
15 @@innodb_flushing_avg_loops
16 30
17 SELECT local.innodb_flushing_avg_loops;
18 ERROR 42S02: Unknown table 'local' in field list
19 SET global innodb_flushing_avg_loops = 1;
20 SELECT @@global.innodb_flushing_avg_loops;
21 @@global.innodb_flushing_avg_loops
22 1
23 '#--------------------FN_DYNVARS_046_03------------------------#'
24 SET @@global.innodb_flushing_avg_loops = 1;
25 SELECT @@global.innodb_flushing_avg_loops;
26 @@global.innodb_flushing_avg_loops
27 1
28 SET @@global.innodb_flushing_avg_loops = 60;
29 SELECT @@global.innodb_flushing_avg_loops;
30 @@global.innodb_flushing_avg_loops
31 60
32 SET @@global.innodb_flushing_avg_loops = 1000;
33 SELECT @@global.innodb_flushing_avg_loops;
34 @@global.innodb_flushing_avg_loops
35 1000
36 '#--------------------FN_DYNVARS_046_04-------------------------#'
37 SET @@global.innodb_flushing_avg_loops = -1;
38 Warnings:
39 Warning 1292 Truncated incorrect innodb_flushing_avg_loops value: '-1'
40 SELECT @@global.innodb_flushing_avg_loops;
41 @@global.innodb_flushing_avg_loops
42 1
43 SET @@global.innodb_flushing_avg_loops = "T";
44 ERROR 42000: Incorrect argument type to variable 'innodb_flushing_avg_loops'
45 SELECT @@global.innodb_flushing_avg_loops;
46 @@global.innodb_flushing_avg_loops
47 1
48 SET @@global.innodb_flushing_avg_loops = "Y";
49 ERROR 42000: Incorrect argument type to variable 'innodb_flushing_avg_loops'
50 SELECT @@global.innodb_flushing_avg_loops;
51 @@global.innodb_flushing_avg_loops
52 1
53 SET @@global.innodb_flushing_avg_loops = 1001;
54 Warnings:
55 Warning 1292 Truncated incorrect innodb_flushing_avg_loops value: '1001'
56 SELECT @@global.innodb_flushing_avg_loops;
57 @@global.innodb_flushing_avg_loops
58 1000
59 SET @@global.innodb_flushing_avg_loops = ' ';
60 ERROR 42000: Incorrect argument type to variable 'innodb_flushing_avg_loops'
61 SELECT @@global.innodb_flushing_avg_loops;
62 @@global.innodb_flushing_avg_loops
63 1000
64 SET @@global.innodb_flushing_avg_loops = " ";
65 ERROR 42000: Incorrect argument type to variable 'innodb_flushing_avg_loops'
66 SELECT @@global.innodb_flushing_avg_loops;
67 @@global.innodb_flushing_avg_loops
68 1000
69 '#----------------------FN_DYNVARS_046_05------------------------#'
70 SELECT @@global.innodb_flushing_avg_loops =
71 VARIABLE_VALUE FROM performance_schema.global_variables
72 WHERE VARIABLE_NAME='innodb_flushing_avg_loops';
73 @@global.innodb_flushing_avg_loops =
74 VARIABLE_VALUE
75 1
76 SELECT @@global.innodb_flushing_avg_loops;
77 @@global.innodb_flushing_avg_loops
78 1000
79 SELECT VARIABLE_VALUE FROM performance_schema.global_variables
80 WHERE VARIABLE_NAME='innodb_flushing_avg_loops';
81 VARIABLE_VALUE
82 1000
83 '#---------------------FN_DYNVARS_046_06-------------------------#'
84 SET @@global.innodb_flushing_avg_loops = OFF;
85 ERROR 42000: Incorrect argument type to variable 'innodb_flushing_avg_loops'
86 SELECT @@global.innodb_flushing_avg_loops;
87 @@global.innodb_flushing_avg_loops
88 1000
89 SET @@global.innodb_flushing_avg_loops = ON;
90 ERROR 42000: Incorrect argument type to variable 'innodb_flushing_avg_loops'
91 SELECT @@global.innodb_flushing_avg_loops;
92 @@global.innodb_flushing_avg_loops
93 1000
94 '#---------------------FN_DYNVARS_046_07----------------------#'
95 SET @@global.innodb_flushing_avg_loops = TRUE;
96 SELECT @@global.innodb_flushing_avg_loops;
97 @@global.innodb_flushing_avg_loops
98 1
99 SET @@global.innodb_flushing_avg_loops = FALSE;
100 Warnings:
101 Warning 1292 Truncated incorrect innodb_flushing_avg_loops value: '0'
102 SELECT @@global.innodb_flushing_avg_loops;
103 @@global.innodb_flushing_avg_loops
104 1
105 SET @@global.innodb_flushing_avg_loops = @global_start_value;
106 SELECT @@global.innodb_flushing_avg_loops;
107 @@global.innodb_flushing_avg_loops
108 30