PHP 4.0 Bug #6383 Updated: DB Persistent Connection not re-used

ID: 6383 Updated by: kara Reported By: Howard.Cohodas@dkt.com Status: Closed Bug Type: MySQL related Assigned To: Comments: Connections can only be reused in the same process / thread. Since you cannot route requests to specific processes/threads, additional connections are opened while there would be other processes/threads available with already open connections. Previous Comments: --------------------------------------------------------------------------- [2000-10-30 17:12:30] jmoore@php.net Your assumption that I was running in cgi mode is not accurate. I may have failed to mention it in the bug report, but a note to me before you closed the bug would have cleared up the misunderstanding. The problem: In a Windows environment using the ISAPI version of PHP4 with several data bases (MySQL, PostgreSQL) with several servers (IIS, WebSite Pro), persistent connections are not reused and just accumulate forever or whenever the db server is stopped and restarted, whichever comes first. Howard A. Cohodas Design Knowledge Technologies Inc. Phone: (011)(330)492-9900 FAX: (011)(330)492-1100 otfGIF Encoder: http://www.dkt.com/otfGIF --------------------------------------------------------------------------- [2000-10-30 14:45:02] mathieu@php.net Reopened, sorry.. Misassumption on my behave --------------------------------------------------------------------------- [2000-10-30 13:44:30] mathieu@php.net You're using PHP in a CGI environment (php.exe gets ran) Persistent Database connections are not possible for obvious reasons.. It even says in the manual. --------------------------------------------------------------------------- [2000-08-30 09:32:08] Howard.Cohodas@dkt.com Bug persists in PHP4.0.2. --------------------------------------------------------------------------- [2000-08-27 15:27:25] Howard.Cohodas@dkt.com Configuration... php-4.0.2-dev-Win32-24-8-2000.zip WinNT4 SP6a HTTP Server: WebSitePro/2.5.4 mySQL: 3.23.22-beta ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Refer to Bug id #5807. Seems similar. If so then might be OS relateded, not mySQL or PostgreSQL related. Script... <html> <head> <title>DB Persistant Connection Test</title> </head> <body> <?php $db = mysql_pconnect ("localhost", "root") or die ("Could not connect"); if (mysql_create_db ("myXdb")) { print ("Database created successfully"); } else { printf ("Error creating database: %s", mysql_error ()); } print "<br>"; if (mysql_drop_db ("myXdb")) { print "Database dropped successfully"; } else { printf ("Error dropping database: %s", mysql_error ()); } print "<br>"; mysql_close($db); show_source(__FILE__); phpinfo(); ?> </body> </html> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Problem.. Running WinMySQLadmin, observing Processes. Each time the script is run another process is added th the process list. The process goes into Sleep mode. Rather than re-using the idle persistent connection, another process is created. --------------------------------------------------------------------------- The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online. Full Bug description available at: http://bugs.php.net/?id=6383