Debian Codegraph @

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

raw
1 SELECT COUNT(@@GLOBAL.innodb_doublewrite);
2 COUNT(@@GLOBAL.innodb_doublewrite)
3 1
4 1 Expected
5 SET @@GLOBAL.innodb_doublewrite=off;
6 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to OFF if doublewrite is enabled. Please shutdown and change value to OFF
7 SET @@GLOBAL.innodb_doublewrite=on;
8 SELECT COUNT(@@GLOBAL.innodb_doublewrite);
9 COUNT(@@GLOBAL.innodb_doublewrite)
10 1
11 1 Expected
12 SELECT @@GLOBAL.innodb_doublewrite = VARIABLE_VALUE
13 FROM performance_schema.global_variables
14 WHERE VARIABLE_NAME='innodb_doublewrite';
15 @@GLOBAL.innodb_doublewrite = VARIABLE_VALUE
16 1
17 1 Expected
18 SELECT COUNT(@@GLOBAL.innodb_doublewrite);
19 COUNT(@@GLOBAL.innodb_doublewrite)
20 1
21 1 Expected
22 SELECT COUNT(VARIABLE_VALUE)
23 FROM performance_schema.global_variables
24 WHERE VARIABLE_NAME='innodb_doublewrite';
25 COUNT(VARIABLE_VALUE)
26 1
27 1 Expected
28 SELECT @@innodb_doublewrite = @@GLOBAL.innodb_doublewrite;
29 @@innodb_doublewrite = @@GLOBAL.innodb_doublewrite
30 1
31 1 Expected
32 SELECT COUNT(@@innodb_doublewrite);
33 COUNT(@@innodb_doublewrite)
34 1
35 1 Expected
36 SELECT COUNT(@@local.innodb_doublewrite);
37 ERROR HY000: Variable 'innodb_doublewrite' is a GLOBAL variable
38 Expected error 'Variable is a GLOBAL variable'
39 SELECT COUNT(@@SESSION.innodb_doublewrite);
40 ERROR HY000: Variable 'innodb_doublewrite' is a GLOBAL variable
41 Expected error 'Variable is a GLOBAL variable'
42 SELECT COUNT(@@GLOBAL.innodb_doublewrite);
43 COUNT(@@GLOBAL.innodb_doublewrite)
44 1
45 1 Expected
46 "##############################################"
47 # restart: --innodb-doublewrite=ON
48 SELECT @@global.innodb_doublewrite;
49 @@global.innodb_doublewrite
50 ON
51 # doublewrite mode is OFF
52 SET @@GLOBAL.innodb_doublewrite=0;
53 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to OFF if doublewrite is enabled. Please shutdown and change value to OFF
54 SELECT @@global.innodb_doublewrite;
55 @@global.innodb_doublewrite
56 ON
57 # doublewrite mode is ON
58 SET @@GLOBAL.innodb_doublewrite=1;
59 SELECT @@global.innodb_doublewrite;
60 @@global.innodb_doublewrite
61 ON
62 # doublewrite mode is DETECT_ONLY
63 SET @@GLOBAL.innodb_doublewrite=2;
64 SELECT @@global.innodb_doublewrite;
65 @@global.innodb_doublewrite
66 DETECT_ONLY
67 # doublewrite mode is DETECT_AND_RECOVER
68 SET @@GLOBAL.innodb_doublewrite=3;
69 SELECT @@global.innodb_doublewrite;
70 @@global.innodb_doublewrite
71 DETECT_AND_RECOVER
72 # doublewrite mode is FALSE
73 SET @@GLOBAL.innodb_doublewrite=4;
74 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to FALSE if doublewrite is enabled. Please shutdown and change value to FALSE
75 SELECT @@global.innodb_doublewrite;
76 @@global.innodb_doublewrite
77 DETECT_AND_RECOVER
78 # doublewrite mode is TRUE
79 SET @@GLOBAL.innodb_doublewrite=5;
80 SELECT @@global.innodb_doublewrite;
81 @@global.innodb_doublewrite
82 DETECT_AND_RECOVER
83 SET @@GLOBAL.innodb_doublewrite=6;
84 ERROR 42000: Variable 'innodb_doublewrite' can't be set to the value of '6'
85 SELECT @@global.innodb_doublewrite;
86 @@global.innodb_doublewrite
87 DETECT_AND_RECOVER
88 "##############################################"
89 # restart: --innodb-doublewrite=DETECT_AND_RECOVER
90 SELECT @@global.innodb_doublewrite;
91 @@global.innodb_doublewrite
92 DETECT_AND_RECOVER
93 # doublewrite mode is OFF
94 SET @@GLOBAL.innodb_doublewrite=0;
95 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to OFF if doublewrite is enabled. Please shutdown and change value to OFF
96 SELECT @@global.innodb_doublewrite;
97 @@global.innodb_doublewrite
98 DETECT_AND_RECOVER
99 # doublewrite mode is ON
100 SET @@GLOBAL.innodb_doublewrite=1;
101 SELECT @@global.innodb_doublewrite;
102 @@global.innodb_doublewrite
103 DETECT_AND_RECOVER
104 # doublewrite mode is DETECT_ONLY
105 SET @@GLOBAL.innodb_doublewrite=2;
106 SELECT @@global.innodb_doublewrite;
107 @@global.innodb_doublewrite
108 DETECT_ONLY
109 # doublewrite mode is DETECT_AND_RECOVER
110 SET @@GLOBAL.innodb_doublewrite=3;
111 SELECT @@global.innodb_doublewrite;
112 @@global.innodb_doublewrite
113 DETECT_AND_RECOVER
114 # doublewrite mode is FALSE
115 SET @@GLOBAL.innodb_doublewrite=4;
116 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to FALSE if doublewrite is enabled. Please shutdown and change value to FALSE
117 SELECT @@global.innodb_doublewrite;
118 @@global.innodb_doublewrite
119 DETECT_AND_RECOVER
120 # doublewrite mode is TRUE
121 SET @@GLOBAL.innodb_doublewrite=5;
122 SELECT @@global.innodb_doublewrite;
123 @@global.innodb_doublewrite
124 DETECT_AND_RECOVER
125 SET @@GLOBAL.innodb_doublewrite=6;
126 ERROR 42000: Variable 'innodb_doublewrite' can't be set to the value of '6'
127 SELECT @@global.innodb_doublewrite;
128 @@global.innodb_doublewrite
129 DETECT_AND_RECOVER
130 "##############################################"
131 # restart: --innodb-doublewrite=off
132 SELECT @@global.innodb_doublewrite;
133 @@global.innodb_doublewrite
134 OFF
135 # doublewrite mode is OFF
136 SET @@GLOBAL.innodb_doublewrite=0;
137 SELECT @@global.innodb_doublewrite;
138 @@global.innodb_doublewrite
139 OFF
140 # doublewrite mode is ON
141 SET @@GLOBAL.innodb_doublewrite=1;
142 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to ON if doublewrite is disabled. Please shutdown and change value to ON
143 SELECT @@global.innodb_doublewrite;
144 @@global.innodb_doublewrite
145 OFF
146 # doublewrite mode is DETECT_ONLY
147 SET @@GLOBAL.innodb_doublewrite=2;
148 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to DETECT_ONLY if doublewrite is disabled. Please shutdown and change value to DETECT_ONLY
149 SELECT @@global.innodb_doublewrite;
150 @@global.innodb_doublewrite
151 OFF
152 # doublewrite mode is DETECT_AND_RECOVER
153 SET @@GLOBAL.innodb_doublewrite=3;
154 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to DETECT_AND_RECOVER if doublewrite is disabled. Please shutdown and change value to DETECT_AND_RECOVER
155 SELECT @@global.innodb_doublewrite;
156 @@global.innodb_doublewrite
157 OFF
158 # doublewrite mode is FALSE
159 SET @@GLOBAL.innodb_doublewrite=4;
160 SELECT @@global.innodb_doublewrite;
161 @@global.innodb_doublewrite
162 OFF
163 # doublewrite mode is TRUE
164 SET @@GLOBAL.innodb_doublewrite=5;
165 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to TRUE if doublewrite is disabled. Please shutdown and change value to TRUE
166 SELECT @@global.innodb_doublewrite;
167 @@global.innodb_doublewrite
168 OFF
169 SET @@GLOBAL.innodb_doublewrite=6;
170 ERROR 42000: Variable 'innodb_doublewrite' can't be set to the value of '6'
171 SELECT @@global.innodb_doublewrite;
172 @@global.innodb_doublewrite
173 OFF
174 "##############################################"
175 # restart: --innodb-doublewrite=FALSE
176 SELECT @@global.innodb_doublewrite;
177 @@global.innodb_doublewrite
178 FALSE
179 # doublewrite mode is OFF
180 SET @@GLOBAL.innodb_doublewrite=0;
181 SELECT @@global.innodb_doublewrite;
182 @@global.innodb_doublewrite
183 FALSE
184 # doublewrite mode is ON
185 SET @@GLOBAL.innodb_doublewrite=1;
186 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to ON if doublewrite is disabled. Please shutdown and change value to ON
187 SELECT @@global.innodb_doublewrite;
188 @@global.innodb_doublewrite
189 FALSE
190 # doublewrite mode is DETECT_ONLY
191 SET @@GLOBAL.innodb_doublewrite=2;
192 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to DETECT_ONLY if doublewrite is disabled. Please shutdown and change value to DETECT_ONLY
193 SELECT @@global.innodb_doublewrite;
194 @@global.innodb_doublewrite
195 FALSE
196 # doublewrite mode is DETECT_AND_RECOVER
197 SET @@GLOBAL.innodb_doublewrite=3;
198 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to DETECT_AND_RECOVER if doublewrite is disabled. Please shutdown and change value to DETECT_AND_RECOVER
199 SELECT @@global.innodb_doublewrite;
200 @@global.innodb_doublewrite
201 FALSE
202 # doublewrite mode is FALSE
203 SET @@GLOBAL.innodb_doublewrite=4;
204 SELECT @@global.innodb_doublewrite;
205 @@global.innodb_doublewrite
206 FALSE
207 # doublewrite mode is TRUE
208 SET @@GLOBAL.innodb_doublewrite=5;
209 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to TRUE if doublewrite is disabled. Please shutdown and change value to TRUE
210 SELECT @@global.innodb_doublewrite;
211 @@global.innodb_doublewrite
212 FALSE
213 SET @@GLOBAL.innodb_doublewrite=6;
214 ERROR 42000: Variable 'innodb_doublewrite' can't be set to the value of '6'
215 SELECT @@global.innodb_doublewrite;
216 @@global.innodb_doublewrite
217 FALSE
218 "##############################################"
219 # restart: --innodb-doublewrite=DETECT_ONLY
220 SELECT @@global.innodb_doublewrite;
221 @@global.innodb_doublewrite
222 DETECT_ONLY
223 SET @@GLOBAL.innodb_doublewrite=off;
224 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to OFF if doublewrite is enabled. Please shutdown and change value to OFF
225 SELECT @@global.innodb_doublewrite;
226 @@global.innodb_doublewrite
227 DETECT_ONLY
228 SET @@GLOBAL.innodb_doublewrite=false;
229 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to OFF if doublewrite is enabled. Please shutdown and change value to OFF
230 SELECT @@global.innodb_doublewrite;
231 @@global.innodb_doublewrite
232 DETECT_ONLY
233 SET @@GLOBAL.innodb_doublewrite=on;
234 SELECT @@global.innodb_doublewrite;
235 @@global.innodb_doublewrite
236 ON
237 SET @@GLOBAL.innodb_doublewrite=detect_only;
238 SELECT @@global.innodb_doublewrite;
239 @@global.innodb_doublewrite
240 DETECT_ONLY
241 SET @@GLOBAL.innodb_doublewrite=DETECT_AND_RECOVER;
242 SELECT @@global.innodb_doublewrite;
243 @@global.innodb_doublewrite
244 DETECT_AND_RECOVER
245 SET @@GLOBAL.innodb_doublewrite=true;
246 SELECT @@global.innodb_doublewrite;
247 @@global.innodb_doublewrite
248 DETECT_AND_RECOVER
249 "##############################################"
250 # restart: --innodb-doublewrite
251 SELECT @@global.innodb_doublewrite;
252 @@global.innodb_doublewrite
253 ON
254 SET @@GLOBAL.innodb_doublewrite=off;
255 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to OFF if doublewrite is enabled. Please shutdown and change value to OFF
256 SELECT @@global.innodb_doublewrite;
257 @@global.innodb_doublewrite
258 ON
259 SET @@GLOBAL.innodb_doublewrite=false;
260 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to OFF if doublewrite is enabled. Please shutdown and change value to OFF
261 SELECT @@global.innodb_doublewrite;
262 @@global.innodb_doublewrite
263 ON
264 SET @@GLOBAL.innodb_doublewrite=on;
265 SELECT @@global.innodb_doublewrite;
266 @@global.innodb_doublewrite
267 ON
268 SET @@GLOBAL.innodb_doublewrite=detect_only;
269 SELECT @@global.innodb_doublewrite;
270 @@global.innodb_doublewrite
271 DETECT_ONLY
272 SET @@GLOBAL.innodb_doublewrite=true;
273 SELECT @@global.innodb_doublewrite;
274 @@global.innodb_doublewrite
275 ON
276 SET @@GLOBAL.innodb_doublewrite=detect_and_recover;
277 SELECT @@global.innodb_doublewrite;
278 @@global.innodb_doublewrite
279 ON
280 "##############################################"
281 # restart: --innodb-doublewrite=0
282 SELECT @@global.innodb_doublewrite;
283 @@global.innodb_doublewrite
284 OFF
285 # doublewrite mode is OFF
286 SET @@GLOBAL.innodb_doublewrite=0;
287 SELECT @@global.innodb_doublewrite;
288 @@global.innodb_doublewrite
289 OFF
290 # doublewrite mode is ON
291 SET @@GLOBAL.innodb_doublewrite=1;
292 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to ON if doublewrite is disabled. Please shutdown and change value to ON
293 SELECT @@global.innodb_doublewrite;
294 @@global.innodb_doublewrite
295 OFF
296 # doublewrite mode is DETECT_ONLY
297 SET @@GLOBAL.innodb_doublewrite=2;
298 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to DETECT_ONLY if doublewrite is disabled. Please shutdown and change value to DETECT_ONLY
299 SELECT @@global.innodb_doublewrite;
300 @@global.innodb_doublewrite
301 OFF
302 # doublewrite mode is DETECT_AND_RECOVER
303 SET @@GLOBAL.innodb_doublewrite=3;
304 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to DETECT_AND_RECOVER if doublewrite is disabled. Please shutdown and change value to DETECT_AND_RECOVER
305 SELECT @@global.innodb_doublewrite;
306 @@global.innodb_doublewrite
307 OFF
308 # doublewrite mode is FALSE
309 SET @@GLOBAL.innodb_doublewrite=4;
310 SELECT @@global.innodb_doublewrite;
311 @@global.innodb_doublewrite
312 OFF
313 # doublewrite mode is TRUE
314 SET @@GLOBAL.innodb_doublewrite=5;
315 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to TRUE if doublewrite is disabled. Please shutdown and change value to TRUE
316 SELECT @@global.innodb_doublewrite;
317 @@global.innodb_doublewrite
318 OFF
319 SET @@GLOBAL.innodb_doublewrite=6;
320 ERROR 42000: Variable 'innodb_doublewrite' can't be set to the value of '6'
321 SELECT @@global.innodb_doublewrite;
322 @@global.innodb_doublewrite
323 OFF
324 "##############################################"
325 # restart: --innodb-doublewrite=1
326 SELECT @@global.innodb_doublewrite;
327 @@global.innodb_doublewrite
328 ON
329 # doublewrite mode is OFF
330 SET @@GLOBAL.innodb_doublewrite=0;
331 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to OFF if doublewrite is enabled. Please shutdown and change value to OFF
332 SELECT @@global.innodb_doublewrite;
333 @@global.innodb_doublewrite
334 ON
335 # doublewrite mode is ON
336 SET @@GLOBAL.innodb_doublewrite=1;
337 SELECT @@global.innodb_doublewrite;
338 @@global.innodb_doublewrite
339 ON
340 # doublewrite mode is DETECT_ONLY
341 SET @@GLOBAL.innodb_doublewrite=2;
342 SELECT @@global.innodb_doublewrite;
343 @@global.innodb_doublewrite
344 DETECT_ONLY
345 # doublewrite mode is DETECT_AND_RECOVER
346 SET @@GLOBAL.innodb_doublewrite=3;
347 SELECT @@global.innodb_doublewrite;
348 @@global.innodb_doublewrite
349 DETECT_AND_RECOVER
350 # doublewrite mode is FALSE
351 SET @@GLOBAL.innodb_doublewrite=4;
352 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to FALSE if doublewrite is enabled. Please shutdown and change value to FALSE
353 SELECT @@global.innodb_doublewrite;
354 @@global.innodb_doublewrite
355 DETECT_AND_RECOVER
356 # doublewrite mode is TRUE
357 SET @@GLOBAL.innodb_doublewrite=5;
358 SELECT @@global.innodb_doublewrite;
359 @@global.innodb_doublewrite
360 DETECT_AND_RECOVER
361 SET @@GLOBAL.innodb_doublewrite=6;
362 ERROR 42000: Variable 'innodb_doublewrite' can't be set to the value of '6'
363 SELECT @@global.innodb_doublewrite;
364 @@global.innodb_doublewrite
365 DETECT_AND_RECOVER
366 "##############################################"
367 # restart: --innodb-doublewrite=3
368 SELECT @@global.innodb_doublewrite;
369 @@global.innodb_doublewrite
370 DETECT_AND_RECOVER
371 # doublewrite mode is OFF
372 SET @@GLOBAL.innodb_doublewrite=0;
373 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to OFF if doublewrite is enabled. Please shutdown and change value to OFF
374 SELECT @@global.innodb_doublewrite;
375 @@global.innodb_doublewrite
376 DETECT_AND_RECOVER
377 # doublewrite mode is ON
378 SET @@GLOBAL.innodb_doublewrite=1;
379 SELECT @@global.innodb_doublewrite;
380 @@global.innodb_doublewrite
381 DETECT_AND_RECOVER
382 # doublewrite mode is DETECT_ONLY
383 SET @@GLOBAL.innodb_doublewrite=2;
384 SELECT @@global.innodb_doublewrite;
385 @@global.innodb_doublewrite
386 DETECT_ONLY
387 # doublewrite mode is DETECT_AND_RECOVER
388 SET @@GLOBAL.innodb_doublewrite=3;
389 SELECT @@global.innodb_doublewrite;
390 @@global.innodb_doublewrite
391 DETECT_AND_RECOVER
392 # doublewrite mode is FALSE
393 SET @@GLOBAL.innodb_doublewrite=4;
394 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to FALSE if doublewrite is enabled. Please shutdown and change value to FALSE
395 SELECT @@global.innodb_doublewrite;
396 @@global.innodb_doublewrite
397 DETECT_AND_RECOVER
398 # doublewrite mode is TRUE
399 SET @@GLOBAL.innodb_doublewrite=5;
400 SELECT @@global.innodb_doublewrite;
401 @@global.innodb_doublewrite
402 DETECT_AND_RECOVER
403 SET @@GLOBAL.innodb_doublewrite=6;
404 ERROR 42000: Variable 'innodb_doublewrite' can't be set to the value of '6'
405 SELECT @@global.innodb_doublewrite;
406 @@global.innodb_doublewrite
407 DETECT_AND_RECOVER
408 "##############################################"
409 # restart: --innodb-doublewrite=4
410 SELECT @@global.innodb_doublewrite;
411 @@global.innodb_doublewrite
412 FALSE
413 # doublewrite mode is OFF
414 SET @@GLOBAL.innodb_doublewrite=0;
415 SELECT @@global.innodb_doublewrite;
416 @@global.innodb_doublewrite
417 FALSE
418 # doublewrite mode is ON
419 SET @@GLOBAL.innodb_doublewrite=1;
420 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to ON if doublewrite is disabled. Please shutdown and change value to ON
421 SELECT @@global.innodb_doublewrite;
422 @@global.innodb_doublewrite
423 FALSE
424 # doublewrite mode is DETECT_ONLY
425 SET @@GLOBAL.innodb_doublewrite=2;
426 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to DETECT_ONLY if doublewrite is disabled. Please shutdown and change value to DETECT_ONLY
427 SELECT @@global.innodb_doublewrite;
428 @@global.innodb_doublewrite
429 FALSE
430 # doublewrite mode is DETECT_AND_RECOVER
431 SET @@GLOBAL.innodb_doublewrite=3;
432 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to DETECT_AND_RECOVER if doublewrite is disabled. Please shutdown and change value to DETECT_AND_RECOVER
433 SELECT @@global.innodb_doublewrite;
434 @@global.innodb_doublewrite
435 FALSE
436 # doublewrite mode is FALSE
437 SET @@GLOBAL.innodb_doublewrite=4;
438 SELECT @@global.innodb_doublewrite;
439 @@global.innodb_doublewrite
440 FALSE
441 # doublewrite mode is TRUE
442 SET @@GLOBAL.innodb_doublewrite=5;
443 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to TRUE if doublewrite is disabled. Please shutdown and change value to TRUE
444 SELECT @@global.innodb_doublewrite;
445 @@global.innodb_doublewrite
446 FALSE
447 SET @@GLOBAL.innodb_doublewrite=6;
448 ERROR 42000: Variable 'innodb_doublewrite' can't be set to the value of '6'
449 SELECT @@global.innodb_doublewrite;
450 @@global.innodb_doublewrite
451 FALSE
452 "##############################################"
453 # restart: --innodb-doublewrite=5
454 SELECT @@global.innodb_doublewrite;
455 @@global.innodb_doublewrite
456 TRUE
457 # doublewrite mode is OFF
458 SET @@GLOBAL.innodb_doublewrite=0;
459 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to OFF if doublewrite is enabled. Please shutdown and change value to OFF
460 SELECT @@global.innodb_doublewrite;
461 @@global.innodb_doublewrite
462 TRUE
463 # doublewrite mode is ON
464 SET @@GLOBAL.innodb_doublewrite=1;
465 SELECT @@global.innodb_doublewrite;
466 @@global.innodb_doublewrite
467 TRUE
468 # doublewrite mode is DETECT_ONLY
469 SET @@GLOBAL.innodb_doublewrite=2;
470 SELECT @@global.innodb_doublewrite;
471 @@global.innodb_doublewrite
472 DETECT_ONLY
473 # doublewrite mode is DETECT_AND_RECOVER
474 SET @@GLOBAL.innodb_doublewrite=3;
475 SELECT @@global.innodb_doublewrite;
476 @@global.innodb_doublewrite
477 DETECT_AND_RECOVER
478 # doublewrite mode is FALSE
479 SET @@GLOBAL.innodb_doublewrite=4;
480 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to FALSE if doublewrite is enabled. Please shutdown and change value to FALSE
481 SELECT @@global.innodb_doublewrite;
482 @@global.innodb_doublewrite
483 DETECT_AND_RECOVER
484 # doublewrite mode is TRUE
485 SET @@GLOBAL.innodb_doublewrite=5;
486 SELECT @@global.innodb_doublewrite;
487 @@global.innodb_doublewrite
488 DETECT_AND_RECOVER
489 SET @@GLOBAL.innodb_doublewrite=6;
490 ERROR 42000: Variable 'innodb_doublewrite' can't be set to the value of '6'
491 SELECT @@global.innodb_doublewrite;
492 @@global.innodb_doublewrite
493 DETECT_AND_RECOVER
494 "##############################################"
495 # restart: --innodb-doublewrite=2
496 SELECT @@global.innodb_doublewrite;
497 @@global.innodb_doublewrite
498 DETECT_ONLY
499 # doublewrite mode is OFF
500 SET @@GLOBAL.innodb_doublewrite=0;
501 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to OFF if doublewrite is enabled. Please shutdown and change value to OFF
502 SELECT @@global.innodb_doublewrite;
503 @@global.innodb_doublewrite
504 DETECT_ONLY
505 # doublewrite mode is ON
506 SET @@GLOBAL.innodb_doublewrite=1;
507 SELECT @@global.innodb_doublewrite;
508 @@global.innodb_doublewrite
509 ON
510 # doublewrite mode is DETECT_ONLY
511 SET @@GLOBAL.innodb_doublewrite=2;
512 SELECT @@global.innodb_doublewrite;
513 @@global.innodb_doublewrite
514 DETECT_ONLY
515 # doublewrite mode is DETECT_AND_RECOVER
516 SET @@GLOBAL.innodb_doublewrite=3;
517 SELECT @@global.innodb_doublewrite;
518 @@global.innodb_doublewrite
519 DETECT_AND_RECOVER
520 # doublewrite mode is FALSE
521 SET @@GLOBAL.innodb_doublewrite=4;
522 ERROR HY000: Incorrect arguments to InnoDB: cannot change doublewrite mode to FALSE if doublewrite is enabled. Please shutdown and change value to FALSE
523 SELECT @@global.innodb_doublewrite;
524 @@global.innodb_doublewrite
525 DETECT_AND_RECOVER
526 # doublewrite mode is TRUE
527 SET @@GLOBAL.innodb_doublewrite=5;
528 SELECT @@global.innodb_doublewrite;
529 @@global.innodb_doublewrite
530 DETECT_AND_RECOVER
531 SET @@GLOBAL.innodb_doublewrite=6;
532 ERROR 42000: Variable 'innodb_doublewrite' can't be set to the value of '6'
533 SELECT @@global.innodb_doublewrite;
534 @@global.innodb_doublewrite
535 DETECT_AND_RECOVER
536 # restart
537 SET PERSIST innodb_doublewrite=ON;
538 ERROR HY000: Variable 'innodb_doublewrite' is a non persistent variable
539 SET PERSIST innodb_doublewrite=OFF;
540 ERROR HY000: Variable 'innodb_doublewrite' is a non persistent variable
541 SET PERSIST innodb_doublewrite=DETECT_ONLY;
542 ERROR HY000: Variable 'innodb_doublewrite' is a non persistent variable
543 SET PERSIST_ONLY innodb_doublewrite=ON;
544 ERROR HY000: Variable 'innodb_doublewrite' is a non persistent variable
545 SET PERSIST_ONLY innodb_doublewrite=OFF;
546 ERROR HY000: Variable 'innodb_doublewrite' is a non persistent variable
547 SET PERSIST_ONLY innodb_doublewrite=DETECT_ONLY;
548 ERROR HY000: Variable 'innodb_doublewrite' is a non persistent variable