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

热门教程

php的慢速日志引起的Mysql2013错误原因分析

时间:2022-06-24 18:44:38 编辑:袖梨 来源:一聚教程网

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

热门栏目