MySQL Forums
Forum List  »  Partitioning

ask for good suggestion on partition method
Posted by: Jiang Jianping
Date: January 13, 2008 02:40AM

Hi,All:
We need to preserve the most current 90 days data to be analyzed(by day, month, week and date range). The data of a day is very large and increased everyday. One way I thought out is to do the parttion based on the days from year start,that's, 365 days, 365 partitions. Is there more good suggestion to do partition more effectively? Thanks a lot.

Options: ReplyQuote


Subject
Views
Written By
Posted
ask for good suggestion on partition method
3405
January 13, 2008 02:40AM


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.