MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: Building Indexes across partitioned tables longer each day
Posted by: Edward Capriolo
Date: December 23, 2009 12:30PM

We found the problem. Even though many articles on the internet suggests:

alter table disable keys
bulk load
alter table disable keys

That mysql will only rebuild affected indexes, this is not true. MySQL we rebuild all indexes, even if we only insert data into one partition.

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


Subject
Views
Written By
Posted
Building Indexes across partitioned tables longer each day
4302
Edward Capriolo
December 21, 2009 10:46AM
Re: Building Indexes across partitioned tables longer each day
2366
Mattias Jonsson
December 22, 2009 02:48AM
Re: Building Indexes across partitioned tables longer each day
2497
Rick James
December 22, 2009 10:17PM
Re: Building Indexes across partitioned tables longer each day
2311
Edward Capriolo
December 23, 2009 12:30PM


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.