#38280 [Opn->Bgs]: mysql_pconnect !!

ID: 38280 Updated by: tony2001@php.net Reported By: sanry at now dot net dot cn -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: SUSE9.3 PHP Version: 5.1.4 New Comment: Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Due to the volume of reports we can not explain in detail here why your report is not a bug. The support channels will be able to provide an explanation for you. Thank you for your interest in PHP. Previous Comments: ------------------------------------------------------------------------ [2006-08-01 08:48:12] sanry at now dot net dot cn 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 this bug report at http://bugs.php.net/?id=38280&edit=1