ID: 10841
User Update by: [EMAIL PROTECTED]
Old-Status: Feedback
Status: Open
Bug Type: MySQL related
Operating system: Linux 2.2.19
PHP Version: 4.0.4
Description: Only last(?) of multiple mysql_pconnect() connections get reused
Ok, hang on 'till weekend (production site update neccessary :-/)
Thomas
Previous Comments:
---------------------------------------------------------------------------
[2001-05-14 07:18:41] [EMAIL PROTECTED]
Please try PHP 4.0.5
--Jani
---------------------------------------------------------------------------
[2001-05-13 18:50:59] [EMAIL PROTECTED]
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());
}
---------------------------------------------------------------------------
Full Bug description available at: http://bugs.php.net/?id=10841
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
