I'm connecting against oracle. So for every request it establish the connection and it remains stable even though the request has been completed successfully .
-Raja -----Original Message----- From: David E. Wheeler [mailto:da...@kineticode.com] Sent: Tuesday, November 10, 2009 11:03 PM To: Kulasekaran, Raja Cc: Artem Kuchin; modperl@perl.apache.org Subject: Re: DBI Connectons accumulate under Mod_perl On Nov 10, 2009, at 9:19 AM, Kulasekaran, Raja wrote: > I'm using Apache::DBI and DBI->connect (persistence connection) > > So, Do I need to call $dbh->disconnect() for each child to close the > connection ? No, because Apache::DBI turns it into a no-op. Apache::DBI is a very weird beast, with unanticipated action-at-a-distance issues that crop up here and there. It's crazy stuff like this that led me to abandon it -- at first for DBI->connect_cached (though I had to do some extra work to make sure it was safe), and more recently for DBIx::Connector, which does that extra work for me. Can you see what PIDs MySQL is accepting connections from? Are they the same as currently-running Apache processes? Or are (some of them) from dead Apache child processes? Best, David