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?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
