I'm facing a problem running mysql on red hat 6.2.
# uname -a Linux dummy2.ezee 2.2.14-12 #1 Tue Apr 25 13:04:07 EDT 2000 i686 unknown
The problem is that after running the mysql server for a while, clients stop getting connections. netstat returns the following:
# netstat -a | grep -E 'mysql.*TIME_WAIT' | wc -l 14605
And those sockets are not getting closed. Not after waiting for 120 secs. Not even 120 minutes! I think the problem is not with mysql but somewhere else. There are only 67 mysql processes running, so I guess the processes that were using these sockets are probably dead already (assuming mysql forks for every connection).
No clue. How do I free these port numbers so that other sockets can be bound to these ports? Or have I got it totally wrong?
Thanks in advance.
Manish
________________________________________________________________________ Looking for a job? Visit Yahoo! India Careers Visit http://in.careers.yahoo.com