From: Operating system: Any PHP version: 5.2.14 Package: MySQLi related Bug Type: Bug Bug description:Improper connection closing logic leads to TIME_WAIT sockets on server
Description: ------------ Similarly to connector/j bug reported here: http://bugs.mysql.com/bug.php? id=56979, there is a problem with mysql disconnection logic where the TCP connection TIME_WAIT state is found on the server rather than on the client. With multiple clients and multiple connection, the MySQL server can run out of file descriptors quickly. The disconnect method should first set EOF to its input, then send the QUIT command, then set its output to EOF, then close the socket Note: I guess the same bug appears in MySQL-non-i as well -- Edit bug report at http://bugs.php.net/bug.php?id=52948&edit=1 -- Try a snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=52948&r=trysnapshot52 Try a snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=52948&r=trysnapshot53 Try a snapshot (trunk): http://bugs.php.net/fix.php?id=52948&r=trysnapshottrunk Fixed in SVN: http://bugs.php.net/fix.php?id=52948&r=fixed Fixed in SVN and need be documented: http://bugs.php.net/fix.php?id=52948&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=52948&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=52948&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=52948&r=needscript Try newer version: http://bugs.php.net/fix.php?id=52948&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=52948&r=support Expected behavior: http://bugs.php.net/fix.php?id=52948&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=52948&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=52948&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=52948&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=52948&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=52948&r=dst IIS Stability: http://bugs.php.net/fix.php?id=52948&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=52948&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=52948&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=52948&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=52948&r=mysqlcfg