MySQL 8 Cookbook

Purging data

If you want to delete all the rows from the employees table for which hire_date is older than 30 years, you can execute the following:

shell> pt-archiver --source h=localhost,D=employees,t=employees -u <user> -p<pass> --where="hire_date<DATE_ADD(NOW(), INTERVAL -30 YEAR)" --no-check-charset --limit 10000 --commit-each

You can pass the hostname, database name, and table name through the --source option. You can limit the number of rows to delete in a batch using the --limit option.

If you specify --progress, the output is a header row, plus status output at intervals. Each row in the status output lists the current date and time, how many seconds pt-archiver has been running, and how many rows it has archived.

If you specify ...