From: sanry at now dot net dot cn Operating system: SUSE9.3 x86_64 PHP version: 5.1.4 PHP Bug Type: MySQL related Bug description: mysql_pconnect can't reuse the connections
Description: ------------ mysql_pconnect create too many connections , not using the same connection in x86_64 (web server and mysql server not in the same computer) I have test in 32bit system is okay, both using the same mysql5.0.22 Reproduce code: --------------- <?php function getmicrotime(){ list($usec, $sec) = explode(" ",microtime()); return ((float)$usec + (float)$sec); } flush(); $t1=getmicrotime();//start time $db=mysql_pconnect("61.145.112.136", "test", "test"); if($db) echo $i.'connect successfully<br/>'; echo mysql_stat($db).'<br/>'; $t2=getmicrotime(); $tt=$t2-$t1; $sql="SHOW PROCESSLIST "; $res=mysql_query($sql); if($res){ $dbstatus=mysql_num_rows($res); }else $dbstatus=mysql_error(); //mysql_close($db); echo "there are ".$dbstatus." connections "; echo "time for connect is $tt ***"; ?> -- Edit bug report at http://bugs.php.net/?id=38283&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=38283&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=38283&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=38283&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=38283&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=38283&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=38283&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=38283&r=needscript Try newer version: http://bugs.php.net/fix.php?id=38283&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=38283&r=support Expected behavior: http://bugs.php.net/fix.php?id=38283&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=38283&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=38283&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=38283&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=38283&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=38283&r=dst IIS Stability: http://bugs.php.net/fix.php?id=38283&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=38283&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=38283&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=38283&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=38283&r=mysqlcfg