与MySQL服务器进行大量睡眠连接的可能原因?

时间:2022-10-02 21:07:32

What are possible causes for a large number of sleeping connections to a MySQL Server? I'm using CodeIgniter with persistent connections disabled.

与MySQL服务器进行大量睡眠连接的可能原因是什么?我正在使用禁用持久连接的CodeIgniter。

3 个解决方案

#1


2  

Even though the app doesn't keep the connection open, the OS lets it hang around. See http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/

即使应用程序没有保持连接打开,操作系统也会让它闲置。见http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/

#2


0  

could be a timeout issue

可能是超时问题

#3


0  

Doesn't code igniter use a connection pool by default? If so, it will grab a bunch and hang on to them till it needs them.

代码点火器默认使用连接池吗?如果是这样的话,它会抓住一堆并坚持下去,直到需要它们为止。

#1


2  

Even though the app doesn't keep the connection open, the OS lets it hang around. See http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/

即使应用程序没有保持连接打开,操作系统也会让它闲置。见http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/

#2


0  

could be a timeout issue

可能是超时问题

#3


0  

Doesn't code igniter use a connection pool by default? If so, it will grab a bunch and hang on to them till it needs them.

代码点火器默认使用连接池吗?如果是这样的话,它会抓住一堆并坚持下去,直到需要它们为止。