Slow index build on 77 million row table
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?
Subject
Views
Written By
Posted
Slow index build on 77 million row table
3983
December 17, 2004 06:54AM
2271
December 20, 2004 12:51PM
2217
December 20, 2004 05:18PM
2443
December 21, 2004 12:14AM
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.