Re: Persistent DB Connection problem

2005-12-18 Thread Frank Wiles
On Sun, 18 Dec 2005 15:10:43 -0500 Malcolm J Harwood <[EMAIL PROTECTED]> wrote: > On Wednesday 14 December 2005 10:50 am, Perrin Harkins wrote: > > > On Wed, 2005-12-14 at 16:43 +0100, Thomas Schindl wrote: > > > I've now taken a closer look into the whole thing and at the > > > moment it seems t

Re: Persistent DB Connection problem

2005-12-18 Thread Malcolm J Harwood
On Wednesday 14 December 2005 10:50 am, Perrin Harkins wrote: > On Wed, 2005-12-14 at 16:43 +0100, Thomas Schindl wrote: > > I've now taken a closer look into the whole thing and at the moment > > it seems to possible to use mod_dbd to provide the physical connection on > > C-level to DBD::mysql.

Re: Persistent DB Connection problem

2005-12-14 Thread Jonathan Vanasco
This is a ThreeParter On Dec 14, 2005, at 10:43 AM, Thomas Schindl wrote: I brought about a few days ago a discussion about mod_dbd (available with Apache-2.2 ) which exactly acts like I think connection-pooling should work in Apache. on a side note, does mp2 work with apache-2.2 yet? i've

Re: Persistent DB Connection problem

2005-12-14 Thread Perrin Harkins
On Wed, 2005-12-14 at 16:43 +0100, Thomas Schindl wrote: > I've now taken a closer look into the whole thing and at the moment > it seems to possible to use mod_dbd to provide the physical connection on > C-level to DBD::mysql. I've already contacted the maintainer of DBD::mysql > and I hope until

Re: Persistent DB Connection problem

2005-12-14 Thread Thomas Schindl
de the physical connection on C-level to DBD::mysql. I've already contacted the maintainer of DBD::mysql and I hope until next year i get something going. Tom > --- Ursprüngliche Nachricht --- > Von: Jonathan Vanasco <[EMAIL PROTECTED]> > An: Albert Vila <[EMAIL PROTECTED]> >

Re: Persistent DB Connection problem

2005-12-14 Thread Kevin A. McGrail
I'm shocked that nobody mentioned Apache::DBI->connect_on_init() That's because he really doesn't want persistent connections. He's trying to get 1 db connection for XYZ number of child processes. ;-) Regards, KAM

Re: Persistent DB Connection problem

2005-12-13 Thread Philip M. Gollucci
On Tue, 13 Dec 2005, Kevin A. McGrail wrote: I'm having problems setting up the apache + mod_perl + Apache::DBI in order to get persistent db connections. I've added the following line in my httpd.conf: PerlRequire /home/xxx/startup.pl The persistent connection is one per child process

Re: Persistent DB Connection problem

2005-12-13 Thread Larry Leszczynski
Hi Albert - On Tue, 13 Dec 2005, Albert Vila wrote: I thought the persistent connection was only one for all childs. What happens then if I have 1000 childs each one with 1 db connection? This means 1000 database connections. How do you setup apache + mod_perl in this environment? Typical

Re: Persistent DB Connection problem

2005-12-13 Thread Jonathan Vanasco
On Dec 13, 2005, at 12:59 PM, Albert Vila wrote: I thought the persistent connection was only one for all childs. What happens then if I have 1000 childs each one with 1 db connection? This means 1000 database connections. How do you setup apache + mod_perl in this environment? Albert

Re: Persistent DB Connection problem

2005-12-13 Thread Kevin A. McGrail
Albert: You will need 1000 database connections to handle 1000 apache children with persistent connections. The persistent connection only helps get rid of the delay of connecting to the database each time with each script. What I believe you are asking for is a database proxy. Sorry, I don't

Re: Persistent DB Connection problem

2005-12-13 Thread Albert Vila
I thought the persistent connection was only one for all childs. What happens then if I have 1000 childs each one with 1 db connection? This means 1000 database connections. How do you setup apache + mod_perl in this environment? Albert Kevin A. McGrail wrote: I'm having problems setting up

Re: Persistent DB Connection problem

2005-12-13 Thread Perrin Harkins
On Tue, 2005-12-13 at 18:10 +0100, Albert Vila wrote: > However, the persistent connections still does not work. The system > creates a new db connection for earch child. That's what it's supposed to do, as documented in the Apache::DBI man page. If it creates more than one connection with the

Re: Persistent DB Connection problem

2005-12-13 Thread Kevin A. McGrail
I'm having problems setting up the apache + mod_perl + Apache::DBI in order to get persistent db connections. I've added the following line in my httpd.conf: PerlRequire /home/xxx/startup.pl The persistent connection is one per child process so I don't know if your test is correct. Try i

Re: Persistent DB connection problem

2004-07-23 Thread Perrin Harkins
On Fri, 2004-07-23 at 05:27, Batara Kesuma wrote: > Can I use Apache::DBI to initiate persistent DB connection only for some > DB handler? Sure, just use the dbi_connect_method option on the ones you want to make non-persistent: my $dbh = DBI->connect('dbi:...',... ,{'dbi_connect_method' => 'conn