[SAC] Re: ! www.osgeo.org HTTP DOWN

Jason Birch Jason.Birch at nanaimo.ca
Thu Dec 20 12:15:11 EST 2007

Perhaps we should again look at whether there are any high-load or
resource-heavy services that could be redistributed to OSGeo2?  MySQL?

I've noticed slowness on Trac in the past couple days, and it's always
been early hours (I'm guessing between 12:00 and 2:00 in my TZ, GMT-8).
If this is the local backups, I wonder if they could be run from the
second server to reduce load on the primary?  Also, I got errors about
the Trac DB being locked.  I wonder if we need to specificly exclude
live database files from the filesystem backup?

I'm also wondering if this might be partially a result of the spiders
seeing all the cool new content under SVN repository and hammering it.
I know that I was initially a proponent of leaving SVN open to the
spiders, but... maybe it would be better to put that robots.txt back
into place.

Yeah, I know, throwing out suggestions without measuring sucks...  I was
having load issues on one of my servers recently, and it turned out to
be a single IP hammering my MySQL-based forums.


-----Original Message-----
From: Martin Spott
Subject: [SAC] Re: ! www.osgeo.org HTTP DOWN

Adding to that, I've reduced the KeepAliveTimeout from 15 to 7 seconds,
as 7 seconds seems to be a good estimate for the time it takes to load a
single page.

I don't think that increasing the MaxClients number makes too much sense
here: The whole machine has a limited amount of RAM which then has to be
shared among MySQL, Apache, Postfix, Courier IMAP !?!?!?, Mailman, ADSM
(client), a local BIND9, several backup scripts and others. Personally
I'd say we'd better should have a server that behaves a bit slow
sometimes than a server which requires us to take special care every
third morning.

More information about the Sac mailing list