No. We manage http://avantgo.com/frontdoor/ so when it goes down, the site
stops, we panic and restart the db as fast as possible. We think we found a
locking problem in our DBI code that caused a locking issue with our main
User table. If it happens again (God forbid) I'll try 'mysqladmin proc'.
----- Original Message -----
From: Michael Widenius <monty@stripped>
To: David Johnson <davej@stripped>
Sent: Tuesday, May 11, 1999 7:40 AM
> >>>>> "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?
|• Quickie||David Johnson||11 May|
| • Quickie||Michael Widenius||11 May|
| • Re: Quickie||David Johnson||11 May|