Re: Partitioning in MySQL: Range Partitioning
Posted by:
JinNo Kim
Date: September 20, 2005 09:13AM
I was forwarded here from the Performance list, and was wondering if it might be possible to make the leap to daily (within month/year partitions) at some point.
I'm playing with an application that inserts ~10-30 million rows of (multi)integer+(2)datetime data fields /day and will attempt to maintain months (or years) of storage. I'm well over 2 billion rows in the daily tables, after recovering from the first hiccup in my original implementation plan. I am currently messing around with daily tables+merges to get in the neighborhood of our desired application, but this sounds like a very real solution to something I've been slaving over in shell scripts.
Subject
Views
Written By
Posted
10116
May 13, 2005 05:03PM
2938
May 23, 2005 03:29PM
4368
May 24, 2005 01:52AM
3226
May 25, 2005 02:17AM
3169
May 26, 2005 01:45AM
3218
May 25, 2005 04:09PM
3228
May 26, 2005 02:02AM
3336
July 01, 2005 03:11AM
3568
July 01, 2005 03:24PM
3423
July 01, 2005 06:24PM
Re: Partitioning in MySQL: Range Partitioning
2979
September 20, 2005 09:13AM
3376
September 20, 2005 02:26PM
2878
September 20, 2005 04:35PM
3210
October 07, 2005 06:27PM
3209
October 09, 2005 04:11AM
3087
October 10, 2005 05:08AM
3499
July 06, 2005 08:25AM
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.