6
6
Log_name Pos Event_type Server_id End_log_pos Info
7
master-bin.000001 4 Format_desc 1 102 Server ver: #, Binlog ver: #
8
master-bin.000001 102 Query 1 209 use `test`; create table t1 (a int, b int) engine=innodb
9
master-bin.000001 209 Query 1 277 use `test`; BEGIN
10
master-bin.000001 277 Query 1 90 use `test`; insert into t1 values (1,2)
11
master-bin.000001 367 Xid 1 394 COMMIT /* XID */
7
master-bin.000001 4 Format_desc 1 106 Server ver: #, Binlog ver: #
8
master-bin.000001 106 Query 1 213 use `test`; create table t1 (a int, b int) engine=innodb
9
master-bin.000001 213 Query 1 281 use `test`; BEGIN
10
master-bin.000001 281 Query 1 90 use `test`; insert into t1 values (1,2)
11
master-bin.000001 371 Xid 1 398 COMMIT /* XID */
13
13
drop table if exists t1, t2;
21
21
insert t2 values (5);
23
show binlog events from 102;
23
show binlog events from <binlog_start>;
24
24
Log_name Pos Event_type Server_id End_log_pos Info
25
master-bin.000001 # Query 1 # use `test`; create table t1 (a int) engine=innodb
26
master-bin.000001 # Query 1 # use `test`; create table t2 (a int) engine=innodb
27
master-bin.000001 # Query 1 # use `test`; BEGIN
28
master-bin.000001 # Query 1 # use `test`; insert t1 values (5)
29
master-bin.000001 # Xid 1 # COMMIT /* xid= */
30
master-bin.000001 # Query 1 # use `test`; BEGIN
31
master-bin.000001 # Query 1 # use `test`; insert t2 values (5)
32
master-bin.000001 # Xid 1 # COMMIT /* xid= */
25
master-bin.000001 # Query # # use `test`; create table t1 (a int) engine=innodb
26
master-bin.000001 # Query # # use `test`; create table t2 (a int) engine=innodb
27
master-bin.000001 # Query # # use `test`; BEGIN
28
master-bin.000001 # Query # # use `test`; insert t1 values (5)
29
master-bin.000001 # Xid # # COMMIT /* XID */
30
master-bin.000001 # Query # # use `test`; BEGIN
31
master-bin.000001 # Query # # use `test`; insert t2 values (5)
32
master-bin.000001 # Xid # # COMMIT /* XID */
35
35
create table t1 (n int) engine=innodb;
39
show binlog events in 'master-bin.000001' from 102;
39
show binlog events in 'master-bin.000001' from 106;
40
40
Log_name Pos Event_type Server_id End_log_pos Info
41
41
master-bin.000001 # Query 1 # use `test`; create table t1 (n int) engine=innodb
42
42
master-bin.000001 # Query 1 # use `test`; BEGIN
164
164
UPDATE user SET password=password('Another password') WHERE host='localhost' AND user='@#@';
165
165
DELETE FROM user WHERE host='localhost' AND user='@#@';
167
show binlog events from 102;
167
show binlog events from <binlog_start>;
168
168
Log_name Pos Event_type Server_id End_log_pos Info
169
master-bin.000001 # Query 1 # use `test`; create table t1 (id tinyint auto_increment primary key)
170
master-bin.000001 # Intvar 1 # INSERT_ID=127
171
master-bin.000001 # Query 1 # use `test`; insert into t1 values(null)
172
master-bin.000001 # Query 1 # use `test`; drop table t1
173
master-bin.000001 # Query 1 # use `test`; create table t1 (a int)
174
master-bin.000001 # Query 1 # use `test`; create table if not exists t2 select * from t1
175
master-bin.000001 # Query 1 # use `test`; create temporary table tt1 (a int)
176
master-bin.000001 # Query 1 # use `test`; create table if not exists t3 like tt1
177
master-bin.000001 # Query 1 # use `mysql`; INSERT INTO user SET host='localhost', user='@#@', password=password('Just a test')
178
master-bin.000001 # Query 1 # use `mysql`; UPDATE user SET password=password('Another password') WHERE host='localhost' AND user='@#@'
179
master-bin.000001 # Query 1 # use `mysql`; DELETE FROM user WHERE host='localhost' AND user='@#@'
169
master-bin.000001 # Query # # use `test`; create table t1 (id tinyint auto_increment primary key)
170
master-bin.000001 # Intvar # # INSERT_ID=127
171
master-bin.000001 # Query # # use `test`; insert into t1 values(null)
172
master-bin.000001 # Query # # use `test`; drop table t1
173
master-bin.000001 # Query # # use `test`; create table t1 (a int)
174
master-bin.000001 # Query # # use `test`; create table if not exists t2 select * from t1
175
master-bin.000001 # Query # # use `test`; create temporary table tt1 (a int)
176
master-bin.000001 # Query # # use `test`; create table if not exists t3 like tt1
177
master-bin.000001 # Query # # use `mysql`; INSERT INTO user SET host='localhost', user='@#@', password=password('Just a test')
178
master-bin.000001 # Query # # use `mysql`; UPDATE user SET password=password('Another password') WHERE host='localhost' AND user='@#@'
179
master-bin.000001 # Query # # use `mysql`; DELETE FROM user WHERE host='localhost' AND user='@#@'
180
180
drop table t1,t2,t3,tt1;
181
181
create table t1 (a int not null auto_increment, primary key (a)) engine=myisam;
182
182
set @@session.auto_increment_increment=1, @@session.auto_increment_offset=1;
183
183
insert delayed into t1 values (207);
184
184
insert delayed into t1 values (null);
185
185
insert delayed into t1 values (300);
186
show binlog events from 102;
186
show binlog events from <binlog_start>;
187
187
Log_name Pos Event_type Server_id End_log_pos Info
188
master-bin.000001 # Query 1 # use `test`; create table t1 (id tinyint auto_increment primary key)
189
master-bin.000001 # Intvar 1 # INSERT_ID=127
190
master-bin.000001 # Query 1 # use `test`; insert into t1 values(null)
191
master-bin.000001 # Query 1 # use `test`; drop table t1
192
master-bin.000001 # Query 1 # use `test`; create table t1 (a int)
193
master-bin.000001 # Query 1 # use `test`; create table if not exists t2 select * from t1
194
master-bin.000001 # Query 1 # use `test`; create temporary table tt1 (a int)
195
master-bin.000001 # Query 1 # use `test`; create table if not exists t3 like tt1
196
master-bin.000001 # Query 1 # use `mysql`; INSERT INTO user SET host='localhost', user='@#@', password=password('Just a test')
197
master-bin.000001 # Query 1 # use `mysql`; UPDATE user SET password=password('Another password') WHERE host='localhost' AND user='@#@'
198
master-bin.000001 # Query 1 # use `mysql`; DELETE FROM user WHERE host='localhost' AND user='@#@'
199
master-bin.000001 # Query 1 # use `test`; drop table t1,t2,t3,tt1
200
master-bin.000001 # Query 1 # use `test`; create table t1 (a int not null auto_increment, primary key (a)) engine=myisam
201
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
202
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
203
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
204
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
205
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
206
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
188
master-bin.000001 # Query # # use `test`; create table t1 (id tinyint auto_increment primary key)
189
master-bin.000001 # Intvar # # INSERT_ID=127
190
master-bin.000001 # Query # # use `test`; insert into t1 values(null)
191
master-bin.000001 # Query # # use `test`; drop table t1
192
master-bin.000001 # Query # # use `test`; create table t1 (a int)
193
master-bin.000001 # Query # # use `test`; create table if not exists t2 select * from t1
194
master-bin.000001 # Query # # use `test`; create temporary table tt1 (a int)
195
master-bin.000001 # Query # # use `test`; create table if not exists t3 like tt1
196
master-bin.000001 # Query # # use `mysql`; INSERT INTO user SET host='localhost', user='@#@', password=password('Just a test')
197
master-bin.000001 # Query # # use `mysql`; UPDATE user SET password=password('Another password') WHERE host='localhost' AND user='@#@'
198
master-bin.000001 # Query # # use `mysql`; DELETE FROM user WHERE host='localhost' AND user='@#@'
199
master-bin.000001 # Query # # use `test`; drop table t1,t2,t3,tt1
200
master-bin.000001 # Query # # use `test`; create table t1 (a int not null auto_increment, primary key (a)) engine=myisam
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 # Table_map # # table_id: # (test.t1)
204
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
205
master-bin.000001 # Table_map # # table_id: # (test.t1)
206
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
207
207
insert delayed into t1 values (null),(null),(null),(null);
208
208
insert delayed into t1 values (null),(null),(400),(null);