MySQL Forums
Forum List  »  Partitioning

Re: Any hope of seeing these features in 5.1?
Posted by: Mikael Ronström
Date: April 06, 2005 03:10AM

I am currently developing this support as Harrison mentioned. The aim is to have it ready in
5.1 so you should hopefully be able to do source downloads in a not to distant future where this
feature is available. However as usual change of priorities and lots of other things can
change plans so this is just a hint of what should be there.

Rgrds Mikael
PS: MySQL Cluster already does partitioning of tables already in MySQL 4.1, it is however
automatic.

The syntax currently supported in the new development is (there is actually a couple of more
options on the partitions):
CREATE TABLE .... (column-list ..)
PARTITION BY
KEY '(' ( column-list ) ')'
| RANGE '(' ( expr ) ')'
| LIST '(' ( expr ) ')'
| HASH '(' ( expr ) ')'
[PARTITIONS (num) ]
[SUBPARTITION BY
KEY '(' ( column-list ) ')'
| HASH '(' ( expr ) ')'
[SUBPARTITIONS (num) ]
]
[ '('
( PARTITION logical-name
[ VALUES LESS THAN '(' ( expr | MAX_VALUE ) ')' ]
[ VALUES IN '(' (expr)+ ')' ]
[ TABLESPACE tablespace-name ]
[ [ STORAGE ] ENGINE [ '=' ] storage-engine-name ]
[ NODEGROUP nodegroup-id ]
[ '('
( SUBPARTITION logical-name
[ TABLESPACE tablespace-name ]
[ [ STORAGE ] ENGINE [ '=' ] storage-engine-name ]
[ NODEGROUP nodegroup-id ]
)+
')'
)+
')'
]

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Any hope of seeing these features in 5.1?
2503
April 06, 2005 03:10AM


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.