Edit report at http://bugs.php.net/bug.php?id=51605&edit=1
ID: 51605 Updated by: and...@php.net Reported by: bastard dot internets at gmail dot com Summary: Mysqli - zombie links -Status: Assigned +Status: Closed Type: Bug Package: MySQLi related Operating System: vistax64 PHP Version: 5.3.2 Assigned To: mysql New Comment: Fix will appear in 5.3.3. Thanks for reporting this. Previous Comments: ------------------------------------------------------------------------ [2010-05-11 12:03:19] and...@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. ------------------------------------------------------------------------ [2010-04-24 00:40:16] bastard dot internets at gmail dot com No Windows snapshots are currently available on http://windows.php.net/snapshots/ or http://windows.php.net/downloads/snaps/. Should I instead downgrade to PHP 5.2.13 release? ------------------------------------------------------------------------ [2010-04-23 22:14:36] fel...@php.net Please try using this snapshot: http://snaps.php.net/php5.3-latest.tar.gz For Windows: http://windows.php.net/snapshots/ ------------------------------------------------------------------------ [2010-04-22 02:53:02] bastard dot internets at gmail dot com Just to clarify - this is a closed server and db dev environment, and I'm the only one running the above script or connecting to the Mysql server. The 'too many links' PHP error would be expected if multiple users were hitting the page at the exact same time. But not expected if it's just me hitting refresh every once in a while. ------------------------------------------------------------------------ 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 http://bugs.php.net/bug.php?id=51605 -- Edit this bug report at http://bugs.php.net/bug.php?id=51605&edit=1
