Netstat shows numerous CLOSE_WAIT states for mysql connections
- by Sudheer
The output of netstat -an shows many mysql connections in CLOSE_WAIT state and when i checked the processlist in mysql using 'SHOW PROCESSLIST' the connections shown in netstat do not appear. What possible could be the reason for this. I use tomcat with mysql-connector and use a Connection Pool as well.
Is it that the application is not closing the mysql connection or is there any other reason for this behaviour... sometimes the CLOSE_WAIT reaches over 200.
On the application level i made sure that i close all the connections(make sure i issue a close() command in the finally block) created using jdbc.
Any help would be appreciated.