Re: Huge Dataset (perhaps?) made for Range Partitioning (Long)

[JinNo Kim]

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,

-JNK