Date: 01/18/06 (MySQL Communtiy)    Keywords: php, mysql, sql

good evening! has anybody ever seen mysql clients (mysql, php, check_mysql(nagios), etc) choke with an error similar to 'can't assign requested address' ? I've got over 30,000 connections listed in netstat with a status of TIME_WAIT. fairly basic php/mysql site (high traffic), no apparent cause.

possible causes I've thought of:

- maybe somebody initiated a connection but didn't close it.. thrwarted due to the mysql reporting otherwise.
- mysql being retarded? not likely, when the error occurs, no incoming connection is reached by the mysql server (via tcpdump/ngrep), resource usage on the server is fine. same with the process list.
- max files being reached?

any thoughts? :D

Source: http://www.livejournal.com/community/mysql/82879.html