1
docker run --rm percona/percona-toolkit \
2
  pt-archiver \
3
  --source h=192.168.50.21,u=root,p=xxx,D=sephy_app,t=rss_topic \
4
  --dest h=192.168.50.21,u=root,p=xxx,D=sephy_app,t=rss_topic_2022 \
5
  --where "post_time < '2023-01-01 00:00:00'" --limit 10000 --txn-size 1000 \
6
  --bulk-delete --statistics \
7
  --purge --no-check-charset --local --analyze=ds

1
docker run --rm percona/percona-toolkit \
2
  pt-show-grants --user=root --password=pwd --host=192.168.50.21 > /var/lib/mysql/grants.sql