From: Eric Bergen
Date: October 14 2004 12:06am
Subject: Re: How to flush process which are in sleep state
List-Archive: http://lists.mysql.com/mysql/174146
Message-Id: <11b1bd9904101317065bf42905@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Sleeping 'processes' are connections left open by clients. Simply
change your clients to close the connection whent hey are done (don't
use pconnect). Also your wait_timeout is probably still set to the
default 28800 seconds. This should be set to match the idle timeout of
your client (apache or whatever)

-Eric


On Wed, 13 Oct 2004 16:48:21 +0530, Anil Doppalapudi
<adoppalapudi@stripped> wrote:
> Hi,
> 
> when i issue show processlist command it gives very long list of process
> most of them are sleep state .
> is there a way to clear those processs with out killing them
> 
> Thanks in advace
> ANil
> DBA
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=eric.bergen@stripped
> 
> 


-- 
Eric Bergen
eric.bergen@stripped