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
