php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: jeff at spiderinternet dot com
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-2025 The PHP Group
All rights reserved. 		Last updated: Tue May 06 14:01:28 2025 UTC