[wirelesstoronto-discuss] tech help needed!

[Gabe Sawhney]

Top seems to indicate that the problem is with apache and postgres, but I
don't know what the numbers mean.  I took Jon's suggestion and ran a VACUUM
ANALYZE again (I thought I'd done several times before), and it cooled it
down a bunch... now the load avg is between 4 and 5.  That still strikes me
as high, but it's a lot better.  I'll keep an eye on it in the next few
days.

The machine had 638 days uptime until I rebooted it today, trying to
troubleshoot this.  (The reboot didn't help.)

Gabe


On Wed, Apr 16, 2008 at 3:39 PM, Rob Janes <janes.rob at gmail.com> wrote:

> what does top say?
>
> do you want me to log on to the box?
>
> -rob
>
>
> On Wed, Apr 16, 2008 at 2:50 PM, Jon Pounder <Jon at pounder.com> wrote:
>
> > Quoting Gabe Sawhney <gabe at pwd.ca>:
> >
> >  We need some help from someone with Linux performance tuning
> > > experience.
> > > Our auth server in the past few months has been getting really slow...
> > > we
> > > haven't been asking it to do any more work, but while before the load
> > > average sat around 1.1, now it's almost always between 6 and 12(!).
> > >
> > > Basically we're talking about Apache, PHP5 and Postgresql.  There's
> > > also
> > > MySQL and Mailman running on the box, but I doubt those have anything
> > > to do
> > > with it.
> > >
> > > If you've done stuff like this before, please get in touch!
> > >
> >
> >
> > make sure postgres is configured to autovacuum tables.
> >
> > if you don't have it, install pgadmin on your own desktop (windows) and
> > connect to the pg db as the postgres user, then you can fine tune whatever
> > you need on there.
> >
> > also look for any log files that have just gotten massive, and clean
> > them out.
> >
> > if its not been rebooted in a while (like months), also do that which
> > will force a check of the drives in case anything is haywire there.
> >
> >
> > also - btw, the listserver for this mailing list is broken, messages are
> > addressed to the list rather than the person when they arrive so replying if
> > you have multiple email accounts is broken.
> >
> >
> >
> > > Gabe
> > >
> > >
> >
> >
> >
> >
> > Jon Pounder
> >
> >
> > _______________________________________________
> > wirelesstoronto-discuss mailing list
> > wirelesstoronto-discuss at wirelesstoronto.ca
> >
> > http://lists.wirelesstoronto.ca/cgi-bin/mailman/listinfo/wirelesstoronto-discuss
> >
>
>
> _______________________________________________
> wirelesstoronto-discuss mailing list
> wirelesstoronto-discuss at wirelesstoronto.ca
>
> http://lists.wirelesstoronto.ca/cgi-bin/mailman/listinfo/wirelesstoronto-discuss
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.wirelesstoronto.ca/pipermail/wirelesstoronto-discuss/attachments/20080416/b5eb5ab5/attachment-0001.htm