MySQL Forums
Forum List  »  Partitioning

Re: Range partition and unique key
Posted by: Rick James
Date: September 25, 2014 09:59AM

First, explain why you want to PARTITION the table. There is _no_ inherent benefit in adding PARTITIONs, except for a few queries that could take advantage of it.

The answer to that may lead to an un-obvious way to achieve your required UNIQUEness constraint.

Also, please explain why you are using MyISAM, not InnoDB.

Options: ReplyQuote


Subject
Views
Written By
Posted
2902
September 24, 2014 08:42AM
Re: Range partition and unique key
1584
September 25, 2014 09:59AM
1630
September 26, 2014 03:40AM
1635
September 27, 2014 08:25AM


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.