Debian Codegraph @

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

raw
1 --source include/have_debug.inc
2
3 --source include/ib_log_spammer_init.inc
4
5 CREATE TABLE t(a INT PRIMARY KEY, b INT);
6 INSERT INTO t(a, b) VALUES(1, 1);
7
8 let SEARCH_FILE=$MYSQLTEST_VARDIR/log/mysqld.1.err;
9
10 SET GLOBAL innodb_log_checkpoint_now = 1;
11
12 SET GLOBAL DEBUG = 'd,log_force_consumption';
13
14 --echo # Wait until redo occupies no more than 1MB on disk
15 let $wait_timeout= 600;
16 let $wait_condition =
17 SELECT variable_value <= 1024*1024
18 FROM performance_schema.global_status
19 WHERE variable_name = 'Innodb_redo_log_physical_size';
20 --source include/wait_condition.inc
21
22 --echo # Resize redo log to 100M:
23 SET GLOBAL innodb_redo_log_capacity = 100*1024*1024;
24
25 --echo # Create connection which generates spam to the redo log.
26 --connect(C1,localhost,root,,test)
27 --send CALL log_spammer()
28 --connection default
29
30 --echo # Wait until redo occupies at least 10MB on disk
31 let $wait_timeout= 600;
32 let $wait_condition =
33 SELECT variable_value >= 10*1024*1024
34 FROM performance_schema.global_status
35 WHERE variable_name = 'Innodb_redo_log_physical_size';
36 --source include/wait_condition.inc
37
38 --echo # Kill and restart mysql allowing initially big redo log:
39 let $restart_parameters = restart: --innodb-redo-log-capacity=104857600;
40 --source include/kill_and_restart_mysqld.inc
41 let $restart_parameters = restart:;
42
43 --echo # Initial state:
44 SELECT variable_name, variable_value FROM performance_schema.global_status
45 WHERE variable_name = 'Innodb_redo_log_capacity_resized';
46
47 SET GLOBAL DEBUG = '+d,log_force_consumption';
48
49 --echo # Waiting until we have exactly 1 redo log file.
50 let MYSQLD_DATADIR=`SELECT @@datadir`;
51 let MYSQLD_IB_REDO_LOG_NON_TMP_FILES_COUNT_MAX = 1;
52 --source include/ib_redo_log_files_count_wait.inc
53
54 SET GLOBAL DEBUG = '-d,log_force_consumption';
55
56 --echo # Resize redo log to 8M:
57 SET GLOBAL innodb_redo_log_capacity = 8*1024*1024;
58
59 --echo # Waiting for status = OK....
60 let $wait_timeout= 60000;
61 let $wait_condition =
62 SELECT variable_value = 'OK'
63 FROM performance_schema.global_status
64 WHERE variable_name = 'Innodb_redo_log_resize_status';
65 --source include/wait_condition.inc
66
67 --echo # Current state:
68 SELECT variable_name, variable_value FROM performance_schema.global_status
69 WHERE variable_name = 'Innodb_redo_log_capacity_resized';
70
71 let MYSQLD_DATADIR = `SELECT @@datadir`;
72 let MYSQLD_IB_REDO_LOG_PHYSICAL_CAPACITY = 8388608;
73 --source include/ib_redo_log_capacity_check.inc
74
75 let SEARCH_PATTERN=Truncating redo log file;
76 --source include/search_pattern.inc
77
78 UPDATE t SET b = 2 WHERE a = 1;
79
80 CALL mtr.add_suppression("The last block of redo had corrupted first_rec_group");
81
82 --source include/kill_and_restart_mysqld.inc
83
84 SELECT * FROM t;
85
86 DROP TABLE t;
87
88 --source include/ib_log_spammer_cleanup.inc