MySQL Forums
Forum List  »  MyISAM

Re: large table indexing problem
Posted by: Rick James
Date: January 27, 2012 08:38PM

> most cpu is idling, load average 1.00, 1.00, 1.00
That sounds like a contradiction.
Perhaps you mean that 7 of the 8 cores are idle? That is to be expected. MySQL does not use more than one core for one connection.

SHOW CREATE TABLE -- that would give us some more clues.

How is the I/O? If one CPU is at 100%, then I would expect the I/O to be very low.

> 64GB memory,
> key_buffer_size = 6G
OK.

> Strangely, when I restart mysql, running time is shortened considerably.
That would have killed the ALTER, and you would need to start it over.

Unfortunately, live adding of an index is not yet available. It is possibly coming in future versions of InnoDB. (MyISAM is less likely.)

Options: ReplyQuote


Subject
Views
Written By
Posted
3528
January 26, 2012 08:12PM
Re: large table indexing problem
1799
January 27, 2012 08:38PM
1693
January 29, 2012 07:39PM


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.