Debian Codegraph @

mysql-test/suite/mariabackup/big_innodb_log.result

raw
1 # Kill the server
2 # restart: --debug-dbug=+d,innodb_small_log_block_no_limit
3 CREATE TABLE t(i INT) ENGINE InnoDB;
4 INSERT INTO t VALUES
5 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
6 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
7 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
8 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
9 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
10 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
11 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
12 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
13 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
14 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9);
15 set global innodb_log_checkpoint_now = 1;
16 # xtrabackup backup, execute the following query after test.t is copied:
17 # BEGIN NOT ATOMIC INSERT INTO test.t SELECT * FROM test.t; UPDATE test.t SET i = 10 WHERE i = 0; DELETE FROM test.t WHERE i = 1; END
18 SELECT count(*) FROM t WHERE i = 0;
19 count(*)
20 0
21 # xtrabackup prepare
22 # shutdown server
23 # remove datadir
24 # xtrabackup move back
25 # restart: --debug-dbug=+d,innodb_small_log_block_no_limit
26 SELECT count(*) FROM t WHERE i = 0;
27 count(*)
28 0
29 Ok
30 Ok
31 DROP TABLE t;
32 # Kill the server
33 # restart