MySQL Forums
Forum List  »  Partitioning

Rebuilding vs. Optimizing Partition, Time Elapsed to complete
Posted by: Thomas Lekai
Date: June 07, 2010 04:12PM

I am sure this is a very simple response, and I am racking my brain understanding why this might be such a huge difference in the time elapsed to complete this task.

I am experimenting with a partioned table by key, 800M records spread across 100 partions. An rebuild of one of the partitions (5M records) takes 1.5 minutes. An optimize of the same partition takes 4 hours.

Both statements come from the same machine with no load on the server while the action is being taken. Can someone point me to an answer as to why this happens, and in addition, theh exact mechanical steps that cause the difference in processing times.

If this is just a documentation issue I have missed, a simple link is fine as well.

Thanks as always . . .

Options: ReplyQuote

Written By
Rebuilding vs. Optimizing Partition, Time Elapsed to complete
June 07, 2010 04:12PM

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.