MySQL Forums
Forum List  »  Partitioning

Partition Management over rolling 180 days
Posted by: Kate Knudsen
Date: July 09, 2007 08:43AM

I'm planning to partition a very large table with 180 days worth of rolling data -- one partition per day. What is the best way to manage the creation/deletion of partitions on a daily basis? Do I need to store/read the low/high partition names (ex., p1 and pn) so I know which to drop (p1) and what to add (pn+1)? Is there a slick alterative?

Options: ReplyQuote


Subject
Views
Written By
Posted
Partition Management over rolling 180 days
6603
July 09, 2007 08:43AM


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.