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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
