MySQL Forums
Forum List  »  Partitioning

Re: Partition support in 5.0?
Posted by: Lenz Grimmer
Date: September 22, 2007 01:38AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
15759
L G
September 17, 2007 03:05PM
Re: Partition support in 5.0?
8675
September 22, 2007 01:38AM


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.