Data Consistency Verification and Repair Between MySQL Primary and Replica Using Percona Toolkit
pt-table-checksum
Prerequisites (Must Verify Before Running Checks)
Only a single host can be specified, and it must be the IP address of the primary database.
The tool adds S (shared) locks on tables during the check.
If the binary log format on the primary or replica is not STATEMENT, you must use the --no-check-binlog-format option.
Before ...
Posted on Thu, 28 May 2026 19:46:17 +0000 by jack bro
Deep Dive into MySQL Query Analysis with pt-query-digest
Introduction
pt-query-digest is a powerful tool from the Percona Toolkit designed to analyze MySQL slow queries. It can process various input sources such as the slow query log, the binary log (binlog), the general log, output from SHOW PROCESSLIST, or even TCP traffic captured via tcpdump. The tool works by parameterizing query conditions, gro ...
Posted on Wed, 20 May 2026 21:03:56 +0000 by Pig