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

Written By
Partition Management over rolling 180 days
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.