Debian Codegraph @

mysql-test/suite/innodb_undo/t/undo_settings.test

raw
1 --echo # This test changes undo related settings both at runtime, between restarts,
2 --echo # and also after crashes.
3 --echo # Note that innodb_undo_tablespaces is now fixed at 2 so only
4 --echo # innodb_rollback_segments is tested here.
5 --echo # Also make sure that --innodb_validate_tablespace_paths=OFF does not
6 --echo # affect the validation of undo tablespaces. (See undo_settings-master.opt)
7
8 --source include/have_innodb_default_undo_tablespaces.inc
9
10 SET DEFAULT_STORAGE_ENGINE=InnoDB;
11 let MYSQLD_DATADIR=`select @@datadir`;
12 let PAGE_SIZE=`select @@innodb_page_size`;
13 SET GLOBAL innodb_monitor_enable='module_buffer_page';
14 SET GLOBAL innodb_monitor_enable='trx_rseg_current_size';
15
16 --echo #
17 --echo # Create tables and check the default values.
18 --echo #
19
20 CREATE TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd';
21 CREATE TABLE t1 (a INT, b TEXT) TABLESPACE=`ts1`;
22 CREATE TABLE t2 (a INT, b TEXT) TABLESPACE=`innodb_system`;
23 CREATE TABLE t3 (a INT, b TEXT) TABLESPACE=`innodb_file_per_table`;
24
25 connect (con1,localhost,root);
26 --echo # Connection 1
27 INSERT INTO t1 VALUES (1, repeat('a',15));
28 INSERT INTO t2 VALUES (1, repeat('a',15));
29 INSERT INTO t3 VALUES (1, repeat('a',15));
30 SELECT * FROM t1 ORDER BY a;
31 SELECT COUNT(*) FROM t2;
32 SELECT COUNT(*) FROM t3;
33
34 connect (con2,localhost,root);
35 --echo # Connection 2
36 SELECT * FROM t1 ORDER BY a;
37 SELECT COUNT(*) FROM t2;
38 SELECT COUNT(*) FROM t3;
39 XA START 'x1';
40 INSERT INTO t1 VALUES (101, repeat('x1 ',5));
41 INSERT INTO t2 VALUES (101, repeat('x1 ',5));
42 INSERT INTO t3 VALUES (101, repeat('x1 ',5));
43
44 connection default;
45 --echo # Connection default
46 SHOW VARIABLES LIKE 'innodb_rollback_segments';
47 SHOW GLOBAL STATUS LIKE '%undo%';
48 SELECT NAME, ROW_FORMAT, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
49 WHERE name LIKE '%undo%' ORDER BY NAME;
50 SELECT TABLESPACE_NAME, FILE_TYPE, FILE_NAME FROM INFORMATION_SCHEMA.FILES
51 WHERE FILE_NAME LIKE '%undo%' ORDER BY TABLESPACE_NAME;
52 --echo # Directory listing of UNDO tablespace files
53 --list_files $MYSQLD_DATADIR undo_0*
54
55 --echo #
56 --echo # Change number of UNDO tablespaces from 2 to 3 while online.
57 --echo #
58 CREATE UNDO TABLESPACE `undo_003` ADD DATAFILE 'undo_003.ibu';
59 SHOW VARIABLES LIKE 'innodb_rollback_segments';
60 SHOW GLOBAL STATUS LIKE '%undo%';
61 SELECT NAME, ROW_FORMAT, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
62 WHERE name LIKE '%undo%' ORDER BY NAME;
63 SELECT TABLESPACE_NAME, FILE_TYPE, FILE_NAME FROM INFORMATION_SCHEMA.FILES
64 WHERE FILE_NAME LIKE '%undo%' ORDER BY TABLESPACE_NAME;
65 --echo # Directory listing of UNDO tablespace files
66 --list_files $MYSQLD_DATADIR undo_0*
67
68 connection con1;
69 --echo # Connection 1
70 BEGIN;
71 INSERT INTO t1 VALUES (2, repeat('b',15));
72 INSERT INTO t2 VALUES (2, repeat('b',15));
73 INSERT INTO t3 VALUES (2, repeat('b',15));
74
75 connection con2;
76 --echo # Connection 2
77 XA END 'x1';
78 XA PREPARE 'x1';
79 XA COMMIT 'x1';
80 SELECT * FROM t1 ORDER BY a;
81 SELECT COUNT(*) FROM t2;
82 SELECT COUNT(*) FROM t3;
83 XA START 'x2';
84 INSERT INTO t1 VALUES (102, repeat('x2 ',5));
85 INSERT INTO t2 VALUES (102, repeat('x2 ',5));
86 INSERT INTO t3 VALUES (102, repeat('x2 ',5));
87 XA END 'x2';
88
89 connection default;
90 --echo # Connection default
91
92 --echo #
93 --echo # Change number of UNDO tablespaces from 3 to 4 while online.
94 --echo # Change number of Rollback Segments from 1 to 4 while online.
95 --echo #
96 SHOW VARIABLES LIKE 'innodb_rollback_segments';
97 SET GLOBAL innodb_rollback_segments=4;
98
99 SHOW VARIABLES LIKE 'innodb_rollback_segments';
100 CREATE UNDO TABLESPACE `undo_004` ADD DATAFILE 'undo_004.ibu';
101
102 SHOW GLOBAL STATUS LIKE '%undo%';
103 SELECT NAME, ROW_FORMAT, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
104 WHERE name LIKE '%undo%' ORDER BY NAME;
105 SELECT TABLESPACE_NAME, FILE_TYPE, FILE_NAME FROM INFORMATION_SCHEMA.FILES
106 WHERE FILE_NAME LIKE '%undo%' ORDER BY TABLESPACE_NAME;
107 --echo # Directory listing of UNDO tablespace files
108 --list_files $MYSQLD_DATADIR undo_0*
109
110 SELECT * FROM t1 ORDER BY a;
111 SELECT COUNT(*) FROM t2;
112 SELECT COUNT(*) FROM t3;
113
114 connection con1;
115 --echo # Connection 1
116 COMMIT;
117 SELECT * FROM t1 ORDER BY a;
118 SELECT COUNT(*) FROM t2;
119 SELECT COUNT(*) FROM t3;
120 INSERT INTO t1 VALUES (3, repeat('c',15));
121 INSERT INTO t2 VALUES (3, repeat('c',15));
122 INSERT INTO t3 VALUES (3, repeat('c',15));
123
124 connection con2;
125 --echo # Connection 2
126 XA PREPARE 'x2';
127 XA COMMIT 'x2';
128 SELECT * FROM t1 ORDER BY a;
129 SELECT COUNT(*) FROM t2;
130 SELECT COUNT(*) FROM t3;
131 XA START 'x3';
132 INSERT INTO t1 VALUES (103, repeat('x3 ',5));
133 INSERT INTO t2 VALUES (103, repeat('x3 ',5));
134 INSERT INTO t3 VALUES (103, repeat('x3 ',5));
135 XA END 'x3';
136 XA PREPARE 'x3';
137 XA COMMIT 'x3';
138 SELECT * FROM t1 ORDER BY a;
139 SELECT COUNT(*) FROM t2;
140 SELECT COUNT(*) FROM t3;
141 connection default;
142 --echo # Connection default
143 SELECT * FROM t1 ORDER BY a;
144 SELECT COUNT(*) FROM t2;
145 SELECT COUNT(*) FROM t3;
146
147 --echo #
148 --echo # Change number of active UNDO tablespaces from 4 to 2 while online.
149 --echo # Change number of Rollback Segments from 4 to 2 while online.
150 --echo #
151 SHOW VARIABLES LIKE 'innodb_rollback_segments';
152 SET GLOBAL innodb_rollback_segments=2;
153
154 SHOW VARIABLES LIKE 'innodb_rollback_segments';
155 ALTER UNDO TABLESPACE `undo_003` SET INACTIVE;
156 let $inactive_undo_space = undo_003;
157 source include/wait_until_undo_space_is_empty.inc;
158 ALTER UNDO TABLESPACE `undo_004` SET INACTIVE;
159 let $inactive_undo_space = undo_004;
160 source include/wait_until_undo_space_is_empty.inc;
161
162 SHOW GLOBAL STATUS LIKE '%undo%';
163 SELECT NAME, ROW_FORMAT, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
164 WHERE name LIKE '%undo%' ORDER BY NAME;
165 SELECT TABLESPACE_NAME, FILE_TYPE, FILE_NAME FROM INFORMATION_SCHEMA.FILES
166 WHERE FILE_NAME LIKE '%undo%' ORDER BY TABLESPACE_NAME;
167 --echo # Directory listing of UNDO tablespace files
168 --list_files $MYSQLD_DATADIR undo_0*
169
170 INSERT INTO t1 VALUES (4, repeat('d',15));
171 INSERT INTO t2 VALUES (4, repeat('d',15));
172 INSERT INTO t3 VALUES (4, repeat('d',15));
173 SELECT * FROM t1 ORDER BY a;
174 SELECT COUNT(*) FROM t2;
175 SELECT COUNT(*) FROM t3;
176
177 --echo #
178 --echo # Change number of UNDO tablespaces from 2 to 5 while online.
179 --echo # Change number of Rollback Segments from 2 to 5 while online.
180 --echo #
181 SHOW VARIABLES LIKE 'innodb_rollback_segments';
182 SHOW GLOBAL STATUS LIKE '%undo%';
183
184 SET GLOBAL innodb_rollback_segments=5;
185 ALTER UNDO TABLESPACE `undo_003` SET ACTIVE;
186 ALTER UNDO TABLESPACE `undo_004` SET ACTIVE;
187 CREATE UNDO TABLESPACE `undo_005` ADD DATAFILE 'undo_005.ibu';
188
189 SHOW VARIABLES LIKE 'innodb_rollback_segments';
190 SHOW GLOBAL STATUS LIKE '%undo%';
191 SELECT NAME, ROW_FORMAT, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
192 WHERE name LIKE '%undo%' ORDER BY NAME;
193 SELECT TABLESPACE_NAME, FILE_TYPE, FILE_NAME FROM INFORMATION_SCHEMA.FILES
194 WHERE FILE_NAME LIKE '%undo%' ORDER BY TABLESPACE_NAME;
195 --echo # Directory listing of UNDO tablespace files
196 --list_files $MYSQLD_DATADIR undo_0*
197
198 connection con1;
199 --echo # Connection 1
200 INSERT INTO t1 VALUES (5, repeat('e',15));
201 INSERT INTO t2 VALUES (5, repeat('e',15));
202 INSERT INTO t3 VALUES (5, repeat('e',15));
203
204 connection default;
205 --echo # Connection default
206 disconnect con1;
207 disconnect con2;
208 SELECT * FROM t1 ORDER BY a;
209 SELECT COUNT(*) FROM t2;
210 SELECT COUNT(*) FROM t3;
211
212 --echo #
213 --echo # Shutdown mysqld cleanly.
214 --echo # Delete one of the implicit UNDO tablespaces.
215 --echo # Change number of Rollback Segments from 5 to 6 while offline.
216 --echo # Restart mysqld with these larger settings.
217 --echo #
218 --source include/shutdown_mysqld.inc
219 --remove_file $MYSQLD_DATADIR/undo_001
220
221 let $restart_parameters = restart: --innodb_rollback_segments=6;
222 --source include/start_mysqld.inc
223
224 SHOW VARIABLES LIKE 'innodb_rollback_segments';
225 SHOW GLOBAL STATUS LIKE '%undo%';
226 SELECT NAME, ROW_FORMAT, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
227 WHERE name LIKE '%undo%' ORDER BY NAME;
228 SELECT TABLESPACE_NAME, FILE_TYPE, FILE_NAME FROM INFORMATION_SCHEMA.FILES
229 WHERE FILE_NAME LIKE '%undo%' ORDER BY TABLESPACE_NAME;
230 --echo # Directory listing of UNDO tablespace files
231 --list_files $MYSQLD_DATADIR undo_0*
232
233 --echo #
234 --echo # Shutdown mysqld cleanly.
235 --echo # Change number of Rollback Segments from 6 to 4 while offline.
236 --echo # Restart mysqld with these smaller settings.
237 --echo #
238 ALTER UNDO TABLESPACE `undo_003` SET INACTIVE;
239 let $inactive_undo_space = undo_003;
240 source include/wait_until_undo_space_is_empty.inc;
241
242 --source include/shutdown_mysqld.inc
243 let $restart_parameters = restart: --innodb_rollback_segments=4 --innodb_validate_tablespace_paths=0;
244 --source include/start_mysqld.inc
245
246 SHOW VARIABLES LIKE 'innodb_rollback_segments';
247 SHOW GLOBAL STATUS LIKE '%undo%';
248 SELECT NAME, ROW_FORMAT, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
249 WHERE name LIKE '%undo%' ORDER BY NAME;
250 SELECT TABLESPACE_NAME, FILE_TYPE, FILE_NAME FROM INFORMATION_SCHEMA.FILES
251 WHERE FILE_NAME LIKE '%undo%' ORDER BY TABLESPACE_NAME;
252 --echo # Directory listing of UNDO tablespace files
253 --list_files $MYSQLD_DATADIR undo_0*
254
255 --echo #
256 --echo # Kill and restart mysqld with one less active undo tablespace
257 --echo # and less rollback segments=2.
258 --echo #
259 ALTER UNDO TABLESPACE `undo_004` SET INACTIVE;
260 let $inactive_undo_space = undo_004;
261 source include/wait_until_undo_space_is_empty.inc;
262
263 connect (con1,localhost,root);
264 --echo # Connection 1
265 SELECT * FROM t1 ORDER BY a;
266 SELECT COUNT(*) FROM t2;
267 SELECT COUNT(*) FROM t3;
268 BEGIN;
269 INSERT INTO t1 VALUES (6, repeat('f',15));
270 INSERT INTO t2 VALUES (6, repeat('f',15));
271 INSERT INTO t3 VALUES (6, repeat('f',15));
272
273 --echo # Connection default
274 connection default;
275 let $restart_parameters = restart: --innodb_rollback_segments=2 --innodb_validate_tablespace_paths=0;
276 --source include/kill_and_restart_mysqld.inc
277 disconnect con1;
278
279 SHOW VARIABLES LIKE 'innodb_rollback_segments';
280 SHOW GLOBAL STATUS LIKE '%undo%';
281 SELECT NAME, ROW_FORMAT, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
282 WHERE name LIKE '%undo%' ORDER BY NAME;
283 SELECT TABLESPACE_NAME, FILE_TYPE, FILE_NAME FROM INFORMATION_SCHEMA.FILES
284 WHERE FILE_NAME LIKE '%undo%' ORDER BY TABLESPACE_NAME;
285 --echo # Directory listing of UNDO tablespace files
286 --list_files $MYSQLD_DATADIR undo_0*
287 SELECT * FROM t1 ORDER BY a;
288 SELECT COUNT(*) FROM t2;
289 SELECT COUNT(*) FROM t3;
290
291 --echo #
292 --echo # Kill and restart mysqld with more undo tablespaces=6 and more rollback segments=7.
293 --echo #
294 connect (con1,localhost,root);
295 --echo # Connection 1
296 BEGIN;
297 INSERT INTO t1 VALUES (7, repeat('g',15));
298 INSERT INTO t2 VALUES (7, repeat('g',15));
299 INSERT INTO t3 VALUES (7, repeat('g',15));
300 connection default;
301 --echo # Connection default
302 ALTER UNDO TABLESPACE `undo_003` SET ACTIVE;
303 ALTER UNDO TABLESPACE `undo_004` SET ACTIVE;
304 CREATE UNDO TABLESPACE `undo_006` ADD DATAFILE 'undo_006.ibu';
305 SHOW WARNINGS;
306 let $restart_parameters = restart: --innodb_rollback_segments=7;
307 --source include/kill_and_restart_mysqld.inc
308 disconnect con1;
309 SHOW VARIABLES LIKE 'innodb_rollback_segments';
310 SHOW GLOBAL STATUS LIKE '%undo%';
311 SELECT NAME, ROW_FORMAT, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
312 WHERE name LIKE '%undo%' ORDER BY NAME;
313 SELECT TABLESPACE_NAME, FILE_TYPE, FILE_NAME FROM INFORMATION_SCHEMA.FILES
314 WHERE FILE_NAME LIKE '%undo%' ORDER BY TABLESPACE_NAME;
315 --echo # Directory listing of UNDO tablespace files
316 --list_files $MYSQLD_DATADIR undo_0*
317 SELECT * FROM t1 ORDER BY a;
318 SELECT COUNT(*) FROM t2;
319 SELECT COUNT(*) FROM t3;
320
321 --echo #
322 --echo # Restart mysqld in read-only mode with more rollback segments=8.
323 --echo #
324 connect (con1,localhost,root);
325 --echo # Connection 1
326 INSERT INTO t1 VALUES (8, repeat('h',15));
327 INSERT INTO t2 VALUES (8, repeat('h',15));
328 INSERT INTO t3 VALUES (8, repeat('h',15));
329 connection default;
330 --echo # Connection default
331 SELECT * FROM t1 ORDER BY a;
332 SELECT COUNT(*) FROM t2;
333 SELECT COUNT(*) FROM t3;
334 let $extra_restart_parameters=--innodb_rollback_segments=8;
335 --source include/restart_innodb_read_only.inc
336 disconnect con1;
337 --error ER_READ_ONLY_MODE
338 CREATE UNDO TABLESPACE `undo_007` ADD DATAFILE 'undo_007.ibu';
339 SHOW VARIABLES LIKE 'innodb_rollback_segments';
340 SHOW GLOBAL STATUS LIKE '%undo%';
341 SELECT NAME, ROW_FORMAT, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
342 WHERE name LIKE '%undo%' ORDER BY NAME;
343 SELECT TABLESPACE_NAME, FILE_TYPE, FILE_NAME FROM INFORMATION_SCHEMA.FILES
344 WHERE FILE_NAME LIKE '%undo%' ORDER BY TABLESPACE_NAME;
345 --echo # Directory listing of UNDO tablespace files
346 --list_files $MYSQLD_DATADIR undo_0*
347 SET GLOBAL innodb_rollback_segments=8;
348 SHOW VARIABLES LIKE 'innodb_rollback_segments';
349 SET GLOBAL innodb_rollback_segments=3;
350 SHOW VARIABLES LIKE 'innodb_rollback_segments';
351 SELECT * FROM t1 ORDER BY a;
352 SELECT COUNT(*) FROM t2;
353 SELECT COUNT(*) FROM t3;
354
355 --echo #
356 --echo # Restart mysqld in force_recovery mode with more rollback segments=8.
357 --echo #
358 let $restart_parameters = restart: --innodb_force_recovery=1 --innodb_rollback_segments=8;
359 --source include/restart_mysqld.inc
360 --error ER_INNODB_READ_ONLY
361 CREATE UNDO TABLESPACE `undo_007` ADD DATAFILE 'undo_007.ibu';
362 SHOW GLOBAL STATUS LIKE '%undo%';
363 SELECT NAME, ROW_FORMAT, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
364 WHERE name LIKE '%undo%' ORDER BY NAME;
365 SELECT TABLESPACE_NAME, FILE_TYPE, FILE_NAME FROM INFORMATION_SCHEMA.FILES
366 WHERE FILE_NAME LIKE '%undo%' ORDER BY TABLESPACE_NAME;
367 --echo # Directory listing of UNDO tablespace files
368 --list_files $MYSQLD_DATADIR undo_0*
369 SHOW VARIABLES LIKE 'innodb_rollback_segments';
370 SET GLOBAL innodb_rollback_segments=8;
371 SHOW VARIABLES LIKE 'innodb_rollback_segments';
372 SET GLOBAL innodb_rollback_segments=3;
373 SHOW VARIABLES LIKE 'innodb_rollback_segments';
374 SELECT * FROM t1 ORDER BY a;
375 SELECT COUNT(*) FROM t2;
376 SELECT COUNT(*) FROM t3;
377
378 --echo #
379 --echo # Use SET PERSIST to change rollback segments=11
380 --echo # and make some undo logs that must be rolled back on restart.
381 --echo #
382 let $restart_parameters = restart: --innodb_rollback_segments=8;
383 --source include/restart_mysqld.inc
384 BEGIN;
385 INSERT INTO t1 VALUES (9, repeat('i',15));
386 INSERT INTO t2 VALUES (9, repeat('i',15));
387 INSERT INTO t3 VALUES (9, repeat('i',15));
388 SET PERSIST innodb_rollback_segments=11;
389 SHOW VARIABLES LIKE 'innodb_rollback_segments';
390 INSERT INTO t1 VALUES (10, repeat('j',15));
391 INSERT INTO t2 VALUES (10, repeat('j',15));
392 INSERT INTO t3 VALUES (10, repeat('j',15));
393
394 --echo #
395 --echo # Restart in normal mode with default undo tablespaces and rollback segments.
396 --echo # The persisted settings will be set just after startup.
397 --echo #
398 let $restart_parameters = restart;
399 --source include/restart_mysqld.inc
400 SHOW VARIABLES LIKE 'innodb_rollback_segments';
401 SHOW GLOBAL STATUS LIKE '%undo%';
402 SELECT NAME, ROW_FORMAT, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
403 WHERE name LIKE '%undo%' ORDER BY NAME;
404 SELECT TABLESPACE_NAME, FILE_TYPE, FILE_NAME FROM INFORMATION_SCHEMA.FILES
405 WHERE FILE_NAME LIKE '%undo%' ORDER BY TABLESPACE_NAME;
406 --echo # Directory listing of UNDO tablespace files
407 --list_files $MYSQLD_DATADIR undo_0*
408 SELECT * FROM t1 ORDER BY a;
409 SELECT COUNT(*) FROM t2;
410 SELECT COUNT(*) FROM t3;
411 INSERT INTO t1 VALUES (11, repeat('k',15));
412 INSERT INTO t2 VALUES (11, repeat('k',15));
413 INSERT INTO t3 VALUES (11, repeat('k',15));
414 SELECT * FROM t1 ORDER BY a;
415 SELECT COUNT(*) FROM t2;
416 SELECT COUNT(*) FROM t3;
417
418 --echo #
419 --echo # Cleanup
420 --echo #
421 DROP TABLE t1;
422 DROP TABLE t2;
423 DROP TABLE t3;
424 DROP TABLESPACE ts1;
425 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
426 ALTER UNDO TABLESPACE undo_004 SET INACTIVE;
427 ALTER UNDO TABLESPACE undo_005 SET INACTIVE;
428 ALTER UNDO TABLESPACE undo_006 SET INACTIVE;
429 let $inactive_undo_space = undo_003;
430 source include/wait_until_undo_space_is_empty.inc;
431 let $inactive_undo_space = undo_004;
432 source include/wait_until_undo_space_is_empty.inc;
433 let $inactive_undo_space = undo_005;
434 source include/wait_until_undo_space_is_empty.inc;
435 let $inactive_undo_space = undo_006;
436 source include/wait_until_undo_space_is_empty.inc;
437 DROP UNDO TABLESPACE undo_003;
438 DROP UNDO TABLESPACE undo_004;
439 DROP UNDO TABLESPACE undo_005;
440 DROP UNDO TABLESPACE undo_006;
441
442 SET PERSIST innodb_rollback_segments=20;
443 SHOW VARIABLES LIKE 'innodb_rollback_segments';
444 RESET PERSIST innodb_rollback_segments;
445 SHOW VARIABLES LIKE 'innodb_rollback_segments';
446
447 SET GLOBAL innodb_rollback_segments=default;
448 SHOW VARIABLES LIKE 'innodb_rollback_segments';
449
450 SET GLOBAL innodb_fast_shutdown=0;
451 --source include/shutdown_mysqld.inc
452 --remove_files_wildcard $MYSQLD_DATADIR undo_0*
453 --source include/start_mysqld.inc
454 SHOW VARIABLES LIKE 'innodb_rollback_segments';
455
456 --disable_query_log
457 call mtr.add_suppression("Skip re-populating collations and character sets tables in InnoDB read-only mode");
458 call mtr.add_suppression("\\[Warning\\].*Cannot set innodb_rollback_segments to [8,3] when in read-only mode");
459 call mtr.add_suppression("\\[Warning\\].*Cannot set innodb_rollback_segments to [8,3] when in innodb_force_recovery > 0");
460 call mtr.add_suppression("\\[Warning\\].*Doublewrite page .* could not be restored. File name unknown for tablespace ID");
461 --enable_query_log
462