Debian Codegraph @

mysql-test/suite/innodb/t/innochecksum_undo_page.test

raw
1 --source include/have_innodb.inc
2 --source include/not_embedded.inc
3 let MYSQLD_DATADIR= `SELECT @@datadir`;
4
5 SET GLOBAL INNODB_FILE_PER_TABLE= 0;
6 CREATE TABLE t1(f1 INT NOT NULL)ENGINE=InnoDB;
7 INSERT INTO t1 VALUES(1);
8 DROP TABLE t1;
9 SET GLOBAL innodb_fast_shutdown=0;
10 --source include/shutdown_mysqld.inc
11
12 --echo # Run the innochecksum to display undo log pages
13 let $resultlog=$MYSQLTEST_VARDIR/tmp/result.log;
14 let SEARCH_FILE = $MYSQLTEST_VARDIR/tmp/result.log;
15 let SEARCH_ABORT = NOT FOUND;
16 exec $INNOCHECKSUM -S $MYSQLD_DATADIR/ibdata1 > $resultlog;
17 # Expected > 0 cached undo log pages, but can't guarantee it because
18 # the writes of freed pages may be optimized while flushing
19 let SEARCH_PATTERN= Undo page state: 0 active, [0-9]+ cached, [0-9]+ to_purge, [0-9]+ prepared, [0-9]+ other;
20 --source include/search_pattern_in_file.inc
21
22 --echo # Run the innochecksum with --skip-freed-pages
23 exec $INNOCHECKSUM -S -r $MYSQLD_DATADIR/ibdata1 > $resultlog;
24 let SEARCH_PATTERN= Undo page state: 0 active, 0 cached, 0 to_purge, 0 prepared, 0 other;
25 --source include/search_pattern_in_file.inc
26 --remove_file $resultlog
27 --source include/start_mysqld.inc