MySQL Forums
Forum List  »  Performance

Slow index build on 77 million row table
Posted by: Todd Schmitter
Date: December 17, 2004 06:54AM

We have been using mysql (4.1.7-standard) successfully for about 1 year to store system performance data. Our largest table is 22GB with 77 million rows. I am currently attempting to create a new index on one column of this table and the index build has been running for over 12 hours. Is this to be expected, and, if so, why is the create index process so slow?

Options: ReplyQuote

Written By
Slow index build on 77 million row table
December 17, 2004 06:54AM

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.