List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:February 18 2004 8:36pm
Subject:Re: SHOW PROCESSLIST
View as plain text  
Hi,

> > > I executed a SHOW PROCCESSLIST command and
> > > it returned me 39 rows which 21 of than show "Sleep"
> > > in the column "Command".
> > >
> > > What does this tell me?
> >
> > 21 threads are idle.
>
> But, what could make so many threads get idle?

Connecting, but don't doing anything.

> Shouldn´t the queries just be executed, return the results and
> be closed?

If you don't close your connection, what do you expect?

> Does this mean some kind of congestion or it is normal?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

Thread
SHOW PROCESSLISTRonan Lucio18 Feb
  • Re: SHOW PROCESSLISTJeremy Zawodny18 Feb
  • Re: SHOW PROCESSLISTRonan Lucio18 Feb
  • Re: SHOW PROCESSLISTMartijn Tonies18 Feb
  • Re: SHOW PROCESSLISTRonan Lucio18 Feb
  • Re: SHOW PROCESSLISTMartijn Tonies18 Feb