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,
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,
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.
