perl dbi 测试 mysql wait_timeout

最新推荐文章于 2022-09-26 08:52:19 发布

weixin_30345577

最新推荐文章于 2022-09-26 08:52:19 发布

阅读量224

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/zhaoyangjian724/p/6199143.html

版权

The number of seconds the server waits for activity on a noninteractive connection before closing it. 


mysql server 等待活动的秒数在一个非交互式的连接在关闭前,超出这个时间就会关闭连接


[root@wx03 mojo]# morbo relink.pl 
Server available at http://127.0.0.1:3000



$a1 is 1.1.1.1
$a2 is aa
$a3 is test
$a1 is 1.1.1.1
$a2 is aa
$a3 is test
$a1 is 1.1.1.1
$a2 is aa
$a3 is test
$a1 is 1.1.1.1
$a2 is aa
$a3 is test


超过8小时候后,再去调用接口,此时报错

DBD::mysql::st execute failed: MySQL server has gone away at /root/mojo/relink.pl line 25.
DBD::mysql::st bind_columns failed: Statement has no result columns to bind (perhaps you need to successfully call execute first, or again) at /root/mojo/relink.pl line 26.
DBD::mysql::st fetch failed: fetch() without execute() at /root/mojo/relink.pl line 27.
DBD::mysql::st execute failed: MySQL server has gone away at /root/mojo/relink.pl line 25.
DBD::mysql::st bind_columns failed: Statement has no result columns to bind (perhaps you need to successfully call execute first, or again) at /root/mojo/relink.pl line 26.
DBD::mysql::st fetch failed: fetch() without execute() at /root/mojo/relink.pl line 27.
DBD::mysql::st execute failed: MySQL server has gone away at /root/mojo/relink.pl line 25.
DBD::mysql::st bind_columns failed: Statement has no result columns to bind (perhaps you need to successfully call execute first, or again) at /root/mojo/relink.pl line 26.
DBD::mysql::st fetch failed: fetch() without execute() at /root/mojo/relink.pl line 27.
DBD::mysql::st execute failed: MySQL server has gone away at /root/mojo/relink.pl line 25.
DBD::mysql::st bind_columns failed: Statement has no result columns to bind (perhaps you need to successfully call execute first, or again) at /root/mojo/relink.pl line 26.
DBD::mysql::st fetch failed: fetch() without execute() at /root/mojo/relink.pl line 27.

转载于:https://www.cnblogs.com/zhaoyangjian724/p/6199143.html