Re: large table indexing problem
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.
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.