# Run the optimization process using pt-archiver on other partition

**URL:** https://forums.percona.com/t/run-the-optimization-process-using-pt-archiver-on-other-partition/6058
**Category:** Percona Toolkit
**Created:** [December 7, 2017, 6:32am UTC](https://forums.percona.com/t/run-the-optimization-process-using-pt-archiver-on-other-partition/6058 "2017-12-07T06:32:12Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![farhana](https://avatars.discourse-cdn.com/v4/letter/f/41988e/32.png) [@farhana](https://forums.percona.com/u/farhana)
#### Post date: [December 7, 2017, 6:32am UTC](https://forums.percona.com/t/run-the-optimization-process-using-pt-archiver-on-other-partition/6058/1 "2017-12-07T06:32:12Z")

</div>

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  
sesemi@mysql [(none)]\> show variables like ‘tmpdir’;

±--------------±-------------------+  
| Variable\_name | Value |  
±--------------±-------------------+  
| tmpdir | /optimization-data |  
±--------------±-------------------+  
1 row in set (0.00 sec)  
Thank you

---

<div class="post-metadata">

### Author: ![carlos.salguero](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/carlos.salguero/32/20_2.png) [@carlos.salguero](https://forums.percona.com/u/carlos.salguero)
#### Post date: [December 7, 2017, 9:06am UTC](https://forums.percona.com/t/run-the-optimization-process-using-pt-archiver-on-other-partition/6058/2 "2017-12-07T09:06:09Z")

</div>

Hi,

It is not possible to specify a different mount point to run the optimizer but you can move the table to a different (and PERMANENT) mount point using pt-online-schema-change:  
[URL][https://www.percona.com/blog/2016/11/04/changing-tablespace-directory-pt-online-schema-change/[/URL]](https://www.percona.com/blog/2016/11/04/changing-tablespace-directory-pt-online-schema-change/%5B/URL%5D)

---

<div class="post-metadata">

### Author: ![farhana](https://avatars.discourse-cdn.com/v4/letter/f/41988e/32.png) [@farhana](https://forums.percona.com/u/farhana)
#### Post date: [February 12, 2018, 9:44pm UTC](https://forums.percona.com/t/run-the-optimization-process-using-pt-archiver-on-other-partition/6058/3 "2018-02-12T21:44:58Z")

</div>

Thank you for making me clear
