Re: How to flush process which are in sleep state

2004-10-13 Thread Eric Bergen
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 wh

How to flush process which are in sleep state

2004-10-13 Thread Anil Doppalapudi
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:h