If you stick with 53a let us know what you see. Others that experienced problems upgrading from .49 reported positive results when trying the 53a binary. --- Mark <[EMAIL PROTECTED]> wrote: > 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, >
__________________________________________________ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ --------------------------------------------------------------------- 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