我如何 ping MySQL 数据库并使用 PDO 重新连接
问题描述
我使用 MySQL PDO 来处理数据库查询等.但大多数时候,MySQL 连接消失了.所以我正在查看 PDO,它将检查数据库连接是否存在,如果它不退出,那么我需要连接数据库以继续查询执行.
I am using MySQL PDO for handling database querying and all. But most of the time, the MySQL connection is gone away. So i am looking in the PDO that will check if the db connection is exists or not and if it is not exit, then i need to connect the database to continue the query execution.
我是 MySQL pdo 的新手,我不知道如何处理这种情况.如果有人对此提出建议会更好.
I am new to the MySQL pdo and i do not know how to handling this situation. It would be better if anybody suggest on this.
推荐答案
我试图为同样的问题寻找解决方案,但我找到了下一个答案:
I tried to find a solution for the same problem and I found the next answer:
完整故事在这里:https://terenceyim.wordpress.com/2009/01/09/adding-ping-function-to-pdo/
其他人想使用 PDO::ATTR_CONNECTION_STATUS,但他发现:$db->getAttribute(PDO::ATTR_CONNECTION_STATUS)
即使在停止 mysqld 之后,仍然继续回复Localhost via UNIX socket".
Somebody else was thinking to use PDO::ATTR_CONNECTION_STATUS, but he figured out that: "$db->getAttribute(PDO::ATTR_CONNECTION_STATUS)
keeps replying "Localhost via UNIX socket" even after stopping mysqld".
这篇关于我如何 ping MySQL 数据库并使用 PDO 重新连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!