Debian Codegraph @

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

raw
1 SET @global_start_value = @@global.innodb_max_dirty_pages_pct;
2 SELECT @global_start_value;
3 @global_start_value
4 90
5 SET @global_start_max_dirty_lwm_value = @@global.innodb_max_dirty_pages_pct_lwm;
6 SELECT @global_start_max_dirty_lwm_value;
7 @global_start_max_dirty_lwm_value
8 10
9 SET @@global.innodb_max_dirty_pages_pct_lwm = 0;
10 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
11 @@global.innodb_max_dirty_pages_pct_lwm
12 0.000000
13 '#--------------------FN_DYNVARS_046_01------------------------#'
14 SET @@global.innodb_max_dirty_pages_pct = 0;
15 SET @@global.innodb_max_dirty_pages_pct = DEFAULT;
16 SELECT @@global.innodb_max_dirty_pages_pct;
17 @@global.innodb_max_dirty_pages_pct
18 90.000000
19 '#---------------------FN_DYNVARS_046_02-------------------------#'
20 SET innodb_max_dirty_pages_pct = 1;
21 ERROR HY000: Variable 'innodb_max_dirty_pages_pct' is a GLOBAL variable and should be set with SET GLOBAL
22 SELECT @@innodb_max_dirty_pages_pct;
23 @@innodb_max_dirty_pages_pct
24 90.000000
25 SELECT local.innodb_max_dirty_pages_pct;
26 ERROR 42S02: Unknown table 'local' in field list
27 SET global innodb_max_dirty_pages_pct = 0;
28 SELECT @@global.innodb_max_dirty_pages_pct;
29 @@global.innodb_max_dirty_pages_pct
30 0.000000
31 '#--------------------FN_DYNVARS_046_03------------------------#'
32 SET @@global.innodb_max_dirty_pages_pct = 0.0;
33 SELECT @@global.innodb_max_dirty_pages_pct;
34 @@global.innodb_max_dirty_pages_pct
35 0.000000
36 SET @@global.innodb_max_dirty_pages_pct = 1;
37 SELECT @@global.innodb_max_dirty_pages_pct;
38 @@global.innodb_max_dirty_pages_pct
39 1.000000
40 SET @@global.innodb_max_dirty_pages_pct = 99;
41 SELECT @@global.innodb_max_dirty_pages_pct;
42 @@global.innodb_max_dirty_pages_pct
43 99.000000
44 '#--------------------FN_DYNVARS_046_04------------------------#'
45 SET @@global.innodb_max_dirty_pages_pct_lwm = @global_start_value - 1;
46 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
47 @@global.innodb_max_dirty_pages_pct_lwm
48 89.000000
49 SET @@global.innodb_max_dirty_pages_pct = @global_start_value - 2;
50 Warnings:
51 Warning 1210 innodb_max_dirty_pages_pct cannot be set lower than innodb_max_dirty_pages_pct_lwm.
52 Warning 1210 Lowering innodb_max_dirty_page_pct_lwm to 88.000000
53 SELECT @@global.innodb_max_dirty_pages_pct;
54 @@global.innodb_max_dirty_pages_pct
55 88.000000
56 '#--------------------FN_DYNVARS_046_05-------------------------#'
57 SET @@global.innodb_max_dirty_pages_pct = -1;
58 Warnings:
59 Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '-1'
60 Warning 1210 innodb_max_dirty_pages_pct cannot be set lower than innodb_max_dirty_pages_pct_lwm.
61 Warning 1210 Lowering innodb_max_dirty_page_pct_lwm to 0.000000
62 SELECT @@global.innodb_max_dirty_pages_pct;
63 @@global.innodb_max_dirty_pages_pct
64 0.000000
65 SET @@global.innodb_max_dirty_pages_pct = -1024;
66 Warnings:
67 Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '-1024'
68 SELECT @@global.innodb_max_dirty_pages_pct;
69 @@global.innodb_max_dirty_pages_pct
70 0.000000
71 SET @@global.innodb_max_dirty_pages_pct = "T";
72 ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct'
73 SELECT @@global.innodb_max_dirty_pages_pct;
74 @@global.innodb_max_dirty_pages_pct
75 0.000000
76 SET @@global.innodb_max_dirty_pages_pct = "Y";
77 ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct'
78 SELECT @@global.innodb_max_dirty_pages_pct;
79 @@global.innodb_max_dirty_pages_pct
80 0.000000
81 SET @@global.innodb_max_dirty_pages_pct = 100;
82 Warnings:
83 Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '100'
84 SELECT @@global.innodb_max_dirty_pages_pct;
85 @@global.innodb_max_dirty_pages_pct
86 99.999000
87 SET @@global.innodb_max_dirty_pages_pct = 1001;
88 Warnings:
89 Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '1001'
90 SELECT @@global.innodb_max_dirty_pages_pct;
91 @@global.innodb_max_dirty_pages_pct
92 99.999000
93 SET @@global.innodb_max_dirty_pages_pct = 100000;
94 Warnings:
95 Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '100000'
96 SELECT @@global.innodb_max_dirty_pages_pct;
97 @@global.innodb_max_dirty_pages_pct
98 99.999000
99 SET @@global.innodb_max_dirty_pages_pct = ' ';
100 ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct'
101 SELECT @@global.innodb_max_dirty_pages_pct;
102 @@global.innodb_max_dirty_pages_pct
103 99.999000
104 SET @@global.innodb_max_dirty_pages_pct = " ";
105 ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct'
106 SELECT @@global.innodb_max_dirty_pages_pct;
107 @@global.innodb_max_dirty_pages_pct
108 99.999000
109 SET @@global.innodb_max_dirty_pages_pct = 1.1;
110 SELECT @@global.innodb_max_dirty_pages_pct;
111 @@global.innodb_max_dirty_pages_pct
112 1.100000
113 set global innodb_max_dirty_pages_pct = 0.1;
114 SELECT @@global.innodb_max_dirty_pages_pct;
115 @@global.innodb_max_dirty_pages_pct
116 0.100000
117 set global innodb_max_dirty_pages_pct = 31.34;
118 SELECT @@global.innodb_max_dirty_pages_pct;
119 @@global.innodb_max_dirty_pages_pct
120 31.340000
121 set global innodb_max_dirty_pages_pct = 100;
122 Warnings:
123 Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '100'
124 SELECT @@global.innodb_max_dirty_pages_pct;
125 @@global.innodb_max_dirty_pages_pct
126 99.999000
127 set global innodb_max_dirty_pages_pct = 99.999;
128 SELECT @@global.innodb_max_dirty_pages_pct;
129 @@global.innodb_max_dirty_pages_pct
130 99.999000
131 '#----------------------FN_DYNVARS_046_06------------------------#'
132 SELECT @@global.innodb_max_dirty_pages_pct =
133 VARIABLE_VALUE FROM performance_schema.global_variables
134 WHERE VARIABLE_NAME='innodb_max_dirty_pages_pct';
135 @@global.innodb_max_dirty_pages_pct =
136 VARIABLE_VALUE
137 1
138 SELECT @@global.innodb_max_dirty_pages_pct;
139 @@global.innodb_max_dirty_pages_pct
140 99.999000
141 SELECT VARIABLE_VALUE FROM performance_schema.global_variables
142 WHERE VARIABLE_NAME='innodb_max_dirty_pages_pct';
143 VARIABLE_VALUE
144 99.999000
145 '#---------------------FN_DYNVARS_046_07-------------------------#'
146 SET @@global.innodb_max_dirty_pages_pct = OFF;
147 ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct'
148 SELECT @@global.innodb_max_dirty_pages_pct;
149 @@global.innodb_max_dirty_pages_pct
150 99.999000
151 SET @@global.innodb_max_dirty_pages_pct = ON;
152 ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct'
153 SELECT @@global.innodb_max_dirty_pages_pct;
154 @@global.innodb_max_dirty_pages_pct
155 99.999000
156 '#---------------------FN_DYNVARS_046_08----------------------#'
157 SET @@global.innodb_max_dirty_pages_pct = TRUE;
158 SELECT @@global.innodb_max_dirty_pages_pct;
159 @@global.innodb_max_dirty_pages_pct
160 1.000000
161 SET @@global.innodb_max_dirty_pages_pct = FALSE;
162 SELECT @@global.innodb_max_dirty_pages_pct;
163 @@global.innodb_max_dirty_pages_pct
164 0.000000
165 SET @@global.innodb_max_dirty_pages_pct = @global_start_value;
166 SELECT @@global.innodb_max_dirty_pages_pct;
167 @@global.innodb_max_dirty_pages_pct
168 90.000000
169 SET @@global.innodb_max_dirty_pages_pct_lwm = @global_start_max_dirty_lwm_value;
170 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
171 @@global.innodb_max_dirty_pages_pct_lwm
172 10.000000