BestHub
Sign in
Tag

exec_time

1 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
May 14, 2024 · Databases

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.

DatabaseMySQLReplication
0 likes · 15 min read
Understanding Timestamp and exec_time Fields in MySQL Binlog (Master and Slave)
Aikesheng Open Source Community
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.

MySQLReplication LagTroubleshooting
0 likes · 16 min read
Understanding exec_time in MySQL Binlog and Its Impact on Replication Lag
Aikesheng Open Source Community
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.

Database PerformanceMySQLbinlog
0 likes · 5 min read
Why MySQL BEGIN Statement Shows 5‑Second exec_time: Binlog Timestamp Experiments
Qunar Tech Salon
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.

DatabaseGTIDMySQL
0 likes · 10 min read
Understanding Timestamp and exec_time in MySQL Binlog Events