Return-Path: Delivered-To: apmail-perl-modperl-archive@www.apache.org Received: (qmail 26250 invoked from network); 20 Oct 2009 16:59:47 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 20 Oct 2009 16:59:47 -0000 Received: (qmail 96575 invoked by uid 500); 20 Oct 2009 16:59:45 -0000 Delivered-To: apmail-perl-modperl-archive@perl.apache.org Received: (qmail 96538 invoked by uid 500); 20 Oct 2009 16:59:45 -0000 Mailing-List: contact modperl-help@perl.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Delivered-To: mailing list modperl@perl.apache.org Received: (qmail 96530 invoked by uid 99); 20 Oct 2009 16:59:44 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Oct 2009 16:59:44 +0000 X-ASF-Spam-Status: No, hits=-2.6 required=5.0 tests=BAYES_00 X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [84.21.226.211] (HELO corpmail.itlegion.ru) (84.21.226.211) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 20 Oct 2009 16:59:42 +0000 Received: (qmail 18804 invoked from network); 20 Oct 2009 20:59:17 +0400 Received: from unknown (HELO ?192.168.0.12?) (192.168.0.12) by 84.21.226.211 with SMTP; 20 Oct 2009 20:59:17 +0400 Message-ID: <4ADDEC61.2080300@itlegion.ru> Date: Tue, 20 Oct 2009 20:59:13 +0400 From: Artem Kuchin Organization: IT Legion User-Agent: Thunderbird 2.0.0.23 (Windows/20090812) MIME-Version: 1.0 To: "modperl@perl.apache.org" Subject: DBI Connectons accumulate under Mod_perl Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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