MySQL Forums :: MyISAM :: large table indexing problem

Advanced Search

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

Subject Views Written By Posted
large table indexing problem 2792 geonjae yu 01/26/2012 08:12PM
Re: large table indexing problem 1412 Rick James 01/27/2012 08:38PM
Re: large table indexing problem 1285 geonjae yu 01/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.