Re: Production?
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!
Subject
Views
Written By
Posted
4232
December 11, 2006 11:30AM
3078
January 05, 2007 12:05AM
3084
February 20, 2007 08:04AM
2970
January 17, 2007 05:35PM
Re: Production?
3098
July 26, 2007 09:41PM
2965
August 09, 2007 05:06PM
3153
October 19, 2007 10:48AM
3195
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.