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

作者:袖梨 2022-06-24


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

相关文章

精彩推荐