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