MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: Partitioning Limitations
Posted by: Mattias Jonsson
Date: September 21, 2009 02:59AM

This limitation is because MySQL does not implement GLOBAL INDEX yet, so to enforce UNIQUEness (and primary key) partitioning relies on enforcing it within every partition AND that the partitioning function is covered within the UNIQUE/PRIMARY keys.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Partitioning Limitations
6286
Premal Shah
September 17, 2009 07:50PM
Re: Partitioning Limitations
2753
Rick James
September 18, 2009 11:11PM
Re: Partitioning Limitations
2547
Mattias Jonsson
September 21, 2009 02:59AM
Re: Partitioning Limitations
2697
Premal Shah
September 22, 2009 08:28AM
Re: Partitioning Limitations
2536
Jonathan Stephens
September 27, 2009 10:27PM
Re: Partitioning Limitations
2587
Rick James
September 27, 2009 10:47PM
Re: Partitioning Limitations
2751
Jonathan Stephens
October 03, 2009 02:43AM
Re: Partitioning Limitations
2756
Rick James
October 03, 2009 06:03PM


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.