Debian Codegraph @

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

raw
1 --echo # Test resizing the InnoDB redo log.
2
3 --source include/have_debug.inc
4
5 --source ../include/redo_log_error_patterns.inc
6
7 SET GLOBAL innodb_checkpoint_disabled = 1;
8 SET GLOBAL innodb_fast_shutdown = 2;
9
10 CREATE TABLE t1(id INT PRIMARY KEY,bfield BLOB) ENGINE=InnoDB;
11 INSERT INTO t1 VALUES (1,repeat('a',2000)),(2,repeat('b',2000)),
12 (3,repeat('c',2000));
13 START TRANSACTION;
14 INSERT INTO t1 VALUES (11,repeat('a',2000)),(12,repeat('b',2000)),
15 (13,repeat('c',2000));
16 SAVEPOINT A;
17 INSERT INTO t1 VALUES (21,repeat('a',2000)),(22,repeat('b',2000)),
18 (23,repeat('c',2000));
19 SAVEPOINT B;
20 SELECT id,LEFT(bfield,20) FROM t1;
21 ROLLBACK TO A;
22 COMMIT;
23 SELECT id,LEFT(bfield,20) FROM t1;
24
25 --echo
26 --echo # Restart with different redo log size (20M)
27 --let $MYSQLD_LOG_1= $MYSQLTEST_VARDIR/log/log_file_size-1.log
28 --let $restart_parameters = "restart: --innodb-redo-log-capacity=20M --log-error=$MYSQLD_LOG_1"
29 --replace_result $MYSQLD_LOG_1 MYSQLD_LOG
30 --source include/restart_mysqld.inc
31
32 SET GLOBAL innodb_checkpoint_disabled = 1;
33 SET GLOBAL innodb_fast_shutdown = 2;
34
35 let SEARCH_FILE= $MYSQLD_LOG_1;
36 let SEARCH_PATTERN= $PATTERN_STARTING_CRASH_RECOVERY;
37 --source include/search_pattern.inc
38
39 SELECT id,LEFT(bfield,20) FROM t1;
40
41 --ERROR ER_DUP_ENTRY
42 INSERT INTO t1 VALUES (1,repeat('a',2000)),(2,repeat('b',2000)),
43 (3,repeat('c',2000));
44 INSERT INTO t1 VALUES (21,repeat('a',2000)),(22,repeat('b',2000)),
45 (23,repeat('c',2000));
46 SELECT id,LEFT(bfield,20) FROM t1;
47
48 --echo
49 --echo # Restart with different redo log size (8M)
50 --let $MYSQLD_LOG_2= $MYSQLTEST_VARDIR/log/log_file_size-2.log
51 --let $restart_parameters = "restart: --innodb-redo-log-capacity=8M --log-error=$MYSQLD_LOG_2"
52 --replace_result $MYSQLD_LOG_2 MYSQLD_LOG
53 --source include/restart_mysqld.inc
54
55 SET GLOBAL innodb_checkpoint_disabled = 1;
56 SET GLOBAL innodb_fast_shutdown = 2;
57
58 let SEARCH_FILE= $MYSQLD_LOG_2;
59 let SEARCH_PATTERN= $PATTERN_STARTING_CRASH_RECOVERY;
60 --source include/search_pattern.inc
61
62 --ERROR ER_DUP_ENTRY
63 INSERT INTO t1 VALUES (21,repeat('a',2000));
64 INSERT INTO t1 VALUES (24,repeat('a',2000)),(25,repeat('b',2000));
65 SELECT id,LEFT(bfield,20) FROM t1;
66
67 --echo
68 --echo # Restart with default parameters
69 let $restart_parameters=restart:;
70 --source include/restart_mysqld.inc
71
72 --echo
73 --echo # Cleanup
74 DROP TABLE t1;
75
76 # It might be useful to comment out code below, when debugging test failures
77 --remove_file $MYSQLD_LOG_1
78 --remove_file $MYSQLD_LOG_2