Debian Codegraph @

mysql-test/suite/ndb_binlog/t/ndb_binlog_log_reads.test

raw
1 ########################################################
2 # Test logging of read in different binlog variants
3 # produced by Ndb
4 #
5 # 1) Updates logged as write_row events
6 # Only primary key and updated columns included in the
7 # event
8 # 2) Updates logged as write_row_events
9 # All columns included in the event
10 # 3) Updates logged as update_row events
11 # Only primary key and updated columns included in the
12 # event
13 # 4) Updates logged as update_row events
14 # All columns included in the event
15 #
16 #
17 ########################################################
18 -- source include/have_ndb.inc
19 -- source include/have_binlog_format_row.inc
20 -- source include/have_debug.inc
21
22 # Setup connections
23 connect(mysqld1,127.0.0.1,root,,test,$MASTER_MYPORT);
24 connect(mysqld2,127.0.0.1,root,,test,$MASTER_MYPORT1);
25 connect(mysqld3,127.0.0.1,root,,test,$MASTER_MYPORT2);
26 connect(mysqld4,127.0.0.1,root,,test,$MASTER_MYPORT3);
27
28 connection mysqld1;
29
30 #
31 # WL#7642 Ndb Active Active Binlog read tracking
32 #
33
34 create table test.t1 (
35 a int primary key,
36 b varchar(2000),
37 c int not null unique,
38 d int,
39 key(d)) engine=ndb;
40
41 insert into test.t1 values
42 (1, "Initial data 1", 1, 1),
43 (2, "Initial data 2", 2, 2),
44 (3, "Initial data 3", 3, 3),
45 (4, "Initial data 4", 4, 4),
46 (5, "Initial data 5", 5, 5),
47 (6, "Initial data 6", 6, 6),
48 (7, "Initial data 7", 7, 7),
49 (8, "Initial data 8", 8, 8),
50 (9, "Initial data 9", 9, 9),
51 (10, "Initial data 10", 10, 10);
52
53 create table test.synch(x int primary key) engine=ndb;
54
55 -- echo Test 1: Testing logging of pk reads
56
57 reset master;
58
59 connection mysqld2;
60 --disable_result_log
61 show create table test.synch;
62 --enable_result_log
63 reset master;
64 connection mysqld3;
65 --disable_result_log
66 show create table test.synch;
67 --enable_result_log
68 reset master;
69 connection mysqld4;
70 --disable_result_log
71 show create table test.synch;
72 --enable_result_log
73 reset master;
74
75 connection mysqld1;
76 SET ndb_log_exclusive_reads= 1;
77 select * from test.t1 where a = 7 order by a for update;
78
79 --disable_query_log
80 --disable_result_log
81 insert into test.synch values (1);
82 --enable_result_log
83 --enable_query_log
84
85 # Wait for epoch boundary
86 --disable_query_log
87 --disable_result_log
88 show binlog events;
89 --enable_result_log
90 --enable_query_log
91
92 --disable_query_log
93 let $MYSQLD_DATADIR= `select @@datadir;`;
94 --exec $MYSQL_BINLOG --verbose $MYSQLD_DATADIR/binlog.000001 > $MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql
95
96 create table raw_binlog_rows (txt varchar(1000));
97
98 --eval load data local infile '$MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql' into table raw_binlog_rows columns terminated by '\n';
99
100 --echo "Check that the binlog contains the AnyValue bit set in extra row data for a WRITE_ROW since ndb-log-update-as-write=1"
101 select "mysqld1:",replace(txt, '\r', '') as txt from raw_binlog_rows where replace(txt, '\r', '') like "### % `test`.`t1`" or txt like "### Extra row ndb info: data_format:%";
102 drop table raw_binlog_rows;
103 --enable_query_log
104
105 connection mysqld2;
106 --disable_query_log
107 --disable_result_log
108 insert into test.synch values (2);
109 --enable_result_log
110 --enable_query_log
111
112 # Wait for epoch boundary
113 --disable_query_log
114 --disable_result_log
115 show binlog events;
116 --enable_result_log
117 --enable_query_log
118
119 --disable_query_log
120 let $MYSQLD_DATADIR= `select @@datadir;`;
121 --exec $MYSQL_BINLOG --verbose $MYSQLD_DATADIR/binlog.000001 > $MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql
122
123 create table raw_binlog_rows (txt varchar(1000));
124
125 --eval load data local infile '$MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql' into table raw_binlog_rows columns terminated by '\n';
126
127 --echo "Check that the binlog contains the AnyValue bit set in extra row data for a WRITE_ROW since ndb-log-update-as-write=1"
128 select "mysqld2:",replace(txt, '\r', '') as txt from raw_binlog_rows where replace(txt, '\r', '') like "### % `test`.`t1`" or txt like "### Extra row ndb info: data_format:%";
129
130 drop table raw_binlog_rows;
131 --enable_query_log
132
133 connection mysqld3;
134 --disable_query_log
135 --disable_result_log
136 insert into test.synch values (3);
137 --enable_result_log
138 --enable_query_log
139
140 # Wait for epoch boundary
141 --disable_query_log
142 --disable_result_log
143 show binlog events;
144 --enable_result_log
145 --enable_query_log
146
147 --disable_query_log
148 let $MYSQLD_DATADIR= `select @@datadir;`;
149 --exec $MYSQL_BINLOG --verbose $MYSQLD_DATADIR/binlog.000001 > $MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql
150
151 create table raw_binlog_rows (txt varchar(1000));
152
153 --eval load data local infile '$MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql' into table raw_binlog_rows columns terminated by '\n';
154
155 --echo "Check that the binlog contains the AnyValue bit set in extra row data for a UPDATE_ROW since ndb-log-update-as-write=0"
156 select "mysqld3:",replace(txt, '\r', '') as txt from raw_binlog_rows where replace(txt, '\r', '') like "### % `test`.`t1`" or txt like "### Extra row ndb info: data_format:%";
157
158 drop table raw_binlog_rows;
159 --enable_query_log
160
161 connection mysqld4;
162 --disable_query_log
163 --disable_result_log
164 insert into test.synch values (4);
165 --enable_result_log
166 --enable_query_log
167
168 # Wait for epoch boundary
169 --disable_query_log
170 --disable_result_log
171 show binlog events;
172 --enable_result_log
173 --enable_query_log
174
175 --disable_query_log
176 let $MYSQLD_DATADIR= `select @@datadir;`;
177 --exec $MYSQL_BINLOG --verbose $MYSQLD_DATADIR/binlog.000001 > $MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql
178
179 create table raw_binlog_rows (txt varchar(1000));
180
181 --eval load data local infile '$MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql' into table raw_binlog_rows columns terminated by '\n';
182
183 --echo "Check that the binlog contains the AnyValue bit set in extra row data for a UPDATE_ROW since ndb-log-update-as-write=0"
184 select "mysqld4:",replace(txt, '\r', '') as txt from raw_binlog_rows where replace(txt, '\r', '') like "### % `test`.`t1`" or txt like "### Extra row ndb info: data_format:%";
185
186 drop table raw_binlog_rows;
187 --enable_query_log
188
189 connection mysqld1;
190 SET ndb_log_exclusive_reads= 0;
191
192 -- echo Test 2: Testing logging of unique index reads
193
194 reset master;
195
196 connection mysqld1;
197 --disable_result_log
198 delete from test.synch;
199 --enable_result_log
200 connection mysqld2;
201 --disable_result_log
202 show create table test.synch;
203 --enable_result_log
204 reset master;
205 connection mysqld3;
206 --disable_result_log
207 show create table test.synch;
208 --enable_result_log
209 reset master;
210 connection mysqld4;
211 --disable_result_log
212 show create table test.synch;
213 --enable_result_log
214 reset master;
215
216 connection mysqld1;
217 SET ndb_log_exclusive_reads= 1;
218 select * from test.t1 where c = 7 order by a for update;
219
220 --disable_query_log
221 --disable_result_log
222 insert into test.synch values (1);
223 --enable_result_log
224 --enable_query_log
225
226 # Wait for epoch boundary
227 --disable_query_log
228 --disable_result_log
229 show binlog events;
230 --enable_result_log
231 --enable_query_log
232
233 --disable_query_log
234 let $MYSQLD_DATADIR= `select @@datadir;`;
235 --exec $MYSQL_BINLOG --verbose $MYSQLD_DATADIR/binlog.000001 > $MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql
236
237 create table raw_binlog_rows (txt varchar(1000));
238
239 --eval load data local infile '$MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql' into table raw_binlog_rows columns terminated by '\n';
240
241 --echo "Check that the binlog contains the AnyValue bit set in extra row data for a WRITE_ROW since ndb-log-update-as-write=1"
242 select "mysqld1:",replace(txt, '\r', '') as txt from raw_binlog_rows where replace(txt, '\r', '') like "### % `test`.`t1`" or txt like "### Extra row ndb info: data_format:%";
243 drop table raw_binlog_rows;
244 --enable_query_log
245
246 connection mysqld2;
247 --disable_query_log
248 --disable_result_log
249 insert into test.synch values (2);
250 --enable_result_log
251 --enable_query_log
252
253 # Wait for epoch boundary
254 --disable_query_log
255 --disable_result_log
256 show binlog events;
257 --enable_result_log
258 --enable_query_log
259
260 --disable_query_log
261 let $MYSQLD_DATADIR= `select @@datadir;`;
262 --exec $MYSQL_BINLOG --verbose $MYSQLD_DATADIR/binlog.000001 > $MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql
263
264 create table raw_binlog_rows (txt varchar(1000));
265
266 --eval load data local infile '$MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql' into table raw_binlog_rows columns terminated by '\n';
267
268 --echo "Check that the binlog contains the AnyValue bit set in extra row data for a WRITE_ROW since ndb-log-update-as-write=1"
269 select "mysqld2:",replace(txt, '\r', '') as txt from raw_binlog_rows where replace(txt, '\r', '') like "### % `test`.`t1`" or txt like "### Extra row ndb info: data_format:%";
270
271 drop table raw_binlog_rows;
272 --enable_query_log
273
274 connection mysqld3;
275 --disable_query_log
276 --disable_result_log
277 insert into test.synch values (3);
278 --enable_result_log
279 --enable_query_log
280
281 # Wait for epoch boundary
282 --disable_query_log
283 --disable_result_log
284 show binlog events;
285 --enable_result_log
286 --enable_query_log
287
288 --disable_query_log
289 let $MYSQLD_DATADIR= `select @@datadir;`;
290 --exec $MYSQL_BINLOG --verbose $MYSQLD_DATADIR/binlog.000001 > $MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql
291
292 create table raw_binlog_rows (txt varchar(1000));
293
294 --eval load data local infile '$MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql' into table raw_binlog_rows columns terminated by '\n';
295
296 --echo "Check that the binlog contains the AnyValue bit set in extra row data for a UPDATE_ROW since ndb-log-update-as-write=0"
297 select "mysqld3:",replace(txt, '\r', '') as txt from raw_binlog_rows where replace(txt, '\r', '') like "### % `test`.`t1`" or txt like "### Extra row ndb info: data_format:%";
298
299 drop table raw_binlog_rows;
300 --enable_query_log
301
302 connection mysqld4;
303 --disable_query_log
304 --disable_result_log
305 insert into test.synch values (4);
306 --enable_result_log
307 --enable_query_log
308
309 # Wait for epoch boundary
310 --disable_query_log
311 --disable_result_log
312 show binlog events;
313 --enable_result_log
314 --enable_query_log
315
316 --disable_query_log
317 let $MYSQLD_DATADIR= `select @@datadir;`;
318 --exec $MYSQL_BINLOG --verbose $MYSQLD_DATADIR/binlog.000001 > $MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql
319
320 create table raw_binlog_rows (txt varchar(1000));
321
322 --eval load data local infile '$MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql' into table raw_binlog_rows columns terminated by '\n';
323
324 --echo "Check that the binlog contains the AnyValue bit set in extra row data for a UPDATE_ROW since ndb-log-update-as-write=0"
325 select "mysqld4:",replace(txt, '\r', '') as txt from raw_binlog_rows where replace(txt, '\r', '') like "### % `test`.`t1`" or txt like "### Extra row ndb info: data_format:%";
326
327 drop table raw_binlog_rows;
328 --enable_query_log
329
330 connection mysqld1;
331 SET ndb_log_exclusive_reads= 0;
332
333 -- echo Test 3: Testing logging of ordered index scans
334
335 reset master;
336
337 connection mysqld1;
338 --disable_result_log
339 delete from test.synch;
340 --enable_result_log
341 connection mysqld2;
342 --disable_result_log
343 show create table test.synch;
344 --enable_result_log
345 reset master;
346 connection mysqld3;
347 --disable_result_log
348 show create table test.synch;
349 --enable_result_log
350 reset master;
351 connection mysqld4;
352 --disable_result_log
353 show create table test.synch;
354 --enable_result_log
355 reset master;
356
357 connection mysqld1;
358 SET ndb_log_exclusive_reads= 1;
359 select * from test.t1 where d = 7 order by a for update;
360
361 --disable_query_log
362 --disable_result_log
363 insert into test.synch values (1);
364 --enable_result_log
365 --enable_query_log
366
367 # Wait for epoch boundary
368 --disable_query_log
369 --disable_result_log
370 show binlog events;
371 --enable_result_log
372 --enable_query_log
373
374 --disable_query_log
375 let $MYSQLD_DATADIR= `select @@datadir;`;
376 --exec $MYSQL_BINLOG --verbose $MYSQLD_DATADIR/binlog.000001 > $MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql
377
378 create table raw_binlog_rows (txt varchar(1000));
379
380 --eval load data local infile '$MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql' into table raw_binlog_rows columns terminated by '\n';
381
382 --echo "Check that the binlog contains the AnyValue bit set in extra row data for a WRITE_ROW since ndb-log-update-as-write=1"
383 select "mysqld1:",replace(txt, '\r', '') as txt from raw_binlog_rows where replace(txt, '\r', '') like "### % `test`.`t1`" or txt like "### Extra row ndb info: data_format:%";
384 drop table raw_binlog_rows;
385 --enable_query_log
386
387 connection mysqld2;
388 --disable_query_log
389 --disable_result_log
390 insert into test.synch values (2);
391 --enable_result_log
392 --enable_query_log
393
394 # Wait for epoch boundary
395 --disable_query_log
396 --disable_result_log
397 show binlog events;
398 --enable_result_log
399 --enable_query_log
400
401 --disable_query_log
402 let $MYSQLD_DATADIR= `select @@datadir;`;
403 --exec $MYSQL_BINLOG --verbose $MYSQLD_DATADIR/binlog.000001 > $MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql
404
405 create table raw_binlog_rows (txt varchar(1000));
406
407 --eval load data local infile '$MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql' into table raw_binlog_rows columns terminated by '\n';
408
409 --echo "Check that the binlog contains the AnyValue bit set in extra row data for a WRITE_ROW since ndb-log-update-as-write=1"
410 select "mysqld2:",replace(txt, '\r', '') as txt from raw_binlog_rows where replace(txt, '\r', '') like "### % `test`.`t1`" or txt like "### Extra row ndb info: data_format:%";
411
412 drop table raw_binlog_rows;
413 --enable_query_log
414
415 connection mysqld3;
416 --disable_query_log
417 --disable_result_log
418 insert into test.synch values (3);
419 --enable_result_log
420 --enable_query_log
421
422 # Wait for epoch boundary
423 --disable_query_log
424 --disable_result_log
425 show binlog events;
426 --enable_result_log
427 --enable_query_log
428
429 --disable_query_log
430 let $MYSQLD_DATADIR= `select @@datadir;`;
431 --exec $MYSQL_BINLOG --verbose $MYSQLD_DATADIR/binlog.000001 > $MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql
432
433 create table raw_binlog_rows (txt varchar(1000));
434
435 --eval load data local infile '$MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql' into table raw_binlog_rows columns terminated by '\n';
436
437 --echo "Check that the binlog contains the AnyValue bit set in extra row data for a UPDATE_ROW since ndb-log-update-as-write=0"
438 select "mysqld3:",replace(txt, '\r', '') as txt from raw_binlog_rows where replace(txt, '\r', '') like "### % `test`.`t1`" or txt like "### Extra row ndb info: data_format:%";
439
440 drop table raw_binlog_rows;
441 --enable_query_log
442
443 connection mysqld4;
444 --disable_query_log
445 --disable_result_log
446 insert into test.synch values (4);
447 --enable_result_log
448 --enable_query_log
449
450 # Wait for epoch boundary
451 --disable_query_log
452 --disable_result_log
453 show binlog events;
454 --enable_result_log
455 --enable_query_log
456
457 --disable_query_log
458 let $MYSQLD_DATADIR= `select @@datadir;`;
459 --exec $MYSQL_BINLOG --verbose $MYSQLD_DATADIR/binlog.000001 > $MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql
460
461 create table raw_binlog_rows (txt varchar(1000));
462
463 --eval load data local infile '$MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql' into table raw_binlog_rows columns terminated by '\n';
464
465 --echo "Check that the binlog contains the AnyValue bit set in extra row data for a UPDATE_ROW since ndb-log-update-as-write=0"
466 select "mysqld4:",replace(txt, '\r', '') as txt from raw_binlog_rows where replace(txt, '\r', '') like "### % `test`.`t1`" or txt like "### Extra row ndb info: data_format:%";
467
468 drop table raw_binlog_rows;
469 --enable_query_log
470
471 connection mysqld1;
472 SET ndb_log_exclusive_reads= 0;
473
474 -- echo Test 4: Testing logging of table scans
475
476 reset master;
477
478 connection mysqld1;
479 --disable_result_log
480 delete from test.synch;
481 --enable_result_log
482 connection mysqld2;
483 --disable_result_log
484 show create table test.synch;
485 --enable_result_log
486 reset master;
487 connection mysqld3;
488 --disable_result_log
489 show create table test.synch;
490 --enable_result_log
491 reset master;
492 connection mysqld4;
493 --disable_result_log
494 show create table test.synch;
495 --enable_result_log
496 reset master;
497
498 connection mysqld1;
499 SET ndb_log_exclusive_reads= 1;
500 select * from test.t1 where b like "Initial data 7" order by a for update;
501
502 --disable_query_log
503 --disable_result_log
504 insert into test.synch values (1);
505 --enable_result_log
506 --enable_query_log
507
508 # Wait for epoch boundary
509 --disable_query_log
510 --disable_result_log
511 show binlog events;
512 --enable_result_log
513 --enable_query_log
514
515 --disable_query_log
516 let $MYSQLD_DATADIR= `select @@datadir;`;
517 --exec $MYSQL_BINLOG --verbose $MYSQLD_DATADIR/binlog.000001 > $MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql
518
519 create table raw_binlog_rows (txt varchar(1000));
520
521 --eval load data local infile '$MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql' into table raw_binlog_rows columns terminated by '\n';
522
523 --echo "Check that the binlog contains the AnyValue bit set in extra row data for a WRITE_ROW since ndb-log-update-as-write=1"
524 select "mysqld1:",replace(txt, '\r', '') as txt from raw_binlog_rows where replace(txt, '\r', '') like "### % `test`.`t1`" or txt like "### Extra row ndb info: data_format:%";
525 drop table raw_binlog_rows;
526 --enable_query_log
527
528 connection mysqld2;
529 --disable_query_log
530 --disable_result_log
531 insert into test.synch values (2);
532 --enable_result_log
533 --enable_query_log
534
535 # Wait for epoch boundary
536 --disable_query_log
537 --disable_result_log
538 show binlog events;
539 --enable_result_log
540 --enable_query_log
541
542 --disable_query_log
543 let $MYSQLD_DATADIR= `select @@datadir;`;
544 --exec $MYSQL_BINLOG --verbose $MYSQLD_DATADIR/binlog.000001 > $MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql
545
546 create table raw_binlog_rows (txt varchar(1000));
547
548 --eval load data local infile '$MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql' into table raw_binlog_rows columns terminated by '\n';
549
550 --echo "Check that the binlog contains the AnyValue bit set in extra row data for a WRITE_ROW since ndb-log-update-as-write=1"
551 select "mysqld2:",replace(txt, '\r', '') as txt from raw_binlog_rows where replace(txt, '\r', '') like "### % `test`.`t1`" or txt like "### Extra row ndb info: data_format:%";
552
553 drop table raw_binlog_rows;
554 --enable_query_log
555
556 connection mysqld3;
557 --disable_query_log
558 --disable_result_log
559 insert into test.synch values (3);
560 --enable_result_log
561 --enable_query_log
562
563 # Wait for epoch boundary
564 --disable_query_log
565 --disable_result_log
566 show binlog events;
567 --enable_result_log
568 --enable_query_log
569
570 --disable_query_log
571 let $MYSQLD_DATADIR= `select @@datadir;`;
572 --exec $MYSQL_BINLOG --verbose $MYSQLD_DATADIR/binlog.000001 > $MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql
573
574 create table raw_binlog_rows (txt varchar(1000));
575
576 --eval load data local infile '$MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql' into table raw_binlog_rows columns terminated by '\n';
577
578 --echo "Check that the binlog contains the AnyValue bit set in extra row data for a UPDATE_ROW since ndb-log-update-as-write=0"
579 select "mysqld3:",replace(txt, '\r', '') as txt from raw_binlog_rows where replace(txt, '\r', '') like "### % `test`.`t1`" or txt like "### Extra row ndb info: data_format:%";
580
581 drop table raw_binlog_rows;
582 --enable_query_log
583
584 connection mysqld4;
585 --disable_query_log
586 --disable_result_log
587 insert into test.synch values (4);
588 --enable_result_log
589 --enable_query_log
590
591 # Wait for epoch boundary
592 --disable_query_log
593 --disable_result_log
594 show binlog events;
595 --enable_result_log
596 --enable_query_log
597
598 --disable_query_log
599 let $MYSQLD_DATADIR= `select @@datadir;`;
600 --exec $MYSQL_BINLOG --verbose $MYSQLD_DATADIR/binlog.000001 > $MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql
601
602 create table raw_binlog_rows (txt varchar(1000));
603
604 --eval load data local infile '$MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql' into table raw_binlog_rows columns terminated by '\n';
605
606 --echo "Check that the binlog contains the AnyValue bit set in extra row data for a UPDATE_ROW since ndb-log-update-as-write=0"
607 select "mysqld4:",replace(txt, '\r', '') as txt from raw_binlog_rows where replace(txt, '\r', '') like "### % `test`.`t1`" or txt like "### Extra row ndb info: data_format:%";
608
609 drop table raw_binlog_rows;
610 --enable_query_log
611
612 connection mysqld1;
613 SET ndb_log_exclusive_reads= 0;
614 drop table test.synch, test.t1;
615 --remove_file $MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql