binlog时间700101（1970-01-01）

最新推荐文章于 2021-05-04 20:48:28 发布

cuiyangshua0551

最新推荐文章于 2021-05-04 20:48:28 发布

阅读量201

点赞数

起因很复杂，就不解释了。

mysql 5.6.20
现象：
mysqlbinlog解析binlog时，发现文件头的信息如下：

/*!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
#700101 8:00:00 server id 169019238 end_log_pos 120 CRC32 0xb825a5f1 Start: binlog v 4, server v 5.6.20-ucloudrel1-log created 700101 8:00:00
# Warning: this binlog is either in use or was not closed properly.
BINLOG '
AAAAAA9mBxMKdAAAAHgAAAABAAQANS42LjIwLXVjbG91ZHJlbDEtbG9nAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAXAAEGggAAAAICAgCAAAACgoKGRkAAfGl
Jbg=
'/*!*/;
# at 120
#160810 19:16:59 server id 169019238 end_log_pos 199 CRC32 0x71012148 Query thread_id=15 exec_time=0 error_code=0
SET TIMESTAMP=1470827819/*!*/;
SET @@session.pseudo_thread_id=15/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=1073741824/*!*/;
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=33/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;