MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Technical Query on Mysql--InnoDB storage engine currently doesn’t support Partitioning on Table which have Foreign key references.
Posted by: RaviSankar Saripalli
Date: June 13, 2014 06:13AM

Hi James

I am from Abhijit's team.

Our requirement is to archive/purging the table data after every 10 months. So we want to achieve this requirement through partitioning approach.

We are having DATE columns and we want to use RANGE partitioning method. But the tables are having referential integrities. We are unable to create partitions on these tables.

Please help us to resolve the above issue and suggest us ideal solution.
Thank You
RaviSankar

Navigate: Previous Message• Next Message
Options: Reply• Quote




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.