MySQL Forums
Forum List  »  Partitioning

Week Partitioning
Posted by: Frank Schuster
Date: July 17, 2009 03:25AM

Hello,

I have a table with a column date and I want to store all datas about the year in the table and will it partioning by 52 weeks.
The question is, what Type of Partitioning is recommended?

The problem is and I don't know how I can solve it is: When the 52 weeks are over, I want that the entries of the oldest week are deleted and a new partition will be add - so I get a constant number of partition.

I hope you can understand the problem or you can ask me.

Frank

Options: ReplyQuote


Subject
Views
Written By
Posted
Week Partitioning
4801
July 17, 2009 03:25AM
2831
July 18, 2009 12:07PM
2689
July 20, 2009 03:29AM
7360
August 06, 2009 04:02PM


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.