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

Run the optimization process using pt-archiver on other partition

farhanafarhana EntrantInactive User Role Beginner
Hello,
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) to run the optimization. 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 < 12345" ========================================
we need to include /optimization-data partition to run the optimization process

fyi.. I have made the changes in the configuration file to read the tmpdir as below
[email protected] [(none)]> show variables like 'tmpdir';

+
+
+
| Variable_name | Value |
+
+
+
| tmpdir | /optimization-data |
+
+
+
1 row in set (0.00 sec)
Thank you

Comments

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.