FW: DBI Connectons accumulate under Mod_perl

2009-11-13 Thread Kulasekaran, Raja
Sure. I will check it up and come back to this thread again Raja -Original Message- From: Perrin Harkins [mailto:phark...@gmail.com] Sent: Saturday, November 14, 2009 12:14 AM To: Kulasekaran, Raja Cc: Artem Kuchin; modperl@perl.apache.org Subject: Re: DBI Connectons accumulate under M

Re: DBI Connectons accumulate under Mod_perl

2009-11-13 Thread Perrin Harkins
On Thu, Nov 12, 2009 at 2:22 AM, Kulasekaran, Raja wrote: > Below is the log of $Apache::DBI::DEBUG = 2; This looks fine. I don't think anything is wrong with your setup. I'm guessing Oracle keeps those processes around for a while in case they are needed again. You might want to see if you can

Re: DBI Connectons accumulate under Mod_perl

2009-11-13 Thread Perrin Harkins
On Fri, Nov 13, 2009 at 4:47 AM, Artem Kuchin wrote: > Nope, i don't use those. Just plain DBI. Parent process does not open up any > connections. This is getting really confusing because two of you are on this thread with completely different problems. Artem, if you aren't using Apache::DBI and

Re: DBI Connectons accumulate under Mod_perl

2009-11-13 Thread David E. Wheeler
On Nov 13, 2009, at 1:47 AM, Artem Kuchin wrote: >> Might you have connections starting in parent processes and not getting >> dropped? Are you using Apache::DBI or DBI->connect_cached or DBIx::Connector? >> >> Best, >> >> David >> > Nope, i don't use those. Just plain DBI. Parent process doe

Re: AJAX pseudo-push

2009-11-13 Thread David Nicol
On Fri, Nov 13, 2009 at 1:19 AM, Scott Gifford > > This is a very interesting idea, it might be possible to implement it > with a custom Apache module, or maybe even with mod_perl if you found > the right hooks. > > Scott. so we're talking about a mod_perl app that opens a file system socket

Re: DBI Connectons accumulate under Mod_perl

2009-11-13 Thread Artem Kuchin
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 (