diff options
4 files changed, 150 insertions, 137 deletions
diff --git a/mysql-test/extra/rpl_tests/rpl_show_relaylog_events.inc b/mysql-test/extra/rpl_tests/rpl_show_relaylog_events.inc index d32dd485e19..d230b743ae8 100644 --- a/mysql-test/extra/rpl_tests/rpl_show_relaylog_events.inc +++ b/mysql-test/extra/rpl_tests/rpl_show_relaylog_events.inc @@ -1,4 +1,7 @@ -- connection master +-- source include/rpl_reset.inc + +-- connection master CREATE TABLE t1 (a INT); INSERT INTO t1 VALUES (1); @@ -8,18 +11,19 @@ INSERT INTO t1 VALUES (4); INSERT INTO t1 VALUES (5); INSERT INTO t1 VALUES (6); --- echo [MASTER] ********* SOW BINLOG EVENTS IN ... ********* +-- echo [MASTER] ********* SHOW BINLOG EVENTS IN ... ********* +let $binlog_file= query_get_value(SHOW MASTER STATUS, File, 1); -- source include/show_binlog_events.inc --- echo [MASTER] ********* SOW BINLOG EVENTS ********* +-- echo [MASTER] ********* SHOW BINLOG EVENTS ********* let $binlog_file= ; -- source include/show_binlog_events.inc --- echo [MASTER] ********* SOW BINLOG EVENTS ... LIMIT rows ********* +-- echo [MASTER] ********* SHOW BINLOG EVENTS ... LIMIT rows ********* let $binlog_limit= 3; -- source include/show_binlog_events.inc --- echo [MASTER] ********* SOW BINLOG EVENTS ... LIMIT offset,rows ********* +-- echo [MASTER] ********* SHOW BINLOG EVENTS ... LIMIT offset,rows ********* let $binlog_limit= 1,4; -- source include/show_binlog_events.inc @@ -28,38 +32,39 @@ let $binlog_limit= ; -- sync_slave_with_master --- echo [SLAVE] ********* SOW BINLOG EVENTS IN ... ********* +-- echo [SLAVE] ********* SHOW BINLOG EVENTS IN ... ********* +let $binlog_file= query_get_value(SHOW MASTER STATUS, File, 1); -- source include/show_binlog_events.inc --- echo [SLAVE] ********* SOW BINLOG EVENTS ********* +-- echo [SLAVE] ********* SHOW BINLOG EVENTS ********* let $binlog_file= ; -- source include/show_binlog_events.inc --- echo [SLAVE] ********* SOW BINLOG EVENTS ... LIMIT rows ********* +-- echo [SLAVE] ********* SHOW BINLOG EVENTS ... LIMIT rows ********* let $binlog_limit= 3; -- source include/show_binlog_events.inc --- echo [SLAVE] ********* SOW BINLOG EVENTS ... LIMIT offset,rows ********* +-- echo [SLAVE] ********* SHOW BINLOG EVENTS ... LIMIT offset,rows ********* let $binlog_limit= 1,4; -- source include/show_binlog_events.inc # clear show_binlog_event/show_relaylog_events parameters let $binlog_limit= ; --- echo [SLAVE] ********* SOW RELAYLOG EVENTS IN ... ********* +-- echo [SLAVE] ********* SHOW RELAYLOG EVENTS IN ... ********* let $binlog_file= query_get_value(SHOW SLAVE STATUS, Relay_Log_File, 1); -- source include/show_relaylog_events.inc --- echo [SLAVE] ********* SOW RELAYLOG EVENTS ********* +-- echo [SLAVE] ********* SHOW RELAYLOG EVENTS ********* let $binlog_file= ; -- source include/show_relaylog_events.inc --- echo [MASTER] ********* SOW RELAYLOG EVENTS ... LIMIT rows ********* +-- echo [MASTER] ********* SHOW RELAYLOG EVENTS ... LIMIT rows ********* let $binlog_file= query_get_value(SHOW SLAVE STATUS, Relay_Log_File, 1); let $binlog_limit= 3; -- source include/show_relaylog_events.inc --- echo [MASTER] ********* SOW RELAYLOG EVENTS ... LIMIT offset,rows ********* +-- echo [MASTER] ********* SHOW RELAYLOG EVENTS ... LIMIT offset,rows ********* let $binlog_limit= 1,3; -- source include/show_relaylog_events.inc @@ -74,28 +79,29 @@ DROP TABLE t1; let $binlog_file= ; let $binlog_limit= ; --- echo [MASTER] ********* SOW BINLOG EVENTS IN ... ********* +-- echo [MASTER] ********* SHOW BINLOG EVENTS IN ... ********* let $binlog_file= query_get_value(SHOW MASTER STATUS, File, 1); -- source include/show_binlog_events.inc --- echo [MASTER] ********* SOW BINLOG EVENTS ********* +-- echo [MASTER] ********* SHOW BINLOG EVENTS ********* let $binlog_file= ; -- source include/show_binlog_events.inc -- sync_slave_with_master --- echo [SLAVE] ********* SOW BINLOG EVENTS IN ... ********* +-- echo [SLAVE] ********* SHOW BINLOG EVENTS IN ... ********* let $binlog_file= query_get_value(SHOW MASTER STATUS, File, 1); -- source include/show_binlog_events.inc --- echo [SLAVE] ********* SOW BINLOG EVENTS ********* +-- echo [SLAVE] ********* SHOW BINLOG EVENTS ********* let $binlog_file= ; -- source include/show_binlog_events.inc --- echo [SLAVE] ********* SOW RELAYLOG EVENTS IN ... ********* +-- echo [SLAVE] ********* SHOW RELAYLOG EVENTS IN ... ********* +let $binlog_file= query_get_value(SHOW SLAVE STATUS, Relay_Log_File, 1); -- source include/show_relaylog_events.inc --- echo [SLAVE] ********* SOW RELAYLOG EVENTS ********* +-- echo [SLAVE] ********* SHOW RELAYLOG EVENTS ********* let $binlog_file= ; -- source include/show_relaylog_events.inc diff --git a/mysql-test/include/setup_fake_relay_log.inc b/mysql-test/include/setup_fake_relay_log.inc index da3ce8e6038..4f1d4f6f162 100644 --- a/mysql-test/include/setup_fake_relay_log.inc +++ b/mysql-test/include/setup_fake_relay_log.inc @@ -74,6 +74,7 @@ let $_fake_relay_index= $_fake_datadir/$_fake_filename.index; let $_fake_relay_log_purge= `SELECT @@global.relay_log_purge`; RESET SLAVE; +let $_orphan_relay_file= query_get_value(SHOW SLAVE STATUS, Relay_Log_File, 1); # Create relay log file. --copy_file $fake_relay_log $_fake_relay_log @@ -102,6 +103,8 @@ RESET SLAVE; # Setup replication from existing relay log. eval CHANGE MASTER TO MASTER_HOST='dummy.localdomain', RELAY_LOG_FILE='$_fake_filename-fake.000001', RELAY_LOG_POS=4; +# remove the orphan log file (became spurious) +-- remove_file $_fake_datadir/$_orphan_relay_file --let $include_filename= setup_fake_relay_log.inc --source include/end_include_file.inc diff --git a/mysql-test/suite/rpl/r/rpl_row_show_relaylog_events.result b/mysql-test/suite/rpl/r/rpl_row_show_relaylog_events.result index 71d1ca9a928..3ec148b9e62 100644 --- a/mysql-test/suite/rpl/r/rpl_row_show_relaylog_events.result +++ b/mysql-test/suite/rpl/r/rpl_row_show_relaylog_events.result @@ -1,5 +1,6 @@ include/master-slave.inc [connection master] +include/rpl_reset.inc CREATE TABLE t1 (a INT); INSERT INTO t1 VALUES (1); INSERT INTO t1 VALUES (2); @@ -7,8 +8,8 @@ INSERT INTO t1 VALUES (3); INSERT INTO t1 VALUES (4); INSERT INTO t1 VALUES (5); INSERT INTO t1 VALUES (6); -[MASTER] ********* SOW BINLOG EVENTS IN ... ********* -show binlog events from <binlog_start>; +[MASTER] ********* SHOW BINLOG EVENTS IN ... ********* +show binlog events in 'master-bin.000001' from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) master-bin.000001 # Query # # BEGIN @@ -35,7 +36,7 @@ master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.t1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -[MASTER] ********* SOW BINLOG EVENTS ********* +[MASTER] ********* SHOW BINLOG EVENTS ********* show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) @@ -63,21 +64,21 @@ master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.t1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -[MASTER] ********* SOW BINLOG EVENTS ... LIMIT rows ********* +[MASTER] ********* SHOW BINLOG EVENTS ... LIMIT rows ********* show binlog events from <binlog_start> limit 3; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.t1) -[MASTER] ********* SOW BINLOG EVENTS ... LIMIT offset,rows ********* +[MASTER] ********* SHOW BINLOG EVENTS ... LIMIT offset,rows ********* show binlog events from <binlog_start> limit 1,4; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.t1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -[SLAVE] ********* SOW BINLOG EVENTS IN ... ********* -show binlog events from <binlog_start>; +[SLAVE] ********* SHOW BINLOG EVENTS IN ... ********* +show binlog events in 'slave-bin.000001' from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) slave-bin.000001 # Query # # BEGIN @@ -104,7 +105,7 @@ slave-bin.000001 # Query # # BEGIN slave-bin.000001 # Table_map # # table_id: # (test.t1) slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F slave-bin.000001 # Query # # COMMIT -[SLAVE] ********* SOW BINLOG EVENTS ********* +[SLAVE] ********* SHOW BINLOG EVENTS ********* show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) @@ -132,73 +133,73 @@ slave-bin.000001 # Query # # BEGIN slave-bin.000001 # Table_map # # table_id: # (test.t1) slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F slave-bin.000001 # Query # # COMMIT -[SLAVE] ********* SOW BINLOG EVENTS ... LIMIT rows ********* +[SLAVE] ********* SHOW BINLOG EVENTS ... LIMIT rows ********* show binlog events from <binlog_start> limit 3; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) slave-bin.000001 # Query # # BEGIN slave-bin.000001 # Table_map # # table_id: # (test.t1) -[SLAVE] ********* SOW BINLOG EVENTS ... LIMIT offset,rows ********* +[SLAVE] ********* SHOW BINLOG EVENTS ... LIMIT offset,rows ********* show binlog events from <binlog_start> limit 1,4; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 # Query # # BEGIN slave-bin.000001 # Table_map # # table_id: # (test.t1) slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F slave-bin.000001 # Query # # COMMIT -[SLAVE] ********* SOW RELAYLOG EVENTS IN ... ********* -show relaylog events in 'slave-relay-bin.000002' from <binlog_start>; +[SLAVE] ********* SHOW RELAYLOG EVENTS IN ... ********* +show relaylog events in 'slave-relay-bin.000003' from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info -slave-relay-bin.000002 # Rotate # # master-bin.000001;pos=4 -slave-relay-bin.000002 # Format_desc # # SERVER_VERSION, BINLOG_VERSION -slave-relay-bin.000002 # Query # # use `test`; CREATE TABLE t1 (a INT) -slave-relay-bin.000002 # Query # # BEGIN -slave-relay-bin.000002 # Table_map # # table_id: # (test.t1) -slave-relay-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F -slave-relay-bin.000002 # Query # # COMMIT -slave-relay-bin.000002 # Query # # BEGIN -slave-relay-bin.000002 # Table_map # # table_id: # (test.t1) -slave-relay-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F -slave-relay-bin.000002 # Query # # COMMIT -slave-relay-bin.000002 # Query # # BEGIN -slave-relay-bin.000002 # Table_map # # table_id: # (test.t1) -slave-relay-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F -slave-relay-bin.000002 # Query # # COMMIT -slave-relay-bin.000002 # Query # # BEGIN -slave-relay-bin.000002 # Table_map # # table_id: # (test.t1) -slave-relay-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F -slave-relay-bin.000002 # Query # # COMMIT -slave-relay-bin.000002 # Query # # BEGIN -slave-relay-bin.000002 # Table_map # # table_id: # (test.t1) -slave-relay-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F -slave-relay-bin.000002 # Query # # COMMIT -slave-relay-bin.000002 # Query # # BEGIN -slave-relay-bin.000002 # Table_map # # table_id: # (test.t1) -slave-relay-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F -slave-relay-bin.000002 # Query # # COMMIT -[SLAVE] ********* SOW RELAYLOG EVENTS ********* +slave-relay-bin.000003 # Rotate # # master-bin.000001;pos=4 +slave-relay-bin.000003 # Format_desc # # SERVER_VERSION, BINLOG_VERSION +slave-relay-bin.000003 # Query # # use `test`; CREATE TABLE t1 (a INT) +slave-relay-bin.000003 # Query # # BEGIN +slave-relay-bin.000003 # Table_map # # table_id: # (test.t1) +slave-relay-bin.000003 # Write_rows # # table_id: # flags: STMT_END_F +slave-relay-bin.000003 # Query # # COMMIT +slave-relay-bin.000003 # Query # # BEGIN +slave-relay-bin.000003 # Table_map # # table_id: # (test.t1) +slave-relay-bin.000003 # Write_rows # # table_id: # flags: STMT_END_F +slave-relay-bin.000003 # Query # # COMMIT +slave-relay-bin.000003 # Query # # BEGIN +slave-relay-bin.000003 # Table_map # # table_id: # (test.t1) +slave-relay-bin.000003 # Write_rows # # table_id: # flags: STMT_END_F +slave-relay-bin.000003 # Query # # COMMIT +slave-relay-bin.000003 # Query # # BEGIN +slave-relay-bin.000003 # Table_map # # table_id: # (test.t1) +slave-relay-bin.000003 # Write_rows # # table_id: # flags: STMT_END_F +slave-relay-bin.000003 # Query # # COMMIT +slave-relay-bin.000003 # Query # # BEGIN +slave-relay-bin.000003 # Table_map # # table_id: # (test.t1) +slave-relay-bin.000003 # Write_rows # # table_id: # flags: STMT_END_F +slave-relay-bin.000003 # Query # # COMMIT +slave-relay-bin.000003 # Query # # BEGIN +slave-relay-bin.000003 # Table_map # # table_id: # (test.t1) +slave-relay-bin.000003 # Write_rows # # table_id: # flags: STMT_END_F +slave-relay-bin.000003 # Query # # COMMIT +[SLAVE] ********* SHOW RELAYLOG EVENTS ********* show relaylog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info -slave-relay-bin.000001 # Rotate # # slave-relay-bin.000002;pos=4 -[MASTER] ********* SOW RELAYLOG EVENTS ... LIMIT rows ********* -show relaylog events in 'slave-relay-bin.000002' from <binlog_start> limit 3; +slave-relay-bin.000002 # Rotate # # slave-relay-bin.000003;pos=4 +[MASTER] ********* SHOW RELAYLOG EVENTS ... LIMIT rows ********* +show relaylog events in 'slave-relay-bin.000003' from <binlog_start> limit 3; Log_name Pos Event_type Server_id End_log_pos Info -slave-relay-bin.000002 # Rotate # # master-bin.000001;pos=4 -slave-relay-bin.000002 # Format_desc # # SERVER_VERSION, BINLOG_VERSION -slave-relay-bin.000002 # Query # # use `test`; CREATE TABLE t1 (a INT) -[MASTER] ********* SOW RELAYLOG EVENTS ... LIMIT offset,rows ********* -show relaylog events in 'slave-relay-bin.000002' from <binlog_start> limit 1,3; +slave-relay-bin.000003 # Rotate # # master-bin.000001;pos=4 +slave-relay-bin.000003 # Format_desc # # SERVER_VERSION, BINLOG_VERSION +slave-relay-bin.000003 # Query # # use `test`; CREATE TABLE t1 (a INT) +[MASTER] ********* SHOW RELAYLOG EVENTS ... LIMIT offset,rows ********* +show relaylog events in 'slave-relay-bin.000003' from <binlog_start> limit 1,3; Log_name Pos Event_type Server_id End_log_pos Info -slave-relay-bin.000002 # Format_desc # # SERVER_VERSION, BINLOG_VERSION -slave-relay-bin.000002 # Query # # use `test`; CREATE TABLE t1 (a INT) -slave-relay-bin.000002 # Query # # BEGIN +slave-relay-bin.000003 # Format_desc # # SERVER_VERSION, BINLOG_VERSION +slave-relay-bin.000003 # Query # # use `test`; CREATE TABLE t1 (a INT) +slave-relay-bin.000003 # Query # # BEGIN FLUSH LOGS; FLUSH LOGS; DROP TABLE t1; -[MASTER] ********* SOW BINLOG EVENTS IN ... ********* +[MASTER] ********* SHOW BINLOG EVENTS IN ... ********* show binlog events in 'master-bin.000002' from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000002 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ -[MASTER] ********* SOW BINLOG EVENTS ********* +[MASTER] ********* SHOW BINLOG EVENTS ********* show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) @@ -227,11 +228,11 @@ master-bin.000001 # Table_map # # table_id: # (test.t1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT master-bin.000001 # Rotate # # master-bin.000002;pos=4 -[SLAVE] ********* SOW BINLOG EVENTS IN ... ********* +[SLAVE] ********* SHOW BINLOG EVENTS IN ... ********* show binlog events in 'slave-bin.000002' from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000002 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ -[SLAVE] ********* SOW BINLOG EVENTS ********* +[SLAVE] ********* SHOW BINLOG EVENTS ********* show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) @@ -260,14 +261,15 @@ slave-bin.000001 # Table_map # # table_id: # (test.t1) slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F slave-bin.000001 # Query # # COMMIT slave-bin.000001 # Rotate # # slave-bin.000002;pos=4 -[SLAVE] ********* SOW RELAYLOG EVENTS IN ... ********* -show relaylog events from <binlog_start>; +[SLAVE] ********* SHOW RELAYLOG EVENTS IN ... ********* +show relaylog events in 'slave-relay-bin.000006' from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info -slave-relay-bin.000004 # Rotate # # master-bin.000002;pos=4 -slave-relay-bin.000004 # Rotate # # slave-relay-bin.000005;pos=4 -[SLAVE] ********* SOW RELAYLOG EVENTS ********* +slave-relay-bin.000006 # Rotate # # master-bin.000002;pos=4 +slave-relay-bin.000006 # Format_desc # # SERVER_VERSION, BINLOG_VERSION +slave-relay-bin.000006 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ +[SLAVE] ********* SHOW RELAYLOG EVENTS ********* show relaylog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info -slave-relay-bin.000004 # Rotate # # master-bin.000002;pos=4 -slave-relay-bin.000004 # Rotate # # slave-relay-bin.000005;pos=4 +slave-relay-bin.000005 # Rotate # # master-bin.000002;pos=4 +slave-relay-bin.000005 # Rotate # # slave-relay-bin.000006;pos=4 include/rpl_end.inc diff --git a/mysql-test/suite/rpl/r/rpl_stm_mix_show_relaylog_events.result b/mysql-test/suite/rpl/r/rpl_stm_mix_show_relaylog_events.result index 0e34c0dfb19..c18c507aa0a 100644 --- a/mysql-test/suite/rpl/r/rpl_stm_mix_show_relaylog_events.result +++ b/mysql-test/suite/rpl/r/rpl_stm_mix_show_relaylog_events.result @@ -1,5 +1,6 @@ include/master-slave.inc [connection master] +include/rpl_reset.inc CREATE TABLE t1 (a INT); INSERT INTO t1 VALUES (1); INSERT INTO t1 VALUES (2); @@ -7,8 +8,8 @@ INSERT INTO t1 VALUES (3); INSERT INTO t1 VALUES (4); INSERT INTO t1 VALUES (5); INSERT INTO t1 VALUES (6); -[MASTER] ********* SOW BINLOG EVENTS IN ... ********* -show binlog events from <binlog_start>; +[MASTER] ********* SHOW BINLOG EVENTS IN ... ********* +show binlog events in 'master-bin.000001' from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) master-bin.000001 # Query # # BEGIN @@ -29,7 +30,7 @@ master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (6) master-bin.000001 # Query # # COMMIT -[MASTER] ********* SOW BINLOG EVENTS ********* +[MASTER] ********* SHOW BINLOG EVENTS ********* show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) @@ -51,21 +52,21 @@ master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (6) master-bin.000001 # Query # # COMMIT -[MASTER] ********* SOW BINLOG EVENTS ... LIMIT rows ********* +[MASTER] ********* SHOW BINLOG EVENTS ... LIMIT rows ********* show binlog events from <binlog_start> limit 3; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1) -[MASTER] ********* SOW BINLOG EVENTS ... LIMIT offset,rows ********* +[MASTER] ********* SHOW BINLOG EVENTS ... LIMIT offset,rows ********* show binlog events from <binlog_start> limit 1,4; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN -[SLAVE] ********* SOW BINLOG EVENTS IN ... ********* -show binlog events from <binlog_start>; +[SLAVE] ********* SHOW BINLOG EVENTS IN ... ********* +show binlog events in 'slave-bin.000001' from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) slave-bin.000001 # Query # # BEGIN @@ -86,7 +87,7 @@ slave-bin.000001 # Query # # COMMIT slave-bin.000001 # Query # # BEGIN slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (6) slave-bin.000001 # Query # # COMMIT -[SLAVE] ********* SOW BINLOG EVENTS ********* +[SLAVE] ********* SHOW BINLOG EVENTS ********* show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) @@ -108,67 +109,67 @@ slave-bin.000001 # Query # # COMMIT slave-bin.000001 # Query # # BEGIN slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (6) slave-bin.000001 # Query # # COMMIT -[SLAVE] ********* SOW BINLOG EVENTS ... LIMIT rows ********* +[SLAVE] ********* SHOW BINLOG EVENTS ... LIMIT rows ********* show binlog events from <binlog_start> limit 3; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) slave-bin.000001 # Query # # BEGIN slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1) -[SLAVE] ********* SOW BINLOG EVENTS ... LIMIT offset,rows ********* +[SLAVE] ********* SHOW BINLOG EVENTS ... LIMIT offset,rows ********* show binlog events from <binlog_start> limit 1,4; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 # Query # # BEGIN slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1) slave-bin.000001 # Query # # COMMIT slave-bin.000001 # Query # # BEGIN -[SLAVE] ********* SOW RELAYLOG EVENTS IN ... ********* -show relaylog events in 'slave-relay-bin.000002' from <binlog_start>; -Log_name Pos Event_type Server_id End_log_pos Info -slave-relay-bin.000002 # Rotate # # master-bin.000001;pos=4 -slave-relay-bin.000002 # Format_desc # # SERVER_VERSION, BINLOG_VERSION -slave-relay-bin.000002 # Query # # use `test`; CREATE TABLE t1 (a INT) -slave-relay-bin.000002 # Query # # BEGIN -slave-relay-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (1) -slave-relay-bin.000002 # Query # # COMMIT -slave-relay-bin.000002 # Query # # BEGIN -slave-relay-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (2) -slave-relay-bin.000002 # Query # # COMMIT -slave-relay-bin.000002 # Query # # BEGIN -slave-relay-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (3) -slave-relay-bin.000002 # Query # # COMMIT -slave-relay-bin.000002 # Query # # BEGIN -slave-relay-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (4) -slave-relay-bin.000002 # Query # # COMMIT -slave-relay-bin.000002 # Query # # BEGIN -slave-relay-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (5) -slave-relay-bin.000002 # Query # # COMMIT -slave-relay-bin.000002 # Query # # BEGIN -slave-relay-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (6) -slave-relay-bin.000002 # Query # # COMMIT -[SLAVE] ********* SOW RELAYLOG EVENTS ********* +[SLAVE] ********* SHOW RELAYLOG EVENTS IN ... ********* +show relaylog events in 'slave-relay-bin.000003' from <binlog_start>; +Log_name Pos Event_type Server_id End_log_pos Info +slave-relay-bin.000003 # Rotate # # master-bin.000001;pos=4 +slave-relay-bin.000003 # Format_desc # # SERVER_VERSION, BINLOG_VERSION +slave-relay-bin.000003 # Query # # use `test`; CREATE TABLE t1 (a INT) +slave-relay-bin.000003 # Query # # BEGIN +slave-relay-bin.000003 # Query # # use `test`; INSERT INTO t1 VALUES (1) +slave-relay-bin.000003 # Query # # COMMIT +slave-relay-bin.000003 # Query # # BEGIN +slave-relay-bin.000003 # Query # # use `test`; INSERT INTO t1 VALUES (2) +slave-relay-bin.000003 # Query # # COMMIT +slave-relay-bin.000003 # Query # # BEGIN +slave-relay-bin.000003 # Query # # use `test`; INSERT INTO t1 VALUES (3) +slave-relay-bin.000003 # Query # # COMMIT +slave-relay-bin.000003 # Query # # BEGIN +slave-relay-bin.000003 # Query # # use `test`; INSERT INTO t1 VALUES (4) +slave-relay-bin.000003 # Query # # COMMIT +slave-relay-bin.000003 # Query # # BEGIN +slave-relay-bin.000003 # Query # # use `test`; INSERT INTO t1 VALUES (5) +slave-relay-bin.000003 # Query # # COMMIT +slave-relay-bin.000003 # Query # # BEGIN +slave-relay-bin.000003 # Query # # use `test`; INSERT INTO t1 VALUES (6) +slave-relay-bin.000003 # Query # # COMMIT +[SLAVE] ********* SHOW RELAYLOG EVENTS ********* show relaylog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info -slave-relay-bin.000001 # Rotate # # slave-relay-bin.000002;pos=4 -[MASTER] ********* SOW RELAYLOG EVENTS ... LIMIT rows ********* -show relaylog events in 'slave-relay-bin.000002' from <binlog_start> limit 3; +slave-relay-bin.000002 # Rotate # # slave-relay-bin.000003;pos=4 +[MASTER] ********* SHOW RELAYLOG EVENTS ... LIMIT rows ********* +show relaylog events in 'slave-relay-bin.000003' from <binlog_start> limit 3; Log_name Pos Event_type Server_id End_log_pos Info -slave-relay-bin.000002 # Rotate # # master-bin.000001;pos=4 -slave-relay-bin.000002 # Format_desc # # SERVER_VERSION, BINLOG_VERSION -slave-relay-bin.000002 # Query # # use `test`; CREATE TABLE t1 (a INT) -[MASTER] ********* SOW RELAYLOG EVENTS ... LIMIT offset,rows ********* -show relaylog events in 'slave-relay-bin.000002' from <binlog_start> limit 1,3; +slave-relay-bin.000003 # Rotate # # master-bin.000001;pos=4 +slave-relay-bin.000003 # Format_desc # # SERVER_VERSION, BINLOG_VERSION +slave-relay-bin.000003 # Query # # use `test`; CREATE TABLE t1 (a INT) +[MASTER] ********* SHOW RELAYLOG EVENTS ... LIMIT offset,rows ********* +show relaylog events in 'slave-relay-bin.000003' from <binlog_start> limit 1,3; Log_name Pos Event_type Server_id End_log_pos Info -slave-relay-bin.000002 # Format_desc # # SERVER_VERSION, BINLOG_VERSION -slave-relay-bin.000002 # Query # # use `test`; CREATE TABLE t1 (a INT) -slave-relay-bin.000002 # Query # # BEGIN +slave-relay-bin.000003 # Format_desc # # SERVER_VERSION, BINLOG_VERSION +slave-relay-bin.000003 # Query # # use `test`; CREATE TABLE t1 (a INT) +slave-relay-bin.000003 # Query # # BEGIN FLUSH LOGS; FLUSH LOGS; DROP TABLE t1; -[MASTER] ********* SOW BINLOG EVENTS IN ... ********* +[MASTER] ********* SHOW BINLOG EVENTS IN ... ********* show binlog events in 'master-bin.000002' from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000002 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ -[MASTER] ********* SOW BINLOG EVENTS ********* +[MASTER] ********* SHOW BINLOG EVENTS ********* show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) @@ -191,11 +192,11 @@ master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (6) master-bin.000001 # Query # # COMMIT master-bin.000001 # Rotate # # master-bin.000002;pos=4 -[SLAVE] ********* SOW BINLOG EVENTS IN ... ********* +[SLAVE] ********* SHOW BINLOG EVENTS IN ... ********* show binlog events in 'slave-bin.000002' from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000002 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ -[SLAVE] ********* SOW BINLOG EVENTS ********* +[SLAVE] ********* SHOW BINLOG EVENTS ********* show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) @@ -218,14 +219,15 @@ slave-bin.000001 # Query # # BEGIN slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (6) slave-bin.000001 # Query # # COMMIT slave-bin.000001 # Rotate # # slave-bin.000002;pos=4 -[SLAVE] ********* SOW RELAYLOG EVENTS IN ... ********* -show relaylog events from <binlog_start>; +[SLAVE] ********* SHOW RELAYLOG EVENTS IN ... ********* +show relaylog events in 'slave-relay-bin.000006' from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info -slave-relay-bin.000004 # Rotate # # master-bin.000002;pos=4 -slave-relay-bin.000004 # Rotate # # slave-relay-bin.000005;pos=4 -[SLAVE] ********* SOW RELAYLOG EVENTS ********* +slave-relay-bin.000006 # Rotate # # master-bin.000002;pos=4 +slave-relay-bin.000006 # Format_desc # # SERVER_VERSION, BINLOG_VERSION +slave-relay-bin.000006 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ +[SLAVE] ********* SHOW RELAYLOG EVENTS ********* show relaylog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info -slave-relay-bin.000004 # Rotate # # master-bin.000002;pos=4 -slave-relay-bin.000004 # Rotate # # slave-relay-bin.000005;pos=4 +slave-relay-bin.000005 # Rotate # # master-bin.000002;pos=4 +slave-relay-bin.000005 # Rotate # # slave-relay-bin.000006;pos=4 include/rpl_end.inc |