MySQL Forums
Forum List  »  Partitioning

Re: Auto Partitioning using unix time
Posted by: JinNo Kim
Date: March 07, 2006 08:00AM

Is the event feature an anticipated replacement for
the auto generation of new partitions, or is it a
suggested work around? I ask specifically because
I've been toying with migrating our existing 5.5
billion row dataset to a partitioned solution and
recently received a new requirement for approx 4.5
billion rows of storage (short term - data import
is occurring now on 4.1, different schema from
the previous project).

Based upon our current disk capacity and the data
rates, I expect to be in the ~20 billion row range
in ~6 months (10 billion existing + ~45
million/day new records). I haven't bothered to
figure out when we'll be out of space - that's
coming soon.

^
| _explains my recent absence from the boards


Just asking for a little clarification (I know
the reqs for auto-part have not yet been
submitted - sorry, my bad been very occupied
recently).

-JNK

Options: ReplyQuote


Subject
Views
Written By
Posted
7377
January 17, 2006 03:14PM
3391
January 30, 2006 07:09AM
2874
January 31, 2006 08:06AM
2598
February 10, 2006 11:22PM
Re: Auto Partitioning using unix time
2662
March 07, 2006 08:00AM


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.