Debian Codegraph @

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

raw
1 # Initialize new data directory...
2 # Restart on the new data directory...
3 # restart: --datadir=tmp/test_data_dir --log-error=my_restart.err
4 SELECT @@GLOBAL.innodb_redo_log_capacity;
5 @@GLOBAL.innodb_redo_log_capacity
6 10485760
7 SELECT @@GLOBAL.innodb_data_file_path;
8 @@GLOBAL.innodb_data_file_path
9 ibdata1:12M:autoextend
10 # Disable page cleaner to have redo logs for recovery later on
11 SET GLOBAL innodb_dict_stats_disabled_debug = 1;
12 SET GLOBAL innodb_master_thread_disabled_debug = 1;
13 SET GLOBAL debug = "+d,disable_se_persists_gtid";
14 FLUSH ENGINE LOGS;
15 SET GLOBAL debug = "+d,gtid_persist_flush_disable";
16 SET GLOBAL innodb_log_checkpoint_now = 1;
17 SET GLOBAL innodb_page_cleaner_disabled_debug = 1;
18 SET GLOBAL innodb_checkpoint_disabled = 1;
19 SET GLOBAL innodb_purge_stop_now = 1;
20 SET @@GLOBAL.DEBUG='+d,ib_redo_log_system_tablespace_expansion';
21 SET GLOBAL innodb_limit_optimistic_insert_debug=2;
22 CREATE TABLE t1 (id INT NOT NULL AUTO_INCREMENT, name VARCHAR(50),
23 PRIMARY KEY (`id`)) TABLESPACE=innodb_system;
24 INSERT INTO t1 VALUES(0, REPEAT('a', 50));
25 #
26 # Insert 2^8 records
27 #
28 Pattern "System tablespace expansion is redo logged" found
29 SET @@GLOBAL.DEBUG='-d,ib_redo_log_system_tablespace_expansion';
30 # Verify no issues observed during crash recovery
31 # Kill and restart: --datadir=tmp/test_data_dir --log-error=temp/mysqld_test.err
32 SELECT * FROM t1 ORDER BY id LIMIT 1;
33 id name
34 1 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
35 DROP TABLE t1;
36 #
37 # Cleanup
38 #
39 # restart: