PHP Adodb 许多休眠连接 [英] PHP Adodb many sleeping connections

问题描述

目前正在努力解决一个奇怪的问题:在使用 adodb 作为 php 的连接层时，它留下了许多休眠和不需要的连接.wait_timeout 设置为 20 但由于系统负载高，仍有大量(~100)睡眠连接.MySQL 版本:5.5.24-0ubuntu0.12.04.1

Currently struggeling with a strange problem: while using adodb as connection layer for php, it leaves many sleeping and unneeded connections behind. wait_timeout is set to 20 but there are still plenty (~100) of sleeping connections due to high load on the system. MySQL Version: 5.5.24-0ubuntu0.12.04.1

是否存在有关 adodb5 和睡眠连接的已知错误?我不使用持久连接！连接建立:

Is there a known bug regarding adodb5 and sleeping connections? I'm not using persistent connections! Connection establishment:

$conn = &ADONewConnection($DBTYPE);
$conn->Connect($DBHOST, $DBUSER, $DBPASSWORD, $DBNAME)

非常感谢有关如何减少休眠连接数的任何提示/建议.

Would really appreciate any hints/suggestions how to reduce sleeping connection count.

推荐答案

好了终于找到问题了:vhost 文档根目录位于 nfs 安装(远程)上.这个挂载有一些 IO 问题，这导致 apache 空闲"连接，直到 nfs 挂载再次准备就绪.

Okay finally found the problem: vhost document root was on an nfs mount (remote). this mount had some IO issues which provoked apache to "idle" connections until the nfs mount is ready again.

这篇关于PHP Adodb 许多休眠连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！