5 Jun
2007
5 Jun
'07
1:01 p.m.
On Tue, Jun 05, 2007 at 12:49:33PM +0100, Bob Walker wrote:
On Tue, 5 Jun 2007, Christopher Schmidt wrote:
Even when memcached is in place, I still connect to the database, even
when all the data is loaded from cache. (That's a bug, but not one I
care about). However, I have my database set up to allow max connections
of twice the number of apache threads I have, and OpenGuides only
connects once per page as far as I remember -- I've done some looking at
this -- so I don't think it'd be a problem...
However, I'm using MySQL, and I know you're not. It's possible that the
W::T Store module for Postgres doesn't do closing and MySQL does?
I can't tell whether memcached would help: it would depend on whether
there is free memory on the box, and whether the load is from getting
the data or from styling it. In general, the latter is generally true,
but someone with access to the box might be better suited to determine
that.
In general, mod_perl has helped much much much more with performance
than memcached has, especially on the single-node case (rather than
category listings or the ilke).
REgards,
--
Christopher Schmidt
Web Developer
I run the Open Guide to Boston under mod_perl
without problems. I
believe that I brought all the patches I made to the code back into line
with the main trunk, so I am not aware of any reason that the code
should not be mod_perl friendly.
is your use of memcached hiding possible connection exhaustion issues?
would your memcached stuff help with london's problem?