Bug #10841 Updated: Only last(?) of multiple mysql_pconnect() connections get reused

ID: 10841 Updated by: sniper Reported By: Thomas.Lamy@netwake.de Old-Status: Feedback Status: Closed Bug Type: MySQL related Operating system: PHP Version: 4.0.4 Assigned To: Comments: Reopen if this happens with PHP 4.0.6RC3: http://www.php.net/~andi/php-4.0.6RC3.tar.gz --Jani Previous Comments: --------------------------------------------------------------------------- [2001-05-23 01:46:46] sniper@php.net Still waiting for the test results... --------------------------------------------------------------------------- [2001-05-14 07:54:17] Thomas.Lamy@netwake.de Ok, hang on 'till weekend (production site update neccessary :-/) Thomas --------------------------------------------------------------------------- [2001-05-14 07:18:41] sniper@php.net Please try PHP 4.0.5 --Jani --------------------------------------------------------------------------- [2001-05-13 18:50:59] Thomas.Lamy@netwake.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()); } --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=10841&edit=2