Bug #13589: Persistent connections stay open and accumulate

From: mtremblay@sitebrand.com Operating system: RedHat 7.1 PHP version: 4.0.6 PHP Bug Type: MySQL related Bug description: Persistent connections stay open and accumulate While trying to use persistent connections for performance on an ad server, connections to the MySQL server stay open and accumulate over time until it hits the max_connections setting is hit. Once this happens, MySQL refuses to allow connections. After looking at the MySQL process list, it seams that connections are not always recycled. In theory, idle established connections' Commands should be "Sleep" but curiously, it looks like connections not being recycled have "Query" command and a state of "NULL". Presently using MySQL 3.23.36. -- Edit bug report at: http://bugs.php.net/?id=13589&edit=1