Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Possible Duplicate:
Huge amount of TIME_WAIT connections says netstat

I have 2167 connections like that:

tcp        0      0 127.0.0.1:34276             127.0.0.1:3306              TIME_WAIT
tcp        0      0 127.0.0.1:34910             127.0.0.1:3306              TIME_WAIT
tcp        0      0 127.0.0.1:3306              127.0.0.1:42749             TIME_WAIT
tcp        0      0 127.0.0.1:34871             127.0.0.1:3306              TIME_WAIT
tcp        0      0 127.0.0.1:34845             127.0.0.1:3306              TIME_WAIT
tcp        0      0 127.0.0.1:34018             127.0.0.1:3306              TIME_WAIT
tcp        0      0 127.0.0.1:35336             127.0.0.1:3306              TIME_WAIT
tcp        0      0 127.0.0.1:34617             127.0.0.1:3306              TIME_WAIT
tcp        0      0 127.0.0.1:3306              127.0.0.1:33750             TIME_WAIT
tcp        0      0 127.0.0.1:34072             127.0.0.1:3306              TIME_WAIT
tcp        0      0 127.0.0.1:34141             127.0.0.1:3306              TIME_WAIT

[root@saritasa semenov]# netstat -an | grep 127.0.0.1 | grep 3306 | wc
1360    8160  121040

Any ideas why and how can I resolve it?

Mysql SHOW PROCESSLIST; does give me just 5 connections. Any ideas?

share|improve this question

marked as duplicate by Michael Hampton, thinice, mulaz, Magellan, Ward Oct 16 '12 at 17:35

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer 1

up vote 1 down vote accepted

lower the following

 /proc/sys/net/ipv4/tcp_fin_timeout

You have so many due it being a security feature for tcp. I forget all the details I just know what the end reason for it was. It's not a big deal to have a lot of time wait's at all

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.