BestHub
Sign in
Tag

pt-heartbeat

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 19, 2025 · Databases

Why MySQL 5.7 Seconds_Behind_Master Is Unreliable and How pt‑heartbeat Provides Accurate Replication Lag Measurement

The article explains why the built‑in MySQL 5.7 Seconds_Behind_Master metric often misrepresents replication delay, analyzes its design flaws, and demonstrates how the Percona Toolkit's pt‑heartbeat tool can reliably measure master‑slave lag with real‑time precision.

Database MonitoringMySQLReplication
0 likes · 10 min read
Why MySQL 5.7 Seconds_Behind_Master Is Unreliable and How pt‑heartbeat Provides Accurate Replication Lag Measurement
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 8, 2020 · Databases

Percona Toolkit Utilities for MySQL: Archiving, Config Comparison, Replication Lag, Variable Advice, and Debugging

This guide introduces several Percona Toolkit command‑line tools—pt‑archiver, pt‑config‑diff, pt‑heartbeat, pt‑variable‑advisor, and pt‑pmp—explaining their purpose, providing example commands for data archiving, configuration comparison, accurate replication lag measurement, variable optimization suggestions, and stack‑trace debugging, plus a quick installation snippet.

Database AdministrationMySQLPercona Toolkit
0 likes · 11 min read
Percona Toolkit Utilities for MySQL: Archiving, Config Comparison, Replication Lag, Variable Advice, and Debugging