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