>> Apache::DBI will cache connections on a per-connection-string basis, >> once in >> each child process. so, if each connection to a database is made using a >> different username each will be cached and you'll end up with >> users*processes number of cached connections in total.
>> > The problem is that connection number is greater than users*processes! I > have 5 db users(one for each of five sites) and MaxClients = 90 but the > connection count can reach 500 limit easily on workload peaks and is > willing to grow further! This sites are very heavyloaded indeed. > I use Apache 2, mp2.0.1 and Apache::DBI -0.9901 are you using the worker or prefork mpm? are you certain that your connect string is identical in each case (and that means identical - same AutoCommit settings, same user/pass, same _everything_)? --Geoff
