MySQL Forums
Forum List  »  Partitioning

Re: Get partition name for specific date
Posted by: Jan Bromberger
Date: October 10, 2012 03:18AM

Hi Rick,

thanks for the good idea.

As I am not experienced with partitioning, I am thankful for your opinion about the number of partitions. I chose 92 because that's the max number of days we keep the historical data. The data set is quite huge for my commodity hardware (10M rows per day). And I have to import them quite fast. Fortunately, most of my queries only require data from one day, a few require data from two dates. So I thought it would be a good way to help keeping the whole index or even data set in memory by using this granular partitioning. It seems to work good for me up until now. What are your worries about having many partitions?

Kind regards
Jan

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Get partition name for specific date
1231
October 10, 2012 03:18AM


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.