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

How to run the optimization process using pt-archiver on some other partition

santhosh.kp@indmax.com[email protected] EntrantLegacy User Role Beginner
When we run the optimization process on some XYZ table using pt-archiver, the optimization process is using /mnt/data (default Data directory) which do not have enough disk space to run the process, so instead of that i have added new disk called (/optimization-data partition). So we are looking for an option to pass the new disk as parameter and try to run the optimization process on that disk.

Is there any such option is available to run the percona pt-archiver (for optimize) to include specific partition in the command
Below is the current command we use for optimize
=======================================
pt-archiver --no-check-charset --source h=localhost,D=ABCD,t=XYZ --purge --optimize=s --where "id < 2635421542"
========================================

we need to include /optimization-data partition to run the optimization process
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.