Is this all true? Bummer. :( I just upgraded to 3.23.53 (from .49). I cannot
afford to get these huge load averages on my news server. Nor can I afford
thread thrashing. I just had to let myself be talked into upgrading. See if
I still have the .49 binary.
Seriously, are there any MySQL developers here on the list who can tell me
why this happens? If at all.
- Mark
System Administrator Asarian-host.org
---
"If you were supposed to understand it,
we wouldn't call it code." - FedEx
----- Original Message -----
From: "heath boutwell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, October 29, 2002 11:34 PM
Subject: Re: Thread Thrashing and 3.23.53a
> Jeremy,
>
> Thanks for mytop. Its a great tool and its been a
> great help in diagnosing our problems.
>
> I saw where a few of the others claimed the latest
> binaries resolved the issues. Its not clear whether
> their problem was the same others were experiencing
> (those whose probs were corrected w/ .53a were
> complaining of 'out of sync' errors which seems
> different than the type of CPU throttling myself and
> others have observed).
>
> Anything over 50 queries a second for even a short
> time brought the cpu to its knees. Mysqld processes
> were eating up all the cpu and the server becomes
> practically non-responsive.
>
> With the older binaries, we avgd 20 queries second
> with bursts up to 200-300 with no problem. The load
> average stayed around .50 or so and went to around 3
> under heaviest load conditions.
>
> With the latest binary (installed under thus far lower
> usage) we are seing 13 queries a second but the load
> average stays at 1.3 which is not a good sign. It
> looks like we will see a meltdown under even moderate
> load conditions.
>
> The weekends our the heaviest times for us and I will
> keep the list posted on what happens as I know there
> were many others that struggled with this over the
> past year and found no resolution other than
> downgrading to ancient versions of the binaries.
>
> Thanks,
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
