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
2072
September 24, 2014 08:42AM
Re: Range partition and unique key
1058
September 25, 2014 09:59AM
1197
September 26, 2014 03:40AM
1145
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.