MySQL Forums :: Partitioning :: EXCHANGE PARTITION and DATA DIRECTORY errors


Advanced Search

Re: EXCHANGE PARTITION and DATA DIRECTORY errors
Posted by: Ekundayo Lasode ()
Date: August 19, 2014 06:28AM

Thanks for the reply Mattias.

Partitioned tables are one of the use limitations for the first option and we can't avoid partitioning because of the sheer size of the database (about 22GB per monthly partition for just 1 table!)

I might have to play with v5.7 to see what's possible. Unfortunately "ALTER TABLE IMPORT PARTITION TABLESPACE" still requires physically copying gigabytes of data on disk to be imported @ the destination schema/server.

Options: ReplyQuote


Subject Views Written By Posted
EXCHANGE PARTITION and DATA DIRECTORY errors 2164 Ekundayo Lasode 08/16/2014 09:47AM
Re: EXCHANGE PARTITION and DATA DIRECTORY errors 998 Mattias Jonsson 08/19/2014 03:32AM
Re: EXCHANGE PARTITION and DATA DIRECTORY errors 1015 Ekundayo Lasode 08/19/2014 06:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.