Detect and Cure MySQL Replication Lag: Step‑by‑Step Guide

This article explains how to identify whether MySQL replication delay originates from the I/O thread or SQL thread, demonstrates diagnostic commands, and provides practical tips, configuration tweaks, and monitoring tools such as pt‑stalk to reduce lag and improve replication performance.

Replicationmysqlperformance

0 likes · 11 min read

Detect and Cure MySQL Replication Lag: Step‑by‑Step Guide

Aikesheng Open Source Community

May 22, 2020 · Databases

Using Percona Toolkit’s pt‑stalk for MySQL Monitoring and Diagnostics

This article introduces the Percona Toolkit utility pt‑stalk, explains its OS‑level and MySQL‑level monitoring capabilities, details configuration parameters and usage scenarios, shows example command lines, describes the generated diagnostic output, and briefly covers the companion pt‑sift tool for analysis.

Linuxdiagnosticsmysql

0 likes · 8 min read

Using Percona Toolkit’s pt‑stalk for MySQL Monitoring and Diagnostics