It's like each child process create a new database process and it remains stable. Instead of establishing a database connection, there is a possibility to share the connection between the child threads using sqlrelay (http://sqlrelay.sourceforge.net/ ). But I have no idea about sqlrelay.
Is this issue resolved in Mod_perl 2.0? . I have read the article "DB::Pool". Can anyone help me out on this. - Raja -----Original Message----- From: Artem Kuchin [mailto:mat...@itlegion.ru] Sent: Tuesday, October 20, 2009 10:29 PM To: modperl@perl.apache.org Subject: DBI Connectons accumulate under Mod_perl Hello! I have a very weird situation. I use MYSQL. Apache 2.2 with mod_perl2 O use Modperl::RegistryBB to run the script, but the script itself is written very nicely for mod_perl. That is no globals at all. Everything is in sub handler. I do not use Apache::DBI, just plain "use DBI;" So, what it does (basic idea) sub handler { db->connect(); .. does all the thing... db->disconnect(); print $output; } however, whe i do in mysql show processlist; I see many connection hanging in sleep state and they grow and grow slowly! Any idea why this happens? Artem