Bug #9879 Updated: ISAPI Not handleing connections to MySQL correctly
| From: | peter at wowpages dot com | Date: | Wed, 21 Nov 2001 15:46:12 +0000 |
| Subject: | Bug #9879 Updated: ISAPI Not handleing connections to MySQL correctly | ||
| References: | 1 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-71244@lists.php.net to get a copy of this message | ||
ID: 9879
User updated by: peter@wowpages.com
Reported By: peter@wowpages.com
Old Status: Feedback
Status: Open
Bug Type: MySQL related
Operating System: Win NT
PHP Version: 4.0.4pl1
New Comment:
I tried the RC releas, and it seems to work fine. The original code that caused the problem has
been modified, but I made a quick page that does a pconnect and does a query. calling that page
many times, then checking the process list in mysql shows sane values. So it seems resolved.
Thanks very much.
Previous Comments:
------------------------------------------------------------------------
[2001-11-20 19:43:35] mfischer@php.net
Can you try if the problem still persists with latest RC
http://phpuk.org/~james/php-4.1.0RC3-win32.zip
Feedback.
------------------------------------------------------------------------
[2001-03-20 14:28:51] peter@wowpages.com
When running php as an isapi filter, php connects and works properly, but does not reuse persistant
connections so that each page view results in many, many open connections to MySQL server, which
ulitmately results in errors because of too many connections. We're connecting with code such
as this:
$db_link = mysql_pconnect (DB_HOST, USERNAME, PASSWORD)
or die ("Could not connect to database");
Where DB_HOST, USERNAME, and PASSWORD are defined as constants. The php version is 4.4pl1, installed
with the windows installer, using the php4isapa.dll from the zipfile.
------------------------------------------------------------------------
Edit this bug report at http://bugs.php.net/?id=9879&edit=1