[SAC] Re: ! www.osgeo.org HTTP DOWN
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
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.
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
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
More information about the Sac