search

top-think / framework

ThinkPHP Framework
http://www.thinkphp.cn
Other
2.72k stars 1.06k forks source link

用的tp5.1 mysql会出现大量的sleep进程 #2119

Closed tonnychina closed 6 months ago

tonnychina commented 4 years ago

用的tp5.1.38 ，目前项目并发量到100的时候，mysql会出现大量的sleep进程，开启长链接，问题会更严重，mysql设置的wait_timeout 为300 ，环境是php7.2.25 +nginx+php-fpm+mariadb

chunpat commented 4 years ago

tp5.1能开启长连接吗？

pifeifei commented 4 years ago

tp5.1能开启长连接吗？

comfig/databases.php

[
    'params'          => [
        \PDO::ATTR_PERSISTENT => true, // 使用长连接
    ]
];
jin123456bat commented 4 years ago

并发起来了，mysql出现大量sleep是正常的呀