1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
1220
1221
|
drop table if exists t1, t2;
reset master;
create table t1 (a int) engine=innodb;
create table t2 (a int) engine=innodb;
begin;
insert t1 values (5);
commit;
begin;
insert t2 values (5);
commit;
show binlog events from <binlog_start>;
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000001 # Query # # use `test`; create table t1 (a int) engine=innodb
master-bin.000001 # Query # # use `test`; create table t2 (a int) engine=innodb
master-bin.000001 # Query # # use `test`; BEGIN
master-bin.000001 # Table_map # # table_id: # (test.t1)
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
master-bin.000001 # Xid # # COMMIT /* XID */
master-bin.000001 # Query # # use `test`; BEGIN
master-bin.000001 # Table_map # # table_id: # (test.t2)
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
master-bin.000001 # Xid # # COMMIT /* XID */
drop table t1,t2;
reset master;
create table t1 (n int) engine=innodb;
begin;
commit;
drop table t1;
show binlog events in 'master-bin.000001' from 107;
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000001 # Query 1 # use `test`; create table t1 (n int) engine=innodb
master-bin.000001 # Query 1 # use `test`; BEGIN
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
master-bin.000001 # Xid 1 # COMMIT /* xid= */
master-bin.000001 # Rotate 1 # master-bin.000002;pos=4
show binlog events in 'master-bin.000002' from 107;
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000002 # Query 1 # use `test`; drop table t1
set @ac = @@autocommit;
set autocommit= 0;
reset master;
create table t1(n int) engine=innodb;
begin;
insert into t1 values (1);
insert into t1 values (2);
insert into t1 values (3);
commit;
drop table t1;
show binlog events from 0;
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000001 4 Format_desc 1 107 Server version, Binlog ver: 4
master-bin.000001 107 Query 1 206 use `test`; create table t1(n int) engine=innodb
master-bin.000001 206 Query 1 274 use `test`; BEGIN
master-bin.000001 274 Table_map 1 315 table_id: # (test.t1)
master-bin.000001 315 Write_rows 1 349 table_id: # flags: STMT_END_F
master-bin.000001 349 Table_map 1 390 table_id: # (test.t1)
master-bin.000001 390 Write_rows 1 424 table_id: # flags: STMT_END_F
master-bin.000001 424 Table_map 1 465 table_id: # (test.t1)
master-bin.000001 465 Write_rows 1 499 table_id: # flags: STMT_END_F
master-bin.000001 499 Xid 1 526 COMMIT /* XID */
master-bin.000001 526 Query 1 602 use `test`; drop table t1
set @bcs = @@binlog_cache_size;
set global binlog_cache_size=4096;
reset master;
create table t1 (a int) engine=innodb;
show binlog events from 0;
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000001 4 Format_desc 1 107 Server version, Binlog ver: 4
master-bin.000001 107 Query 1 207 use `test`; create table t1 (a int) engine=innodb
master-bin.000001 207 Query 1 275 use `test`; BEGIN
master-bin.000001 275 Table_map 1 316 table_id: # (test.t1)
master-bin.000001 316 Write_rows 1 350 table_id: # flags: STMT_END_F
master-bin.000001 350 Table_map 1 391 table_id: # (test.t1)
master-bin.000001 391 Write_rows 1 425 table_id: # flags: STMT_END_F
master-bin.000001 425 Table_map 1 466 table_id: # (test.t1)
master-bin.000001 466 Write_rows 1 500 table_id: # flags: STMT_END_F
master-bin.000001 500 Table_map 1 541 table_id: # (test.t1)
master-bin.000001 541 Write_rows 1 575 table_id: # flags: STMT_END_F
master-bin.000001 575 Table_map 1 616 table_id: # (test.t1)
master-bin.000001 616 Write_rows 1 650 table_id: # flags: STMT_END_F
master-bin.000001 650 Table_map 1 691 table_id: # (test.t1)
master-bin.000001 691 Write_rows 1 725 table_id: # flags: STMT_END_F
master-bin.000001 725 Table_map 1 766 table_id: # (test.t1)
master-bin.000001 766 Write_rows 1 800 table_id: # flags: STMT_END_F
master-bin.000001 800 Table_map 1 841 table_id: # (test.t1)
master-bin.000001 841 Write_rows 1 875 table_id: # flags: STMT_END_F
master-bin.000001 875 Table_map 1 916 table_id: # (test.t1)
master-bin.000001 916 Write_rows 1 950 table_id: # flags: STMT_END_F
master-bin.000001 950 Table_map 1 991 table_id: # (test.t1)
master-bin.000001 991 Write_rows 1 1025 table_id: # flags: STMT_END_F
master-bin.000001 1025 Table_map 1 1066 table_id: # (test.t1)
master-bin.000001 1066 Write_rows 1 1100 table_id: # flags: STMT_END_F
master-bin.000001 1100 Table_map 1 1141 table_id: # (test.t1)
master-bin.000001 1141 Write_rows 1 1175 table_id: # flags: STMT_END_F
master-bin.000001 1175 Table_map 1 1216 table_id: # (test.t1)
master-bin.000001 1216 Write_rows 1 1250 table_id: # flags: STMT_END_F
master-bin.000001 1250 Table_map 1 1291 table_id: # (test.t1)
master-bin.000001 1291 Write_rows 1 1325 table_id: # flags: STMT_END_F
master-bin.000001 1325 Table_map 1 1366 table_id: # (test.t1)
master-bin.000001 1366 Write_rows 1 1400 table_id: # flags: STMT_END_F
master-bin.000001 1400 Table_map 1 1441 table_id: # (test.t1)
master-bin.000001 1441 Write_rows 1 1475 table_id: # flags: STMT_END_F
master-bin.000001 1475 Table_map 1 1516 table_id: # (test.t1)
master-bin.000001 1516 Write_rows 1 1550 table_id: # flags: STMT_END_F
master-bin.000001 1550 Table_map 1 1591 table_id: # (test.t1)
master-bin.000001 1591 Write_rows 1 1625 table_id: # flags: STMT_END_F
master-bin.000001 1625 Table_map 1 1666 table_id: # (test.t1)
master-bin.000001 1666 Write_rows 1 1700 table_id: # flags: STMT_END_F
master-bin.000001 1700 Table_map 1 1741 table_id: # (test.t1)
master-bin.000001 1741 Write_rows 1 1775 table_id: # flags: STMT_END_F
master-bin.000001 1775 Table_map 1 1816 table_id: # (test.t1)
master-bin.000001 1816 Write_rows 1 1850 table_id: # flags: STMT_END_F
master-bin.000001 1850 Table_map 1 1891 table_id: # (test.t1)
master-bin.000001 1891 Write_rows 1 1925 table_id: # flags: STMT_END_F
master-bin.000001 1925 Table_map 1 1966 table_id: # (test.t1)
master-bin.000001 1966 Write_rows 1 2000 table_id: # flags: STMT_END_F
master-bin.000001 2000 Table_map 1 2041 table_id: # (test.t1)
master-bin.000001 2041 Write_rows 1 2075 table_id: # flags: STMT_END_F
master-bin.000001 2075 Table_map 1 2116 table_id: # (test.t1)
master-bin.000001 2116 Write_rows 1 2150 table_id: # flags: STMT_END_F
master-bin.000001 2150 Table_map 1 2191 table_id: # (test.t1)
master-bin.000001 2191 Write_rows 1 2225 table_id: # flags: STMT_END_F
master-bin.000001 2225 Table_map 1 2266 table_id: # (test.t1)
master-bin.000001 2266 Write_rows 1 2300 table_id: # flags: STMT_END_F
master-bin.000001 2300 Table_map 1 2341 table_id: # (test.t1)
master-bin.000001 2341 Write_rows 1 2375 table_id: # flags: STMT_END_F
master-bin.000001 2375 Table_map 1 2416 table_id: # (test.t1)
master-bin.000001 2416 Write_rows 1 2450 table_id: # flags: STMT_END_F
master-bin.000001 2450 Table_map 1 2491 table_id: # (test.t1)
master-bin.000001 2491 Write_rows 1 2525 table_id: # flags: STMT_END_F
master-bin.000001 2525 Table_map 1 2566 table_id: # (test.t1)
master-bin.000001 2566 Write_rows 1 2600 table_id: # flags: STMT_END_F
master-bin.000001 2600 Table_map 1 2641 table_id: # (test.t1)
master-bin.000001 2641 Write_rows 1 2675 table_id: # flags: STMT_END_F
master-bin.000001 2675 Table_map 1 2716 table_id: # (test.t1)
master-bin.000001 2716 Write_rows 1 2750 table_id: # flags: STMT_END_F
master-bin.000001 2750 Table_map 1 2791 table_id: # (test.t1)
master-bin.000001 2791 Write_rows 1 2825 table_id: # flags: STMT_END_F
master-bin.000001 2825 Table_map 1 2866 table_id: # (test.t1)
master-bin.000001 2866 Write_rows 1 2900 table_id: # flags: STMT_END_F
master-bin.000001 2900 Table_map 1 2941 table_id: # (test.t1)
master-bin.000001 2941 Write_rows 1 2975 table_id: # flags: STMT_END_F
master-bin.000001 2975 Table_map 1 3016 table_id: # (test.t1)
master-bin.000001 3016 Write_rows 1 3050 table_id: # flags: STMT_END_F
master-bin.000001 3050 Table_map 1 3091 table_id: # (test.t1)
master-bin.000001 3091 Write_rows 1 3125 table_id: # flags: STMT_END_F
master-bin.000001 3125 Table_map 1 3166 table_id: # (test.t1)
master-bin.000001 3166 Write_rows 1 3200 table_id: # flags: STMT_END_F
master-bin.000001 3200 Table_map 1 3241 table_id: # (test.t1)
master-bin.000001 3241 Write_rows 1 3275 table_id: # flags: STMT_END_F
master-bin.000001 3275 Table_map 1 3316 table_id: # (test.t1)
master-bin.000001 3316 Write_rows 1 3350 table_id: # flags: STMT_END_F
master-bin.000001 3350 Table_map 1 3391 table_id: # (test.t1)
master-bin.000001 3391 Write_rows 1 3425 table_id: # flags: STMT_END_F
master-bin.000001 3425 Table_map 1 3466 table_id: # (test.t1)
master-bin.000001 3466 Write_rows 1 3500 table_id: # flags: STMT_END_F
master-bin.000001 3500 Table_map 1 3541 table_id: # (test.t1)
master-bin.000001 3541 Write_rows 1 3575 table_id: # flags: STMT_END_F
master-bin.000001 3575 Table_map 1 3616 table_id: # (test.t1)
master-bin.000001 3616 Write_rows 1 3650 table_id: # flags: STMT_END_F
master-bin.000001 3650 Table_map 1 3691 table_id: # (test.t1)
master-bin.000001 3691 Write_rows 1 3725 table_id: # flags: STMT_END_F
master-bin.000001 3725 Table_map 1 3766 table_id: # (test.t1)
master-bin.000001 3766 Write_rows 1 3800 table_id: # flags: STMT_END_F
master-bin.000001 3800 Table_map 1 3841 table_id: # (test.t1)
master-bin.000001 3841 Write_rows 1 3875 table_id: # flags: STMT_END_F
master-bin.000001 3875 Table_map 1 3916 table_id: # (test.t1)
master-bin.000001 3916 Write_rows 1 3950 table_id: # flags: STMT_END_F
master-bin.000001 3950 Table_map 1 3991 table_id: # (test.t1)
master-bin.000001 3991 Write_rows 1 4025 table_id: # flags: STMT_END_F
master-bin.000001 4025 Table_map 1 4066 table_id: # (test.t1)
master-bin.000001 4066 Write_rows 1 4100 table_id: # flags: STMT_END_F
master-bin.000001 4100 Table_map 1 4141 table_id: # (test.t1)
master-bin.000001 4141 Write_rows 1 4175 table_id: # flags: STMT_END_F
master-bin.000001 4175 Table_map 1 4216 table_id: # (test.t1)
master-bin.000001 4216 Write_rows 1 4250 table_id: # flags: STMT_END_F
master-bin.000001 4250 Table_map 1 4291 table_id: # (test.t1)
master-bin.000001 4291 Write_rows 1 4325 table_id: # flags: STMT_END_F
master-bin.000001 4325 Table_map 1 4366 table_id: # (test.t1)
master-bin.000001 4366 Write_rows 1 4400 table_id: # flags: STMT_END_F
master-bin.000001 4400 Table_map 1 4441 table_id: # (test.t1)
master-bin.000001 4441 Write_rows 1 4475 table_id: # flags: STMT_END_F
master-bin.000001 4475 Table_map 1 4516 table_id: # (test.t1)
master-bin.000001 4516 Write_rows 1 4550 table_id: # flags: STMT_END_F
master-bin.000001 4550 Table_map 1 4591 table_id: # (test.t1)
master-bin.000001 4591 Write_rows 1 4625 table_id: # flags: STMT_END_F
master-bin.000001 4625 Table_map 1 4666 table_id: # (test.t1)
master-bin.000001 4666 Write_rows 1 4700 table_id: # flags: STMT_END_F
master-bin.000001 4700 Table_map 1 4741 table_id: # (test.t1)
master-bin.000001 4741 Write_rows 1 4775 table_id: # flags: STMT_END_F
master-bin.000001 4775 Table_map 1 4816 table_id: # (test.t1)
master-bin.000001 4816 Write_rows 1 4850 table_id: # flags: STMT_END_F
master-bin.000001 4850 Table_map 1 4891 table_id: # (test.t1)
master-bin.000001 4891 Write_rows 1 4925 table_id: # flags: STMT_END_F
master-bin.000001 4925 Table_map 1 4966 table_id: # (test.t1)
master-bin.000001 4966 Write_rows 1 5000 table_id: # flags: STMT_END_F
master-bin.000001 5000 Table_map 1 5041 table_id: # (test.t1)
master-bin.000001 5041 Write_rows 1 5075 table_id: # flags: STMT_END_F
master-bin.000001 5075 Table_map 1 5116 table_id: # (test.t1)
master-bin.000001 5116 Write_rows 1 5150 table_id: # flags: STMT_END_F
master-bin.000001 5150 Table_map 1 5191 table_id: # (test.t1)
master-bin.000001 5191 Write_rows 1 5225 table_id: # flags: STMT_END_F
master-bin.000001 5225 Table_map 1 5266 table_id: # (test.t1)
master-bin.000001 5266 Write_rows 1 5300 table_id: # flags: STMT_END_F
master-bin.000001 5300 Table_map 1 5341 table_id: # (test.t1)
master-bin.000001 5341 Write_rows 1 5375 table_id: # flags: STMT_END_F
master-bin.000001 5375 Table_map 1 5416 table_id: # (test.t1)
master-bin.000001 5416 Write_rows 1 5450 table_id: # flags: STMT_END_F
master-bin.000001 5450 Table_map 1 5491 table_id: # (test.t1)
master-bin.000001 5491 Write_rows 1 5525 table_id: # flags: STMT_END_F
master-bin.000001 5525 Table_map 1 5566 table_id: # (test.t1)
master-bin.000001 5566 Write_rows 1 5600 table_id: # flags: STMT_END_F
master-bin.000001 5600 Table_map 1 5641 table_id: # (test.t1)
master-bin.000001 5641 Write_rows 1 5675 table_id: # flags: STMT_END_F
master-bin.000001 5675 Table_map 1 5716 table_id: # (test.t1)
master-bin.000001 5716 Write_rows 1 5750 table_id: # flags: STMT_END_F
master-bin.000001 5750 Table_map 1 5791 table_id: # (test.t1)
master-bin.000001 5791 Write_rows 1 5825 table_id: # flags: STMT_END_F
master-bin.000001 5825 Table_map 1 5866 table_id: # (test.t1)
master-bin.000001 5866 Write_rows 1 5900 table_id: # flags: STMT_END_F
master-bin.000001 5900 Table_map 1 5941 table_id: # (test.t1)
master-bin.000001 5941 Write_rows 1 5975 table_id: # flags: STMT_END_F
master-bin.000001 5975 Table_map 1 6016 table_id: # (test.t1)
master-bin.000001 6016 Write_rows 1 6050 table_id: # flags: STMT_END_F
master-bin.000001 6050 Table_map 1 6091 table_id: # (test.t1)
master-bin.000001 6091 Write_rows 1 6125 table_id: # flags: STMT_END_F
master-bin.000001 6125 Table_map 1 6166 table_id: # (test.t1)
master-bin.000001 6166 Write_rows 1 6200 table_id: # flags: STMT_END_F
master-bin.000001 6200 Table_map 1 6241 table_id: # (test.t1)
master-bin.000001 6241 Write_rows 1 6275 table_id: # flags: STMT_END_F
master-bin.000001 6275 Table_map 1 6316 table_id: # (test.t1)
master-bin.000001 6316 Write_rows 1 6350 table_id: # flags: STMT_END_F
master-bin.000001 6350 Table_map 1 6391 table_id: # (test.t1)
master-bin.000001 6391 Write_rows 1 6425 table_id: # flags: STMT_END_F
master-bin.000001 6425 Table_map 1 6466 table_id: # (test.t1)
master-bin.000001 6466 Write_rows 1 6500 table_id: # flags: STMT_END_F
master-bin.000001 6500 Table_map 1 6541 table_id: # (test.t1)
master-bin.000001 6541 Write_rows 1 6575 table_id: # flags: STMT_END_F
master-bin.000001 6575 Table_map 1 6616 table_id: # (test.t1)
master-bin.000001 6616 Write_rows 1 6650 table_id: # flags: STMT_END_F
master-bin.000001 6650 Table_map 1 6691 table_id: # (test.t1)
master-bin.000001 6691 Write_rows 1 6725 table_id: # flags: STMT_END_F
master-bin.000001 6725 Table_map 1 6766 table_id: # (test.t1)
master-bin.000001 6766 Write_rows 1 6800 table_id: # flags: STMT_END_F
master-bin.000001 6800 Table_map 1 6841 table_id: # (test.t1)
master-bin.000001 6841 Write_rows 1 6875 table_id: # flags: STMT_END_F
master-bin.000001 6875 Table_map 1 6916 table_id: # (test.t1)
master-bin.000001 6916 Write_rows 1 6950 table_id: # flags: STMT_END_F
master-bin.000001 6950 Table_map 1 6991 table_id: # (test.t1)
master-bin.000001 6991 Write_rows 1 7025 table_id: # flags: STMT_END_F
master-bin.000001 7025 Table_map 1 7066 table_id: # (test.t1)
master-bin.000001 7066 Write_rows 1 7100 table_id: # flags: STMT_END_F
master-bin.000001 7100 Table_map 1 7141 table_id: # (test.t1)
master-bin.000001 7141 Write_rows 1 7175 table_id: # flags: STMT_END_F
master-bin.000001 7175 Table_map 1 7216 table_id: # (test.t1)
master-bin.000001 7216 Write_rows 1 7250 table_id: # flags: STMT_END_F
master-bin.000001 7250 Table_map 1 7291 table_id: # (test.t1)
master-bin.000001 7291 Write_rows 1 7325 table_id: # flags: STMT_END_F
master-bin.000001 7325 Table_map 1 7366 table_id: # (test.t1)
master-bin.000001 7366 Write_rows 1 7400 table_id: # flags: STMT_END_F
master-bin.000001 7400 Table_map 1 7441 table_id: # (test.t1)
master-bin.000001 7441 Write_rows 1 7475 table_id: # flags: STMT_END_F
master-bin.000001 7475 Table_map 1 7516 table_id: # (test.t1)
master-bin.000001 7516 Write_rows 1 7550 table_id: # flags: STMT_END_F
master-bin.000001 7550 Table_map 1 7591 table_id: # (test.t1)
master-bin.000001 7591 Write_rows 1 7625 table_id: # flags: STMT_END_F
master-bin.000001 7625 Table_map 1 7666 table_id: # (test.t1)
master-bin.000001 7666 Write_rows 1 7700 table_id: # flags: STMT_END_F
master-bin.000001 7700 Table_map 1 7741 table_id: # (test.t1)
master-bin.000001 7741 Write_rows 1 7775 table_id: # flags: STMT_END_F
master-bin.000001 7775 Table_map 1 7816 table_id: # (test.t1)
master-bin.000001 7816 Write_rows 1 7850 table_id: # flags: STMT_END_F
master-bin.000001 7850 Table_map 1 7891 table_id: # (test.t1)
master-bin.000001 7891 Write_rows 1 7925 table_id: # flags: STMT_END_F
master-bin.000001 7925 Table_map 1 7966 table_id: # (test.t1)
master-bin.000001 7966 Write_rows 1 8000 table_id: # flags: STMT_END_F
master-bin.000001 8000 Table_map 1 8041 table_id: # (test.t1)
master-bin.000001 8041 Write_rows 1 8075 table_id: # flags: STMT_END_F
master-bin.000001 8075 Table_map 1 8116 table_id: # (test.t1)
master-bin.000001 8116 Write_rows 1 8150 table_id: # flags: STMT_END_F
master-bin.000001 8150 Table_map 1 8191 table_id: # (test.t1)
master-bin.000001 8191 Write_rows 1 8225 table_id: # flags: STMT_END_F
master-bin.000001 8225 Table_map 1 8266 table_id: # (test.t1)
master-bin.000001 8266 Write_rows 1 8300 table_id: # flags: STMT_END_F
master-bin.000001 8300 Table_map 1 8341 table_id: # (test.t1)
master-bin.000001 8341 Write_rows 1 8375 table_id: # flags: STMT_END_F
master-bin.000001 8375 Table_map 1 8416 table_id: # (test.t1)
master-bin.000001 8416 Write_rows 1 8450 table_id: # flags: STMT_END_F
master-bin.000001 8450 Table_map 1 8491 table_id: # (test.t1)
master-bin.000001 8491 Write_rows 1 8525 table_id: # flags: STMT_END_F
master-bin.000001 8525 Table_map 1 8566 table_id: # (test.t1)
master-bin.000001 8566 Write_rows 1 8600 table_id: # flags: STMT_END_F
master-bin.000001 8600 Table_map 1 8641 table_id: # (test.t1)
master-bin.000001 8641 Write_rows 1 8675 table_id: # flags: STMT_END_F
master-bin.000001 8675 Table_map 1 8716 table_id: # (test.t1)
master-bin.000001 8716 Write_rows 1 8750 table_id: # flags: STMT_END_F
master-bin.000001 8750 Table_map 1 8791 table_id: # (test.t1)
master-bin.000001 8791 Write_rows 1 8825 table_id: # flags: STMT_END_F
master-bin.000001 8825 Table_map 1 8866 table_id: # (test.t1)
master-bin.000001 8866 Write_rows 1 8900 table_id: # flags: STMT_END_F
master-bin.000001 8900 Table_map 1 8941 table_id: # (test.t1)
master-bin.000001 8941 Write_rows 1 8975 table_id: # flags: STMT_END_F
master-bin.000001 8975 Table_map 1 9016 table_id: # (test.t1)
master-bin.000001 9016 Write_rows 1 9050 table_id: # flags: STMT_END_F
master-bin.000001 9050 Table_map 1 9091 table_id: # (test.t1)
master-bin.000001 9091 Write_rows 1 9125 table_id: # flags: STMT_END_F
master-bin.000001 9125 Table_map 1 9166 table_id: # (test.t1)
master-bin.000001 9166 Write_rows 1 9200 table_id: # flags: STMT_END_F
master-bin.000001 9200 Table_map 1 9241 table_id: # (test.t1)
master-bin.000001 9241 Write_rows 1 9275 table_id: # flags: STMT_END_F
master-bin.000001 9275 Table_map 1 9316 table_id: # (test.t1)
master-bin.000001 9316 Write_rows 1 9350 table_id: # flags: STMT_END_F
master-bin.000001 9350 Table_map 1 9391 table_id: # (test.t1)
master-bin.000001 9391 Write_rows 1 9425 table_id: # flags: STMT_END_F
master-bin.000001 9425 Table_map 1 9466 table_id: # (test.t1)
master-bin.000001 9466 Write_rows 1 9500 table_id: # flags: STMT_END_F
master-bin.000001 9500 Table_map 1 9541 table_id: # (test.t1)
master-bin.000001 9541 Write_rows 1 9575 table_id: # flags: STMT_END_F
master-bin.000001 9575 Table_map 1 9616 table_id: # (test.t1)
master-bin.000001 9616 Write_rows 1 9650 table_id: # flags: STMT_END_F
master-bin.000001 9650 Table_map 1 9691 table_id: # (test.t1)
master-bin.000001 9691 Write_rows 1 9725 table_id: # flags: STMT_END_F
master-bin.000001 9725 Table_map 1 9766 table_id: # (test.t1)
master-bin.000001 9766 Write_rows 1 9800 table_id: # flags: STMT_END_F
master-bin.000001 9800 Table_map 1 9841 table_id: # (test.t1)
master-bin.000001 9841 Write_rows 1 9875 table_id: # flags: STMT_END_F
master-bin.000001 9875 Table_map 1 9916 table_id: # (test.t1)
master-bin.000001 9916 Write_rows 1 9950 table_id: # flags: STMT_END_F
master-bin.000001 9950 Table_map 1 9991 table_id: # (test.t1)
master-bin.000001 9991 Write_rows 1 10025 table_id: # flags: STMT_END_F
master-bin.000001 10025 Table_map 1 10066 table_id: # (test.t1)
master-bin.000001 10066 Write_rows 1 10100 table_id: # flags: STMT_END_F
master-bin.000001 10100 Table_map 1 10141 table_id: # (test.t1)
master-bin.000001 10141 Write_rows 1 10175 table_id: # flags: STMT_END_F
master-bin.000001 10175 Table_map 1 10216 table_id: # (test.t1)
master-bin.000001 10216 Write_rows 1 10250 table_id: # flags: STMT_END_F
master-bin.000001 10250 Table_map 1 10291 table_id: # (test.t1)
master-bin.000001 10291 Write_rows 1 10325 table_id: # flags: STMT_END_F
master-bin.000001 10325 Table_map 1 10366 table_id: # (test.t1)
master-bin.000001 10366 Write_rows 1 10400 table_id: # flags: STMT_END_F
master-bin.000001 10400 Table_map 1 10441 table_id: # (test.t1)
master-bin.000001 10441 Write_rows 1 10475 table_id: # flags: STMT_END_F
master-bin.000001 10475 Table_map 1 10516 table_id: # (test.t1)
master-bin.000001 10516 Write_rows 1 10550 table_id: # flags: STMT_END_F
master-bin.000001 10550 Table_map 1 10591 table_id: # (test.t1)
master-bin.000001 10591 Write_rows 1 10625 table_id: # flags: STMT_END_F
master-bin.000001 10625 Table_map 1 10666 table_id: # (test.t1)
master-bin.000001 10666 Write_rows 1 10700 table_id: # flags: STMT_END_F
master-bin.000001 10700 Table_map 1 10741 table_id: # (test.t1)
master-bin.000001 10741 Write_rows 1 10775 table_id: # flags: STMT_END_F
master-bin.000001 10775 Table_map 1 10816 table_id: # (test.t1)
master-bin.000001 10816 Write_rows 1 10850 table_id: # flags: STMT_END_F
master-bin.000001 10850 Table_map 1 10891 table_id: # (test.t1)
master-bin.000001 10891 Write_rows 1 10925 table_id: # flags: STMT_END_F
master-bin.000001 10925 Table_map 1 10966 table_id: # (test.t1)
master-bin.000001 10966 Write_rows 1 11000 table_id: # flags: STMT_END_F
master-bin.000001 11000 Table_map 1 11041 table_id: # (test.t1)
master-bin.000001 11041 Write_rows 1 11075 table_id: # flags: STMT_END_F
master-bin.000001 11075 Table_map 1 11116 table_id: # (test.t1)
master-bin.000001 11116 Write_rows 1 11150 table_id: # flags: STMT_END_F
master-bin.000001 11150 Table_map 1 11191 table_id: # (test.t1)
master-bin.000001 11191 Write_rows 1 11225 table_id: # flags: STMT_END_F
master-bin.000001 11225 Table_map 1 11266 table_id: # (test.t1)
master-bin.000001 11266 Write_rows 1 11300 table_id: # flags: STMT_END_F
master-bin.000001 11300 Table_map 1 11341 table_id: # (test.t1)
master-bin.000001 11341 Write_rows 1 11375 table_id: # flags: STMT_END_F
master-bin.000001 11375 Table_map 1 11416 table_id: # (test.t1)
master-bin.000001 11416 Write_rows 1 11450 table_id: # flags: STMT_END_F
master-bin.000001 11450 Table_map 1 11491 table_id: # (test.t1)
master-bin.000001 11491 Write_rows 1 11525 table_id: # flags: STMT_END_F
master-bin.000001 11525 Table_map 1 11566 table_id: # (test.t1)
master-bin.000001 11566 Write_rows 1 11600 table_id: # flags: STMT_END_F
master-bin.000001 11600 Table_map 1 11641 table_id: # (test.t1)
master-bin.000001 11641 Write_rows 1 11675 table_id: # flags: STMT_END_F
master-bin.000001 11675 Table_map 1 11716 table_id: # (test.t1)
master-bin.000001 11716 Write_rows 1 11750 table_id: # flags: STMT_END_F
master-bin.000001 11750 Table_map 1 11791 table_id: # (test.t1)
master-bin.000001 11791 Write_rows 1 11825 table_id: # flags: STMT_END_F
master-bin.000001 11825 Table_map 1 11866 table_id: # (test.t1)
master-bin.000001 11866 Write_rows 1 11900 table_id: # flags: STMT_END_F
master-bin.000001 11900 Table_map 1 11941 table_id: # (test.t1)
master-bin.000001 11941 Write_rows 1 11975 table_id: # flags: STMT_END_F
master-bin.000001 11975 Table_map 1 12016 table_id: # (test.t1)
master-bin.000001 12016 Write_rows 1 12050 table_id: # flags: STMT_END_F
master-bin.000001 12050 Table_map 1 12091 table_id: # (test.t1)
master-bin.000001 12091 Write_rows 1 12125 table_id: # flags: STMT_END_F
master-bin.000001 12125 Table_map 1 12166 table_id: # (test.t1)
master-bin.000001 12166 Write_rows 1 12200 table_id: # flags: STMT_END_F
master-bin.000001 12200 Table_map 1 12241 table_id: # (test.t1)
master-bin.000001 12241 Write_rows 1 12275 table_id: # flags: STMT_END_F
master-bin.000001 12275 Table_map 1 12316 table_id: # (test.t1)
master-bin.000001 12316 Write_rows 1 12350 table_id: # flags: STMT_END_F
master-bin.000001 12350 Table_map 1 12391 table_id: # (test.t1)
master-bin.000001 12391 Write_rows 1 12425 table_id: # flags: STMT_END_F
master-bin.000001 12425 Table_map 1 12466 table_id: # (test.t1)
master-bin.000001 12466 Write_rows 1 12500 table_id: # flags: STMT_END_F
master-bin.000001 12500 Table_map 1 12541 table_id: # (test.t1)
master-bin.000001 12541 Write_rows 1 12575 table_id: # flags: STMT_END_F
master-bin.000001 12575 Table_map 1 12616 table_id: # (test.t1)
master-bin.000001 12616 Write_rows 1 12650 table_id: # flags: STMT_END_F
master-bin.000001 12650 Table_map 1 12691 table_id: # (test.t1)
master-bin.000001 12691 Write_rows 1 12725 table_id: # flags: STMT_END_F
master-bin.000001 12725 Table_map 1 12766 table_id: # (test.t1)
master-bin.000001 12766 Write_rows 1 12800 table_id: # flags: STMT_END_F
master-bin.000001 12800 Table_map 1 12841 table_id: # (test.t1)
master-bin.000001 12841 Write_rows 1 12875 table_id: # flags: STMT_END_F
master-bin.000001 12875 Table_map 1 12916 table_id: # (test.t1)
master-bin.000001 12916 Write_rows 1 12950 table_id: # flags: STMT_END_F
master-bin.000001 12950 Table_map 1 12991 table_id: # (test.t1)
master-bin.000001 12991 Write_rows 1 13025 table_id: # flags: STMT_END_F
master-bin.000001 13025 Table_map 1 13066 table_id: # (test.t1)
master-bin.000001 13066 Write_rows 1 13100 table_id: # flags: STMT_END_F
master-bin.000001 13100 Table_map 1 13141 table_id: # (test.t1)
master-bin.000001 13141 Write_rows 1 13175 table_id: # flags: STMT_END_F
master-bin.000001 13175 Table_map 1 13216 table_id: # (test.t1)
master-bin.000001 13216 Write_rows 1 13250 table_id: # flags: STMT_END_F
master-bin.000001 13250 Table_map 1 13291 table_id: # (test.t1)
master-bin.000001 13291 Write_rows 1 13325 table_id: # flags: STMT_END_F
master-bin.000001 13325 Table_map 1 13366 table_id: # (test.t1)
master-bin.000001 13366 Write_rows 1 13400 table_id: # flags: STMT_END_F
master-bin.000001 13400 Table_map 1 13441 table_id: # (test.t1)
master-bin.000001 13441 Write_rows 1 13475 table_id: # flags: STMT_END_F
master-bin.000001 13475 Table_map 1 13516 table_id: # (test.t1)
master-bin.000001 13516 Write_rows 1 13550 table_id: # flags: STMT_END_F
master-bin.000001 13550 Table_map 1 13591 table_id: # (test.t1)
master-bin.000001 13591 Write_rows 1 13625 table_id: # flags: STMT_END_F
master-bin.000001 13625 Table_map 1 13666 table_id: # (test.t1)
master-bin.000001 13666 Write_rows 1 13700 table_id: # flags: STMT_END_F
master-bin.000001 13700 Table_map 1 13741 table_id: # (test.t1)
master-bin.000001 13741 Write_rows 1 13775 table_id: # flags: STMT_END_F
master-bin.000001 13775 Table_map 1 13816 table_id: # (test.t1)
master-bin.000001 13816 Write_rows 1 13850 table_id: # flags: STMT_END_F
master-bin.000001 13850 Table_map 1 13891 table_id: # (test.t1)
master-bin.000001 13891 Write_rows 1 13925 table_id: # flags: STMT_END_F
master-bin.000001 13925 Table_map 1 13966 table_id: # (test.t1)
master-bin.000001 13966 Write_rows 1 14000 table_id: # flags: STMT_END_F
master-bin.000001 14000 Table_map 1 14041 table_id: # (test.t1)
master-bin.000001 14041 Write_rows 1 14075 table_id: # flags: STMT_END_F
master-bin.000001 14075 Table_map 1 14116 table_id: # (test.t1)
master-bin.000001 14116 Write_rows 1 14150 table_id: # flags: STMT_END_F
master-bin.000001 14150 Table_map 1 14191 table_id: # (test.t1)
master-bin.000001 14191 Write_rows 1 14225 table_id: # flags: STMT_END_F
master-bin.000001 14225 Table_map 1 14266 table_id: # (test.t1)
master-bin.000001 14266 Write_rows 1 14300 table_id: # flags: STMT_END_F
master-bin.000001 14300 Table_map 1 14341 table_id: # (test.t1)
master-bin.000001 14341 Write_rows 1 14375 table_id: # flags: STMT_END_F
master-bin.000001 14375 Table_map 1 14416 table_id: # (test.t1)
master-bin.000001 14416 Write_rows 1 14450 table_id: # flags: STMT_END_F
master-bin.000001 14450 Table_map 1 14491 table_id: # (test.t1)
master-bin.000001 14491 Write_rows 1 14525 table_id: # flags: STMT_END_F
master-bin.000001 14525 Table_map 1 14566 table_id: # (test.t1)
master-bin.000001 14566 Write_rows 1 14600 table_id: # flags: STMT_END_F
master-bin.000001 14600 Table_map 1 14641 table_id: # (test.t1)
master-bin.000001 14641 Write_rows 1 14675 table_id: # flags: STMT_END_F
master-bin.000001 14675 Table_map 1 14716 table_id: # (test.t1)
master-bin.000001 14716 Write_rows 1 14750 table_id: # flags: STMT_END_F
master-bin.000001 14750 Table_map 1 14791 table_id: # (test.t1)
master-bin.000001 14791 Write_rows 1 14825 table_id: # flags: STMT_END_F
master-bin.000001 14825 Table_map 1 14866 table_id: # (test.t1)
master-bin.000001 14866 Write_rows 1 14900 table_id: # flags: STMT_END_F
master-bin.000001 14900 Table_map 1 14941 table_id: # (test.t1)
master-bin.000001 14941 Write_rows 1 14975 table_id: # flags: STMT_END_F
master-bin.000001 14975 Table_map 1 15016 table_id: # (test.t1)
master-bin.000001 15016 Write_rows 1 15050 table_id: # flags: STMT_END_F
master-bin.000001 15050 Table_map 1 15091 table_id: # (test.t1)
master-bin.000001 15091 Write_rows 1 15125 table_id: # flags: STMT_END_F
master-bin.000001 15125 Table_map 1 15166 table_id: # (test.t1)
master-bin.000001 15166 Write_rows 1 15200 table_id: # flags: STMT_END_F
master-bin.000001 15200 Table_map 1 15241 table_id: # (test.t1)
master-bin.000001 15241 Write_rows 1 15275 table_id: # flags: STMT_END_F
master-bin.000001 15275 Table_map 1 15316 table_id: # (test.t1)
master-bin.000001 15316 Write_rows 1 15350 table_id: # flags: STMT_END_F
master-bin.000001 15350 Table_map 1 15391 table_id: # (test.t1)
master-bin.000001 15391 Write_rows 1 15425 table_id: # flags: STMT_END_F
master-bin.000001 15425 Table_map 1 15466 table_id: # (test.t1)
master-bin.000001 15466 Write_rows 1 15500 table_id: # flags: STMT_END_F
master-bin.000001 15500 Table_map 1 15541 table_id: # (test.t1)
master-bin.000001 15541 Write_rows 1 15575 table_id: # flags: STMT_END_F
master-bin.000001 15575 Table_map 1 15616 table_id: # (test.t1)
master-bin.000001 15616 Write_rows 1 15650 table_id: # flags: STMT_END_F
master-bin.000001 15650 Table_map 1 15691 table_id: # (test.t1)
master-bin.000001 15691 Write_rows 1 15725 table_id: # flags: STMT_END_F
master-bin.000001 15725 Table_map 1 15766 table_id: # (test.t1)
master-bin.000001 15766 Write_rows 1 15800 table_id: # flags: STMT_END_F
master-bin.000001 15800 Table_map 1 15841 table_id: # (test.t1)
master-bin.000001 15841 Write_rows 1 15875 table_id: # flags: STMT_END_F
master-bin.000001 15875 Table_map 1 15916 table_id: # (test.t1)
master-bin.000001 15916 Write_rows 1 15950 table_id: # flags: STMT_END_F
master-bin.000001 15950 Table_map 1 15991 table_id: # (test.t1)
master-bin.000001 15991 Write_rows 1 16025 table_id: # flags: STMT_END_F
master-bin.000001 16025 Table_map 1 16066 table_id: # (test.t1)
master-bin.000001 16066 Write_rows 1 16100 table_id: # flags: STMT_END_F
master-bin.000001 16100 Table_map 1 16141 table_id: # (test.t1)
master-bin.000001 16141 Write_rows 1 16175 table_id: # flags: STMT_END_F
master-bin.000001 16175 Table_map 1 16216 table_id: # (test.t1)
master-bin.000001 16216 Write_rows 1 16250 table_id: # flags: STMT_END_F
master-bin.000001 16250 Table_map 1 16291 table_id: # (test.t1)
master-bin.000001 16291 Write_rows 1 16325 table_id: # flags: STMT_END_F
master-bin.000001 16325 Table_map 1 16366 table_id: # (test.t1)
master-bin.000001 16366 Write_rows 1 16400 table_id: # flags: STMT_END_F
master-bin.000001 16400 Table_map 1 16441 table_id: # (test.t1)
master-bin.000001 16441 Write_rows 1 16475 table_id: # flags: STMT_END_F
master-bin.000001 16475 Table_map 1 16516 table_id: # (test.t1)
master-bin.000001 16516 Write_rows 1 16550 table_id: # flags: STMT_END_F
master-bin.000001 16550 Table_map 1 16591 table_id: # (test.t1)
master-bin.000001 16591 Write_rows 1 16625 table_id: # flags: STMT_END_F
master-bin.000001 16625 Table_map 1 16666 table_id: # (test.t1)
master-bin.000001 16666 Write_rows 1 16700 table_id: # flags: STMT_END_F
master-bin.000001 16700 Table_map 1 16741 table_id: # (test.t1)
master-bin.000001 16741 Write_rows 1 16775 table_id: # flags: STMT_END_F
master-bin.000001 16775 Table_map 1 16816 table_id: # (test.t1)
master-bin.000001 16816 Write_rows 1 16850 table_id: # flags: STMT_END_F
master-bin.000001 16850 Table_map 1 16891 table_id: # (test.t1)
master-bin.000001 16891 Write_rows 1 16925 table_id: # flags: STMT_END_F
master-bin.000001 16925 Table_map 1 16966 table_id: # (test.t1)
master-bin.000001 16966 Write_rows 1 17000 table_id: # flags: STMT_END_F
master-bin.000001 17000 Table_map 1 17041 table_id: # (test.t1)
master-bin.000001 17041 Write_rows 1 17075 table_id: # flags: STMT_END_F
master-bin.000001 17075 Table_map 1 17116 table_id: # (test.t1)
master-bin.000001 17116 Write_rows 1 17150 table_id: # flags: STMT_END_F
master-bin.000001 17150 Table_map 1 17191 table_id: # (test.t1)
master-bin.000001 17191 Write_rows 1 17225 table_id: # flags: STMT_END_F
master-bin.000001 17225 Table_map 1 17266 table_id: # (test.t1)
master-bin.000001 17266 Write_rows 1 17300 table_id: # flags: STMT_END_F
master-bin.000001 17300 Table_map 1 17341 table_id: # (test.t1)
master-bin.000001 17341 Write_rows 1 17375 table_id: # flags: STMT_END_F
master-bin.000001 17375 Table_map 1 17416 table_id: # (test.t1)
master-bin.000001 17416 Write_rows 1 17450 table_id: # flags: STMT_END_F
master-bin.000001 17450 Table_map 1 17491 table_id: # (test.t1)
master-bin.000001 17491 Write_rows 1 17525 table_id: # flags: STMT_END_F
master-bin.000001 17525 Table_map 1 17566 table_id: # (test.t1)
master-bin.000001 17566 Write_rows 1 17600 table_id: # flags: STMT_END_F
master-bin.000001 17600 Table_map 1 17641 table_id: # (test.t1)
master-bin.000001 17641 Write_rows 1 17675 table_id: # flags: STMT_END_F
master-bin.000001 17675 Table_map 1 17716 table_id: # (test.t1)
master-bin.000001 17716 Write_rows 1 17750 table_id: # flags: STMT_END_F
master-bin.000001 17750 Table_map 1 17791 table_id: # (test.t1)
master-bin.000001 17791 Write_rows 1 17825 table_id: # flags: STMT_END_F
master-bin.000001 17825 Table_map 1 17866 table_id: # (test.t1)
master-bin.000001 17866 Write_rows 1 17900 table_id: # flags: STMT_END_F
master-bin.000001 17900 Table_map 1 17941 table_id: # (test.t1)
master-bin.000001 17941 Write_rows 1 17975 table_id: # flags: STMT_END_F
master-bin.000001 17975 Table_map 1 18016 table_id: # (test.t1)
master-bin.000001 18016 Write_rows 1 18050 table_id: # flags: STMT_END_F
master-bin.000001 18050 Table_map 1 18091 table_id: # (test.t1)
master-bin.000001 18091 Write_rows 1 18125 table_id: # flags: STMT_END_F
master-bin.000001 18125 Table_map 1 18166 table_id: # (test.t1)
master-bin.000001 18166 Write_rows 1 18200 table_id: # flags: STMT_END_F
master-bin.000001 18200 Table_map 1 18241 table_id: # (test.t1)
master-bin.000001 18241 Write_rows 1 18275 table_id: # flags: STMT_END_F
master-bin.000001 18275 Table_map 1 18316 table_id: # (test.t1)
master-bin.000001 18316 Write_rows 1 18350 table_id: # flags: STMT_END_F
master-bin.000001 18350 Table_map 1 18391 table_id: # (test.t1)
master-bin.000001 18391 Write_rows 1 18425 table_id: # flags: STMT_END_F
master-bin.000001 18425 Table_map 1 18466 table_id: # (test.t1)
master-bin.000001 18466 Write_rows 1 18500 table_id: # flags: STMT_END_F
master-bin.000001 18500 Table_map 1 18541 table_id: # (test.t1)
master-bin.000001 18541 Write_rows 1 18575 table_id: # flags: STMT_END_F
master-bin.000001 18575 Table_map 1 18616 table_id: # (test.t1)
master-bin.000001 18616 Write_rows 1 18650 table_id: # flags: STMT_END_F
master-bin.000001 18650 Table_map 1 18691 table_id: # (test.t1)
master-bin.000001 18691 Write_rows 1 18725 table_id: # flags: STMT_END_F
master-bin.000001 18725 Table_map 1 18766 table_id: # (test.t1)
master-bin.000001 18766 Write_rows 1 18800 table_id: # flags: STMT_END_F
master-bin.000001 18800 Table_map 1 18841 table_id: # (test.t1)
master-bin.000001 18841 Write_rows 1 18875 table_id: # flags: STMT_END_F
master-bin.000001 18875 Table_map 1 18916 table_id: # (test.t1)
master-bin.000001 18916 Write_rows 1 18950 table_id: # flags: STMT_END_F
master-bin.000001 18950 Table_map 1 18991 table_id: # (test.t1)
master-bin.000001 18991 Write_rows 1 19025 table_id: # flags: STMT_END_F
master-bin.000001 19025 Table_map 1 19066 table_id: # (test.t1)
master-bin.000001 19066 Write_rows 1 19100 table_id: # flags: STMT_END_F
master-bin.000001 19100 Table_map 1 19141 table_id: # (test.t1)
master-bin.000001 19141 Write_rows 1 19175 table_id: # flags: STMT_END_F
master-bin.000001 19175 Table_map 1 19216 table_id: # (test.t1)
master-bin.000001 19216 Write_rows 1 19250 table_id: # flags: STMT_END_F
master-bin.000001 19250 Table_map 1 19291 table_id: # (test.t1)
master-bin.000001 19291 Write_rows 1 19325 table_id: # flags: STMT_END_F
master-bin.000001 19325 Table_map 1 19366 table_id: # (test.t1)
master-bin.000001 19366 Write_rows 1 19400 table_id: # flags: STMT_END_F
master-bin.000001 19400 Table_map 1 19441 table_id: # (test.t1)
master-bin.000001 19441 Write_rows 1 19475 table_id: # flags: STMT_END_F
master-bin.000001 19475 Table_map 1 19516 table_id: # (test.t1)
master-bin.000001 19516 Write_rows 1 19550 table_id: # flags: STMT_END_F
master-bin.000001 19550 Table_map 1 19591 table_id: # (test.t1)
master-bin.000001 19591 Write_rows 1 19625 table_id: # flags: STMT_END_F
master-bin.000001 19625 Table_map 1 19666 table_id: # (test.t1)
master-bin.000001 19666 Write_rows 1 19700 table_id: # flags: STMT_END_F
master-bin.000001 19700 Table_map 1 19741 table_id: # (test.t1)
master-bin.000001 19741 Write_rows 1 19775 table_id: # flags: STMT_END_F
master-bin.000001 19775 Table_map 1 19816 table_id: # (test.t1)
master-bin.000001 19816 Write_rows 1 19850 table_id: # flags: STMT_END_F
master-bin.000001 19850 Table_map 1 19891 table_id: # (test.t1)
master-bin.000001 19891 Write_rows 1 19925 table_id: # flags: STMT_END_F
master-bin.000001 19925 Table_map 1 19966 table_id: # (test.t1)
master-bin.000001 19966 Write_rows 1 20000 table_id: # flags: STMT_END_F
master-bin.000001 20000 Table_map 1 20041 table_id: # (test.t1)
master-bin.000001 20041 Write_rows 1 20075 table_id: # flags: STMT_END_F
master-bin.000001 20075 Table_map 1 20116 table_id: # (test.t1)
master-bin.000001 20116 Write_rows 1 20150 table_id: # flags: STMT_END_F
master-bin.000001 20150 Table_map 1 20191 table_id: # (test.t1)
master-bin.000001 20191 Write_rows 1 20225 table_id: # flags: STMT_END_F
master-bin.000001 20225 Table_map 1 20266 table_id: # (test.t1)
master-bin.000001 20266 Write_rows 1 20300 table_id: # flags: STMT_END_F
master-bin.000001 20300 Table_map 1 20341 table_id: # (test.t1)
master-bin.000001 20341 Write_rows 1 20375 table_id: # flags: STMT_END_F
master-bin.000001 20375 Table_map 1 20416 table_id: # (test.t1)
master-bin.000001 20416 Write_rows 1 20450 table_id: # flags: STMT_END_F
master-bin.000001 20450 Table_map 1 20491 table_id: # (test.t1)
master-bin.000001 20491 Write_rows 1 20525 table_id: # flags: STMT_END_F
master-bin.000001 20525 Table_map 1 20566 table_id: # (test.t1)
master-bin.000001 20566 Write_rows 1 20600 table_id: # flags: STMT_END_F
master-bin.000001 20600 Table_map 1 20641 table_id: # (test.t1)
master-bin.000001 20641 Write_rows 1 20675 table_id: # flags: STMT_END_F
master-bin.000001 20675 Table_map 1 20716 table_id: # (test.t1)
master-bin.000001 20716 Write_rows 1 20750 table_id: # flags: STMT_END_F
master-bin.000001 20750 Table_map 1 20791 table_id: # (test.t1)
master-bin.000001 20791 Write_rows 1 20825 table_id: # flags: STMT_END_F
master-bin.000001 20825 Table_map 1 20866 table_id: # (test.t1)
master-bin.000001 20866 Write_rows 1 20900 table_id: # flags: STMT_END_F
master-bin.000001 20900 Table_map 1 20941 table_id: # (test.t1)
master-bin.000001 20941 Write_rows 1 20975 table_id: # flags: STMT_END_F
master-bin.000001 20975 Table_map 1 21016 table_id: # (test.t1)
master-bin.000001 21016 Write_rows 1 21050 table_id: # flags: STMT_END_F
master-bin.000001 21050 Table_map 1 21091 table_id: # (test.t1)
master-bin.000001 21091 Write_rows 1 21125 table_id: # flags: STMT_END_F
master-bin.000001 21125 Table_map 1 21166 table_id: # (test.t1)
master-bin.000001 21166 Write_rows 1 21200 table_id: # flags: STMT_END_F
master-bin.000001 21200 Table_map 1 21241 table_id: # (test.t1)
master-bin.000001 21241 Write_rows 1 21275 table_id: # flags: STMT_END_F
master-bin.000001 21275 Table_map 1 21316 table_id: # (test.t1)
master-bin.000001 21316 Write_rows 1 21350 table_id: # flags: STMT_END_F
master-bin.000001 21350 Table_map 1 21391 table_id: # (test.t1)
master-bin.000001 21391 Write_rows 1 21425 table_id: # flags: STMT_END_F
master-bin.000001 21425 Table_map 1 21466 table_id: # (test.t1)
master-bin.000001 21466 Write_rows 1 21500 table_id: # flags: STMT_END_F
master-bin.000001 21500 Table_map 1 21541 table_id: # (test.t1)
master-bin.000001 21541 Write_rows 1 21575 table_id: # flags: STMT_END_F
master-bin.000001 21575 Table_map 1 21616 table_id: # (test.t1)
master-bin.000001 21616 Write_rows 1 21650 table_id: # flags: STMT_END_F
master-bin.000001 21650 Table_map 1 21691 table_id: # (test.t1)
master-bin.000001 21691 Write_rows 1 21725 table_id: # flags: STMT_END_F
master-bin.000001 21725 Table_map 1 21766 table_id: # (test.t1)
master-bin.000001 21766 Write_rows 1 21800 table_id: # flags: STMT_END_F
master-bin.000001 21800 Table_map 1 21841 table_id: # (test.t1)
master-bin.000001 21841 Write_rows 1 21875 table_id: # flags: STMT_END_F
master-bin.000001 21875 Table_map 1 21916 table_id: # (test.t1)
master-bin.000001 21916 Write_rows 1 21950 table_id: # flags: STMT_END_F
master-bin.000001 21950 Table_map 1 21991 table_id: # (test.t1)
master-bin.000001 21991 Write_rows 1 22025 table_id: # flags: STMT_END_F
master-bin.000001 22025 Table_map 1 22066 table_id: # (test.t1)
master-bin.000001 22066 Write_rows 1 22100 table_id: # flags: STMT_END_F
master-bin.000001 22100 Table_map 1 22141 table_id: # (test.t1)
master-bin.000001 22141 Write_rows 1 22175 table_id: # flags: STMT_END_F
master-bin.000001 22175 Table_map 1 22216 table_id: # (test.t1)
master-bin.000001 22216 Write_rows 1 22250 table_id: # flags: STMT_END_F
master-bin.000001 22250 Table_map 1 22291 table_id: # (test.t1)
master-bin.000001 22291 Write_rows 1 22325 table_id: # flags: STMT_END_F
master-bin.000001 22325 Table_map 1 22366 table_id: # (test.t1)
master-bin.000001 22366 Write_rows 1 22400 table_id: # flags: STMT_END_F
master-bin.000001 22400 Table_map 1 22441 table_id: # (test.t1)
master-bin.000001 22441 Write_rows 1 22475 table_id: # flags: STMT_END_F
master-bin.000001 22475 Table_map 1 22516 table_id: # (test.t1)
master-bin.000001 22516 Write_rows 1 22550 table_id: # flags: STMT_END_F
master-bin.000001 22550 Table_map 1 22591 table_id: # (test.t1)
master-bin.000001 22591 Write_rows 1 22625 table_id: # flags: STMT_END_F
master-bin.000001 22625 Table_map 1 22666 table_id: # (test.t1)
master-bin.000001 22666 Write_rows 1 22700 table_id: # flags: STMT_END_F
master-bin.000001 22700 Table_map 1 22741 table_id: # (test.t1)
master-bin.000001 22741 Write_rows 1 22775 table_id: # flags: STMT_END_F
master-bin.000001 22775 Table_map 1 22816 table_id: # (test.t1)
master-bin.000001 22816 Write_rows 1 22850 table_id: # flags: STMT_END_F
master-bin.000001 22850 Table_map 1 22891 table_id: # (test.t1)
master-bin.000001 22891 Write_rows 1 22925 table_id: # flags: STMT_END_F
master-bin.000001 22925 Table_map 1 22966 table_id: # (test.t1)
master-bin.000001 22966 Write_rows 1 23000 table_id: # flags: STMT_END_F
master-bin.000001 23000 Table_map 1 23041 table_id: # (test.t1)
master-bin.000001 23041 Write_rows 1 23075 table_id: # flags: STMT_END_F
master-bin.000001 23075 Table_map 1 23116 table_id: # (test.t1)
master-bin.000001 23116 Write_rows 1 23150 table_id: # flags: STMT_END_F
master-bin.000001 23150 Table_map 1 23191 table_id: # (test.t1)
master-bin.000001 23191 Write_rows 1 23225 table_id: # flags: STMT_END_F
master-bin.000001 23225 Table_map 1 23266 table_id: # (test.t1)
master-bin.000001 23266 Write_rows 1 23300 table_id: # flags: STMT_END_F
master-bin.000001 23300 Table_map 1 23341 table_id: # (test.t1)
master-bin.000001 23341 Write_rows 1 23375 table_id: # flags: STMT_END_F
master-bin.000001 23375 Table_map 1 23416 table_id: # (test.t1)
master-bin.000001 23416 Write_rows 1 23450 table_id: # flags: STMT_END_F
master-bin.000001 23450 Table_map 1 23491 table_id: # (test.t1)
master-bin.000001 23491 Write_rows 1 23525 table_id: # flags: STMT_END_F
master-bin.000001 23525 Table_map 1 23566 table_id: # (test.t1)
master-bin.000001 23566 Write_rows 1 23600 table_id: # flags: STMT_END_F
master-bin.000001 23600 Table_map 1 23641 table_id: # (test.t1)
master-bin.000001 23641 Write_rows 1 23675 table_id: # flags: STMT_END_F
master-bin.000001 23675 Table_map 1 23716 table_id: # (test.t1)
master-bin.000001 23716 Write_rows 1 23750 table_id: # flags: STMT_END_F
master-bin.000001 23750 Table_map 1 23791 table_id: # (test.t1)
master-bin.000001 23791 Write_rows 1 23825 table_id: # flags: STMT_END_F
master-bin.000001 23825 Table_map 1 23866 table_id: # (test.t1)
master-bin.000001 23866 Write_rows 1 23900 table_id: # flags: STMT_END_F
master-bin.000001 23900 Table_map 1 23941 table_id: # (test.t1)
master-bin.000001 23941 Write_rows 1 23975 table_id: # flags: STMT_END_F
master-bin.000001 23975 Table_map 1 24016 table_id: # (test.t1)
master-bin.000001 24016 Write_rows 1 24050 table_id: # flags: STMT_END_F
master-bin.000001 24050 Table_map 1 24091 table_id: # (test.t1)
master-bin.000001 24091 Write_rows 1 24125 table_id: # flags: STMT_END_F
master-bin.000001 24125 Table_map 1 24166 table_id: # (test.t1)
master-bin.000001 24166 Write_rows 1 24200 table_id: # flags: STMT_END_F
master-bin.000001 24200 Table_map 1 24241 table_id: # (test.t1)
master-bin.000001 24241 Write_rows 1 24275 table_id: # flags: STMT_END_F
master-bin.000001 24275 Table_map 1 24316 table_id: # (test.t1)
master-bin.000001 24316 Write_rows 1 24350 table_id: # flags: STMT_END_F
master-bin.000001 24350 Table_map 1 24391 table_id: # (test.t1)
master-bin.000001 24391 Write_rows 1 24425 table_id: # flags: STMT_END_F
master-bin.000001 24425 Table_map 1 24466 table_id: # (test.t1)
master-bin.000001 24466 Write_rows 1 24500 table_id: # flags: STMT_END_F
master-bin.000001 24500 Table_map 1 24541 table_id: # (test.t1)
master-bin.000001 24541 Write_rows 1 24575 table_id: # flags: STMT_END_F
master-bin.000001 24575 Table_map 1 24616 table_id: # (test.t1)
master-bin.000001 24616 Write_rows 1 24650 table_id: # flags: STMT_END_F
master-bin.000001 24650 Table_map 1 24691 table_id: # (test.t1)
master-bin.000001 24691 Write_rows 1 24725 table_id: # flags: STMT_END_F
master-bin.000001 24725 Table_map 1 24766 table_id: # (test.t1)
master-bin.000001 24766 Write_rows 1 24800 table_id: # flags: STMT_END_F
master-bin.000001 24800 Table_map 1 24841 table_id: # (test.t1)
master-bin.000001 24841 Write_rows 1 24875 table_id: # flags: STMT_END_F
master-bin.000001 24875 Table_map 1 24916 table_id: # (test.t1)
master-bin.000001 24916 Write_rows 1 24950 table_id: # flags: STMT_END_F
master-bin.000001 24950 Table_map 1 24991 table_id: # (test.t1)
master-bin.000001 24991 Write_rows 1 25025 table_id: # flags: STMT_END_F
master-bin.000001 25025 Table_map 1 25066 table_id: # (test.t1)
master-bin.000001 25066 Write_rows 1 25100 table_id: # flags: STMT_END_F
master-bin.000001 25100 Table_map 1 25141 table_id: # (test.t1)
master-bin.000001 25141 Write_rows 1 25175 table_id: # flags: STMT_END_F
master-bin.000001 25175 Table_map 1 25216 table_id: # (test.t1)
master-bin.000001 25216 Write_rows 1 25250 table_id: # flags: STMT_END_F
master-bin.000001 25250 Table_map 1 25291 table_id: # (test.t1)
master-bin.000001 25291 Write_rows 1 25325 table_id: # flags: STMT_END_F
master-bin.000001 25325 Table_map 1 25366 table_id: # (test.t1)
master-bin.000001 25366 Write_rows 1 25400 table_id: # flags: STMT_END_F
master-bin.000001 25400 Table_map 1 25441 table_id: # (test.t1)
master-bin.000001 25441 Write_rows 1 25475 table_id: # flags: STMT_END_F
master-bin.000001 25475 Table_map 1 25516 table_id: # (test.t1)
master-bin.000001 25516 Write_rows 1 25550 table_id: # flags: STMT_END_F
master-bin.000001 25550 Table_map 1 25591 table_id: # (test.t1)
master-bin.000001 25591 Write_rows 1 25625 table_id: # flags: STMT_END_F
master-bin.000001 25625 Table_map 1 25666 table_id: # (test.t1)
master-bin.000001 25666 Write_rows 1 25700 table_id: # flags: STMT_END_F
master-bin.000001 25700 Table_map 1 25741 table_id: # (test.t1)
master-bin.000001 25741 Write_rows 1 25775 table_id: # flags: STMT_END_F
master-bin.000001 25775 Table_map 1 25816 table_id: # (test.t1)
master-bin.000001 25816 Write_rows 1 25850 table_id: # flags: STMT_END_F
master-bin.000001 25850 Table_map 1 25891 table_id: # (test.t1)
master-bin.000001 25891 Write_rows 1 25925 table_id: # flags: STMT_END_F
master-bin.000001 25925 Table_map 1 25966 table_id: # (test.t1)
master-bin.000001 25966 Write_rows 1 26000 table_id: # flags: STMT_END_F
master-bin.000001 26000 Table_map 1 26041 table_id: # (test.t1)
master-bin.000001 26041 Write_rows 1 26075 table_id: # flags: STMT_END_F
master-bin.000001 26075 Table_map 1 26116 table_id: # (test.t1)
master-bin.000001 26116 Write_rows 1 26150 table_id: # flags: STMT_END_F
master-bin.000001 26150 Table_map 1 26191 table_id: # (test.t1)
master-bin.000001 26191 Write_rows 1 26225 table_id: # flags: STMT_END_F
master-bin.000001 26225 Table_map 1 26266 table_id: # (test.t1)
master-bin.000001 26266 Write_rows 1 26300 table_id: # flags: STMT_END_F
master-bin.000001 26300 Table_map 1 26341 table_id: # (test.t1)
master-bin.000001 26341 Write_rows 1 26375 table_id: # flags: STMT_END_F
master-bin.000001 26375 Table_map 1 26416 table_id: # (test.t1)
master-bin.000001 26416 Write_rows 1 26450 table_id: # flags: STMT_END_F
master-bin.000001 26450 Table_map 1 26491 table_id: # (test.t1)
master-bin.000001 26491 Write_rows 1 26525 table_id: # flags: STMT_END_F
master-bin.000001 26525 Table_map 1 26566 table_id: # (test.t1)
master-bin.000001 26566 Write_rows 1 26600 table_id: # flags: STMT_END_F
master-bin.000001 26600 Table_map 1 26641 table_id: # (test.t1)
master-bin.000001 26641 Write_rows 1 26675 table_id: # flags: STMT_END_F
master-bin.000001 26675 Table_map 1 26716 table_id: # (test.t1)
master-bin.000001 26716 Write_rows 1 26750 table_id: # flags: STMT_END_F
master-bin.000001 26750 Table_map 1 26791 table_id: # (test.t1)
master-bin.000001 26791 Write_rows 1 26825 table_id: # flags: STMT_END_F
master-bin.000001 26825 Table_map 1 26866 table_id: # (test.t1)
master-bin.000001 26866 Write_rows 1 26900 table_id: # flags: STMT_END_F
master-bin.000001 26900 Table_map 1 26941 table_id: # (test.t1)
master-bin.000001 26941 Write_rows 1 26975 table_id: # flags: STMT_END_F
master-bin.000001 26975 Table_map 1 27016 table_id: # (test.t1)
master-bin.000001 27016 Write_rows 1 27050 table_id: # flags: STMT_END_F
master-bin.000001 27050 Table_map 1 27091 table_id: # (test.t1)
master-bin.000001 27091 Write_rows 1 27125 table_id: # flags: STMT_END_F
master-bin.000001 27125 Table_map 1 27166 table_id: # (test.t1)
master-bin.000001 27166 Write_rows 1 27200 table_id: # flags: STMT_END_F
master-bin.000001 27200 Table_map 1 27241 table_id: # (test.t1)
master-bin.000001 27241 Write_rows 1 27275 table_id: # flags: STMT_END_F
master-bin.000001 27275 Table_map 1 27316 table_id: # (test.t1)
master-bin.000001 27316 Write_rows 1 27350 table_id: # flags: STMT_END_F
master-bin.000001 27350 Table_map 1 27391 table_id: # (test.t1)
master-bin.000001 27391 Write_rows 1 27425 table_id: # flags: STMT_END_F
master-bin.000001 27425 Table_map 1 27466 table_id: # (test.t1)
master-bin.000001 27466 Write_rows 1 27500 table_id: # flags: STMT_END_F
master-bin.000001 27500 Table_map 1 27541 table_id: # (test.t1)
master-bin.000001 27541 Write_rows 1 27575 table_id: # flags: STMT_END_F
master-bin.000001 27575 Table_map 1 27616 table_id: # (test.t1)
master-bin.000001 27616 Write_rows 1 27650 table_id: # flags: STMT_END_F
master-bin.000001 27650 Table_map 1 27691 table_id: # (test.t1)
master-bin.000001 27691 Write_rows 1 27725 table_id: # flags: STMT_END_F
master-bin.000001 27725 Table_map 1 27766 table_id: # (test.t1)
master-bin.000001 27766 Write_rows 1 27800 table_id: # flags: STMT_END_F
master-bin.000001 27800 Table_map 1 27841 table_id: # (test.t1)
master-bin.000001 27841 Write_rows 1 27875 table_id: # flags: STMT_END_F
master-bin.000001 27875 Table_map 1 27916 table_id: # (test.t1)
master-bin.000001 27916 Write_rows 1 27950 table_id: # flags: STMT_END_F
master-bin.000001 27950 Table_map 1 27991 table_id: # (test.t1)
master-bin.000001 27991 Write_rows 1 28025 table_id: # flags: STMT_END_F
master-bin.000001 28025 Table_map 1 28066 table_id: # (test.t1)
master-bin.000001 28066 Write_rows 1 28100 table_id: # flags: STMT_END_F
master-bin.000001 28100 Table_map 1 28141 table_id: # (test.t1)
master-bin.000001 28141 Write_rows 1 28175 table_id: # flags: STMT_END_F
master-bin.000001 28175 Table_map 1 28216 table_id: # (test.t1)
master-bin.000001 28216 Write_rows 1 28250 table_id: # flags: STMT_END_F
master-bin.000001 28250 Table_map 1 28291 table_id: # (test.t1)
master-bin.000001 28291 Write_rows 1 28325 table_id: # flags: STMT_END_F
master-bin.000001 28325 Table_map 1 28366 table_id: # (test.t1)
master-bin.000001 28366 Write_rows 1 28400 table_id: # flags: STMT_END_F
master-bin.000001 28400 Table_map 1 28441 table_id: # (test.t1)
master-bin.000001 28441 Write_rows 1 28475 table_id: # flags: STMT_END_F
master-bin.000001 28475 Table_map 1 28516 table_id: # (test.t1)
master-bin.000001 28516 Write_rows 1 28550 table_id: # flags: STMT_END_F
master-bin.000001 28550 Table_map 1 28591 table_id: # (test.t1)
master-bin.000001 28591 Write_rows 1 28625 table_id: # flags: STMT_END_F
master-bin.000001 28625 Table_map 1 28666 table_id: # (test.t1)
master-bin.000001 28666 Write_rows 1 28700 table_id: # flags: STMT_END_F
master-bin.000001 28700 Table_map 1 28741 table_id: # (test.t1)
master-bin.000001 28741 Write_rows 1 28775 table_id: # flags: STMT_END_F
master-bin.000001 28775 Table_map 1 28816 table_id: # (test.t1)
master-bin.000001 28816 Write_rows 1 28850 table_id: # flags: STMT_END_F
master-bin.000001 28850 Table_map 1 28891 table_id: # (test.t1)
master-bin.000001 28891 Write_rows 1 28925 table_id: # flags: STMT_END_F
master-bin.000001 28925 Table_map 1 28966 table_id: # (test.t1)
master-bin.000001 28966 Write_rows 1 29000 table_id: # flags: STMT_END_F
master-bin.000001 29000 Table_map 1 29041 table_id: # (test.t1)
master-bin.000001 29041 Write_rows 1 29075 table_id: # flags: STMT_END_F
master-bin.000001 29075 Table_map 1 29116 table_id: # (test.t1)
master-bin.000001 29116 Write_rows 1 29150 table_id: # flags: STMT_END_F
master-bin.000001 29150 Table_map 1 29191 table_id: # (test.t1)
master-bin.000001 29191 Write_rows 1 29225 table_id: # flags: STMT_END_F
master-bin.000001 29225 Table_map 1 29266 table_id: # (test.t1)
master-bin.000001 29266 Write_rows 1 29300 table_id: # flags: STMT_END_F
master-bin.000001 29300 Table_map 1 29341 table_id: # (test.t1)
master-bin.000001 29341 Write_rows 1 29375 table_id: # flags: STMT_END_F
master-bin.000001 29375 Table_map 1 29416 table_id: # (test.t1)
master-bin.000001 29416 Write_rows 1 29450 table_id: # flags: STMT_END_F
master-bin.000001 29450 Table_map 1 29491 table_id: # (test.t1)
master-bin.000001 29491 Write_rows 1 29525 table_id: # flags: STMT_END_F
master-bin.000001 29525 Table_map 1 29566 table_id: # (test.t1)
master-bin.000001 29566 Write_rows 1 29600 table_id: # flags: STMT_END_F
master-bin.000001 29600 Table_map 1 29641 table_id: # (test.t1)
master-bin.000001 29641 Write_rows 1 29675 table_id: # flags: STMT_END_F
master-bin.000001 29675 Table_map 1 29716 table_id: # (test.t1)
master-bin.000001 29716 Write_rows 1 29750 table_id: # flags: STMT_END_F
master-bin.000001 29750 Table_map 1 29791 table_id: # (test.t1)
master-bin.000001 29791 Write_rows 1 29825 table_id: # flags: STMT_END_F
master-bin.000001 29825 Table_map 1 29866 table_id: # (test.t1)
master-bin.000001 29866 Write_rows 1 29900 table_id: # flags: STMT_END_F
master-bin.000001 29900 Table_map 1 29941 table_id: # (test.t1)
master-bin.000001 29941 Write_rows 1 29975 table_id: # flags: STMT_END_F
master-bin.000001 29975 Table_map 1 30016 table_id: # (test.t1)
master-bin.000001 30016 Write_rows 1 30050 table_id: # flags: STMT_END_F
master-bin.000001 30050 Table_map 1 30091 table_id: # (test.t1)
master-bin.000001 30091 Write_rows 1 30125 table_id: # flags: STMT_END_F
master-bin.000001 30125 Table_map 1 30166 table_id: # (test.t1)
master-bin.000001 30166 Write_rows 1 30200 table_id: # flags: STMT_END_F
master-bin.000001 30200 Table_map 1 30241 table_id: # (test.t1)
master-bin.000001 30241 Write_rows 1 30275 table_id: # flags: STMT_END_F
master-bin.000001 30275 Xid 1 30302 COMMIT /* XID */
master-bin.000001 30302 Rotate 1 30346 master-bin.000002;pos=4
drop table t1;
set global binlog_cache_size=@bcs;
set session autocommit = @ac;
drop table if exists t1;
reset master;
create table t1 (a bigint unsigned, b bigint(20) unsigned);
prepare stmt from "insert into t1 values (?,?)";
set @a= 9999999999999999;
set @b= 14632475938453979136;
execute stmt using @a, @b;
deallocate prepare stmt;
drop table t1;
show binlog events from 0;
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000001 4 Format_desc 1 107 Server version, Binlog ver: 4
master-bin.000001 107 Query 1 228 use `test`; create table t1 (a bigint unsigned, b bigint(20) unsigned)
master-bin.000001 228 Query 1 296 use `test`; BEGIN
master-bin.000001 296 Table_map 1 338 table_id: # (test.t1)
master-bin.000001 338 Write_rows 1 384 table_id: # flags: STMT_END_F
master-bin.000001 384 Query 1 453 use `test`; COMMIT
master-bin.000001 453 Query 1 529 use `test`; drop table t1
End of 5.0 tests
reset master;
create table t1 (id tinyint auto_increment primary key);
set insert_id=128;
insert into t1 values(null);
Warnings:
Warning 1264 Out of range value for column 'id' at row 1
select * from t1;
id
127
drop table t1;
create table t1 (a int);
create table if not exists t2 select * from t1;
create temporary table tt1 (a int);
create table if not exists t3 like tt1;
USE mysql;
INSERT INTO user SET host='localhost', user='@#@', password=password('Just a test');
UPDATE user SET password=password('Another password') WHERE host='localhost' AND user='@#@';
DELETE FROM user WHERE host='localhost' AND user='@#@';
use test;
show binlog events from <binlog_start>;
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000001 # Query # # use `test`; create table t1 (id tinyint auto_increment primary key)
master-bin.000001 # Query # # use `test`; BEGIN
master-bin.000001 # Table_map # # table_id: # (test.t1)
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
master-bin.000001 # Query # # use `test`; COMMIT
master-bin.000001 # Query # # use `test`; drop table t1
master-bin.000001 # Query # # use `test`; create table t1 (a int)
master-bin.000001 # Query # # use `test`; BEGIN
master-bin.000001 # Query # # use `test`; CREATE TABLE IF NOT EXISTS `t2` (
`a` int(11) DEFAULT NULL
)
master-bin.000001 # Query # # use `test`; COMMIT
master-bin.000001 # Query # # use `test`; CREATE TABLE IF NOT EXISTS `t3` (
`a` int(11) DEFAULT NULL
)
master-bin.000001 # Query # # use `mysql`; BEGIN
master-bin.000001 # Table_map # # table_id: # (mysql.user)
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
master-bin.000001 # Query # # use `mysql`; COMMIT
master-bin.000001 # Query # # use `mysql`; BEGIN
master-bin.000001 # Table_map # # table_id: # (mysql.user)
master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
master-bin.000001 # Query # # use `mysql`; COMMIT
master-bin.000001 # Query # # use `mysql`; BEGIN
master-bin.000001 # Table_map # # table_id: # (mysql.user)
master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F
master-bin.000001 # Query # # use `mysql`; COMMIT
drop table t1,t2,t3,tt1;
create table t1 (a int not null auto_increment, primary key (a)) engine=myisam;
set @@session.auto_increment_increment=1, @@session.auto_increment_offset=1;
insert delayed into t1 values (207);
insert delayed into t1 values (null);
insert delayed into t1 values (300);
show binlog events from <binlog_start>;
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000001 # Query # # use `test`; create table t1 (id tinyint auto_increment primary key)
master-bin.000001 # Query # # use `test`; BEGIN
master-bin.000001 # Table_map # # table_id: # (test.t1)
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
master-bin.000001 # Query # # use `test`; COMMIT
master-bin.000001 # Query # # use `test`; drop table t1
master-bin.000001 # Query # # use `test`; create table t1 (a int)
master-bin.000001 # Query # # use `test`; BEGIN
master-bin.000001 # Query # # use `test`; CREATE TABLE IF NOT EXISTS `t2` (
`a` int(11) DEFAULT NULL
)
master-bin.000001 # Query # # use `test`; COMMIT
master-bin.000001 # Query # # use `test`; CREATE TABLE IF NOT EXISTS `t3` (
`a` int(11) DEFAULT NULL
)
master-bin.000001 # Query # # use `mysql`; BEGIN
master-bin.000001 # Table_map # # table_id: # (mysql.user)
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
master-bin.000001 # Query # # use `mysql`; COMMIT
master-bin.000001 # Query # # use `mysql`; BEGIN
master-bin.000001 # Table_map # # table_id: # (mysql.user)
master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
master-bin.000001 # Query # # use `mysql`; COMMIT
master-bin.000001 # Query # # use `mysql`; BEGIN
master-bin.000001 # Table_map # # table_id: # (mysql.user)
master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F
master-bin.000001 # Query # # use `mysql`; COMMIT
master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2`,`t3` /* generated by server */
master-bin.000001 # Query # # use `test`; create table t1 (a int not null auto_increment, primary key (a)) engine=myisam
master-bin.000001 # Query # # use `test`; BEGIN
master-bin.000001 # Table_map # # table_id: # (test.t1)
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
master-bin.000001 # Query # # use `test`; COMMIT
master-bin.000001 # Query # # use `test`; BEGIN
master-bin.000001 # Table_map # # table_id: # (test.t1)
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
master-bin.000001 # Query # # use `test`; COMMIT
master-bin.000001 # Query # # use `test`; BEGIN
master-bin.000001 # Table_map # # table_id: # (test.t1)
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
master-bin.000001 # Query # # use `test`; COMMIT
insert delayed into t1 values (null),(null),(null),(null);
insert delayed into t1 values (null),(null),(400),(null);
11 == 11
select * from t1;
a
207
208
300
301
302
303
304
305
306
400
401
drop table t1;
reset master;
drop table if exists t3;
create table t3 (a int(11) NOT NULL AUTO_INCREMENT, b text, PRIMARY KEY (a) ) engine=innodb;
show master status;
File Position Binlog_Do_DB Binlog_Ignore_DB
master-bin.000001 347
insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
show master status /* must show new binlog index after rotating */;
File Position Binlog_Do_DB Binlog_Ignore_DB
master-bin.000002 107
drop table t3;
|