Sure I could create an external process that will poll the process list every few minutes but I was hoping for some direction on how to have the MySQL server do it internally. At least that was my impression from reading the docs on the 'wait_timeout' value. Paul
Rudy Metzger <[EMAIL PROTECTED]> wrote: Kill them :) http://www.mysql.com/doc/en/KILL.html Cheers /rudy -----Original Message----- From: PAUL MENARD [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 16:44 To: [EMAIL PROTECTED] Subject: How to terminate dead connections that are in SLEEP? Good morning all, I have a problem with inceasing connection to my database that eventually result in connections being rejected. I know I have an application that is terminating a thread without closing the database handle. Problem is I'm waiting for the fix on some other changes. Here is my reseach. If I check the connections with 'SHOW PROCESSLIST'. I may have 30 connections showing. Some of these show a 'Time' value of 500+ and the 'Command' column reads 'Sleep'. If I check in 15 minutes this same ID will still show as connected but of course the 'Time' value will be greater. So, I checked my variables and for 'wait_timeout' I have this set to '65'. Question is how can I terminate these 'dead' connections? Paul -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
