MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Slow index build on 77 million row table
Posted by: STARYNKEVITCH Basile
Date: December 21, 2004 12:14AM

Todd Schmitter wrote:
> 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?

I think a similar issue was covered on the "General" or "Performance" forum a few weeks ago... (I don't know when & where exactly). IIRC, locking the table should help.

--
Basile STARYNKEVITCH :::: http://starynkevitch.net/Basile/

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Slow index build on 77 million row table
3984
Todd Schmitter
December 17, 2004 06:54AM
Re: Slow index build on 77 million row table
2272
Don Beesing
December 20, 2004 12:51PM
Re: Slow index build on 77 million row table
2218
Todd Schmitter
December 20, 2004 05:18PM
Re: Slow index build on 77 million row table
2443
STARYNKEVITCH Basile
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.