On Jul 17, 2007, at 6:31 AM, Clinton Gormley wrote:
You should not share connections between processes. You will end up
with segfaults.
Thats a 'best case scenario'. More typically, you'll just have a ton
of transactional issues and not have any integrity on your database
of app/db logic
On Fri, 13 Jul 2007 15:15:32 -0700
"Justin Maggard" <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I've run into a bit of a problem. I'm trying to load a B::Bytecode
> compiled perl module with modperl2 running on Apache 2.2.3. But the
> memory usage keep going up each time I do a graceful restart of
On 7/17/07, Clinton Gormley <[EMAIL PROTECTED]> wrote:
But yes, 150 connections may be a lot depending on your database.
However, if you need 150 mod_perl children, then it is a busy site, and
you need a database server big enough to support it.
Anthony, Clinton is right. I suspect you haven't
Well, I've just my own stress tests and it handled 400 concurrent users v well.
I'm going to get our QA guys to rerun the tests but just the tests that run the
DB to see what happens.
As for using alternatives, I'm all for that, sadly, this as a big organisation
and they use Oracle.
Thanks for
On Tue, 2007-07-17 at 12:36 +0100, Anthony Gardner wrote:
> Yes, I'm aware of all of that, but it's the 'you will only have one
> connection per apache child'. So with 150 processes, that's 150
> connections / DB instance. No?!
Correct
>
> And the 'Oracle can handle this with ease.' Oracle can ha
You should not share connections between processes. You will end up
with segfaults.
The way Apache::DBI works is as follows:
- you connect and disconnect from the DBI as per normal
- Apache::DBI caches your connection and overrides disconnect
so that it doesn't actually disconnect
- when yo
I'm a little confused over the use of Apache::DBI or using DBI's connect_cached.
I always thought that Apache::DBI would allow me to use one connection through
multiple processes, but that seems to be not true. After reading the docs more
thoroughly , it seems as though one handle can not be sha
