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