MySQL中binlog参数:binlog
# mysqlbinlog --no-defaults -v -v --base64-output=DECODE-ROWS mysql_bin.000030/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#1704248:58:35 server>
# Warning: this binlog is either in use or was not closed properly.
# at 123
#1704248:58:35 server>
# a0c06ec7-fef0-11e6-9f85-525400a7d662:1-812
# at 194
#1704248:58:52 server>
SET @@SESSION.GTID_NEXT= 'a0c06ec7-fef0-11e6-9f85-525400a7d662:813'/*!*/;
# at 259
#1704248:58:52 server>
SET TIMESTAMP=1492995532/*!*/;
SET @@session.pseudo_thread_id=34/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=1436549120/*!*/;
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/*!*/;
BEGIN
/*!*/;
# at 331
#1704248:58:52 server>
# at 429
#1704248:58:52 server>
### UPDATE `boss`.`t`
### WHERE
### @1=7 /* INT meta=0 nullable=1 is_null=0 */
### SET
### @1=8 /* INT meta=0 nullable=1 is_null=0 */
# at 475
#1704248:58:52 server>
COMMIT/*!*/;
SET @@SESSION.GTID_NEXT= 'AUTOMATIC' /* added by mysqlbinlog */ /*!*/;
DELIMITER ;
# End of log file
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
页:
[1]