mysql binglog

本文主要是介绍mysql binglog，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

mysqlbinlog.exe 下载 适用8.0版本
https://wwd.lanzoub.com/iO5by091g32h

在bin目录执行
mysqlbinlog.exe --no-defaults -vv --base64-output=decode-rows "C:\phpstudy_pro\Extensions\MySQL8.0.12\data\binlog.000017" >mysqlbinbibinbinbbin.log

# The proper term is pseudo_replica_mode, but we use this compatibility alias
# to make the statement usable on server versions 8.0.24 and older.
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#220805 12:27:39 server id 1  end_log_pos 124 CRC32 0xb51bf591 	Start: binlog v 4, server v 8.0.12 created 220805 12:27:39 at startup
ROLLBACK/*!*/;
# at 124
#220805 12:27:39 server id 1  end_log_pos 155 CRC32 0x897dc175 	Previous-GTIDs
# [empty]
# at 155
#220805 12:38:38 server id 1  end_log_pos 230 CRC32 0x75cee8b5 	Anonymous_GTID	last_committed=0	sequence_number=1	rbr_only=yes	original_committed_timestamp=1659674318295850	immediate_commit_timestamp=1659674318295850	transaction_length=554
/*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
# original_commit_timestamp=1659674318295850 (2022-08-05 12:38:38.295850 Öйú±ê׼ʱ¼ä)
# immediate_commit_timestamp=1659674318295850 (2022-08-05 12:38:38.295850 Öйú±ê׼ʱ¼ä)
/*!80001 SET @@session.original_commit_timestamp=1659674318295850*//*!*/;
/*!80014 SET @@session.original_server_version=999999*//*!*/;
/*!80014 SET @@session.immediate_server_version=999999*//*!*/;
SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/;
# at 230
#220805 12:38:38 server id 1  end_log_pos 323 CRC32 0x6fb8b723 	Query	thread_id=11	exec_time=0	error_code=0
SET TIMESTAMP=1659674318/*!*/;
SET @@session.pseudo_thread_id=11/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=1168113696/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8mb4 *//*!*/;
SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=192/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
/*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
BEGIN
/*!*/;
# at 323
#220805 12:38:38 server id 1  end_log_pos 426 CRC32 0x00a57d2c 	Table_map: `liangdong-hao`.`agent_account` mapped to number 72
# at 426
#220805 12:38:38 server id 1  end_log_pos 678 CRC32 0x669f89b4 	Update_rows: table id 72 flags: STMT_END_F
### UPDATE `liangdong-hao`.`agent_account`
### WHERE
###   @1=3 /* LONGINT meta=0 nullable=0 is_null=0 */
###   @2=3 /* LONGINT meta=0 nullable=1 is_null=0 */
###   @3=0 /* INT meta=0 nullable=1 is_null=0 */
###   @4=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */
###   @5=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */
###   @6=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */
###   @7=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */
###   @8=3.170 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */
###   @9=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */
###   @10=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */
###   @11='bec5508bc8bf3ed621c034c832cd1ed3' /* VARSTRING(128) meta=128 nullable=1 is_null=0 */
###   @12='2022-04-08 00:30:29' /* DATETIME(0) meta=0 nullable=1 is_null=0 */
###   @13='2022-04-08 00:30:29' /* DATETIME(0) meta=0 nullable=1 is_null=0 */
### SET
###   @1=3 /* LONGINT meta=0 nullable=0 is_null=0 */
###   @2=31 /* LONGINT meta=0 nullable=1 is_null=0 */
###   @3=0 /* INT meta=0 nullable=1 is_null=0 */
###   @4=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */
###   @5=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */
###   @6=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */
###   @7=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */
###   @8=3.170 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */
###   @9=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */
###   @10=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */
###   @11='bec5508bc8bf3ed621c034c832cd1ed3' /* VARSTRING(128) meta=128 nullable=1 is_null=0 */
###   @12='2022-04-08 00:30:29' /* DATETIME(0) meta=0 nullable=1 is_null=0 */
###   @13='2022-04-08 00:30:29' /* DATETIME(0) meta=0 nullable=1 is_null=0 */
# at 678
#220805 12:38:38 server id 1  end_log_pos 709 CRC32 0xf55ba82f 	Xid = 67
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*/;

这篇关于mysql binglog的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！