1
CREATE TABLE t1 (id INT) ENGINE = InnoDB;
2
SET BINLOG_FORMAT = STATEMENT;
5
INSERT INTO t1 VALUES (1);
6
show binlog events from <binlog_start>;
7
Log_name Pos Event_type Server_id End_log_pos Info
9
show binlog events from <binlog_start>;
10
Log_name Pos Event_type Server_id End_log_pos Info
11
master-bin.000001 # Query # # use `test`; BEGIN
12
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1)
13
master-bin.000001 # Xid # # COMMIT /* XID */
18
INSERT INTO t1 VALUES (2);
19
show binlog events from <binlog_start>;
20
Log_name Pos Event_type Server_id End_log_pos Info
22
show binlog events from <binlog_start>;
23
Log_name Pos Event_type Server_id End_log_pos Info
24
master-bin.000001 # Query # # use `test`; BEGIN
25
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2)
26
master-bin.000001 # Xid # # COMMIT /* XID */
27
INSERT INTO t1 VALUES (3);
28
show binlog events from <binlog_start>;
29
Log_name Pos Event_type Server_id End_log_pos Info
30
master-bin.000001 # Query # # use `test`; BEGIN
31
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2)
32
master-bin.000001 # Xid # # COMMIT /* XID */
33
master-bin.000001 # Query # # use `test`; BEGIN
34
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3)
35
master-bin.000001 # Xid # # COMMIT /* XID */
37
show binlog events from <binlog_start>;
38
Log_name Pos Event_type Server_id End_log_pos Info
39
master-bin.000001 # Query # # use `test`; BEGIN
40
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2)
41
master-bin.000001 # Xid # # COMMIT /* XID */
42
master-bin.000001 # Query # # use `test`; BEGIN
43
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3)
44
master-bin.000001 # Xid # # COMMIT /* XID */
48
INSERT INTO t1 VALUES (1);
49
show binlog events from <binlog_start>;
50
Log_name Pos Event_type Server_id End_log_pos Info
51
master-bin.000001 # Query # # use `test`; BEGIN
52
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1)
53
master-bin.000001 # Xid # # COMMIT /* XID */
55
show binlog events from <binlog_start>;
56
Log_name Pos Event_type Server_id End_log_pos Info
57
master-bin.000001 # Query # # use `test`; BEGIN
58
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1)
59
master-bin.000001 # Xid # # COMMIT /* XID */
64
INSERT INTO t1 VALUES (2);
65
show binlog events from <binlog_start>;
66
Log_name Pos Event_type Server_id End_log_pos Info
68
show binlog events from <binlog_start>;
69
Log_name Pos Event_type Server_id End_log_pos Info
70
INSERT INTO t1 VALUES (3);
71
show binlog events from <binlog_start>;
72
Log_name Pos Event_type Server_id End_log_pos Info
74
show binlog events from <binlog_start>;
75
Log_name Pos Event_type Server_id End_log_pos Info
76
master-bin.000001 # Query # # use `test`; BEGIN
77
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2)
78
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3)
79
master-bin.000001 # Xid # # COMMIT /* XID */
83
INSERT INTO t1 VALUES (1);
84
show binlog events from <binlog_start>;
85
Log_name Pos Event_type Server_id End_log_pos Info
87
show binlog events from <binlog_start>;
88
Log_name Pos Event_type Server_id End_log_pos Info
93
INSERT INTO t1 VALUES (2);
94
show binlog events from <binlog_start>;
95
Log_name Pos Event_type Server_id End_log_pos Info
97
show binlog events from <binlog_start>;
98
Log_name Pos Event_type Server_id End_log_pos Info
99
INSERT INTO t1 VALUES (3);
100
show binlog events from <binlog_start>;
101
Log_name Pos Event_type Server_id End_log_pos Info
103
show binlog events from <binlog_start>;
104
Log_name Pos Event_type Server_id End_log_pos Info
105
master-bin.000001 # Query # # use `test`; BEGIN
106
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2)
107
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3)
108
master-bin.000001 # Xid # # COMMIT /* XID */
112
INSERT INTO t1 VALUES (1);
113
show binlog events from <binlog_start>;
114
Log_name Pos Event_type Server_id End_log_pos Info
115
master-bin.000001 # Query # # use `test`; BEGIN
116
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1)
117
master-bin.000001 # Xid # # COMMIT /* XID */
119
show binlog events from <binlog_start>;
120
Log_name Pos Event_type Server_id End_log_pos Info
121
master-bin.000001 # Query # # use `test`; BEGIN
122
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1)
123
master-bin.000001 # Xid # # COMMIT /* XID */
128
INSERT INTO t1 VALUES (2);
129
show binlog events from <binlog_start>;
130
Log_name Pos Event_type Server_id End_log_pos Info
132
show binlog events from <binlog_start>;
133
Log_name Pos Event_type Server_id End_log_pos Info
134
INSERT INTO t1 VALUES (3);
135
show binlog events from <binlog_start>;
136
Log_name Pos Event_type Server_id End_log_pos Info
138
show binlog events from <binlog_start>;
139
Log_name Pos Event_type Server_id End_log_pos Info
140
master-bin.000001 # Query # # use `test`; BEGIN
141
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2)
142
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3)
143
master-bin.000001 # Xid # # COMMIT /* XID */
145
SET BINLOG_FORMAT = ROW;
148
INSERT INTO t1 VALUES (1);
149
show binlog events from <binlog_start>;
150
Log_name Pos Event_type Server_id End_log_pos Info
152
show binlog events from <binlog_start>;
153
Log_name Pos Event_type Server_id End_log_pos Info
154
master-bin.000001 # Query # # use `test`; BEGIN
155
master-bin.000001 # Table_map # # table_id: # (test.t1)
156
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
157
master-bin.000001 # Xid # # COMMIT /* XID */
162
INSERT INTO t1 VALUES (2);
163
show binlog events from <binlog_start>;
164
Log_name Pos Event_type Server_id End_log_pos Info
166
show binlog events from <binlog_start>;
167
Log_name Pos Event_type Server_id End_log_pos Info
168
master-bin.000001 # Query # # use `test`; BEGIN
169
master-bin.000001 # Table_map # # table_id: # (test.t1)
170
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
171
master-bin.000001 # Xid # # COMMIT /* XID */
172
INSERT INTO t1 VALUES (3);
173
show binlog events from <binlog_start>;
174
Log_name Pos Event_type Server_id End_log_pos Info
175
master-bin.000001 # Query # # use `test`; BEGIN
176
master-bin.000001 # Table_map # # table_id: # (test.t1)
177
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
178
master-bin.000001 # Xid # # COMMIT /* XID */
179
master-bin.000001 # Query # # use `test`; BEGIN
180
master-bin.000001 # Table_map # # table_id: # (test.t1)
181
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
182
master-bin.000001 # Xid # # COMMIT /* XID */
184
show binlog events from <binlog_start>;
185
Log_name Pos Event_type Server_id End_log_pos Info
186
master-bin.000001 # Query # # use `test`; BEGIN
187
master-bin.000001 # Table_map # # table_id: # (test.t1)
188
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
189
master-bin.000001 # Xid # # COMMIT /* XID */
190
master-bin.000001 # Query # # use `test`; BEGIN
191
master-bin.000001 # Table_map # # table_id: # (test.t1)
192
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
193
master-bin.000001 # Xid # # COMMIT /* XID */
197
INSERT INTO t1 VALUES (1);
198
show binlog events from <binlog_start>;
199
Log_name Pos Event_type Server_id End_log_pos Info
200
master-bin.000001 # Query # # use `test`; BEGIN
201
master-bin.000001 # Table_map # # table_id: # (test.t1)
202
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
203
master-bin.000001 # Xid # # COMMIT /* XID */
205
show binlog events from <binlog_start>;
206
Log_name Pos Event_type Server_id End_log_pos Info
207
master-bin.000001 # Query # # use `test`; BEGIN
208
master-bin.000001 # Table_map # # table_id: # (test.t1)
209
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
210
master-bin.000001 # Xid # # COMMIT /* XID */
215
INSERT INTO t1 VALUES (2);
216
show binlog events from <binlog_start>;
217
Log_name Pos Event_type Server_id End_log_pos Info
219
show binlog events from <binlog_start>;
220
Log_name Pos Event_type Server_id End_log_pos Info
221
INSERT INTO t1 VALUES (3);
222
show binlog events from <binlog_start>;
223
Log_name Pos Event_type Server_id End_log_pos Info
225
show binlog events from <binlog_start>;
226
Log_name Pos Event_type Server_id End_log_pos Info
227
master-bin.000001 # Query # # use `test`; BEGIN
228
master-bin.000001 # Table_map # # table_id: # (test.t1)
229
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
230
master-bin.000001 # Table_map # # table_id: # (test.t1)
231
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
232
master-bin.000001 # Xid # # COMMIT /* XID */
236
INSERT INTO t1 VALUES (1);
237
show binlog events from <binlog_start>;
238
Log_name Pos Event_type Server_id End_log_pos Info
240
show binlog events from <binlog_start>;
241
Log_name Pos Event_type Server_id End_log_pos Info
246
INSERT INTO t1 VALUES (2);
247
show binlog events from <binlog_start>;
248
Log_name Pos Event_type Server_id End_log_pos Info
250
show binlog events from <binlog_start>;
251
Log_name Pos Event_type Server_id End_log_pos Info
252
INSERT INTO t1 VALUES (3);
253
show binlog events from <binlog_start>;
254
Log_name Pos Event_type Server_id End_log_pos Info
256
show binlog events from <binlog_start>;
257
Log_name Pos Event_type Server_id End_log_pos Info
258
master-bin.000001 # Query # # use `test`; BEGIN
259
master-bin.000001 # Table_map # # table_id: # (test.t1)
260
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
261
master-bin.000001 # Table_map # # table_id: # (test.t1)
262
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
263
master-bin.000001 # Xid # # COMMIT /* XID */
267
INSERT INTO t1 VALUES (1);
268
show binlog events from <binlog_start>;
269
Log_name Pos Event_type Server_id End_log_pos Info
270
master-bin.000001 # Query # # use `test`; BEGIN
271
master-bin.000001 # Table_map # # table_id: # (test.t1)
272
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
273
master-bin.000001 # Xid # # COMMIT /* XID */
275
show binlog events from <binlog_start>;
276
Log_name Pos Event_type Server_id End_log_pos Info
277
master-bin.000001 # Query # # use `test`; BEGIN
278
master-bin.000001 # Table_map # # table_id: # (test.t1)
279
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
280
master-bin.000001 # Xid # # COMMIT /* XID */
285
INSERT INTO t1 VALUES (2);
286
show binlog events from <binlog_start>;
287
Log_name Pos Event_type Server_id End_log_pos Info
289
show binlog events from <binlog_start>;
290
Log_name Pos Event_type Server_id End_log_pos Info
291
INSERT INTO t1 VALUES (3);
292
show binlog events from <binlog_start>;
293
Log_name Pos Event_type Server_id End_log_pos Info
295
show binlog events from <binlog_start>;
296
Log_name Pos Event_type Server_id End_log_pos Info
297
master-bin.000001 # Query # # use `test`; BEGIN
298
master-bin.000001 # Table_map # # table_id: # (test.t1)
299
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
300
master-bin.000001 # Table_map # # table_id: # (test.t1)
301
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
302
master-bin.000001 # Xid # # COMMIT /* XID */
306
INSERT INTO t1 VALUES (1);
307
show binlog events from <binlog_start>;
308
Log_name Pos Event_type Server_id End_log_pos Info
309
LOCK TABLES t1 WRITE;
310
show binlog events from <binlog_start>;
311
Log_name Pos Event_type Server_id End_log_pos Info
312
master-bin.000001 # Query # # use `test`; BEGIN
313
master-bin.000001 # Table_map # # table_id: # (test.t1)
314
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
315
master-bin.000001 # Xid # # COMMIT /* XID */
316
INSERT INTO t1 VALUES (2);
317
show binlog events from <binlog_start>;
318
Log_name Pos Event_type Server_id End_log_pos Info
319
master-bin.000001 # Query # # use `test`; BEGIN
320
master-bin.000001 # Table_map # # table_id: # (test.t1)
321
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
322
master-bin.000001 # Xid # # COMMIT /* XID */
324
show binlog events from <binlog_start>;
325
Log_name Pos Event_type Server_id End_log_pos Info
326
master-bin.000001 # Query # # use `test`; BEGIN
327
master-bin.000001 # Table_map # # table_id: # (test.t1)
328
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
329
master-bin.000001 # Xid # # COMMIT /* XID */
330
master-bin.000001 # Query # # use `test`; BEGIN
331
master-bin.000001 # Table_map # # table_id: # (test.t1)
332
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
333
master-bin.000001 # Xid # # COMMIT /* XID */
335
show binlog events from <binlog_start>;
336
Log_name Pos Event_type Server_id End_log_pos Info
337
master-bin.000001 # Query # # use `test`; BEGIN
338
master-bin.000001 # Table_map # # table_id: # (test.t1)
339
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
340
master-bin.000001 # Xid # # COMMIT /* XID */
341
master-bin.000001 # Query # # use `test`; BEGIN
342
master-bin.000001 # Table_map # # table_id: # (test.t1)
343
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
344
master-bin.000001 # Xid # # COMMIT /* XID */