Re: large table indexing problem

[geonjae yu]

>> 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.