Not the answer you need?
Register and ask your own question!

pt-archiver Cleaning up a table containing longtext columns is slow

FanFan ContributorCurrent User Role Patron
It seems to be slow on select, why pt-archiver query all columns instead of just select the primary key column?


  • carlos.salguerocarlos.salguero Percona Toolkit Developer Percona Staff Role
    Could you provide more information?
    - pt tools version
    - MySQL version
    - The output of the SHOW CREATE TABLE for the table you are trying to archive.
    - Command line parameters used with pt-archiver
    - Are there slaves in you set up?

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.