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

ID: 10841 User Update by: Thomas.Lamy@netwake.de 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] 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()); } --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=10841