SET TIMESTAMP=1437102374/*!*/;
insertinto t6 value(3)
/*!*/;
# at 821
#150717 11:06:14 server id 1 end_log_pos 852 CRC32 0x6eccabd7 Xid = 75158
COMMIT/*!*/;
# at 852
#150717 11:06:36 server id 1 end_log_pos 933 CRC32 0x1d97f072 Query thread_id=24910 exec_time=0 error_code=0
SET TIMESTAMP=1437102396/*!*/;
BEGIN
/*!*/;
# at 933
#150717 11:06:36 server id 1 end_log_pos 1034 CRC32 0xca5d7197 Query thread_id=24910 exec_time=0 error_code=0
SET TIMESTAMP=1437102396/*!*/;
deletefrom t6 where id=3
/*!*/;
# at 1034
#150717 11:06:36 server id 1 end_log_pos 1065 CRC32 0xc36e2552 Xid = 75159
COMMIT/*!*/;
# at 1065
#150717 11:21:20 server id 1 end_log_pos 1166 CRC32 0x937167ae Query thread_id=24910 exec_time=0 error_code=0
use `jiaowu`/*!*/;
SET TIMESTAMP=1437103280/*!*/;
createtable t7(id int)
/*!*/;
# at 1166
#150717 11:22:03 server id 1 end_log_pos 1261 CRC32 0xb31be6d1 Query thread_id=24910 exec_time=0 error_code=0
SET TIMESTAMP=1437103323/*!*/;
truncatetable t7
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SETCOMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET@@SESSION.PSEUDO_SLAVE_MODE=0*/;
1. 做一些操作
mysql>create table t6(id int);
Query OK, 0 rows affected (0.02 sec)
?
mysql>insert into t6 value(1);
Query OK, 1 row affected (0.00 sec)
?
mysql>insert into t6 value(2);
Query OK, 1 row affected (0.01 sec)
?
mysql>insert into t6 value(3);
Query OK, 1 row affected (0.01 sec)
?
mysql>delete from t6 where id=3;
Query OK, 1 row affected (0.00 sec)
2. 只看jiaowu库中的信息
[root@localhostdata]# mysqlbinlog mysql.000007 -d jiaowu
/*!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
#150717 11:01:43 server id 1 end_log_pos 120 CRC32 0xc3bad8fd Start: binlog v 4, server v 5.6.12-logcreated 150717 11:01:43
# Warning: this binlog is either in use orwas not closed properly.
BINLOG '
F3CoVQ8BAAAAdAAAAHgAAAABAAQANS42LjEyLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAXAAEGggAAAAICAgCAAAACgoKGRkAAf3Y
usM=
'/*!*/;
# at 120
# at 219
#150717 11:06:09 server id 1 end_log_pos 300 CRC32 0xd883c511 Query thread_id=24910 exec_time=0 error_code=0
SET TIMESTAMP=1437102369/*!*/;
SET @@session.pseudo_thread_id=24910/*!*/;
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 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/*!*/;
BEGIN
/*!*/;
# at 300
# at 399
#150717 11:06:09 server id 1 end_log_pos 430 CRC32 0x254bd95b Xid = 75156
COMMIT/*!*/;
# at 430
#150717 11:06:12 server id 1 end_log_pos 511 CRC32 0x400701db Query thread_id=24910 exec_time=0 error_code=0
SET TIMESTAMP=1437102372/*!*/;
BEGIN
/*!*/;
# at 511
# at 610
#150717 11:06:12 server id 1 end_log_pos 641 CRC32 0xc0160921 Xid = 75157
COMMIT/*!*/;
# at 641
#150717 11:0