MySQL Forums
Forum List  »  Partitioning

Re: Partitioning in MySQL: Range Partitioning
Posted by: Mikael Ronström
Date: May 26, 2005 01:45AM

Hi,

Kristian Myllymäki wrote:
> Full partitioning support in MySQL would indeed be
> very interesting when comparing it against other
> vendors that have the same functionality for
> VLDBs.
>
> Just some interesting questions:
>
> * Indexing functionality. Will you support indexes
> on partitioned tables?

Yes

How should we maintain
> indexes when dropping partitions? Will indexes
> also be partitioned or will they be global to the
> table data?

The indexes will belong to the partitions in the first version.
Thus dropping a partition is not a problem since the index is
dropped as well so no particular maintenance of indexes are
needed.

In the first version there will also be a limitation in that if there
are any primary key or unique keys in the table then all fields
of the partitioning function have to be part of each of those keys.
This is a consequence of not having global indexes that are needed
for a general solution to maintain the uniqueness constraint.
(There is one exception here with MySQL Cluster that supports unique
keys without this limitation)

> * Will you support updates on the partitioning key
> columns which could cause rows to be moved from
> one partition to another?
>

Yes.

Rgrds Mikael

> There are other questions regarding statistics,
> split/merge functionality of partitions but I
> don't find them as vital as the questions above.
>
> Thanks,
>
> /Kristian

Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog: http://mikaelronstrom.blogspot.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Partitioning in MySQL: Range Partitioning
3198
May 26, 2005 01:45AM


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.