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

Help using pt-archiver for archiving DB

ronakshahronakshah EntrantCurrent User Role Beginner

We are in the process of archiving our DB since the size of the table is increasing which in turn is slowing down the application. Each table is having around 60-70 lakhs of records and the database is having records for last 4 yrs. After analyzing we have found that the past year records are not accessed frequently so we have decided to keep only 6 months of data on live DB & archive the rest.

Have gone through the pt-archiver documentation & in that it has mentioned option of `before_delete` function by extending the tool to archive all dependent tables. I am completely new to perl & percona toolkit. Would like to explore this option since most of our tables are dependent on single table

Can anyone point me in direction on how to move ahead with this
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.