Re: Partitioned Tables

[Mikael Ronström]

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 ]
)+
')'
)+
')'
]