#42665 [Fbk->Opn]: PDO_MYSQL no persistent but idle connections

ID: 42665 User updated by: vgass at gmx dot de Reported By: vgass at gmx dot de -Status: Feedback +Status: Open Bug Type: PDO related Operating System: Linux (Debian) PHP Version: 5.2.4 New Comment: I have to correct: there is not one idle process per call, but idle processes accumulating. No change with current snapshoot! Additionaly: please add something like "mysql.allow_persistent" and "mysql.max_persistent" for mysqli and PDO_MYSQL as a feature request. As an ISP we need a little control and influence... And please excuse my bad English - I have nearly no more speaking/ writing practice since my school days 25 years ago. Previous Comments: ------------------------------------------------------------------------ [2007-09-16 15:33:30] iliaa@php.net Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows (zip): http://snaps.php.net/win32/php5.2-win32-latest.zip For Windows (installer): http://snaps.php.net/win32/php5.2-win32-installer-latest.msi ------------------------------------------------------------------------ [2007-09-14 05:44:10] vgass at gmx dot de - ------------------------------------------------------------------------ [2007-09-14 05:19:05] vgass at gmx dot de Description: ------------ With an attempt to use PDO_MYSQL with PDO::ATTR_PERSISTENT => true I stated coincidentally that no persistent connections were used, but dozens idle "hanging" processes had remained open: one process for one call to "new PDO(...)"! As an ISP this is catastrophic and we are missing the possibility to disable persistant connections as with mySQL. (settings like "mysql.allow_persistent" and "mysql.max_persistent") mySQL: 4.0.25 Thanks for any help you can provide. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=42665&edit=1