MySQL Forums
Forum List  »  Partitioning

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
6267
September 17, 2009 07:50PM
2741
September 18, 2009 11:11PM
Re: Partitioning Limitations
2540
September 21, 2009 02:59AM
2689
September 22, 2009 08:28AM
2527
September 27, 2009 10:27PM
2578
September 27, 2009 10:47PM
2740
October 03, 2009 02:43AM
2746
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.