Re: Bug #14149: Loses Track of Persistent Connections
| From: | Prottoss | Date: | Tue, 20 Nov 2001 15:45:01 +0000 |
| Subject: | Re: Bug #14149: Loses Track of Persistent Connections | ||
| References: | 1 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-71084@lists.php.net to get a copy of this message | ||
On Tuesday 20 November 2001 09:52, craigawlin@wvhmhc.org wrote:
> From: craigawlin@wvhmhc.org
> Operating system: Win2000
> PHP version: 4.0.6
> PHP Bug Type: MySQL related
> Bug description: Loses Track of Persistent Connections
>
> 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!)
I have the same problem occuring with Running Apache 1.3.20 with php 4.0.6
using MySQL 3.23.43 on Linux (2.4.10). It would appear every time a script is
run a new socket to mysql is open, after the query is finished the socket
just stays open and waits in sleep state (according to mysql's process-list)
until mysql kills when the wait_timeout is reached.
I've switched to using mysql_connect() and the problem has dissapeared. Could
it be that the mysql's socket when using mysql_pconnect() is only shared
within the apache child, thus every child needs to open a new socket to mysql?