List:General Discussion« Previous MessageNext Message »
From:Eric Bergen Date:October 14 2004 12:06am
Subject:Re: How to flush process which are in sleep state
View as plain text  
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=1
> 
> 


-- 
Eric Bergen
eric.bergen@stripped
Thread
How to flush process which are in sleep stateAnil Doppalapudi13 Oct
  • Re: How to flush process which are in sleep stateEric Bergen14 Oct