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