Re: Move from unpartitioned database to partitioned database

[Piyush Maheshwari]

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