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
4005
December 11, 2006 11:30AM
2955
January 05, 2007 12:05AM
2945
February 20, 2007 08:04AM
2843
January 17, 2007 05:35PM
Re: Production?
2974
July 26, 2007 09:41PM
2853
August 09, 2007 05:06PM
3034
October 19, 2007 10:48AM
3076
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.