MySQL Forums
Forum List  »  Partitioning

Re: Partitioning by year and day
Posted by: Adam Israel
Date: June 17, 2011 09:48AM

Hey Rick,

I'm looking at 100M+ rows per day.

What I meant about the insert/selects was, if I only did day partitioning and created duplicate tables by years, I would have to dynamically choose the table based on the year I was looking up.

I think the solution here, then, is one table partitioned by year and day, and the daily script you mentioned to add a new and remove the old partition to prevent hitting the limit.


Options: ReplyQuote

Written By
June 16, 2011 01:52AM
June 17, 2011 09:34AM
Re: Partitioning by year and day
June 17, 2011 09:48AM

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.