Re: problem with pconnect

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 <mbruder@spaun-it.de> To: php-db@lists.php.net <php-db@lists.php.net> 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: php-db-unsubscribe@lists.php.net >For additional commands, e-mail: php-db-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net > >