9
9
insert t2 values (5);
11
show binlog events from 102;
11
show binlog events from <binlog_start>;
12
12
Log_name Pos Event_type Server_id End_log_pos Info
13
master-bin.000001 # Query 1 # use `test`; create table t1 (a int) engine=innodb
14
master-bin.000001 # Query 1 # use `test`; create table t2 (a int) engine=innodb
15
master-bin.000001 # Query 1 # use `test`; BEGIN
16
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
17
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
18
master-bin.000001 # Xid 1 # COMMIT /* xid= */
19
master-bin.000001 # Query 1 # use `test`; BEGIN
20
master-bin.000001 # Table_map 1 # table_id: # (test.t2)
21
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
22
master-bin.000001 # Xid 1 # COMMIT /* xid= */
13
master-bin.000001 # Query # # use `test`; create table t1 (a int) engine=innodb
14
master-bin.000001 # Query # # use `test`; create table t2 (a int) engine=innodb
15
master-bin.000001 # Query # # use `test`; BEGIN
16
master-bin.000001 # Table_map # # table_id: # (test.t1)
17
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
18
master-bin.000001 # Xid # # COMMIT /* XID */
19
master-bin.000001 # Query # # use `test`; BEGIN
20
master-bin.000001 # Table_map # # table_id: # (test.t2)
21
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
22
master-bin.000001 # Xid # # COMMIT /* XID */
25
25
create table t1 (n int) engine=innodb;
29
show binlog events in 'master-bin.000001' from 102;
29
show binlog events in 'master-bin.000001' from 106;
30
30
Log_name Pos Event_type Server_id End_log_pos Info
31
31
master-bin.000001 # Query 1 # use `test`; create table t1 (n int) engine=innodb
32
32
master-bin.000001 # Query 1 # use `test`; BEGIN
254
254
UPDATE user SET password=password('Another password') WHERE host='localhost' AND user='@#@';
255
255
DELETE FROM user WHERE host='localhost' AND user='@#@';
257
show binlog events from 102;
257
show binlog events from <binlog_start>;
258
258
Log_name Pos Event_type Server_id End_log_pos Info
259
master-bin.000001 # Query 1 # use `test`; create table t1 (id tinyint auto_increment primary key)
260
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
261
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
262
master-bin.000001 # Query 1 # use `test`; drop table t1
263
master-bin.000001 # Query 1 # use `test`; create table t1 (a int)
264
master-bin.000001 # Query 1 # use `test`; CREATE TABLE IF NOT EXISTS `t2` (
265
`a` int(11) DEFAULT NULL
267
master-bin.000001 # Query 1 # use `test`; CREATE TABLE IF NOT EXISTS `t3` (
268
`a` int(11) DEFAULT NULL
270
master-bin.000001 # Table_map 1 # table_id: # (mysql.user)
271
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
272
master-bin.000001 # Table_map 1 # table_id: # (mysql.user)
273
master-bin.000001 # Update_rows 1 # table_id: # flags: STMT_END_F
274
master-bin.000001 # Table_map 1 # table_id: # (mysql.user)
275
master-bin.000001 # Delete_rows 1 # table_id: # flags: STMT_END_F
259
master-bin.000001 # Query # # use `test`; create table t1 (id tinyint auto_increment primary key)
260
master-bin.000001 # Table_map # # table_id: # (test.t1)
261
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
262
master-bin.000001 # Query # # use `test`; drop table t1
263
master-bin.000001 # Query # # use `test`; create table t1 (a int)
264
master-bin.000001 # Query # # use `test`; CREATE TABLE IF NOT EXISTS `t2` (
265
`a` int(11) DEFAULT NULL
267
master-bin.000001 # Query # # use `test`; CREATE TABLE IF NOT EXISTS `t3` (
268
`a` int(11) DEFAULT NULL
270
master-bin.000001 # Table_map # # table_id: # (mysql.user)
271
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
272
master-bin.000001 # Table_map # # table_id: # (mysql.user)
273
master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
274
master-bin.000001 # Table_map # # table_id: # (mysql.user)
275
master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F
276
276
drop table t1,t2,t3,tt1;
277
277
create table t1 (a int not null auto_increment, primary key (a)) engine=myisam;
278
278
set @@session.auto_increment_increment=1, @@session.auto_increment_offset=1;
279
279
insert delayed into t1 values (207);
280
280
insert delayed into t1 values (null);
281
281
insert delayed into t1 values (300);
282
show binlog events from 102;
282
show binlog events from <binlog_start>;
283
283
Log_name Pos Event_type Server_id End_log_pos Info
284
master-bin.000001 # Query 1 # use `test`; create table t1 (id tinyint auto_increment primary key)
285
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
286
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
287
master-bin.000001 # Query 1 # use `test`; drop table t1
288
master-bin.000001 # Query 1 # use `test`; create table t1 (a int)
289
master-bin.000001 # Query 1 # use `test`; CREATE TABLE IF NOT EXISTS `t2` (
290
`a` int(11) DEFAULT NULL
292
master-bin.000001 # Query 1 # use `test`; CREATE TABLE IF NOT EXISTS `t3` (
293
`a` int(11) DEFAULT NULL
295
master-bin.000001 # Table_map 1 # table_id: # (mysql.user)
296
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
297
master-bin.000001 # Table_map 1 # table_id: # (mysql.user)
298
master-bin.000001 # Update_rows 1 # table_id: # flags: STMT_END_F
299
master-bin.000001 # Table_map 1 # table_id: # (mysql.user)
300
master-bin.000001 # Delete_rows 1 # table_id: # flags: STMT_END_F
301
master-bin.000001 # Query 1 # use `test`; DROP TABLE `t1`,`t2`,`t3` /* generated by server */
302
master-bin.000001 # Query 1 # use `test`; create table t1 (a int not null auto_increment, primary key (a)) engine=myisam
303
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
304
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
305
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
306
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
307
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
308
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
284
master-bin.000001 # Query # # use `test`; create table t1 (id tinyint auto_increment primary key)
285
master-bin.000001 # Table_map # # table_id: # (test.t1)
286
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
287
master-bin.000001 # Query # # use `test`; drop table t1
288
master-bin.000001 # Query # # use `test`; create table t1 (a int)
289
master-bin.000001 # Query # # use `test`; CREATE TABLE IF NOT EXISTS `t2` (
290
`a` int(11) DEFAULT NULL
292
master-bin.000001 # Query # # use `test`; CREATE TABLE IF NOT EXISTS `t3` (
293
`a` int(11) DEFAULT NULL
295
master-bin.000001 # Table_map # # table_id: # (mysql.user)
296
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
297
master-bin.000001 # Table_map # # table_id: # (mysql.user)
298
master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
299
master-bin.000001 # Table_map # # table_id: # (mysql.user)
300
master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F
301
master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2`,`t3` /* generated by server */
302
master-bin.000001 # Query # # use `test`; create table t1 (a int not null auto_increment, primary key (a)) engine=myisam
303
master-bin.000001 # Table_map # # table_id: # (test.t1)
304
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
305
master-bin.000001 # Table_map # # table_id: # (test.t1)
306
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
307
master-bin.000001 # Table_map # # table_id: # (test.t1)
308
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
309
309
insert delayed into t1 values (null),(null),(null),(null);
310
310
insert delayed into t1 values (null),(null),(400),(null);