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: MyS
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 fo
> On Wed, Dec 11, 2002 at 11:12:33AM -0500, 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 an
On Wed, Dec 11, 2002 at 11:12:33AM -0500, 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,
