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


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to