From: Martijn Tonies
Date: February 18 2004 8:58pm
Subject: Re: SHOW PROCESSLIST
List-Archive: http://lists.mysql.com/mysql/159951
Message-Id: <105001c3f661$fdbcdf20$0e02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

Hi Ronan,

> > > > 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?
>
> Itīs a website, so itīs possible that the users closed his browsers
> before the query finishes?

I don't know - that all depends on how you coded your back-end.

For example: if I write a cgi-bin in Delphi, and a user closed the
browser while waiting for a result, I'm sure the cgi-bin gets cleaned
up and I can close the connection in my executable.



With regards,

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