Already asked the question on stackoverflow but i guess this might be a better place for it.
I'm 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:
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.
Machine Setup: two servers with
lighty, loadbalancer and firewall in front,
nfs mount with document root and virtual machine with
Got a huge amount of connections to the database:
Strange thing: there are only 3-6 active processes on the database - the other ones are sleeping.