一聚教程网:一个值得你收藏的教程网站

最新下载

热门教程

php的慢速日志引起的Mysql 2013错误怎么办

时间:2015-08-05 编辑:简简单单 来源:一聚教程网


Description:
————
If mysql query is longer as request_slowlog_timeout, connection breaks.

Test script:


// request_slowlog_timeout = 10s  (at /etc/php5/fpm/php-fpm.conf)
 
// $mysqli =
// ...
$query = "SELECT SLEEP (15)";
 
$res = $mysqli->query($query);
if (!$res) {
    echo $mysqli->error; // Error Code: 2013. Lost connection to MySQL server during query
    exit;
}
Expected result:
—————-
connection must be preserved and the request should be executed

热门栏目