Hi Shawn, Also under BSDi make sure you are not running out of file descriptors. MySQL behaves very badly on BSDi when file descriptors run out!
Ken ----- Original Message ----- From: "shawn xu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 11, 2002 11:12 AM Subject: MySQL eats 99& CPU time problem help > We have MySQL 3.23.53 running on Intel machine with OS > BSDI 4.3. > > The problem happened more often like this. > > MySQL eated up 99% cpu time which was told by running > "top". When this happened, I guess it still answer > queries, but it is too slow to answer, which results > in the customers complaining. > > What we have tried, none of them work except wiping > the disk and reinstalling everything. > > I`d appreciate any suggestions to fix this problem. > > Shawn > > > ______________________________________________________________________ > Post your free ad now! http://personals.yahoo.ca > > -------------------------------------------------------------------- - > 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 > > --------------------------------------------------------------------- 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