MySQL Forums
Forum List  »  Partitioning

Re: Move from unpartitioned database to partitioned database
Posted by: Piyush Maheshwari
Date: March 20, 2012 03:39AM

Thanks for the reply.

So my main reason for adding partition is to have rolling partitions. This is for primarily purging the very old data and maintaining data for a window of say two years.
So I want to old partitions to get dropped off automatically.
How can I make rolling partitions in MySql?

1) Do you know how fast/efficient is the alter table to add parition operation?
I have a table with 500 million rows

3) How can I add the event?

-Piyush

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Move from unpartitioned database to partitioned database
1674
March 20, 2012 03:39AM


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.