Re: SHOW PROCESSLIST

[Ronan Lucio]

Jeremy,

> On Wed, Feb 18, 2004 at 04:01:57PM -0300, Ronan Lucio wrote:
> > Hi All,
> >
> > 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?

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

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

Thanks
Ronan