MySQL Forums
Forum List  »  Partitioning

Re: Partitioned Tables
Posted by: Mikael Ronström
Date: April 06, 2005 03:06AM

Bill Kolbenschlag wrote:
> Does MySQL support Partitioning of tables?

I am currently developing this support. 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
3746
March 08, 2005 09:31AM
2923
March 16, 2005 10:18PM
2786
March 17, 2005 12:38AM
Re: Partitioned Tables
2458
April 06, 2005 03:06AM


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.