Debian Codegraph @

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

raw
1 # Test with log_writer_write_end
2 DROP DATABASE IF EXISTS dbredoopt;
3 CREATE DATABASE dbredoopt;
4 USE dbredoopt;
5 CREATE TABLE dbredoopt.t1
6 (col1 INT, col2 INT, c1 LONGBLOB, c2 LONGBLOB,
7 PRIMARY KEY(col1), INDEX `idx2` (col2),
8 INDEX `idx3` (c1(300),c2(200))
9 );
10 CREATE PROCEDURE dbredoopt.populate_t1()
11 BEGIN
12 DECLARE i INT DEFAULT 1;
13 while (i <= 500) DO
14 INSERT INTO dbredoopt.t1 values (i, i,REPEAT('a',5000), REPEAT('b',5000));
15 SET i = i + 1;
16 END WHILE;
17 END|
18 CREATE USER 'redo_wl_user'@'localhost';
19 GRANT ALL PRIVILEGES ON *.* TO 'redo_wl_user'@'localhost' WITH GRANT OPTION;
20 START TRANSACTION;
21 SELECT count(*) FROM dbredoopt.t1;
22 count(*)
23 0
24 call dbredoopt.populate_t1();
25 SELECT count(*) FROM dbredoopt.t1;
26 count(*)
27 500
28 SELECT col1 FROM dbredoopt.t1 LIMIT 10;
29 col1
30 1
31 2
32 3
33 4
34 5
35 6
36 7
37 8
38 9
39 10
40 COMMIT;
41 # Check rows which are not modified by parallel load
42 SELECT col1 FROM dbredoopt.t1 WHERE col1%50=0 AND (col1 < 501 AND col1 > 0 );
43 col1
44 50
45 100
46 150
47 200
48 250
49 300
50 350
51 400
52 450
53 500
54 # Wait till all mysql clients are connected
55 # Singal all mysql clients since each one is waiting for signal go_ahead
56 # with 'go_ahead' signal , all client suppose to resume in parallel
57 # Wait till all clients are over or server is gone
58 # restart
59 # Check rows which are not modified by parallel load
60 SELECT col1 FROM dbredoopt.t1 WHERE col1%50=0 AND (col1 < 501 AND col1 > 0 );
61 col1
62 50
63 100
64 150
65 200
66 250
67 300
68 350
69 400
70 450
71 500
72 # Check rows which are updated by parallel load
73 SELECT count(*)=0 FROM (SELECT col1,col2 FROM dbredoopt.t1 WHERE col1 NOT BETWEEN 1 AND 501 ) AS A WHERE (A.col1+A.col2) != 0 ;
74 count(*)=0
75 1
76 DROP DATABASE dbredoopt;
77 DROP USER 'redo_wl_user'@'localhost';
78 # Test with log_writer_before_write_from_log_buffer
79 DROP DATABASE IF EXISTS dbredoopt;
80 CREATE DATABASE dbredoopt;
81 USE dbredoopt;
82 CREATE TABLE dbredoopt.t1
83 (col1 INT, col2 INT, c1 LONGBLOB, c2 LONGBLOB,
84 PRIMARY KEY(col1), INDEX `idx2` (col2),
85 INDEX `idx3` (c1(300),c2(200))
86 );
87 CREATE PROCEDURE dbredoopt.populate_t1()
88 BEGIN
89 DECLARE i INT DEFAULT 1;
90 while (i <= 500) DO
91 INSERT INTO dbredoopt.t1 values (i, i,REPEAT('a',5000), REPEAT('b',5000));
92 SET i = i + 1;
93 END WHILE;
94 END|
95 CREATE USER 'redo_wl_user'@'localhost';
96 GRANT ALL PRIVILEGES ON *.* TO 'redo_wl_user'@'localhost' WITH GRANT OPTION;
97 START TRANSACTION;
98 SELECT count(*) FROM dbredoopt.t1;
99 count(*)
100 0
101 call dbredoopt.populate_t1();
102 SELECT count(*) FROM dbredoopt.t1;
103 count(*)
104 500
105 SELECT col1 FROM dbredoopt.t1 LIMIT 10;
106 col1
107 1
108 2
109 3
110 4
111 5
112 6
113 7
114 8
115 9
116 10
117 COMMIT;
118 # Check rows which are not modified by parallel load
119 SELECT col1 FROM dbredoopt.t1 WHERE col1%50=0 AND (col1 < 501 AND col1 > 0 );
120 col1
121 50
122 100
123 150
124 200
125 250
126 300
127 350
128 400
129 450
130 500
131 # Wait till all mysql clients are connected
132 # Singal all mysql clients since each one is waiting for signal go_ahead
133 # with 'go_ahead' signal , all client suppose to resume in parallel
134 # Wait till all clients are over or server is gone
135 # restart
136 # Check rows which are not modified by parallel load
137 SELECT col1 FROM dbredoopt.t1 WHERE col1%50=0 AND (col1 < 501 AND col1 > 0 );
138 col1
139 50
140 100
141 150
142 200
143 250
144 300
145 350
146 400
147 450
148 500
149 # Check rows which are updated by parallel load
150 SELECT count(*)=0 FROM (SELECT col1,col2 FROM dbredoopt.t1 WHERE col1 NOT BETWEEN 1 AND 501 ) AS A WHERE (A.col1+A.col2) != 0 ;
151 count(*)=0
152 1
153 DROP DATABASE dbredoopt;
154 DROP USER 'redo_wl_user'@'localhost';
155 # Test with log_writer_before_copy_to_write_ahead_buffer
156 DROP DATABASE IF EXISTS dbredoopt;
157 CREATE DATABASE dbredoopt;
158 USE dbredoopt;
159 CREATE TABLE dbredoopt.t1
160 (col1 INT, col2 INT, c1 LONGBLOB, c2 LONGBLOB,
161 PRIMARY KEY(col1), INDEX `idx2` (col2),
162 INDEX `idx3` (c1(300),c2(200))
163 );
164 CREATE PROCEDURE dbredoopt.populate_t1()
165 BEGIN
166 DECLARE i INT DEFAULT 1;
167 while (i <= 500) DO
168 INSERT INTO dbredoopt.t1 values (i, i,REPEAT('a',5000), REPEAT('b',5000));
169 SET i = i + 1;
170 END WHILE;
171 END|
172 CREATE USER 'redo_wl_user'@'localhost';
173 GRANT ALL PRIVILEGES ON *.* TO 'redo_wl_user'@'localhost' WITH GRANT OPTION;
174 START TRANSACTION;
175 SELECT count(*) FROM dbredoopt.t1;
176 count(*)
177 0
178 call dbredoopt.populate_t1();
179 SELECT count(*) FROM dbredoopt.t1;
180 count(*)
181 500
182 SELECT col1 FROM dbredoopt.t1 LIMIT 10;
183 col1
184 1
185 2
186 3
187 4
188 5
189 6
190 7
191 8
192 9
193 10
194 COMMIT;
195 # Check rows which are not modified by parallel load
196 SELECT col1 FROM dbredoopt.t1 WHERE col1%50=0 AND (col1 < 501 AND col1 > 0 );
197 col1
198 50
199 100
200 150
201 200
202 250
203 300
204 350
205 400
206 450
207 500
208 # Wait till all mysql clients are connected
209 # Singal all mysql clients since each one is waiting for signal go_ahead
210 # with 'go_ahead' signal , all client suppose to resume in parallel
211 # Wait till all clients are over or server is gone
212 # restart
213 # Check rows which are not modified by parallel load
214 SELECT col1 FROM dbredoopt.t1 WHERE col1%50=0 AND (col1 < 501 AND col1 > 0 );
215 col1
216 50
217 100
218 150
219 200
220 250
221 300
222 350
223 400
224 450
225 500
226 # Check rows which are updated by parallel load
227 SELECT count(*)=0 FROM (SELECT col1,col2 FROM dbredoopt.t1 WHERE col1 NOT BETWEEN 1 AND 501 ) AS A WHERE (A.col1+A.col2) != 0 ;
228 count(*)=0
229 1
230 DROP DATABASE dbredoopt;
231 DROP USER 'redo_wl_user'@'localhost';
232 # Test with log_writer_before_write_ahead
233 DROP DATABASE IF EXISTS dbredoopt;
234 CREATE DATABASE dbredoopt;
235 USE dbredoopt;
236 CREATE TABLE dbredoopt.t1
237 (col1 INT, col2 INT, c1 LONGBLOB, c2 LONGBLOB,
238 PRIMARY KEY(col1), INDEX `idx2` (col2),
239 INDEX `idx3` (c1(300),c2(200))
240 );
241 CREATE PROCEDURE dbredoopt.populate_t1()
242 BEGIN
243 DECLARE i INT DEFAULT 1;
244 while (i <= 500) DO
245 INSERT INTO dbredoopt.t1 values (i, i,REPEAT('a',5000), REPEAT('b',5000));
246 SET i = i + 1;
247 END WHILE;
248 END|
249 CREATE USER 'redo_wl_user'@'localhost';
250 GRANT ALL PRIVILEGES ON *.* TO 'redo_wl_user'@'localhost' WITH GRANT OPTION;
251 START TRANSACTION;
252 SELECT count(*) FROM dbredoopt.t1;
253 count(*)
254 0
255 call dbredoopt.populate_t1();
256 SELECT count(*) FROM dbredoopt.t1;
257 count(*)
258 500
259 SELECT col1 FROM dbredoopt.t1 LIMIT 10;
260 col1
261 1
262 2
263 3
264 4
265 5
266 6
267 7
268 8
269 9
270 10
271 COMMIT;
272 # Check rows which are not modified by parallel load
273 SELECT col1 FROM dbredoopt.t1 WHERE col1%50=0 AND (col1 < 501 AND col1 > 0 );
274 col1
275 50
276 100
277 150
278 200
279 250
280 300
281 350
282 400
283 450
284 500
285 # Wait till all mysql clients are connected
286 # Singal all mysql clients since each one is waiting for signal go_ahead
287 # with 'go_ahead' signal , all client suppose to resume in parallel
288 # Wait till all clients are over or server is gone
289 # restart
290 # Check rows which are not modified by parallel load
291 SELECT col1 FROM dbredoopt.t1 WHERE col1%50=0 AND (col1 < 501 AND col1 > 0 );
292 col1
293 50
294 100
295 150
296 200
297 250
298 300
299 350
300 400
301 450
302 500
303 # Check rows which are updated by parallel load
304 SELECT count(*)=0 FROM (SELECT col1,col2 FROM dbredoopt.t1 WHERE col1 NOT BETWEEN 1 AND 501 ) AS A WHERE (A.col1+A.col2) != 0 ;
305 count(*)=0
306 1
307 DROP DATABASE dbredoopt;
308 DROP USER 'redo_wl_user'@'localhost';
309 # Test with log_writer_before_lsn_update
310 DROP DATABASE IF EXISTS dbredoopt;
311 CREATE DATABASE dbredoopt;
312 USE dbredoopt;
313 CREATE TABLE dbredoopt.t1
314 (col1 INT, col2 INT, c1 LONGBLOB, c2 LONGBLOB,
315 PRIMARY KEY(col1), INDEX `idx2` (col2),
316 INDEX `idx3` (c1(300),c2(200))
317 );
318 CREATE PROCEDURE dbredoopt.populate_t1()
319 BEGIN
320 DECLARE i INT DEFAULT 1;
321 while (i <= 500) DO
322 INSERT INTO dbredoopt.t1 values (i, i,REPEAT('a',5000), REPEAT('b',5000));
323 SET i = i + 1;
324 END WHILE;
325 END|
326 CREATE USER 'redo_wl_user'@'localhost';
327 GRANT ALL PRIVILEGES ON *.* TO 'redo_wl_user'@'localhost' WITH GRANT OPTION;
328 START TRANSACTION;
329 SELECT count(*) FROM dbredoopt.t1;
330 count(*)
331 0
332 call dbredoopt.populate_t1();
333 SELECT count(*) FROM dbredoopt.t1;
334 count(*)
335 500
336 SELECT col1 FROM dbredoopt.t1 LIMIT 10;
337 col1
338 1
339 2
340 3
341 4
342 5
343 6
344 7
345 8
346 9
347 10
348 COMMIT;
349 # Check rows which are not modified by parallel load
350 SELECT col1 FROM dbredoopt.t1 WHERE col1%50=0 AND (col1 < 501 AND col1 > 0 );
351 col1
352 50
353 100
354 150
355 200
356 250
357 300
358 350
359 400
360 450
361 500
362 # Wait till all mysql clients are connected
363 # Singal all mysql clients since each one is waiting for signal go_ahead
364 # with 'go_ahead' signal , all client suppose to resume in parallel
365 # Wait till all clients are over or server is gone
366 # restart
367 # Check rows which are not modified by parallel load
368 SELECT col1 FROM dbredoopt.t1 WHERE col1%50=0 AND (col1 < 501 AND col1 > 0 );
369 col1
370 50
371 100
372 150
373 200
374 250
375 300
376 350
377 400
378 450
379 500
380 # Check rows which are updated by parallel load
381 SELECT count(*)=0 FROM (SELECT col1,col2 FROM dbredoopt.t1 WHERE col1 NOT BETWEEN 1 AND 501 ) AS A WHERE (A.col1+A.col2) != 0 ;
382 count(*)=0
383 1
384 DROP DATABASE dbredoopt;
385 DROP USER 'redo_wl_user'@'localhost';