# Test resizing the InnoDB redo log. SET GLOBAL innodb_checkpoint_disabled = 1; SET GLOBAL innodb_fast_shutdown = 2; CREATE TABLE t1(id INT PRIMARY KEY,bfield BLOB) ENGINE=InnoDB; INSERT INTO t1 VALUES (1,repeat('a',2000)),(2,repeat('b',2000)), (3,repeat('c',2000)); START TRANSACTION; INSERT INTO t1 VALUES (11,repeat('a',2000)),(12,repeat('b',2000)), (13,repeat('c',2000)); SAVEPOINT A; INSERT INTO t1 VALUES (21,repeat('a',2000)),(22,repeat('b',2000)), (23,repeat('c',2000)); SAVEPOINT B; SELECT id,LEFT(bfield,20) FROM t1; id LEFT(bfield,20) 1 aaaaaaaaaaaaaaaaaaaa 2 bbbbbbbbbbbbbbbbbbbb 3 cccccccccccccccccccc 11 aaaaaaaaaaaaaaaaaaaa 12 bbbbbbbbbbbbbbbbbbbb 13 cccccccccccccccccccc 21 aaaaaaaaaaaaaaaaaaaa 22 bbbbbbbbbbbbbbbbbbbb 23 cccccccccccccccccccc ROLLBACK TO A; COMMIT; SELECT id,LEFT(bfield,20) FROM t1; id LEFT(bfield,20) 1 aaaaaaaaaaaaaaaaaaaa 2 bbbbbbbbbbbbbbbbbbbb 3 cccccccccccccccccccc 11 aaaaaaaaaaaaaaaaaaaa 12 bbbbbbbbbbbbbbbbbbbb 13 cccccccccccccccccccc # Restart with different redo log size (20M) # restart: --innodb-redo-log-capacity=20M --log-error=MYSQLD_LOG SET GLOBAL innodb_checkpoint_disabled = 1; SET GLOBAL innodb_fast_shutdown = 2; Pattern "Starting crash recovery" found SELECT id,LEFT(bfield,20) FROM t1; id LEFT(bfield,20) 1 aaaaaaaaaaaaaaaaaaaa 2 bbbbbbbbbbbbbbbbbbbb 3 cccccccccccccccccccc 11 aaaaaaaaaaaaaaaaaaaa 12 bbbbbbbbbbbbbbbbbbbb 13 cccccccccccccccccccc INSERT INTO t1 VALUES (1,repeat('a',2000)),(2,repeat('b',2000)), (3,repeat('c',2000)); ERROR 23000: Duplicate entry '1' for key 't1.PRIMARY' INSERT INTO t1 VALUES (21,repeat('a',2000)),(22,repeat('b',2000)), (23,repeat('c',2000)); SELECT id,LEFT(bfield,20) FROM t1; id LEFT(bfield,20) 1 aaaaaaaaaaaaaaaaaaaa 2 bbbbbbbbbbbbbbbbbbbb 3 cccccccccccccccccccc 11 aaaaaaaaaaaaaaaaaaaa 12 bbbbbbbbbbbbbbbbbbbb 13 cccccccccccccccccccc 21 aaaaaaaaaaaaaaaaaaaa 22 bbbbbbbbbbbbbbbbbbbb 23 cccccccccccccccccccc # Restart with different redo log size (8M) # restart: --innodb-redo-log-capacity=8M --log-error=MYSQLD_LOG SET GLOBAL innodb_checkpoint_disabled = 1; SET GLOBAL innodb_fast_shutdown = 2; Pattern "Starting crash recovery" found INSERT INTO t1 VALUES (21,repeat('a',2000)); ERROR 23000: Duplicate entry '21' for key 't1.PRIMARY' INSERT INTO t1 VALUES (24,repeat('a',2000)),(25,repeat('b',2000)); SELECT id,LEFT(bfield,20) FROM t1; id LEFT(bfield,20) 1 aaaaaaaaaaaaaaaaaaaa 2 bbbbbbbbbbbbbbbbbbbb 3 cccccccccccccccccccc 11 aaaaaaaaaaaaaaaaaaaa 12 bbbbbbbbbbbbbbbbbbbb 13 cccccccccccccccccccc 21 aaaaaaaaaaaaaaaaaaaa 22 bbbbbbbbbbbbbbbbbbbb 23 cccccccccccccccccccc 24 aaaaaaaaaaaaaaaaaaaa 25 bbbbbbbbbbbbbbbbbbbb # Restart with default parameters # restart: # Cleanup DROP TABLE t1;