BestHub
search
Sign in
Tag

pt-archiver

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 28, 2021 · Databases

Using pt-archiver for Batch Deletion of Large MySQL Tables

The article explains why massive MySQL tables need periodic cleanup, compares risky drop/truncate approaches, and provides a step‑by‑step guide to safely delete historical data in batches using pt‑archiver with proper parameters, session handling, and post‑deletion maintenance.

Data CleanupDatabase MaintenanceMySQL
0 likes · 7 min read
Using pt-archiver for Batch Deletion of Large MySQL Tables
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 8, 2020 · Databases

Percona Toolkit Utilities for MySQL: Archiving, Config Comparison, Replication Lag, Variable Advice, and Debugging

This guide introduces several Percona Toolkit command‑line tools—pt‑archiver, pt‑config‑diff, pt‑heartbeat, pt‑variable‑advisor, and pt‑pmp—explaining their purpose, providing example commands for data archiving, configuration comparison, accurate replication lag measurement, variable optimization suggestions, and stack‑trace debugging, plus a quick installation snippet.

Database AdministrationMySQLPercona Toolkit
0 likes · 11 min read
Percona Toolkit Utilities for MySQL: Archiving, Config Comparison, Replication Lag, Variable Advice, and Debugging