--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > I've read others who've said it fixed the problem > for them. Did you > check the archives?
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