[root@ovaistariq-test node1]# mysqlbinlog data/mysql_sandbox23390-relay-bin.000008
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#131115 10:42:18 server id 101 end_log_pos 107 Start: binlog v 4, server v 5.5.34-rel32.0-log created 131115 10:42:18
BINLOG '
euyFUg9lAAAAZwAAAGsAAAAAAAQANS41LjM0LXJlbDMyLjAtbG9nAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA==
'/*!*/;
# at 107
#700101 1:00:00 server id 1 end_log_pos 0 Rotate to mysql-bin.000004 pos: 4
# at 150
#131115 17:37:14 server id 1 end_log_pos 107 Start: binlog v 4, server v 5.5.34-rel32.0-log created 131115 17:37:14 at startup
ROLLBACK/*!*/;
BINLOG '
uk2GUg8BAAAAZwAAAGsAAAAAAAQANS41LjM0LXJlbDMyLjAtbG9nAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAC6TYZSEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA==
'/*!*/;
# at 253
#131115 17:37:40 server id 1 end_log_pos 197 Query thread_id=2 exec_time=0 error_code=0
use test/*!*/;
SET TIMESTAMP=1384533460/*!*/;
SET @@session.pseudo_thread_id=2/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=0/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8 *//*!*/;
SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=8/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
truncate table log_messages
/*!*/;
# at 343
#131115 17:39:29 server id 1 end_log_pos 273 Query thread_id=3 exec_time=0 error_code=0
SET TIMESTAMP=1384533569/*!*/;
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
SET @@session.time_zone='SYSTEM'/*!*/;
BEGIN
/*!*/;
# at 419
#131115 17:39:29 server id 1 end_log_pos 658 Query thread_id=3 exec_time=0 error_code=0
SET TIMESTAMP=1384533569/*!*/;
INSERT INTO test.log_messages (time_stamp, message, url, hash) VALUES(CURRENT_TIMESTAMP, 'test_msg_1', 'test_url_1', '0bee89b07a248e27c83fc3d5951213c1');INSERT DELAYED INTO test.log_messages (time_stamp, message, url, hash) VALUES(CURRENT_TIMESTAMP, 'test_msg_2', 'test_url_2', 'b6273b589df2dfdbd8fe35b1011e3183')
/*!*/;
# at 804
#131115 17:39:29 server id 1 end_log_pos 735 Query thread_id=3 exec_time=0 error_code=0
SET TIMESTAMP=1384533569/*!*/;
COMMIT
/*!*/;
# at 881
#131115 17:39:29 server id 1 end_log_pos 811 Query thread_id=3 exec_time=0 error_code=0
SET TIMESTAMP=1384533569/*!*/;
BEGIN
/*!*/;
# at 957
#131115 17:39:29 server id 1 end_log_pos 1035 Query thread_id=3 exec_time=0 error_code=0
SET TIMESTAMP=1384533569/*!*/;
INSERT INTO test.log_messages (time_stamp, message, url, hash) VALUES(CURRENT_TIMESTAMP, 'test_msg_2', 'test_url_2', 'b6273b589df2dfdbd8fe35b1011e3183')
/*!*/;
# at 1181
#131115 17:39:29 server id 1 end_log_pos 1112 Query thread_id=3 exec_time=0 error_code=0
SET TIMESTAMP=1384533569/*!*/;
COMMIT
/*!*/;
# at 1258
#131115 17:45:08 server id 101 end_log_pos 1277 Stop
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
Relay log generated on the slave:
[root@ovaistari q-test node1]# mysqlbinlog data/mysql_ sandbox23390- relay-bin. 000008 max_insert_ delayed_ threads= 0*/; _TYPE=@ @COMPLETION_ TYPE,COMPLETION _TYPE=0* /; AAGsAAAAAAAQANS 41LjM0LXJlbDMyL jAtbG9nAAAAAAAA AAAAAAAAAAAAAAA A AAAAAAAAAEzgNAA gAEgAEBAQEEgAAV AAEGggAAAAICAgC AA== AAGsAAAAAAAQANS 41LjM0LXJlbDMyL jAtbG9nAAAAAAAA AAAAAAAAAAAAAAA A AAAC6TYZSEzgNAA gAEgAEBAQEEgAAV AAEGggAAAAICAgC AA== 1384533460/ *!*/; pseudo_ thread_ id=2/*! */; foreign_ key_checks= 1, @@session. sql_auto_ is_null= 0, @@session. unique_ checks= 1, @@session. autocommit= 1/*!*/; sql_mode= 0/*!*/; auto_increment_ increment= 1, @@session. auto_increment_ offset= 1/*!*/; character_ set_client= 33,@@session. collation_ connection= 33,@@session. collation_ server= 8/*!*/; lc_time_ names=0/ *!*/; collation_ database= DEFAULT/ *!*/; 1384533569/ *!*/; character_ set_client= 8,@@session. collation_ connection= 8,@@session. collation_ server= 8/*!*/; time_zone= 'SYSTEM' /*!*/; 1384533569/ *!*/; CURRENT_ TIMESTAMP, 'test_msg_1', 'test_url_1', '0bee89b07a248e 27c83fc3d595121 3c1');INSERT DELAYED INTO test.log_messages (time_stamp, message, url, hash) VALUES( CURRENT_ TIMESTAMP, 'test_msg_2', 'test_url_2', 'b6273b589df2df dbd8fe35b1011e3 183') 1384533569/ *!*/; 1384533569/ *!*/; 1384533569/ *!*/; CURRENT_ TIMESTAMP, 'test_msg_2', 'test_url_2', 'b6273b589df2df dbd8fe35b1011e3 183') 1384533569/ *!*/; TYPE=@OLD_ COMPLETION_ TYPE*/;
/*!40019 SET @@session.
/*!50003 SET @OLD_COMPLETION
DELIMITER /*!*/;
# at 4
#131115 10:42:18 server id 101 end_log_pos 107 Start: binlog v 4, server v 5.5.34-rel32.0-log created 131115 10:42:18
BINLOG '
euyFUg9lAAAAZwA
AAAAAAAAAAAAAAA
'/*!*/;
# at 107
#700101 1:00:00 server id 1 end_log_pos 0 Rotate to mysql-bin.000004 pos: 4
# at 150
#131115 17:37:14 server id 1 end_log_pos 107 Start: binlog v 4, server v 5.5.34-rel32.0-log created 131115 17:37:14 at startup
ROLLBACK/*!*/;
BINLOG '
uk2GUg8BAAAAZwA
AAAAAAAAAAAAAAA
'/*!*/;
# at 253
#131115 17:37:40 server id 1 end_log_pos 197 Query thread_id=2 exec_time=0 error_code=0
use test/*!*/;
SET TIMESTAMP=
SET @@session.
SET @@session.
SET @@session.
SET @@session.
/*!\C utf8 *//*!*/;
SET @@session.
SET @@session.
SET @@session.
truncate table log_messages
/*!*/;
# at 343
#131115 17:39:29 server id 1 end_log_pos 273 Query thread_id=3 exec_time=0 error_code=0
SET TIMESTAMP=
/*!\C latin1 *//*!*/;
SET @@session.
SET @@session.
BEGIN
/*!*/;
# at 419
#131115 17:39:29 server id 1 end_log_pos 658 Query thread_id=3 exec_time=0 error_code=0
SET TIMESTAMP=
INSERT INTO test.log_messages (time_stamp, message, url, hash) VALUES(
/*!*/;
# at 804
#131115 17:39:29 server id 1 end_log_pos 735 Query thread_id=3 exec_time=0 error_code=0
SET TIMESTAMP=
COMMIT
/*!*/;
# at 881
#131115 17:39:29 server id 1 end_log_pos 811 Query thread_id=3 exec_time=0 error_code=0
SET TIMESTAMP=
BEGIN
/*!*/;
# at 957
#131115 17:39:29 server id 1 end_log_pos 1035 Query thread_id=3 exec_time=0 error_code=0
SET TIMESTAMP=
INSERT INTO test.log_messages (time_stamp, message, url, hash) VALUES(
/*!*/;
# at 1181
#131115 17:39:29 server id 1 end_log_pos 1112 Query thread_id=3 exec_time=0 error_code=0
SET TIMESTAMP=
COMMIT
/*!*/;
# at 1258
#131115 17:45:08 server id 101 end_log_pos 1277 Stop
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_