Bug #51605 [Csd]: Mysqli - zombie links

Edit report at https://bugs.php.net/bug.php?id=51605&edit=1 ID: 51605 User updated by: bastard dot internets at gmail dot com Reported by: bastard dot internets at gmail dot com Summary: Mysqli - zombie links Status: Closed Type: Bug Package: MySQLi related Operating System: vistax64 PHP Version: 5.3.2 Assigned To: mysql Block user comment: N Private report: N New Comment: Corrected issue for http://www.afateam.org/ with exceeding process issues. Previous Comments: ------------------------------------------------------------------------ [2010-05-13 13:06:02] andrey@php.net Automatic comment from SVN on behalf of andrey Revision: http://svn.php.net/viewvc/?view=revision&revision=299336 Log: Somehow missed to commit this, for better fix for #51605 ------------------------------------------------------------------------ [2010-05-13 13:05:11] andrey@php.net Automatic comment from SVN on behalf of andrey Revision: http://svn.php.net/viewvc/?view=revision&revision=299335 Log: Better fix for #51605 ------------------------------------------------------------------------ [2010-05-11 12:04:28] andrey@php.net Fix will appear in 5.3.3. Thanks for reporting this. ------------------------------------------------------------------------ [2010-05-11 12:03:19] andrey@php.net Automatic comment from SVN on behalf of andrey Revision: http://svn.php.net/viewvc/?view=revision&revision=299239 Log: Fix for bug #51605 (Mysqli zombie links) ------------------------------------------------------------------------ [2010-04-24 04:40:58] bastard dot internets at gmail dot com Found a temporary solution - actually use real persistent connections: append "p:" to the hostname on mysqli::__connect(), set "mysqli.allow_persistent = On", set "mysqli.max_persistent = 1", and use all default mysql connection timeout settings. This correctly reuses the single active persistent link and established tcp socket connection for all page loads for as long as the connection timeout settings allow. Either that or revert to using the regular mysql extension. This doesn't take care of the growing number of active, permanent, non-persistent links spawned by any regular mysqli connection though. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=51605 -- Edit this bug report at https://bugs.php.net/bug.php?id=51605&edit=1