Bug #14149 Updated: Loses Track of Persistent Connections
| From: | derick@php.net | Date: | Tue, 20 Nov 2001 17:15:36 +0000 |
| Subject: | Bug #14149 Updated: Loses Track of Persistent Connections | ||
| References: | 1 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-71100@lists.php.net to get a copy of this message | ||
ID: 14149
Updated by: derick
Reported By: craigawlin@wvhmhc.org
Old Status: Duplicate
Status: Closed
Bug Type: MySQL related
Operating System: Win2000
PHP Version: 4.0.6
New Comment:
THis is not a bug, the MySLQ extneion will open a new connection if the _current apache child_ has
no open connection to MySQL.
With this in mind, it's very normal to see that apache has multiple connections open to MySQL.
Derick
Previous Comments:
------------------------------------------------------------------------
[2001-11-20 11:01:08] sander@php.net
Dupe of 13589
------------------------------------------------------------------------
[2001-11-20 09:52:04] craigawlin@wvhmhc.org
Running Apache 1.3.20 with php 4.0.6
MySQL 3.23.42nt running on the same machine.
I have 2 accounts which pconnect to mySQL. It looks like php is forgetting it has connections open
when pconnect is called, and opening duplicates, as the MySQL process table gets filled up.
(Made worse since MySQL seems to ignore its wait_timeout setting!)
------------------------------------------------------------------------
Edit this bug report at http://bugs.php.net/?id=14149&edit=1