# Pt-osc to use different storage for temporary table

**URL:** <https://forums.percona.com/t/pt-osc-to-use-different-storage-for-temporary-table/27729>\
**Category:** Percona Toolkit\
**Created:** [January 11, 2024, 10:14pm UTC](https://forums.percona.com/t/pt-osc-to-use-different-storage-for-temporary-table/27729 "2024-01-11T22:14:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![vdamyanov](https://avatars.discourse-cdn.com/v4/letter/v/4bbf92/32.png) [@vdamyanov](https://forums.percona.com/u/vdamyanov)\
**Post date:** [January 11, 2024, 10:14pm UTC](https://forums.percona.com/t/pt-osc-to-use-different-storage-for-temporary-table/27729/1 "2024-01-11T22:14:44Z")

</div>

While using pt-osc , is there an option or process to use for creating temporary table to different storage than current data folder of original table. Asking this in cases when we do not have enough space on current data folder. Idea is not to add more space to current datafolder but just use different storage/mount and after we are done to remove the mount with the storage?

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [January 11, 2024, 11:03pm UTC](https://forums.percona.com/t/pt-osc-to-use-different-storage-for-temporary-table/27729/2 "2024-01-11T23:03:05Z")

</div>

@vdamyanov pt-osc does not create a temporary table. pt-osc creates a new table using the same engine as the original table. After the data copy process completes, the old and new tables are simply swapped via atomic table rename. If you created the new table in a different engine, yes, you could swap them via rename, but the new table would not be using the correct engine and you would need to run pt-osc once again to alter the table engine.

---

<div class="post-metadata">

**Author:** ![vdamyanov](https://avatars.discourse-cdn.com/v4/letter/v/4bbf92/32.png) [@vdamyanov](https://forums.percona.com/u/vdamyanov)\
**Post date:** [January 11, 2024, 11:51pm UTC](https://forums.percona.com/t/pt-osc-to-use-different-storage-for-temporary-table/27729/3 "2024-01-11T23:51:02Z")

</div>

Thanks for confirming my suspicion…