[root@mysql5612 binlog_new]# /usr/local/mysql/bin/mysqlbinlog --base64-output=DECODE-ROWS -v mysql-bin.000002
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#151210 21:10:05 server id 72 end_log_pos 120 CRC32 0xa723f142 Start: binlog v 4, server v 5.6.12-log created 151210 21:10:05 at startup
# Warning: this binlog is either in use or was not closed properly.
ROLLBACK/*!*/;
# at 120
#151210 21:10:07 server id 72 end_log_pos 206 CRC32 0x447f5733 Query thread_id=1 exec_time=0 error_code=0
SET TIMESTAMP=1449753007/*!*/;
SET @@session.pseudo_thread_id=1/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=1075838976/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8mb4 *//*!*/;
SET @@session.character_set_client=45,@@session.collation_connection=45,@@session.collation_server=45/*!*/;
SET @@session.time_zone='SYSTEM'/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
BEGIN
/*!*/;
# at 206
#151210 21:10:07 server id 72 end_log_pos 274 CRC32 0xde0b7250 Table_map: `access_log`.`access_log` mapped to number 70
# at 274
#151210 21:10:07 server id 72 end_log_pos 368 CRC32 0xa03a9659 Write_rows: table id 70 flags: STMT_END_F
### INSERT INTO `access_log`.`access_log`
### SET
### @1=10534
### @2=1
### @3=1449753007
### @4='park_user@192.168.121.243'
### @5='park_user@192.168.%'
# at 368
#151210 21:10:07 server id 72 end_log_pos 399 CRC32 0x3ccf3c72 Xid = 3
COMMIT/*!*/;
# at 399
#151210 21:10:58 server id 72 end_log_pos 471 CRC32 0xef9ce950 Query thread_id=2 exec_time=0 error_code=0
SET TIMESTAMP=1449753058/*!*/;
BEGIN
/*!*/;
# at 471
#151210 21:10:58 server id 72 end_log_pos 593 CRC32 0x92e79f36 Query thread_id=2 exec_time=0 error_code=0
use `test`/*!*/;
SET TIMESTAMP=1449753058/*!*/;
CREATETABLE`z3` (
`a` int(1)NOTNULLDEFAULT'0'
)
/*!*/;
# at 593
#151210 21:10:58 server id 72 end_log_pos 638 CRC32 0x65f13b58 Table_map: `test`.`z3` mapped to number 107
# at 638
#151210 21:10:58 server id 72 end_log_pos 678 CRC32 0xaa7fb7e1 Write_rows: table id 107 flags: STMT_END_F
### INSERT INTO `test`.`z3`
### SET
### @1=3
# at 678
#151210 21:10:58 server id 72 end_log_pos 709 CRC32 0x218a319c Xid = 60
COMMIT/*!*/;
# at 709
#151210 21:11:04 server id 72 end_log_pos 781 CRC32 0x9662b95e Query thread_id=2 exec_time=0 error_code=0
SET TIMESTAMP=1449753064/*!*/;
BEGIN
/*!*/;
# at 781
#151210 21:11:04 server id 72 end_log_pos 826 CRC32 0x46f32822 Table_map: `test`.`z3` mapped to number 107
# at 826
#151210 21:11:04 server id 72 end_log_pos 866 CRC32 0xafb27f1e Write_rows: table id 107 flags: STMT_END_F
### INSERT INTO `test`.`z3`
### SET
### @1=4
# at 866
#151210 21:11:04 server id 72 end_log_pos 897 CRC32 0x351c7718 Xid = 63
COMMIT/*!*/;
# at 897
#151210 21:11:10 server id 72 end_log_pos 969 CRC32 0x76931e05 Query thread_id=2 exec_time=0 error_code=0
SET TIMESTAMP=1449753070/*!*/;
BEGIN
/*!*/;
# at 969
#151210 21:11:10 server id 72 end_log_pos 1014 CRC32 0xe7e8947b Table_map: `test`.`z3` mapped to number 107
# at 1014
#151210 21:11:10 server id 72 end_log_pos 1054 CRC32 0xbdafa096 Write_rows: table id 107 flags: STMT_END_F
### INSERT INTO `test`.`z3`
### SET
### @1=5
# at 1054
#151210 21:11:10 server id 72 end_log_pos 1085 CRC32 0x831695c0 Xid = 64
COMMIT/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
[root@mysql5612 binlog_new]#