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

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