From: sanry at now dot net dot cn
Operating system: SUSE9.3
PHP version: 5.1.4
PHP Bug Type: MySQL related
Bug description: mysql_pconnect !!
Description:
------------
more than 6000 CLOSE_WAIT
when using mysql_pconnect
but mysql_connect is just 200,
MySQL server and PHP not in the same server.
MySQL server total 300 network connection
when php WEB server has 6000 CLOSE_WAIT .
Reproduce code:
---------------
1 0 61.145.112.137:40384 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:40372 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:40340 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:40322 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:40029 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:40015 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:39987 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:39986 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:39990 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:39989 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:39988 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:39939 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:40152 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:40149 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:40148 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:40122 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38769 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38780 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38734 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38689 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38674 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38687 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38659 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38894 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38860 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38861 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38842 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38843 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38846 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38787 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38796 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38527 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38469 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38451 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38416 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38424 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38645 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38592 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38600 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38576 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38587 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38548 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38533 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38539 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38386 61.145.112.136:3306
CLOSE_WAIT
tcp 1 0 61.145.112.137:38392 61.145.112.136:3306
CLOSE_WAIT
--
Edit bug report at http://bugs.php.net/?id=38280&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=38280&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=38280&r=trysnapshot52
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=38280&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=38280&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=38280&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=38280&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=38280&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=38280&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=38280&r=support
Expected behavior: http://bugs.php.net/fix.php?id=38280&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=38280&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=38280&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=38280&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=38280&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=38280&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=38280&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=38280&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=38280&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=38280&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=38280&r=mysqlcfg
