[OGDev] [OpenGuides-Dev] OG performance

[Paul Makepeace]

[+earle]

On 6/5/07, Dominic Hargreaves <dom at earth.li> wrote:
> On Tue, Jun 05, 2007 at 09:58:37AM +0100, Paul Makepeace wrote:
> > A follow-up on a 2.5yr-old mail from your London OG admin,
> >
> > OpenGuides London is frequently bursting 100% of a 3Ghz HT CPU which is
> > causing stix (the server) load problems,
> >
> >  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
> > 11060 www-data  19   0 18940  15m 2576 R 26.5  1.5   0:00.80 index.cgi
> > 11040 www-data  19   0 21420  17m 2612 R  6.9  1.7   0:01.12 index.cgi
> > 11039 www-data  19   0 21004  17m 2584 R  6.6  1.7   0:01.04 index.cgi
> > 11048 www-data  19   0 21392  17m 2612 R  6.6  1.7   0:01.10 index.cgi
> > 11051 www-data  19   0 21248  17m 2612 R  4.6  1.7   0:01.02 index.cgi
> >
> > This CPU's nearly twice as fast as the server's the hosting was on when
> > I last wrote this (the IO yet faster) and not using supersearch.cgi has
> > obviously helped, all of which has bought some time, retrospectively. Some
> > plan however to make use of mod_perl or other CPU-reduction measure
> > needs to come into effect pretty soon.
> >
> > What say ye?
>
> I think this has to be directed at Earle in the first instance, as the
> rest of us are not party to the configuration or any statistics of
> london.openguides.org, or, for example, if the relevant database
> indexes are configured (this, I recall, improves certain expects of
> OpenGuides significantly).
>
> The last time I tried OpenGuides under mod_perl it mostly worked, though
> for some reason that escaped me (possibly time) I never went as far as
> declaring it so - there were some niggles to clean up.
>
> These days my own interest in persistent perl applications lies within
> FastCGI (since this allows one to run the application under its own user
> id) and restructing wiki.cgi et al to use CGI::Fast should be fairly
> simple (especially since CGI::Fast will also work in plain CGI mode)
> but since I'm not currently suffering from resource problems this
> isn't a priority for me.
>
> http://dev.openguides.org/ticket/150
>
> is one ticket about this issue.

Thanks Dom. FastCGI is another route that seems reasonable, in fact
preferable probably since it's somewhat easier to hive off and debug
resource issues than apache+mod_perl, specifically restarting an fcgi
instance is less disruptive in a shared environment.

Can I request someone (Earle, with help from others if nec) propose a
deadline on ameliorating this? I'm of course happy as usual to help
from the admin end.

P

> Dominic.
>
> --
> Dominic Hargreaves | http://www.larted.org.uk/~dom/
> PGP key 5178E2A5 from the.earth.li (keyserver,web,email)
>
> --
> OpenGuides-Dev mailing list - OpenGuides-Dev at lists.openguides.org
> http://lists.openguides.org/cgi-bin/mailman/listinfo/openguides-dev
>