MySQL Forums
Forum List  »  Partitioning

Re: Production?
Posted by: Robert Freeland
Date: July 26, 2007 09:41PM

FWIW, we intend to give large-scale partitioning a shot in a production environment next month. We handle about 3 million transactions/day, and we have over a year's worth of historical data to wrestle with. We figured it was worth giving MySQL a shot at this job before ponying up big $$ for the SQL Server version that supports partitioning.

I've been tracking the release reports for the last few releases of MySQL 5.1, and I'm not seeing a lot of fixes in the partitioning code, so that has given me the courage to try it.

I would sure like to see partition pruning via the MONTHS function, though! Then we could partition by YEARS, then subpartition by MONTHS. I can't imagine how that use case didn't make it into the 5.1 planning!

Options: ReplyQuote


Subject
Views
Written By
Posted
3951
December 11, 2006 11:30AM
2929
January 05, 2007 12:05AM
2904
February 20, 2007 08:04AM
2815
January 17, 2007 05:35PM
Re: Production?
2940
July 26, 2007 09:41PM
2824
August 09, 2007 05:06PM
3005
October 19, 2007 10:48AM
3041
March 09, 2007 12:08AM


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.