MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: Create index on parttion table (manually and dynamically)
Posted by: Vladimir Pivovar
Date: July 07, 2013 12:20AM

MySQL Server version 5.5.32
TYPE = MyISAM

help please,
As in my case, to build an index on for each partition (subpartition),
not on single table.

on table 3 billion rows!
If I add new rows on partitioned table, as will be rebuild index?

I want to add new partition (subpartition) and create index on new partition later.

please show me code, how to do it.

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


Subject
Views
Written By
Posted
Create index on partition table (manually and dynamically)
9254
Vladimir Pivovar
July 05, 2013 11:26PM
Re: Create index on parttion table (manually and dynamically)
2949
Rick James
July 06, 2013 10:52PM
Re: Create index on parttion table (manually and dynamically)
2641
Vladimir Pivovar
July 07, 2013 12:20AM
Re: Create index on parttion table (manually and dynamically)
2273
Vladimir Pivovar
July 07, 2013 10:57AM
Re: Create index on parttion table (manually and dynamically)
2526
Rick James
July 08, 2013 09:46AM
Re: Create index on partition table (manually and dynamically)
2859
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.