ID: 38283
Updated by: [EMAIL PROTECTED]
Reported By: sanry at now dot net dot cn
-Status: Open
+Status: Feedback
Bug Type: MySQL related
Operating System: SUSE9.3 x86_64
PHP Version: 5.1.4
New Comment:
Can't reproduce with Apache2.0.55/worker and 5.2-CVS on Intel 64
server.
I get 1 persistent connection per Apache child/thread and this is the
expected result.
Previous Comments:
------------------------------------------------------------------------
[2006-08-01 14:39:35] sanry at now dot net dot cn
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 this bug report at http://bugs.php.net/?id=38283&edit=1
