[OGDev] URGENT Re: [OpenGuides-Dev] OG performance

[Paul Makepeace]

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 at 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 at lists.openguides.org
> http://lists.openguides.org/cgi-bin/mailman/listinfo/openguides-dev
>