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
4099
December 11, 2006 11:30AM
2997
January 05, 2007 12:05AM
2998
February 20, 2007 08:04AM
2891
January 17, 2007 05:35PM
Re: Production?
3023
July 26, 2007 09:41PM
2890
August 09, 2007 05:06PM
3087
October 19, 2007 10:48AM
3127
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.