Hi, Check the description and the comments on www.php.net/manual/en/features.persistent-connections.php there is a very good explanation of this problem.
The basic idea is that mysql_pconnect() will not reuse connections opened by different httpd processes. If you don't expect more than 100 concurrent connections stick to the mysql_connect function() Hope this helps Dobromir Velev Web Developer http://www.websitepulse.com/ -----Original Message----- From: Markus Bruder <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, December 11, 2001 18:04 Subject: [PHP-DB] problem with pconnect >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] > > -- 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]
