MySQL Forums
Forum List  »  Partitioning

Re: Partitioning in MySQL: Range Partitioning
Posted by: Kristian Myllymäki
Date: May 25, 2005 02:17AM

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? How should we maintain indexes when dropping partitions? Will indexes also be partitioned or will they be global to the table data?
* Will you support updates on the partitioning key columns which could cause rows to be moved from one partition to another?

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Partitioning in MySQL: Range Partitioning
2971
May 25, 2005 02:17AM


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.