Bob,
If you'd like to help here I can grant you root for a while and you
can take a poke around. The load is up around 2.5 and there's no
obvious (to me) cause. iostat -kx5 isn't showing anything dramatic. OG
gets about a hit a second which doesn't seem like it ought to cause a
problem but with cgi...
I shut off Pg and the load stayed the same. Taking apache-perl down it
went to 0%us. Bringing apache-perl & Pg back up it's ok again. So it
suggests something's getting wedged. Of course, it's possible it's not
actually OpenGuides, but OG gets by far the most number of hits, and
has the most index.cgi processes hanging around, and it is the only Pg
user.
As an aside, if you have raidtools/mdadm skillz that might come in
handy here too.
P
On 7/25/07, Bob Walker <bob(a)randomness.org.uk> wrote:
On Wed, 25 Jul 2007, Paul Makepeace wrote:
I'm looking for a response along the lines
of,
"We will test and thrash a local instance of OG London with FastCGI
and Apache Bench on our home boxen by date YYYY-MM-DD. At this point
we'd like to set up a test instance on stix on date YYYY-MM-DD, and
let it bake for a week. If that's OK, we'll move the install over on
YYYY-MM-DD."
in which case we need more info . give us specs of the box its on. what
access numbers are like currently. what versions of postgres and apache.
also, is there iowait on the box.
is the database being vacuumed? (just to make sure)
has the database setup been tweaked.
not that i really care but no one else seems to have these issues.
well boston may have done but then crschimdt implemented mod_perl,
memcached and better indexes and indeed uses mysql i think.
ive certainly seen that some workloads dont cope very well on postgres.
--
Bob Walker
http://london.randomness.org.uk/
For great beery Justice!
--
OpenGuides-Dev mailing list - OpenGuides-Dev(a)lists.openguides.org
http://lists.openguides.org/cgi-bin/mailman/listinfo/openguides-dev