RE: DBI Connectons accumulate under Mod_perl

2009-11-10 Thread Kulasekaran, Raja
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: K

Re: FreeBSD 7.2, mod_perl2 & Apache2::Cookie (libapreq2)

2009-11-10 Thread Joe Niederberger
Well, I didn't make the changes myself - they were done by Datapipe staff who run a server for me. The route taken was extreme - they basically de-installed all packages and reinstalled. There may be better ways to go about it. Joe N. - Original Message - From: "Foo JH" To: "Joe Niederb

Re: FreeBSD 7.2, mod_perl2 & Apache2::Cookie (libapreq2)

2009-11-10 Thread Foo JH
Hello Joe, Do you think you can post the changes that need to be made here, for us to reference when we hit the same problem? Thanks. Joe Niederberger wrote: Thanks to everyone who contributed their insights to this thread - I did get in touch with Mr. Galucci - and he did help straighten ou

Re: DBI Connectons accumulate under Mod_perl

2009-11-10 Thread David E. Wheeler
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

RE: DBI Connectons accumulate under Mod_perl

2009-11-10 Thread Kulasekaran, Raja
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 ? Raja . -Original Message- From: David E. Wheeler [mailto:da...@kineticode.com] Sent: Tuesday, November 10, 2009 10:43 PM To: Artem Kuchin

Re: DBI Connectons accumulate under Mod_perl

2009-11-10 Thread David E. Wheeler
On Nov 10, 2009, at 7:04 AM, Artem Kuchin wrote: > You mean each child process creates a new database CONNECTION (not process) ? > The process is just one multhreaded mysql. But this is exactly what i want. I > do not want any > connection sharing because of the locking issues (lock tables). But

Re: DBI Connectons accumulate under Mod_perl

2009-11-10 Thread Artem Kuchin
Kulasekaran, Raja: 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 abou