Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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: 5.5.24-0ubuntu0.12.04.1

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 apache2 and lighty, loadbalancer and firewall in front, nfs mount with document root and virtual machine with mysql.

Got a huge amount of connections to the database:

863 <db01>

other machine:

476 <db01>

Strange thing: there are only 3-6 active processes on the database - the other ones are sleeping.

share|improve this question

1 Answer 1

up vote 0 down vote accepted

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.