Bug #36602 [Com]: "MySQL server has gone away" with PDO::ATTR_PERSISTENT => true

Edit report at https://bugs.php.net/bug.php?id=36602&edit=1 ID: 36602 Comment by: rgagnon24 at gmail dot com Reported by: nerve at gmx dot net Summary: "MySQL server has gone away" with PDO::ATTR_PERSISTENT => true Status: Closed Type: Bug Package: PDO related Operating System: Gentoo Linux PHP Version: 5.1.2 Block user comment: N Private report: N New Comment: It's 2020 and this is still a thing in 7.4.x Previous Comments: ------------------------------------------------------------------------ [2016-03-04 11:35:03] source dot spider at gmail dot com It's 2016 and this is still broken. ------------------------------------------------------------------------ [2006-04-09 08:12:37] wez@php.net Fixed in CVS. ------------------------------------------------------------------------ [2006-03-13 15:47:31] damien dot harper at gmail dot com I'm running a debian box dual Xeon 2 gigs of RAM and powering Apache 2.2.0, PHP 5.1.2, MySQL 5.0.18, PDO_mysql 5.0.18 and getting the same issues. It would be really nice to be able to set the persistent connections lifetime. Otherwise, PDO should be smart enough to autodetect dead connections and avoid to return them. ------------------------------------------------------------------------ [2006-03-08 15:54:03] nerve at gmx dot net Or an other idea, how about the posibility to specify a time after which the persistent connection is closed ? (Aka timeout). I want beleve that mysql is the only pdo backend with useles persistent connections. I (and every other ho is using persistent connections for a big or important aplication) thank you for a good solution. Daniel Heule ------------------------------------------------------------------------ [2006-03-08 15:48:27] nerve at gmx dot net And what is abaut a new method to destroy the death persistent object ? So every user can destroy it and recreate the persistent connection without restarting the webserver ? Not all php users have the choise to restart the webserver if a persistent connection is going to hell ? Thank you Daniel ------------------------------------------------------------------------ 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=36602 -- Edit this bug report at https://bugs.php.net/bug.php?id=36602&edit=1