Understanding Timestamp and exec_time Fields in MySQL Binlog (Master and Slave)

This article analyzes how MySQL binlog records timestamps and exec_time for GTID, BEGIN, Table_map, Write, and Xid events on both master and slave, explains the calculation of original_commit_timestamp and immediate_commit_timestamp, and provides formulas and source‑code references to help diagnose replication delay.

exec_timemysqltimestamp

0 likes · 15 min read

Understanding Timestamp and exec_time Fields in MySQL Binlog (Master and Slave)

Aikesheng Open Source Community

May 13, 2021 · Databases

Understanding exec_time in MySQL Binlog and Its Impact on Replication Lag

This article investigates the meaning of exec_time in MySQL binary logs, demonstrates how row and statement binlog formats record execution times through systematic tests, analyzes the underlying principles, and shows how exec_time can be used to diagnose replication lag caused by CPU, disk, or network bottlenecks.

Binlogexec_timemysql

0 likes · 16 min read

Understanding exec_time in MySQL Binlog and Its Impact on Replication Lag

Aikesheng Open Source Community

Jan 15, 2021 · Databases

Why MySQL BEGIN Statement Shows 5‑Second exec_time: Binlog Timestamp Experiments

This article examines how MySQL binlog timestamps and the SET TIMESTAMP command affect the exec_time values of statements, especially the BEGIN event, through step‑by‑step experiments that reveal timing discrepancies and their impact on log accuracy.

BinlogDatabase Performanceexec_time

0 likes · 5 min read

Why MySQL BEGIN Statement Shows 5‑Second exec_time: Binlog Timestamp Experiments

Qunar Tech Salon

Apr 6, 2017 · Databases

Understanding Timestamp and exec_time in MySQL Binlog Events

This article explains how MySQL binlog timestamps are derived from the THD start_time, why all events in a transaction share the same timestamp, how exec_time is calculated, and demonstrates the effect of autocommit and manual commit on binlog timing through concrete examples and source code analysis.

BinlogGTIDdatabase

0 likes · 10 min read

Understanding Timestamp and exec_time in MySQL Binlog Events