Req #66522 [NEW]: Ping functionality

From: myselfasunder at gmail dot com Operating system: Linux PHP version: Irrelevant Package: PDO Core Bug Type: Feature/Change Request Bug description:Ping functionality Description: ------------ There is a problem with persistent MySQL connections, wherein an abrupt, broken, persistent connection raises a "server has gone away" error. Using the original "mysql" or newer "mysqli" extensions, this can be mitigated by doing a "ping" (mysql_ping(), mysqli_ping(), ->ping()) before a query or other operation is attempted. If the connection is healthy, this is a trivial check similar to a standard heartbeat. If the connection has collapsed, it will be automatically reestablished using the original connection information. Currently, PDO does not [obviously] support this. I am recommending that support for this functionality be added to PDO core, and implementations be added for each driver where supported, or be translated to a no-op for those that don't. -- Edit bug report at https://bugs.php.net/bug.php?id=66522&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=66522&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=66522&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=66522&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=66522&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=66522&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=66522&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=66522&r=needscript Try newer version: https://bugs.php.net/fix.php?id=66522&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=66522&r=support Expected behavior: https://bugs.php.net/fix.php?id=66522&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=66522&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=66522&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=66522&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=66522&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=66522&r=dst IIS Stability: https://bugs.php.net/fix.php?id=66522&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=66522&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=66522&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=66522&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=66522&r=mysqlcfg