1CREATE TABLE t1(a INT PRIMARY KEY) ENGINE=InnoDB; 2# restart: --innodb-thread-concurrency=1 --innodb-log-file-size=1m --innodb-log-files-in-group=2 3SELECT * FROM INFORMATION_SCHEMA.ENGINES 4WHERE engine = 'innodb' 5AND support IN ('YES', 'DEFAULT', 'ENABLED'); 6ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS 7FOUND 1 /InnoDB: Log file .*ib_logfile1 is of different size .* bytes than other log files 0 bytes!/ in mysqld.1.err 8# restart: --innodb-thread-concurrency=1 --innodb-log-file-size=1m --innodb-log-files-in-group=2 9CHECK TABLE t1; 10Table Op Msg_type Msg_text 11test.t1 check status OK 12# restart: --innodb-thread-concurrency=100 --innodb-log-file-size=10M --innodb-log-files-in-group=2 13BEGIN; 14INSERT INTO t1 VALUES (42); 15# restart: --innodb-log-file-size=6M 16SELECT * FROM t1; 17a 18INSERT INTO t1 VALUES (42); 19BEGIN; 20DELETE FROM t1; 21# restart: --innodb-log-files-in-group=3 --innodb-log-file-size=5M 22SELECT * FROM t1; 23a 2442 25INSERT INTO t1 VALUES (0),(123); 26BEGIN; 27DELETE FROM t1 WHERE a>0; 28# Persist the state of the above incomplete transaction by 29# causing a redo log write for another transaction. 30connect con1, localhost, root; 31SET GLOBAL innodb_flush_log_at_trx_commit=1; 32DELETE FROM t1 WHERE a=0; 33disconnect con1; 34connection default; 35# Kill the server 36# restart: --innodb-log-group-home-dir=foo\;bar 37SELECT * FROM t1; 38ERROR 42000: Unknown storage engine 'InnoDB' 39FOUND 1 /syntax error in innodb_log_group_home_dir/ in mysqld.1.err 40# restart: --debug=d,innodb_log_abort_1 41SELECT * FROM t1; 42ERROR 42000: Unknown storage engine 'InnoDB' 43FOUND 1 /InnoDB: Starting crash recovery from checkpoint LSN=.*/ in mysqld.1.err 44# restart: --debug=d,innodb_log_abort_3 45SELECT * FROM t1; 46ERROR 42000: Unknown storage engine 'InnoDB' 47# restart: --innodb-read-only 48SELECT * FROM t1; 49ERROR 42000: Unknown storage engine 'InnoDB' 50FOUND 1 /InnoDB: innodb_read_only prevents crash recovery/ in mysqld.1.err 51# restart: --debug=d,innodb_log_abort_4 52SELECT * FROM t1; 53ERROR 42000: Unknown storage engine 'InnoDB' 54FOUND 2 /redo log from 3\*[0-9]+ to 2\*[0-9]+ bytes/ in mysqld.1.err 55# restart: --debug=d,innodb_log_abort_5 56SELECT * FROM t1; 57ERROR 42000: Unknown storage engine 'InnoDB' 58FOUND 3 /redo log from 3\*[0-9]+ to 2\*[0-9]+ bytes/ in mysqld.1.err 59# restart: --innodb-read-only 60SELECT * FROM t1; 61ERROR 42000: Unknown storage engine 'InnoDB' 62FOUND 2 /InnoDB: innodb_read_only prevents crash recovery/ in mysqld.1.err 63# restart: --debug=d,innodb_log_abort_6 64SELECT * FROM t1; 65ERROR 42000: Unknown storage engine 'InnoDB' 66FOUND 4 /redo log from 3\*[0-9]+ to 2\*[0-9]+ bytes/ in mysqld.1.err 67# restart: --debug=d,innodb_log_abort_7 68SELECT * FROM t1; 69ERROR 42000: Unknown storage engine 'InnoDB' 70# restart: --innodb-read-only 71SELECT * FROM t1; 72ERROR 42000: Unknown storage engine 'InnoDB' 73FOUND 1 /InnoDB: Cannot create log files in read-only mode/ in mysqld.1.err 74# restart: --debug=d,innodb_log_abort_8 75SELECT * FROM t1; 76ERROR 42000: Unknown storage engine 'InnoDB' 77FOUND 1 /InnoDB: Setting log file .*ib_logfile[0-9]+ size to/ in mysqld.1.err 78# restart: --debug=d,innodb_log_abort_9 79SELECT * FROM t1; 80ERROR 42000: Unknown storage engine 'InnoDB' 81FOUND 1 /InnoDB: Setting log file .*ib_logfile[0-9]+ size to/ in mysqld.1.err 82# restart: --debug=d,innodb_log_abort_9 83SELECT * FROM t1; 84ERROR 42000: Unknown storage engine 'InnoDB' 85FOUND 1 /InnoDB: Log file .*ib_logfile0 size 7 is not a multiple of 512 bytes/ in mysqld.1.err 86# restart: --debug=d,innodb_log_abort_9 87SELECT * FROM t1; 88ERROR 42000: Unknown storage engine 'InnoDB' 89FOUND 1 /InnoDB: Log file .*ib_logfile1 is of different size 1048576 bytes than other log files/ in mysqld.1.err 90# restart: --debug=d,innodb_log_abort_10 91SELECT * FROM t1; 92ERROR 42000: Unknown storage engine 'InnoDB' 93FOUND 1 /InnoDB: Setting log file .*ib_logfile[0-9]+ size to/ in mysqld.1.err 94FOUND 1 /InnoDB: Renaming log file .*ib_logfile101 to .*ib_logfile0/ in mysqld.1.err 95# restart 96SELECT * FROM t1; 97a 9842 99123 100DROP TABLE t1; 101