php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #4549 MySQL pconnect
Submitted: 2000-05-22 16:09 UTC Modified: 2001-02-10 15:39 UTC
From: jeff at spiderinternet dot com Assigned:
Status: Closed Package: MySQL related
PHP Version: 3.0.14 OS: BSDI 4
Private report: No CVE-ID: None
 [2000-05-22 16:09 UTC] jeff at spiderinternet dot com
mysql_pconnect is creating a new connection to mysql when it is run on a child process that doesn't already have a connection to the mysql server.

We are running Apache 1.3.11 with a minimum of 50 child processes due to the amount of traffic and have been able to replicate this on another server as well.

Eventually it creates too many persistent connections and overloads the mysql server.

We have turned off mysql.allow_persistent in the php3.ini but find this to be a workaround and not a fix. 

Please let us know what you know about this.

Thanks,

Jeff

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-02-10 15:39 UTC] jimw@php.net
that is what is supposed to happen. persistent connections are per-child.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Mar 29 14:01:28 2024 UTC