MySQL Forums
Forum List  »  Partitioning

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Partitioning in MySQL: Range Partitioning
2737
September 20, 2005 09:13AM


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.