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