One thing to look at is the number of connections to the MySQL server. We have seen this problem when the number of connections reaches the limit set by the my.cnf file. One reason for the connections filling up is a long process that locks a much used table. This will cause all new requests for this table to back up.
On 11 Dec 2002 at 11:12, shawn xu wrote: > 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
