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

作者:简简单单 2016-03-01

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

相关文章

精彩推荐