List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:May 11 1999 2:40pm
Subject:Quickie
View as plain text  
>>>>> "David" == David Johnson <davej@stripped> writes:

David> We had our production database go bezerk and take 100% of the CPU for about 5
> minutes before we had to kill it.  There is speculation that we had some table locking
> contention, but it seems to me that a bad lock wouldn't cause the locked threads to sleep
> and wait instead of eating all the CPU.  Am I right?  

Normally bad locking will put all threads to sleep, but there are
always exceptions to this rule.

Did you manage to do a 'mysqladmin proc' when this happen?

Regards,
Monty

Thread
QuickieDavid Johnson11 May
  • QuickieMichael Widenius11 May
  • Re: QuickieDavid Johnson11 May