Comments on: Changing the Tablespace Directory with pt-online-schema-change https://www.percona.com/blog/changing-tablespace-directory-pt-online-schema-change/ Tue, 06 Aug 2019 19:50:13 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Farhana Mohammed https://www.percona.com/blog/changing-tablespace-directory-pt-online-schema-change/#comment-10968774 Sun, 10 Dec 2017 10:27:10 +0000 https://www.percona.com/blog/?p=39085#comment-10968774 Thankyou for the post. It’s really very helpful and understanding.

]]> By: Daniel https://www.percona.com/blog/changing-tablespace-directory-pt-online-schema-change/#comment-10967497 Fri, 23 Dec 2016 12:42:47 +0000 https://www.percona.com/blog/?p=39085#comment-10967497 Johnson, if you mean tables created with the “temporary” keyword the answer is no. A TEMPORARY table is visible only to the current session, and is dropped automatically when the session is closed.

]]> By: Johnson https://www.percona.com/blog/changing-tablespace-directory-pt-online-schema-change/#comment-10967487 Thu, 22 Dec 2016 09:23:12 +0000 https://www.percona.com/blog/?p=39085#comment-10967487 Does pt-osc support create temporary table with other table engine, like myisam ?

]]> By: nethalo https://www.percona.com/blog/changing-tablespace-directory-pt-online-schema-change/#comment-10967330 Thu, 10 Nov 2016 17:01:07 +0000 https://www.percona.com/blog/?p=39085#comment-10967330 Robert, from the doc: (http://dev.mysql.com/doc/refman/5.6/en/partitioning-limitations.html)

DATA DIRECTORY and INDEX DIRECTORY are subject to the following restrictions when used with partitioned tables:

Table-level DATA DIRECTORY and INDEX DIRECTORY options are ignored (see Bug #32091).

And pt-osc will only do table-level DATA DIECTORY.

Is not a bug, is just not supported in this version 🙂

Take in account that partitions with data directory faces bugs, like http://bugs.mysql.com/bug.php?id=73084

]]> By: robert rost https://www.percona.com/blog/changing-tablespace-directory-pt-online-schema-change/#comment-10967327 Wed, 09 Nov 2016 20:19:53 +0000 https://www.percona.com/blog/?p=39085#comment-10967327 Quick follow-up.. We found that the table partitioning was causing -data-dir option to be ignored. Will submit a bug report once we do some testing.

]]> By: robert rost https://www.percona.com/blog/changing-tablespace-directory-pt-online-schema-change/#comment-10967325 Tue, 08 Nov 2016 20:56:50 +0000 https://www.percona.com/blog/?p=39085#comment-10967325 For those interested in the failure… the pt-online-schema-change command works with the –data-dir=’/new/datadir’ option but it simply does not do whats it’s suppose to do (table copy is still in $datadir as defined by my.cnf). I am using PT 2.2.19 and copied the code from repo listed above.

]]> By: robert rost https://www.percona.com/blog/changing-tablespace-directory-pt-online-schema-change/#comment-10967324 Tue, 08 Nov 2016 20:52:23 +0000 https://www.percona.com/blog/?p=39085#comment-10967324 I have a similar project that i need to complete but was unable to get the above to work. Any idea on a release date for PT2.2.20?

]]> By: vidyadhar https://www.percona.com/blog/changing-tablespace-directory-pt-online-schema-change/#comment-10967320 Tue, 08 Nov 2016 07:03:15 +0000 https://www.percona.com/blog/?p=39085#comment-10967320 adding new feature in the tool to support customer requirement is awesome.. Good customer support from Percona..

]]> By: Jo Valerio https://www.percona.com/blog/changing-tablespace-directory-pt-online-schema-change/#comment-10967314 Mon, 07 Nov 2016 02:26:18 +0000 https://www.percona.com/blog/?p=39085#comment-10967314 Thanks for sharing! Keep it up Percona Team!

]]> By: William P Santana https://www.percona.com/blog/changing-tablespace-directory-pt-online-schema-change/#comment-10967305 Sat, 05 Nov 2016 16:17:55 +0000 https://www.percona.com/blog/?p=39085#comment-10967305 Awesome!!! Thanks Percona Team, always helping the community.

]]> By: Arnoldas https://www.percona.com/blog/changing-tablespace-directory-pt-online-schema-change/#comment-10967304 Sat, 05 Nov 2016 08:23:15 +0000 https://www.percona.com/blog/?p=39085#comment-10967304 Nice work, it provides some flexibility in extra cases

]]> By: Rick Pizzi https://www.percona.com/blog/changing-tablespace-directory-pt-online-schema-change/#comment-10967299 Fri, 04 Nov 2016 20:51:34 +0000 https://www.percona.com/blog/?p=39085#comment-10967299 Nice one!!! Thank you pt-osc team!

]]>