Bug #52561 [Wfx]: function mysqli_ping no attempted reconnection!

Edit report at https://bugs.php.net/bug.php?id=52561&edit=1 ID: 52561 Updated by: andrey@php.net Reported by: paulgao at yeah dot net Summary: function mysqli_ping no attempted reconnection! Status: Wont fix Type: Bug Package: MySQL related Operating System: irrelevant PHP Version: 5.3.3 Assigned To: mysql Block user comment: N Private report: N New Comment: It is not implemented because reconnect creates a new connection which has new state and the state of the old connection is gone - session variables, transaction. In this context automatic reconnect is considered dangerous and is disabled since years in libmysql. mysqlnd doesn't provide this for the very same reason. Previous Comments: ------------------------------------------------------------------------ [2014-09-26 23:40:07] jay at grooveshark dot com This caused problems for us trying to upgrade. Why is ping/reconnect considered dangerous? It has been working fine for us problem free for years. ------------------------------------------------------------------------ [2010-08-18 12:23:29] andrey@php.net You are using mysqlnd and it doesn't reconnect. It has no such capability by design. reconnect is off by default since ages and is considered dangerous. Thus, reconnect wasn't implemented in mysqlnd. Ergo, mysqli.reconnect has no meaning. You can either stay with libmysql, which however is not recommended in the long run. Or change your code so you reconnect explicitly. ------------------------------------------------------------------------ [2010-08-14 19:28:48] paulgao at yeah dot net when i use libmysql, sleep 31s+, mysqli_ping() is work, it can reconnection. ------------------------------------------------------------------------ [2010-08-14 18:41:12] kalle@php.net Does this happen with libmysql aswell? ------------------------------------------------------------------------ [2010-08-07 13:41:12] paulgao at yeah dot net and mysql server version 5.1.49. ------------------------------------------------------------------------ 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=52561 -- Edit this bug report at https://bugs.php.net/bug.php?id=52561&edit=1