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 # Intvar 1 # INSERT_ID=1
24
master-bin.000001 # Query 1 # use `test`; insert into t1 values (NULL)
25
master-bin.000001 # Query 1 # use `test`; drop table t1
26
master-bin.000001 # Query 1 # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
27
master-bin.000001 # Begin_load_query 1 # ;file_id=1;block_len=581
28
master-bin.000001 # Execute_load_query 1 # use `test`; LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 1 LINES (`word`) ;file_id=1
29
show binlog events from 106 limit 1;
30
Log_name Pos Event_type Server_id End_log_pos Info
31
master-bin.000001 # Query 1 # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
32
show binlog events from 106 limit 2;
33
Log_name Pos Event_type Server_id End_log_pos Info
34
master-bin.000001 # Query 1 # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
35
master-bin.000001 # Intvar 1 # INSERT_ID=1
36
show binlog events from 106 limit 2,1;
37
Log_name Pos Event_type Server_id End_log_pos Info
38
master-bin.000001 # Query 1 # use `test`; insert into t1 values (NULL)
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 # Intvar # # INSERT_ID=1
23
master-bin.000001 # Query # # use `test`; insert into t1 values (NULL)
24
master-bin.000001 # Query # # use `test`; drop table t1
25
master-bin.000001 # Query # # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
26
master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=#
27
master-bin.000001 # Execute_load_query # # use `test`; LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 1 LINES (`word`) ;file_id=#
28
show binlog events from <binlog_start> limit 1;
29
Log_name Pos Event_type Server_id End_log_pos Info
30
master-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
31
show binlog events from <binlog_start> limit 2;
32
Log_name Pos Event_type Server_id End_log_pos Info
33
master-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
34
master-bin.000001 # Intvar # # INSERT_ID=1
35
show binlog events from <binlog_start> limit 2,1;
36
Log_name Pos Event_type Server_id End_log_pos Info
37
master-bin.000001 # Query # # use `test`; insert into t1 values (NULL)
40
39
create table t3 (a int)ENGINE=MyISAM;
41
40
select * from t1 order by 1 asc;
195
194
master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=#
196
195
master-bin.000001 # Execute_load_query # # use `test`; LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 1 LINES (`word`) ;file_id=#
197
196
master-bin.000001 # Rotate # # master-bin.000002;pos=4
198
show binlog events in 'master-bin.000002';
197
show binlog events in 'master-bin.000002' from <binlog_start>;
199
198
Log_name Pos Event_type Server_id End_log_pos Info
200
master-bin.000002 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4
201
master-bin.000002 # Query 1 # use `test`; create table t3 (a int)ENGINE=MyISAM
202
master-bin.000002 # Query 1 # use `test`; create table t2 (n int)ENGINE=MyISAM
203
master-bin.000002 # Query 1 # use `test`; insert into t2 values (1)
199
master-bin.000002 # Query # # use `test`; create table t3 (a int)ENGINE=MyISAM
200
master-bin.000002 # Query # # use `test`; create table t2 (n int)ENGINE=MyISAM
201
master-bin.000002 # Query # # use `test`; insert into t2 values (1)
204
202
show binary logs;
205
203
Log_name File_size
206
204
master-bin.000001 #
209
207
Log_name File_size
210
208
slave-bin.000001 #
211
209
slave-bin.000002 #
212
show binlog events in 'slave-bin.000001' from 4;
213
Log_name Pos Event_type Server_id End_log_pos Info
214
slave-bin.000001 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4
215
slave-bin.000001 # Query 1 # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
216
slave-bin.000001 # Intvar 1 # INSERT_ID=1
217
slave-bin.000001 # Query 1 # use `test`; insert into t1 values (NULL)
218
slave-bin.000001 # Query 1 # use `test`; drop table t1
219
slave-bin.000001 # Query 1 # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
220
slave-bin.000001 # Begin_load_query 1 # ;file_id=1;block_len=581
221
slave-bin.000001 # Execute_load_query 1 # use `test`; LOAD DATA INFILE '../../tmp/SQL_LOAD-2-1-1.data' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 1 LINES (`word`) ;file_id=1
222
slave-bin.000001 # Query 1 # use `test`; create table t3 (a int)ENGINE=MyISAM
223
slave-bin.000001 # Rotate 2 # slave-bin.000002;pos=4
224
show binlog events in 'slave-bin.000002' from 4;
225
Log_name Pos Event_type Server_id End_log_pos Info
226
slave-bin.000002 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4
227
slave-bin.000002 # Query 1 # use `test`; create table t2 (n int)ENGINE=MyISAM
228
slave-bin.000002 # Query 1 # use `test`; insert into t2 values (1)
231
Master_Host 127.0.0.1
233
Master_Port MASTER_PORT
235
Master_Log_File master-bin.000002
236
Read_Master_Log_Pos 392
239
Relay_Master_Log_File master-bin.000002
241
Slave_SQL_Running Yes
245
Replicate_Ignore_Table #
246
Replicate_Wild_Do_Table
247
Replicate_Wild_Ignore_Table
251
Exec_Master_Log_Pos 392
256
Master_SSL_Allowed No
262
Seconds_Behind_Master #
263
Master_SSL_Verify_Server_Cert No
210
show binlog events from <binlog_start>;
211
Log_name Pos Event_type Server_id End_log_pos Info
212
slave-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
213
slave-bin.000001 # Intvar # # INSERT_ID=1
214
slave-bin.000001 # Query # # use `test`; insert into t1 values (NULL)
215
slave-bin.000001 # Query # # use `test`; drop table t1
216
slave-bin.000001 # Query # # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
217
slave-bin.000001 # Begin_load_query # # ;file_id=#;block_len=#
218
slave-bin.000001 # Execute_load_query # # use `test`; LOAD DATA INFILE '../../tmp/SQL_LOAD-2-1-1.data' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 1 LINES (`word`) ;file_id=#
219
slave-bin.000001 # Query # # use `test`; create table t3 (a int)ENGINE=MyISAM
220
slave-bin.000001 # Rotate # # slave-bin.000002;pos=4
221
show binlog events in 'slave-bin.000002' from <binlog_start>;
222
Log_name Pos Event_type Server_id End_log_pos Info
223
slave-bin.000002 # Query # # use `test`; create table t2 (n int)ENGINE=MyISAM
224
slave-bin.000002 # Query # # use `test`; insert into t2 values (1)
225
Checking that both slave threads are running.
268
226
show binlog events in 'slave-bin.000005' from 4;
269
227
ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log