MySQL Forums
Forum List  »  MyISAM

Re: large table indexing problem
Posted by: geonjae yu
Date: January 29, 2012 07:39PM

>> 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.
yes, you are right. I'm mistake.
6~7 of the 8 cores are idle.

> SHOW CREATE TABLE -- that would give us some more clues.
Not something stragne.

> How is the I/O? If one CPU is at 100%, then I would expect the I/O to be very low.
yes. I/O is very very low. 0.05 wMB/s or less. MySQL use 100% cpu using 1~2 core.

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

Thanks Rick.

Options: ReplyQuote

Written By
January 26, 2012 08:12PM
January 27, 2012 08:38PM
Re: large table indexing problem
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.