MySQL Forums
Forum List  »  Performance

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/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Slow index build on 77 million row table
2386
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.