MySQL Forums
Forum List  »  Partitioning

Re: How are indexes partitioned on a partitioned table
Posted by: Phil Hildebrand
Date: March 24, 2008 01:06PM

Currently, all MySQL partitioned indexes are similar to Oracle local indexes.
As of 5.1.24 there is not concept of Global indexes that I know of.

If you have a table partitioned by month, and create an index on that table,
it will effectively be partitioned by month as well.

There are some constraints/limitations with respect to MySQL partitioning
that you should look at coming from Oracle:

http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations.html

Specifically things pertaining to foreign keys not allowed, most partition
types require integers for key(s), etc. There are also some differences as
far as how maint works from an 'online' perspective.

They do, however, work quite well...

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How are indexes partitioned on a partitioned table
14652
March 24, 2008 01:06PM


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.