RE: Creating new database handles with mod_perl

2012-05-20 Thread Schultz, Len
ab stress tests. If they pass, then maybe I can just assume the processes correctly have different connections. --len -Original Message- From: Peter J. Holzer [mailto:h...@wsr.ac.at] Sent: Sunday, May 20, 2012 3:27 AM To: Schultz, Len Cc: dbi-users@perl.org Subject: Re: Creating new d

Re: Creating new database handles with mod_perl

2012-05-20 Thread Peter J. Holzer
On 2012-05-19 20:06:44 -0400, Schultz, Len wrote: > I've run into an issue when stress testing mod_perl that the database > connections are going away. I suspect that processes are sharing > database connections, causing the issue. > > But I've followed all instructions for Apache::DBI, and can't

Re: Creating new database handles with mod_perl

2012-05-19 Thread Schultz, Len
Darren, Thanks for the suggestion. I tried that today and noticed the same behavior. This is not surprising as both are using DBI internally to get the connection. All httpd processes point to the same DBH after connection. Should they or should each process have a unique address returned by

Re: Creating new database handles with mod_perl

2012-05-19 Thread Darren Duncan
Instead of using Apache::DBI directly, I recommend using the CPAN module http://search.cpan.org/dist/DBIx-Connector/ instead, which is focused on handling your use case effectively. -- Darren Duncan Schultz, Len wrote: I've run into an issue when stress testing mod_perl that the database conne

Creating new database handles with mod_perl

2012-05-19 Thread Schultz, Len
I've run into an issue when stress testing mod_perl that the database connections are going away. I suspect that processes are sharing database connections, causing the issue. But I've followed all instructions for Apache::DBI, and can't figure this out. I'm making the connections in the child pr