Partitioning development first version has now been pushed to 5.1 and the first 5.1 version
is very close now so in a short time the partitioning feature becomes available in alpha
version.
The next step in the description of the partitioning variants is the LIST partitioning.
List partitioning is useful when partitioning is based on a field with only a limited set of
values. An example could be to partitioning based on Country Code. All records
pertaining to a certain country is assigned to a specific partition and there could be
several countries in one partition.
List partitioning can be combined with HASH/KEY partitioning in a composite partitioning
(also called subpartitioning).
If someone tries to assign a value in the fields of the partition function such that the partition
function returns a value not in any of the lists of the partitions, an error will occur for that
query.
List partitioning makes it easy to add/drop partitions for a table without requiring a major
reorganisation of the table. The aim is to support this in 5.1 but it will not be a part of the
very first release of 5.1.
Rgrds Mikael
Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:
http://mikaelronstrom.blogspot.com
Edited 1 time(s). Last edit at 07/21/2005 09:46AM by Edwin DeSouza.