Debian Codegraph @

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

raw
1 --echo #######################################################################
2 --echo # Innodb Buffer Pool Resize Status Codes
3 --echo #
4 --echo # Print status codes that can be seen when resize is in progress. We
5 --echo # have a debug variable for each status code. The resize thread will
6 --echo # wait on the debug variable corresponding to the current status code.
7 --echo # This will allow the test to synchronize with the resize thread.
8 --echo #######################################################################
9
10 --source include/have_debug.inc
11 --source include/have_debug_sync.inc
12
13 --echo #######################################################################
14 --echo # Set all the debug variables and unset them after the query
15 --echo #######################################################################
16 --disable_query_log
17 SET @prev_size = @@innodb_buffer_pool_size;
18
19 SET GLOBAL debug = "+d,ib_buf_pool_resize_complete_status_code";
20 SET GLOBAL debug = "+d,ib_buf_pool_resize_start_status_code";
21 SET GLOBAL debug = "+d,ib_buf_pool_resize_disable_ahi_status_code";
22 SET GLOBAL debug = "+d,ib_buf_pool_resize_withdraw_blocks_status_code";
23 SET GLOBAL debug = "+d,ib_buf_pool_resize_global_lock_status_code";
24 SET GLOBAL debug = "+d,ib_buf_pool_resize_in_progress_status_code";
25 SET GLOBAL debug = "+d,ib_buf_pool_resize_hash_status_code";
26 SET GLOBAL debug = "+d,ib_buf_pool_resize_failed_status_code";
27 --enable_query_log
28
29 --echo #######################################################################
30 --echo # Query status code when no resize is in progress:
31 --echo #######################################################################
32 SELECT variable_name, variable_value FROM
33 performance_schema.global_status WHERE LOWER(variable_name) LIKE
34 'innodb_buffer_pool_resize_status%';
35
36 --echo #######################################################################
37 --echo # Trigger the resize operation to 4 times chunk size
38 --echo #######################################################################
39 SET GLOBAL innodb_buffer_pool_size = @prev_size + 4 * 25165824;
40
41 --echo #######################################################################
42 --echo # BUF_POOL_RESIZE_START (1)
43 --echo #######################################################################
44 LET $wait_timeout = 60;
45 LET $wait_condition =
46 SELECT variable_value = 1 FROM performance_schema.global_status
47 WHERE LOWER(variable_name) LIKE
48 'innodb_buffer_pool_resize_status_code';
49 --source include/wait_condition.inc
50
51 LET $wait_timeout = 60;
52 LET $wait_condition =
53 SELECT variable_value = 100 FROM performance_schema.global_status
54 WHERE LOWER(variable_name) LIKE
55 'innodb_buffer_pool_resize_status_progress';
56 --source include/wait_condition.inc
57
58 SELECT variable_name, variable_value FROM
59 performance_schema.global_status WHERE LOWER(variable_name) LIKE
60 'innodb_buffer_pool_resize_status%';
61
62 SET GLOBAL debug = "-d,ib_buf_pool_resize_start_status_code";
63
64 --echo #######################################################################
65 --echo # BUF_POOL_RESIZE_DISABLE_AHI (2)
66 --echo #######################################################################
67 LET $wait_timeout = 60;
68 LET $wait_condition =
69 SELECT variable_value = 2 FROM performance_schema.global_status
70 WHERE LOWER(variable_name) LIKE
71 'innodb_buffer_pool_resize_status_code';
72 --source include/wait_condition.inc
73
74 LET $wait_timeout = 60;
75 LET $wait_condition =
76 SELECT variable_value = 100 FROM performance_schema.global_status
77 WHERE LOWER(variable_name) LIKE
78 'innodb_buffer_pool_resize_status_progress';
79 --source include/wait_condition.inc
80
81 SELECT variable_name, variable_value FROM
82 performance_schema.global_status WHERE LOWER(variable_name) LIKE
83 'innodb_buffer_pool_resize_status%';
84
85 SET GLOBAL debug = "-d,ib_buf_pool_resize_disable_ahi_status_code";
86
87 --echo #######################################################################
88 --echo # BUF_POOL_RESIZE_WITHDRAW_BLOCKS (3)
89 --echo #######################################################################
90 LET $wait_timeout = 60;
91 LET $wait_condition =
92 SELECT variable_value = 3 FROM performance_schema.global_status
93 WHERE LOWER(variable_name) LIKE
94 'innodb_buffer_pool_resize_status_code';
95 --source include/wait_condition.inc
96
97 LET $wait_timeout = 60;
98 LET $wait_condition =
99 SELECT variable_value = 100 FROM performance_schema.global_status
100 WHERE LOWER(variable_name) LIKE
101 'innodb_buffer_pool_resize_status_progress';
102 --source include/wait_condition.inc
103
104 SELECT variable_name, variable_value FROM
105 performance_schema.global_status WHERE LOWER(variable_name) LIKE
106 'innodb_buffer_pool_resize_status%';
107
108 SET GLOBAL debug = "-d,ib_buf_pool_resize_withdraw_blocks_status_code";
109
110 --echo #######################################################################
111 --echo # BUF_POOL_RESIZE_GLOBAL_LOCK (4)
112 --echo #######################################################################
113 LET $wait_timeout = 60;
114 LET $wait_condition =
115 SELECT variable_value = 4 FROM performance_schema.global_status
116 WHERE LOWER(variable_name) LIKE
117 'innodb_buffer_pool_resize_status_code';
118 --source include/wait_condition.inc
119
120 LET $wait_timeout = 60;
121 LET $wait_condition =
122 SELECT variable_value = 100 FROM performance_schema.global_status
123 WHERE LOWER(variable_name) LIKE
124 'innodb_buffer_pool_resize_status_progress';
125 --source include/wait_condition.inc
126
127 SELECT variable_name, variable_value FROM
128 performance_schema.global_status WHERE LOWER(variable_name) LIKE
129 'innodb_buffer_pool_resize_status%';
130
131 SET GLOBAL debug = "-d,ib_buf_pool_resize_global_lock_status_code";
132
133 --echo #######################################################################
134 --echo # BUF_POOL_RESIZE_IN_PROGRESS (5)
135 --echo #######################################################################
136 LET $wait_timeout = 60;
137 LET $wait_condition =
138 SELECT variable_value = 5 FROM performance_schema.global_status
139 WHERE LOWER(variable_name) LIKE
140 'innodb_buffer_pool_resize_status_code';
141 --source include/wait_condition.inc
142
143 LET $wait_timeout = 60;
144 LET $wait_condition =
145 SELECT variable_value = 100 FROM performance_schema.global_status
146 WHERE LOWER(variable_name) LIKE
147 'innodb_buffer_pool_resize_status_progress';
148 --source include/wait_condition.inc
149
150 SELECT variable_name, variable_value FROM
151 performance_schema.global_status WHERE LOWER(variable_name) LIKE
152 'innodb_buffer_pool_resize_status%';
153
154 SET GLOBAL debug = "-d,ib_buf_pool_resize_in_progress_status_code";
155
156 --echo #######################################################################
157 --echo # BUF_POOL_RESIZE_HASH (6)
158 --echo #######################################################################
159 LET $wait_timeout = 60;
160 LET $wait_condition =
161 SELECT variable_value = 6 FROM performance_schema.global_status
162 WHERE LOWER(variable_name) LIKE
163 'innodb_buffer_pool_resize_status_code';
164 --source include/wait_condition.inc
165
166 LET $wait_timeout = 60;
167 LET $wait_condition =
168 SELECT variable_value = 100 FROM performance_schema.global_status
169 WHERE LOWER(variable_name) LIKE
170 'innodb_buffer_pool_resize_status_progress';
171 --source include/wait_condition.inc
172
173 LET $wait_timeout = 60;
174 LET $wait_condition =
175 SELECT SUBSTR(variable_value, 1, 31) = "Resizing also other hash tables"
176 FROM performance_schema.global_status WHERE LOWER(variable_name)
177 LIKE 'innodb_buffer_pool_resize_status';
178 --source include/wait_condition.inc
179
180 SELECT variable_name, variable_value FROM
181 performance_schema.global_status WHERE LOWER(variable_name) LIKE
182 'innodb_buffer_pool_resize_status%';
183
184 SET GLOBAL debug = "-d,ib_buf_pool_resize_hash_status_code";
185
186 --echo #######################################################################
187 --echo # BUF_POOL_RESIZE_COMPLETE (0) (exclude message as it has timestamp)
188 --echo #######################################################################
189 LET $wait_timeout = 60;
190 LET $wait_condition =
191 SELECT variable_value = 0 FROM performance_schema.global_status
192 WHERE LOWER(variable_name) LIKE
193 'innodb_buffer_pool_resize_status_code';
194 --source include/wait_condition.inc
195
196 LET $wait_timeout = 60;
197 LET $wait_condition =
198 SELECT variable_value = 100 FROM performance_schema.global_status
199 WHERE LOWER(variable_name) LIKE
200 'innodb_buffer_pool_resize_status_progress';
201 --source include/wait_condition.inc
202
203 SELECT variable_name, variable_value FROM
204 performance_schema.global_status WHERE LOWER(variable_name) LIKE
205 'innodb_buffer_pool_resize_status_%';
206
207 SET GLOBAL debug = "-d,ib_buf_pool_resize_complete_status_code";
208
209 --echo #######################################################################
210 --echo # Trigger a resize that will fail
211 --echo #######################################################################
212 LET $restart_parameters = restart: --innodb-buffer-pool-instances=2
213 --innodb-buffer-pool-size=1G;
214 --source include/restart_mysqld.inc
215 SET GLOBAL innodb_buffer_pool_size = @prev_size + 4 * 25165824;
216
217 --echo #######################################################################
218 --echo # BUF_POOL_RESIZE_FAILED (7)
219 --echo #######################################################################
220 LET $wait_timeout = 60;
221 LET $wait_condition =
222 SELECT variable_value = 7 FROM performance_schema.global_status
223 WHERE LOWER(variable_name) LIKE
224 'innodb_buffer_pool_resize_status_code';
225 --source include/wait_condition.inc
226
227 LET $wait_timeout = 60;
228 LET $wait_condition =
229 SELECT variable_value = 100 FROM performance_schema.global_status
230 WHERE LOWER(variable_name) LIKE
231 'innodb_buffer_pool_resize_status_progress';
232 --source include/wait_condition.inc
233
234 SELECT variable_name, variable_value FROM
235 performance_schema.global_status WHERE LOWER(variable_name) LIKE
236 'innodb_buffer_pool_resize_status%';
237
238 SET GLOBAL debug = "-d,ib_buf_pool_resize_failed_status_code";
239
240 --echo #######################################################################
241 --echo # CLEAN UP
242 --echo #######################################################################
243 --disable_query_log
244 SET GLOBAL debug = "-d,ib_buf_pool_resize_complete_status_code";
245 SET GLOBAL debug = "-d,ib_buf_pool_resize_start_status_code";
246 SET GLOBAL debug = "-d,ib_buf_pool_resize_disable_ahi_status_code";
247 SET GLOBAL debug = "-d,ib_buf_pool_resize_withdraw_blocks_status_code";
248 SET GLOBAL debug = "-d,ib_buf_pool_resize_global_lock_status_code";
249 SET GLOBAL debug = "-d,ib_buf_pool_resize_in_progress_status_code";
250 SET GLOBAL debug = "-d,ib_buf_pool_resize_hash_status_code";
251 SET GLOBAL debug = "-d,ib_buf_pool_resize_failed_status_code";
252 --echo # Reset back to previous state
253 LET $restart_parameters = restart;
254 --source include/restart_mysqld.inc
255 --enable_query_log