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
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