From: Dan Nelson
Date: December 3 2002 5:27pm
Subject: Re: sleeping threads problem
List-Archive: http://lists.mysql.com/mysql/126436
Message-Id: <20021203172738.GE3438@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Dec 03), cristian ditoiu said:
> Hello , i  use MySql 3.23.49-log with Php 4.2.1on RH 7.2 .
> The problem is that i got many many (16-30) sleeping threads almost all the
> time . The code is pretty clean , and i suspect
> that those threads are sleaping beacuse of some strange ascii characters
> (like CR) .
> Is any intelegent way to find out WHY are those threads sleeping ?

They are sleeping because you have not given them a query to process. 
Sleeping threads are idle connections.

-- 
	Dan Nelson
	dnelson@stripped