Hi,
L G Wrote:
-------------------------------------------------------
> I would like to use partition on some huge
> tables(100M+ rows), however, our production server
> is not ready to upgrade to 5.1. So, does 5.0
> support partition? Any way around I can achieve
> partition in 5.0?
Unfortunately MySQL 5.0 does not support partitioning. However, you can start testing the new functionality without having to discrupt operations:
http://datacharmer.blogspot.com/2007/06/use-51-partitions-in-production-today.html
Hope that helps!
LenZ
Lenz Grimmer - MySQL Community Relations Manager -
http://de.sun.com/
Sun Microsystems GmbH, Sonnenallee 1, 85551 Kirchheim-Heimstetten, DE
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels
Vorsitz d. Aufsichtsrates: Martin Haering AG Muenchen: HRB161028