Debian Codegraph @

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

raw
1 --source include/have_debug.inc
2
3 --source include/ib_log_spammer_init.inc
4
5 SET GLOBAL innodb_log_checkpoint_now = 1;
6
7 let SEARCH_FILE=$MYSQLTEST_VARDIR/log/mysqld.1.err;
8
9 --echo # Initial state:
10 SELECT variable_name, variable_value FROM performance_schema.global_status
11 WHERE variable_name = 'Innodb_redo_log_capacity_resized';
12
13 --echo # Resize redo log to 100M:
14 SET GLOBAL innodb_redo_log_capacity = 100*1024*1024;
15
16 let SEARCH_PATTERN=User has set innodb_redo_log_capacity to 100M;
17 --source include/search_pattern.inc
18 let SEARCH_PATTERN=Redo log has been resized to 100M;
19 --source include/search_pattern.inc
20
21 --echo # Current state:
22 SELECT variable_name, variable_value FROM performance_schema.global_status
23 WHERE variable_name = 'Innodb_redo_log_capacity_resized';
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 # Disable checkpointing to ensure redo would grow and to allow test of redo-resize cancellation.
31 SET GLOBAL innodb_checkpoint_disabled = 1;
32
33 --echo # Wait until redo occupies at least 10MB
34 let $wait_timeout= 600;
35 let $wait_condition =
36 SELECT variable_value >= 10*1024*1024
37 FROM performance_schema.global_status
38 WHERE variable_name = 'Innodb_redo_log_logical_size';
39 --source include/wait_condition.inc
40
41 --echo # Start resizing down the redo log (spammer is working in background)
42 SET GLOBAL innodb_redo_log_capacity = 9*1024*1024;
43
44 let SEARCH_PATTERN=User has set innodb_redo_log_capacity to 9M;
45 --source include/search_pattern.inc
46 let SEARCH_PATTERN=Redo log has been requested to resize from 100M to 9M;
47 --source include/search_pattern.inc
48 --echo # Expected - not found:
49 let SEARCH_PATTERN=Redo log has been resized to 9M;
50 --source include/search_pattern.inc
51
52 --echo # Checkpoint is still disabled so resize hasn't been finished. Cancel the resize.
53 SET GLOBAL innodb_redo_log_capacity = 102*1024*1024;
54 let SEARCH_PATTERN=User has set innodb_redo_log_capacity to 102M;
55 --source include/search_pattern.inc
56 let SEARCH_PATTERN=Redo log resize has been cancelled;
57 --source include/search_pattern.inc
58 let SEARCH_PATTERN=Redo log has been resized to 102M;
59 --source include/search_pattern.inc
60
61 --echo # Restart resizing down.
62 SET GLOBAL innodb_redo_log_capacity = 8*1024*1024;
63 let SEARCH_PATTERN=User has set innodb_redo_log_capacity to 8M;
64 --source include/search_pattern.inc
65 let SEARCH_PATTERN=Redo log has been requested to resize from 102M to 8M;
66 --source include/search_pattern.inc
67 --echo # Expected - not found:
68 let SEARCH_PATTERN=Redo log has been resized to 8M;
69 --source include/search_pattern.inc
70
71 SET GLOBAL innodb_checkpoint_disabled = 0;
72
73 --echo # Waiting for status = OK....
74 let $wait_timeout= 600;
75 let $wait_condition =
76 SELECT variable_value = 'OK'
77 FROM performance_schema.global_status
78 WHERE variable_name = 'Innodb_redo_log_resize_status';
79 --source include/wait_condition.inc
80
81 let SEARCH_PATTERN=Redo log has been resized to 8M;
82 --source include/search_pattern.inc
83
84 --echo # Current state:
85 SELECT variable_name, variable_value FROM performance_schema.global_status
86 WHERE variable_name = 'Innodb_redo_log_capacity_resized';
87
88 let MYSQLD_DATADIR = `SELECT @@datadir`;
89 let MYSQLD_IB_REDO_LOG_PHYSICAL_CAPACITY = 8388608;
90 --source include/ib_redo_log_capacity_check.inc
91
92 --echo # Kill and restart mysql:
93 --source include/kill_and_restart_mysqld.inc
94
95 --echo # Initial state:
96 SELECT variable_name, variable_value FROM performance_schema.global_status
97 WHERE variable_name = 'Innodb_redo_log_capacity_resized';
98
99 --echo # Resize redo log to 500M:
100 SET GLOBAL innodb_redo_log_capacity = 500*1024*1024;
101
102 --echo # Current state:
103 SELECT variable_name, variable_value FROM performance_schema.global_status
104 WHERE variable_name = 'Innodb_redo_log_capacity_resized';
105
106 --echo # Create connection which generates spam to the redo log.
107 --connect(C2,localhost,root,,test)
108 --send CALL log_spammer()
109 --connection default
110
111 --echo # Wait until redo occupies at least 10MB
112 let $wait_timeout= 600;
113 let $wait_condition =
114 SELECT variable_value >= 10*1024*1024
115 FROM performance_schema.global_status
116 WHERE variable_name = 'Innodb_redo_log_physical_size';
117 --source include/wait_condition.inc
118
119 --echo # Kill and restart mysql with --innodb-redo-log-capacity=1G:
120 --let $restart_parameters = restart: --innodb-redo-log-capacity=1G
121 --source include/kill_and_restart_mysqld.inc
122
123 --echo # Initial state:
124 SELECT variable_name, variable_value FROM performance_schema.global_status
125 WHERE variable_name = 'Innodb_redo_log_capacity_resized';
126
127 --echo # Start resizing down the redo log (spammer is NOT working in background)
128 SET GLOBAL innodb_redo_log_capacity = 8*1024*1024;
129
130 --echo # Waiting for status = OK....
131 let $wait_timeout= 60000;
132 let $wait_condition =
133 SELECT variable_value = 'OK'
134 FROM performance_schema.global_status
135 WHERE variable_name = 'Innodb_redo_log_resize_status';
136 --source include/wait_condition.inc
137
138 --echo # Current state:
139 SELECT variable_name, variable_value FROM performance_schema.global_status
140 WHERE variable_name = 'Innodb_redo_log_capacity_resized';
141
142 let MYSQLD_DATADIR = `SELECT @@datadir`;
143 let MYSQLD_IB_REDO_LOG_PHYSICAL_CAPACITY = 8388608;
144 --source include/ib_redo_log_capacity_check.inc
145
146 --echo # Create connection which generates spam to the redo log.
147 --connect(C3,localhost,root,,test)
148 --send CALL log_spammer()
149 --connection default
150
151 --echo # Resize redo log to 1GB:
152 SET GLOBAL innodb_redo_log_capacity = 1024*1024*1024;
153
154 --echo # Current state:
155 SELECT variable_name, variable_value FROM performance_schema.global_status
156 WHERE variable_name = 'Innodb_redo_log_capacity_resized';
157
158 --echo # Wait until redo occupies at least 20MB
159 let $wait_timeout= 600;
160 let $wait_condition =
161 SELECT variable_value >= 20*1024*1024
162 FROM performance_schema.global_status
163 WHERE variable_name = 'Innodb_redo_log_physical_size';
164 --source include/wait_condition.inc
165
166 --echo # Kill and restart mysql without --innodb-redo-log-capacity
167 --let $restart_parameters = restart:
168 --source include/kill_and_restart_mysqld.inc
169
170 let SEARCH_PATTERN=Redo log has been requested to resize from .* to .*M;
171 --source include/search_pattern.inc
172
173 --source include/ib_log_spammer_cleanup.inc