MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: Create index on parttion table (manually and dynamically)
Posted by: Rick James
Date: July 06, 2013 10:52PM

* What version of MySQL are you running? Newer versions have better CREATE INDEX times. Older versions: Do all INDEX operations in a single ALTER statement. Newer versions: separate ALTERs (see 'online vs offline).

* It might be better to partition by RANGE, without subpartitions.

* With InnoDB, you should always have a PRIMARY KEY, not add it later.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Create index on partition table (manually and dynamically)
8843
Vladimir Pivovar
July 05, 2013 11:26PM
Re: Create index on parttion table (manually and dynamically)
2848
Rick James
July 06, 2013 10:52PM
Re: Create index on parttion table (manually and dynamically)
2562
Vladimir Pivovar
July 07, 2013 12:20AM
Re: Create index on parttion table (manually and dynamically)
2211
Vladimir Pivovar
July 07, 2013 10:57AM
Re: Create index on parttion table (manually and dynamically)
2430
Rick James
July 08, 2013 09:46AM
Re: Create index on partition table (manually and dynamically)
2748
Vladimir Pivovar
July 10, 2013 02:23PM


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.