MySQL Forums
Forum List  »  Partitioning

Re: How to partition my table
Posted by: Rick James
Date: April 08, 2009 08:00AM

For starters (into building indexes):
"All columns used in the partitioning expression for a partitioned table must be part of every unique key that the table may have." -- See
http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations-partitioning-keys-unique-keys.html
Note the first User Comment.

If the table is InnoDB, it is strongly advised to build your own PRIMARY KEY rather than letting the engine add a BIGINT for you.

As for what indexes (aside from the above points) to have, the question is best answered by looking at the SELECT statements you will have.

Options: ReplyQuote


Subject
Views
Written By
Posted
10192
March 15, 2009 09:36AM
4674
March 15, 2009 01:09PM
3949
March 17, 2009 10:35PM
3561
March 18, 2009 12:16AM
3393
March 18, 2009 09:12PM
3383
March 18, 2009 10:19PM
3714
March 19, 2009 05:18AM
3655
March 19, 2009 05:34AM
3371
April 06, 2009 08:08AM
3868
April 07, 2009 09:44PM
Re: How to partition my table
2710
April 08, 2009 08:00AM


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.