MySQL Forums
Forum List  »  Partitioning

Re: best way to take backup for old partition and create new one?
Posted by: Rick James
Date: December 05, 2013 12:15PM

For rolling date-based partitions, I like to keep an empty `future` partition, then REORGANIZE PARTITIONS to split `future` into a new partition plus an empty `future`. I do that just before the new partition is needed. This REORG will be very fast. Further details:

http://mysql.rjweb.org/doc.php/partitionmaint

As for how to schedule it...
Unix: One way is a Perl script that runs via cron.
MySQL: You could put it in an EVENT.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: best way to take backup for old partition and create new one?
1615
December 05, 2013 12:15PM


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.