MySQL Forums
Forum List  »  Partitioning

Re: Huge Dataset (perhaps?) made for Range Partitioning (Long)
Posted by: JinNo Kim
Date: September 23, 2005 08:45AM

Great, the script is running in the office to drop the 'A' column (16G is 16G) :). I'm up to 6/17 on the unpack, check, alter, pack, check cycle @11:13P KST - should be done by Monday:)

I'll sync my sources Sunday and build 5.1 on the new server Sunday night, KST. As far as speeding up the push process, I work on your schedule (well, within a couple of days, barring crisis management) :). I'll start playing with 10k rows from each of the existing daily tables sometime next week(hopefully). That should yield ~1M rows in the table to play with (10000 per daily partition). I'll start out slow with a few days and when I'm comfortable, pull the rest in.

One thing I'm not totally clear about, will there be a way for me to autogenerate a new parititon for a new days data in the definition, or will I need to be doing that by hand (or script)?

This is one of those times where I'm really motivated to help and excited about the prospect of contributing anything (even just a testbed) to something great.

Thank you,


Options: ReplyQuote

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.