MySQL Forums
Forum List  »  Partitioning

Re: Partition and subpartition are different column
Posted by: Mattias Jonsson
Date: July 24, 2012 04:57AM

You can partition by one column and subpartition by another column, but you have to partition by range or list first and then subpartition by hash/key.

Also note that all partition and subpartition columns must be part of all unique keys (including primary key).

So I suggest you to try PARTITION BY RANGE (topic_id) SUBPARTITION BY HASH (site_id).

btw, what will the main use of partitioning be?

Options: ReplyQuote

Written By
Re: Partition and subpartition are different column
July 24, 2012 04:57AM

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.