Debian Codegraph @

mysql-test/suite/innodb/r/log_file_size_1.result

raw
1 # Test resizing the InnoDB redo log.
2 SET GLOBAL innodb_checkpoint_disabled = 1;
3 SET GLOBAL innodb_fast_shutdown = 2;
4 CREATE TABLE t1(id INT PRIMARY KEY,bfield BLOB) ENGINE=InnoDB;
5 INSERT INTO t1 VALUES (1,repeat('a',2000)),(2,repeat('b',2000)),
6 (3,repeat('c',2000));
7 START TRANSACTION;
8 INSERT INTO t1 VALUES (11,repeat('a',2000)),(12,repeat('b',2000)),
9 (13,repeat('c',2000));
10 SAVEPOINT A;
11 INSERT INTO t1 VALUES (21,repeat('a',2000)),(22,repeat('b',2000)),
12 (23,repeat('c',2000));
13 SAVEPOINT B;
14 SELECT id,LEFT(bfield,20) FROM t1;
15 id LEFT(bfield,20)
16 1 aaaaaaaaaaaaaaaaaaaa
17 2 bbbbbbbbbbbbbbbbbbbb
18 3 cccccccccccccccccccc
19 11 aaaaaaaaaaaaaaaaaaaa
20 12 bbbbbbbbbbbbbbbbbbbb
21 13 cccccccccccccccccccc
22 21 aaaaaaaaaaaaaaaaaaaa
23 22 bbbbbbbbbbbbbbbbbbbb
24 23 cccccccccccccccccccc
25 ROLLBACK TO A;
26 COMMIT;
27 SELECT id,LEFT(bfield,20) FROM t1;
28 id LEFT(bfield,20)
29 1 aaaaaaaaaaaaaaaaaaaa
30 2 bbbbbbbbbbbbbbbbbbbb
31 3 cccccccccccccccccccc
32 11 aaaaaaaaaaaaaaaaaaaa
33 12 bbbbbbbbbbbbbbbbbbbb
34 13 cccccccccccccccccccc
35
36 # Restart with different redo log size (20M)
37 # restart: --innodb-redo-log-capacity=20M --log-error=MYSQLD_LOG
38 SET GLOBAL innodb_checkpoint_disabled = 1;
39 SET GLOBAL innodb_fast_shutdown = 2;
40 Pattern "Starting crash recovery" found
41 SELECT id,LEFT(bfield,20) FROM t1;
42 id LEFT(bfield,20)
43 1 aaaaaaaaaaaaaaaaaaaa
44 2 bbbbbbbbbbbbbbbbbbbb
45 3 cccccccccccccccccccc
46 11 aaaaaaaaaaaaaaaaaaaa
47 12 bbbbbbbbbbbbbbbbbbbb
48 13 cccccccccccccccccccc
49 INSERT INTO t1 VALUES (1,repeat('a',2000)),(2,repeat('b',2000)),
50 (3,repeat('c',2000));
51 ERROR 23000: Duplicate entry '1' for key 't1.PRIMARY'
52 INSERT INTO t1 VALUES (21,repeat('a',2000)),(22,repeat('b',2000)),
53 (23,repeat('c',2000));
54 SELECT id,LEFT(bfield,20) FROM t1;
55 id LEFT(bfield,20)
56 1 aaaaaaaaaaaaaaaaaaaa
57 2 bbbbbbbbbbbbbbbbbbbb
58 3 cccccccccccccccccccc
59 11 aaaaaaaaaaaaaaaaaaaa
60 12 bbbbbbbbbbbbbbbbbbbb
61 13 cccccccccccccccccccc
62 21 aaaaaaaaaaaaaaaaaaaa
63 22 bbbbbbbbbbbbbbbbbbbb
64 23 cccccccccccccccccccc
65
66 # Restart with different redo log size (8M)
67 # restart: --innodb-redo-log-capacity=8M --log-error=MYSQLD_LOG
68 SET GLOBAL innodb_checkpoint_disabled = 1;
69 SET GLOBAL innodb_fast_shutdown = 2;
70 Pattern "Starting crash recovery" found
71 INSERT INTO t1 VALUES (21,repeat('a',2000));
72 ERROR 23000: Duplicate entry '21' for key 't1.PRIMARY'
73 INSERT INTO t1 VALUES (24,repeat('a',2000)),(25,repeat('b',2000));
74 SELECT id,LEFT(bfield,20) FROM t1;
75 id LEFT(bfield,20)
76 1 aaaaaaaaaaaaaaaaaaaa
77 2 bbbbbbbbbbbbbbbbbbbb
78 3 cccccccccccccccccccc
79 11 aaaaaaaaaaaaaaaaaaaa
80 12 bbbbbbbbbbbbbbbbbbbb
81 13 cccccccccccccccccccc
82 21 aaaaaaaaaaaaaaaaaaaa
83 22 bbbbbbbbbbbbbbbbbbbb
84 23 cccccccccccccccccccc
85 24 aaaaaaaaaaaaaaaaaaaa
86 25 bbbbbbbbbbbbbbbbbbbb
87
88 # Restart with default parameters
89 # restart:
90
91 # Cleanup
92 DROP TABLE t1;