MySQL Forums
Forum List  »  Partitioning

Partitioning in MySQL: LIST Partitioning
Posted by: Mikael Ronström
Date: July 20, 2005 04:58PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Partitioning in MySQL: LIST Partitioning
3418
July 20, 2005 04:58PM


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.