MySQL Forums
Forum List  »  Partitioning

Force only one table partition's index to regenerate
Posted by: Andreas Paepcke
Date: December 18, 2017 05:54PM

I update a partitioned table with a large number
of inserts once a week. New inserts are guaranteed
to enter only into one of the partitions.

For speed I DISABLE KEYS before the insert, then
ENABLE KEYS at the end. From the amount of time it
takes for the index repair I suspect that MySQL rebuilds
index(es) for all partitions, not just the one that
contains new rows; but I'm not sure.

1. How can I tell whether MySQL only re-indexes the partition
that has new rows, and/or
2. How can I convince MySQL only do re-build the needed
index(es) in the one partition?

Any insight is appreciated.

Andreas

Options: ReplyQuote


Subject
Views
Written By
Posted
Force only one table partition's index to regenerate
1715
December 18, 2017 05:54PM


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.