problem with pconnect
| From: | Markus Bruder | Date: | Tue, 11 Dec 2001 15:39:08 +0000 |
| Subject: | problem with pconnect | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14925@lists.php.net to get a copy of this message | ||
Hello all,
I used to following test-script to analyze my problems with
sleeping-MySQL-pconnects:
Script:
<?
require ('database.php');
$sql = "insert into <tablename> ...";
$res = query($sql);
echo "<META HTTP-EQUIV=\"refresh\" CONTENT=\"10; URL=<path to
script>\">";
?>
Required file (database.php):
<?
function query($sql)
{
$hostname = "<databasehostname>";
$username = "<databaseusername>";
$password = "<databasepassword>";
$database = "<database>";
$connect = mysql_pconnect("$hostname","$username","$password");
mysql_select_db("$database",$connect);
$result = mysql_query($sql,$connect);
return $connect;
}
?>
The first browser-connect opens up two processes, which are used every time,
the script reloads itself (rest of time 'Sleep').
The second browser-connect opens up two processes, too.
And so on.
After ending this browser-connects, the processes are all in state 'Sleep'.
Next browser-connect doesn't re-use any of this processes - it opens up two
more.
I thought (according to the php-manual) the pconnect-function would re-use
existing connections, but it doesn't.
Does anybody know how to solve this problem?