I have been running a server for almost 2 years completely without incident. I have made no significant changes recently, but for the past month or so I have been having connection problems. Users cannot connect, but existing connections seem to be maintained.
Here are some symptoms: I cannot stop the server using mysqladmin. It hangs (I've let it run for an hour) and cannot be interrupted with ctrl-c. The error log shows "too many open files" ps aux | grep mysql shows a constantly increasing number of mysql processes: mysqluser 11894 0.0 7.5 34692 9692 pts/1 S 11:21 0:00 /usr/local/mysql/ There are 600 of them right now :( I'm at a loss as to how to effectively troubleshoot this. Does anyone have any suggestions? The version is 3.23.37 running on RedHat Regards, Gary H. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
