Archiving Historical MySQL Data with pt-archiver Tool
Background
Starting from December 5th, a production instance began experiancing daily replica lag alerts. After investigation, the TPS during the lag period was not high, with only about 1K DML operations on the clickstream_events table. However, this table had grown to 60GB, far exceeding the recommended maximum single table size of 10GB.
This ...
Posted on Wed, 16 Sep 2026 16:05:06 +0000 by fpyontek
Percona Toolkit Practical Usage Guide
Percona Toolkit Operations Guide
Table of Contents
pt-online-schema-change
Adding Columns Online
Creating Indexes Online
Modifying Table Columns Online
Foreign Key Handling
pt-archiver
Data Cleanup
Data Archiving
Parameter Reference
Known Bug Resolution
Usage Examples
pt-query-digest - Slow Query Analysis
pt-heartbeat - Replication Lag M ...
Posted on Sun, 06 Sep 2026 16:39:16 +0000 by kaspari22
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