16
16
select count(*) from t1;
20
Log_name Pos Event_type Server_id End_log_pos Info
21
master-bin.000001 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4
22
master-bin.000001 # Query 1 # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
23
master-bin.000001 # Query 1 # BEGIN
24
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
25
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
26
master-bin.000001 # Query 1 # COMMIT
27
master-bin.000001 # Query 1 # use `test`; drop table t1
28
master-bin.000001 # Query 1 # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
29
master-bin.000001 # Query 1 # BEGIN
30
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
31
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
32
master-bin.000001 # Query 1 # COMMIT
33
show binlog events from 106 limit 1;
34
Log_name Pos Event_type Server_id End_log_pos Info
35
master-bin.000001 # Query 1 # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
36
show binlog events from 106 limit 2;
37
Log_name Pos Event_type Server_id End_log_pos Info
38
master-bin.000001 # Query 1 # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
39
master-bin.000001 # Query 1 # BEGIN
40
show binlog events from 106 limit 2,1;
41
Log_name Pos Event_type Server_id End_log_pos Info
42
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
19
show binlog events from <binlog_start>;
20
Log_name Pos Event_type Server_id End_log_pos Info
21
master-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
22
master-bin.000001 # Query # # BEGIN
23
master-bin.000001 # Table_map # # table_id: # (test.t1)
24
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
25
master-bin.000001 # Query # # COMMIT
26
master-bin.000001 # Query # # use `test`; drop table t1
27
master-bin.000001 # Query # # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
28
master-bin.000001 # Query # # BEGIN
29
master-bin.000001 # Table_map # # table_id: # (test.t1)
30
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
31
master-bin.000001 # Query # # COMMIT
32
show binlog events from <binlog_start> limit 1;
33
Log_name Pos Event_type Server_id End_log_pos Info
34
master-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
35
show binlog events from <binlog_start> limit 2;
36
Log_name Pos Event_type Server_id End_log_pos Info
37
master-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
38
master-bin.000001 # Query # # BEGIN
39
show binlog events from <binlog_start> limit 2,1;
40
Log_name Pos Event_type Server_id End_log_pos Info
41
master-bin.000001 # Table_map # # table_id: # (test.t1)
44
43
create table t3 (a int)ENGINE=MyISAM;
45
44
select * from t1 order by 1 asc;
203
202
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
204
203
master-bin.000001 # Query # # COMMIT
205
204
master-bin.000001 # Rotate # # master-bin.000002;pos=4
206
show binlog events in 'master-bin.000002';
205
show binlog events in 'master-bin.000002' from <binlog_start>;
207
206
Log_name Pos Event_type Server_id End_log_pos Info
208
master-bin.000002 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4
209
master-bin.000002 # Query 1 # use `test`; create table t3 (a int)ENGINE=MyISAM
210
master-bin.000002 # Query 1 # use `test`; create table t2 (n int)ENGINE=MyISAM
211
master-bin.000002 # Query 1 # BEGIN
212
master-bin.000002 # Table_map 1 # table_id: # (test.t2)
213
master-bin.000002 # Write_rows 1 # table_id: # flags: STMT_END_F
214
master-bin.000002 # Query 1 # COMMIT
207
master-bin.000002 # Query # # use `test`; create table t3 (a int)ENGINE=MyISAM
208
master-bin.000002 # Query # # use `test`; create table t2 (n int)ENGINE=MyISAM
209
master-bin.000002 # Query # # BEGIN
210
master-bin.000002 # Table_map # # table_id: # (test.t2)
211
master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
212
master-bin.000002 # Query # # COMMIT
215
213
show binary logs;
216
214
Log_name File_size
217
215
master-bin.000001 #
220
218
Log_name File_size
221
219
slave-bin.000001 #
222
220
slave-bin.000002 #
223
show binlog events in 'slave-bin.000001' from 4;
224
Log_name Pos Event_type Server_id End_log_pos Info
225
slave-bin.000001 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4
226
slave-bin.000001 # Query 1 # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
227
slave-bin.000001 # Query 1 # BEGIN
228
slave-bin.000001 # Table_map 1 # table_id: # (test.t1)
229
slave-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
230
slave-bin.000001 # Query 1 # COMMIT
231
slave-bin.000001 # Query 1 # use `test`; drop table t1
232
slave-bin.000001 # Query 1 # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
233
slave-bin.000001 # Query 1 # BEGIN
234
slave-bin.000001 # Table_map 1 # table_id: # (test.t1)
235
slave-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
236
slave-bin.000001 # Query 1 # COMMIT
237
slave-bin.000001 # Query 1 # use `test`; create table t3 (a int)ENGINE=MyISAM
238
slave-bin.000001 # Rotate 2 # slave-bin.000002;pos=4
239
show binlog events in 'slave-bin.000002' from 4;
240
Log_name Pos Event_type Server_id End_log_pos Info
241
slave-bin.000002 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4
242
slave-bin.000002 # Query 1 # use `test`; create table t2 (n int)ENGINE=MyISAM
243
slave-bin.000002 # Query 1 # BEGIN
244
slave-bin.000002 # Table_map 1 # table_id: # (test.t2)
245
slave-bin.000002 # Write_rows 1 # table_id: # flags: STMT_END_F
246
slave-bin.000002 # Query 1 # COMMIT
249
Master_Host 127.0.0.1
251
Master_Port MASTER_PORT
253
Master_Log_File master-bin.000002
254
Read_Master_Log_Pos 516
257
Relay_Master_Log_File master-bin.000002
259
Slave_SQL_Running Yes
263
Replicate_Ignore_Table #
264
Replicate_Wild_Do_Table
265
Replicate_Wild_Ignore_Table
269
Exec_Master_Log_Pos 516
274
Master_SSL_Allowed No
280
Seconds_Behind_Master #
281
Master_SSL_Verify_Server_Cert No
221
show binlog events from <binlog_start>;
222
Log_name Pos Event_type Server_id End_log_pos Info
223
slave-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
224
slave-bin.000001 # Query # # BEGIN
225
slave-bin.000001 # Table_map # # table_id: # (test.t1)
226
slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
227
slave-bin.000001 # Query # # COMMIT
228
slave-bin.000001 # Query # # use `test`; drop table t1
229
slave-bin.000001 # Query # # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
230
slave-bin.000001 # Query # # BEGIN
231
slave-bin.000001 # Table_map # # table_id: # (test.t1)
232
slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
233
slave-bin.000001 # Query # # COMMIT
234
slave-bin.000001 # Query # # use `test`; create table t3 (a int)ENGINE=MyISAM
235
slave-bin.000001 # Rotate # # slave-bin.000002;pos=4
236
show binlog events in 'slave-bin.000002' from <binlog_start>;
237
Log_name Pos Event_type Server_id End_log_pos Info
238
slave-bin.000002 # Query # # use `test`; create table t2 (n int)ENGINE=MyISAM
239
slave-bin.000002 # Query # # BEGIN
240
slave-bin.000002 # Table_map # # table_id: # (test.t2)
241
slave-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
242
slave-bin.000002 # Query # # COMMIT
243
Checking that both slave threads are running.
286
244
show binlog events in 'slave-bin.000005' from 4;
287
245
ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log