php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #10841 Only last(?) of multiple mysql_pconnect() connections get reused
Submitted: 2001-05-13 18:50 UTC Modified: 2001-06-12 17:23 UTC
From: Thomas dot Lamy at netwake dot de Assigned:
Status: Closed Package: MySQL related
PHP Version: 4.0.4 OS: Linux 2.2.19
Private report: No CVE-ID: None
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: Thomas dot Lamy at netwake dot de
New email:
PHP Version: OS:

 

 [2001-05-13 18:50 UTC] Thomas dot Lamy at netwake dot de
After doing multiple (say 3) mysql_pconnect() from within
one page, as suspected the number of mysql threads
increases, but only the last connection made is being reused
by subsequent calls to mysql_pconnect from other pages/requests.
This is a bit unconfirmed, since I don't have the time and
resources right now, but tests on a production site (which
has crashed very often the last time) showed that the
following code cut down the number of mysql threads at least
tenfold:

if (!@mysql_select_db ("test")) {
  mysql_pconnect("db","user","pass") or die ("No
DB:".mysql_error());
  mysql_select_db ("test") or die ("database does not exist:
".mysql_error());
}


Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-05-14 07:18 UTC] sniper@php.net
Please try PHP 4.0.5

--Jani

 [2001-05-14 07:54 UTC] Thomas dot Lamy at netwake dot de
Ok, hang on 'till weekend (production site update neccessary :-/)

Thomas
 [2001-05-23 01:46 UTC] sniper@php.net
Still waiting for the test results...

 [2001-06-12 17:23 UTC] sniper@php.net
Reopen if this happens with PHP 4.0.6RC3:

http://www.php.net/~andi/php-4.0.6RC3.tar.gz

--Jani

 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Mon May 05 18:01:29 2025 UTC