Force only one table partition's index to regenerate
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
Subject
Views
Written By
Posted
Force only one table partition's index to regenerate
1673
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.