MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Heikki Tuuri Date:July 23 2003 8:30pm
Subject:Re: mysql stops processing
View as plain text  
Joe,

----- Original Message ----- 
From: "Joe Shear" <joe@stripped>
To: "Heikki Tuuri" <Heikki.Tuuri@stripped>
Cc: <mysql@stripped>
Sent: Wednesday, July 23, 2003 11:23 PM
Subject: Re: mysql stops processing


>
>
> On Wed, 2003-07-23 at 13:11, Heikki Tuuri wrote:
> > Joe,
> >
> > ----- Original Message ----- 
> > From: "Joe Shear" <joe@stripped>
> > To: "Heikki Tuuri" <Heikki.Tuuri@stripped>
> > Cc: <mysql@stripped>
> > Sent: Wednesday, July 23, 2003 11:03 PM
> > Subject: Re: mysql stops processing
...
> > 50 % during the hang? Is mysqld taking that much though it is not
processing
> > anything?
> >
>
> I think its all mysqld -- even when it's not going anything.  Could it
> be thrashing on something?  We don't have our max connections set that
> high (100).  When we were using 3.23.52, we had really bad problems with
> a similar problem but the CPU usage would hit 100%.  When we upgraded,
> the problem went away for a month.

The 'thread thrashing' problem of 2002 caused CPU usage to increase by a
factor of 100, but it did not stop processing completely.

Anyway, we need the diagnostic outputs to conclude anything further.

Regards,

Heikki


Thread
mysql stops processingJoe Shear23 Jul
RE: mysql stops processingAndrew Braithwaite23 Jul
  • RE: mysql stops processingJoe Shear23 Jul
  • HELP WITH mySQL!!!Michael C. Podlesny23 Jul
    • Re: HELP WITH mySQL!!!Nils Valentin24 Jul
Re: mysql stops processingHeikki Tuuri23 Jul
  • Re: mysql stops processingJoe Shear23 Jul
Re: mysql stops processingHeikki Tuuri23 Jul
  • Re: mysql stops processingJoe Shear23 Jul
RE: mysql stops processingAndrew Braithwaite23 Jul
Re: mysql stops processingHeikki Tuuri23 Jul
Re: mysql stops processingHeikki Tuuri24 Jul
  • Re: mysql stops processingJoe Shear24 Jul
Re: mysql stops processingHeikki Tuuri24 Jul
Re: mysql stops processingInfo26 Jul
Re: mysql stops processingInfo26 Jul