MySQL Forums
Forum List  »  Partitioning

Re: Partition Management in MySQL 5.1
Posted by: Steven Roussey
Date: October 27, 2005 01:10PM

Ah!!

That looks great, but I have one important request. Currently we manually partition our tables, and one thing we do as part of our database management is to to an ALTER TABLE ... ORDER BY on each table (partition). In real life situations, this one thing has such an advantage in speed over the life of the tables that is mandatory. We never changed to InnoDB because of it, etc.

BTW: We do the ORDER BY on a key that is not the PK but does have the PK columns as the first columns in its key. (PK is (a,b), the key we order by is (a,b,c,d)).

Can we add:

ALTER TABLE t1 PARTITION (x0) ORDER BY (a,b,c,d);

???

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
13791
October 06, 2005 06:41PM
Re: Partition Management in MySQL 5.1
3128
October 27, 2005 01:10PM
2890
November 07, 2005 07:36PM


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.