I think I know why OpenGuides has a habit of occasionally
taking over servers. If you've experienced problems with occasional
ridiculously high load averages, take a look at the Action paragraph
In the short term, I suggest that anyone who's been having trouble
with OpenGuides taking over their machines should comment the per-user
RSS feed links out of userstats.tt - copy it to your custom_templates
directory and either delete everything between [% IF username %] and
the next [% END %] statement (inclusive), or change [% IF username %]
to [% IF username AND 0 %] - both will have the same effect.
I suspect that I have at last found out the thing that makes
OpenGuides take people's servers over. It's the per-user RSS feeds,
which are usually linked from e.g.
The problematic feeds are those which omit minor edits, and they're
only a problem on large guides (Cambridge is fine, RGL is not). The
reason for this is that they effectively select _everything_ from the
database and then winnow it down. When a spider is hitting one of
these feeds every second... I think you can see where this is going,
and it's not pretty.
The reason this has gone unnoticed for so long is that (a) nobody
really uses these feeds anyway, so they only get accessed by spiders
etc, and spiders aren't going to email us and say "hey, this link is
very slow", and (b) these feeds are the only thing in OpenGuides that
use "last n changes" as a selection criterion - Recent Changes uses
"last n days", which is much more efficient.
The root problem is with the _find_recent_changed_by_criteria method
in Wiki::Toolkit::Store::Database, specifically the "metadata_wasnt"
parameter in combination with the "limit" one. I am working on a
rewrite of this method to make it more efficient, but this is going to
require some thinking and hence some time.
Following a conversation that I just had on the IRC channel with Kake
and Christopher Schmidt, it seems my sole remaining interest area in
the project (RDF functionality) is no longer of interest to other
users and developers of OpenGuides. Therefore I am withdrawing from
the project. I will relinquish the domain name and website hosting to
whoever wishes to take over it - please mail me offlist.
I wish OpenGuides good luck in the future.
قبائلَ صوتي – على صمتها
Earle Martin | http://downlode.org/
Apparently there's now a universal edit button, embedded in Wiki pages
in a manner similar to RSS:
There's a Firefox extension to enable it, but I imagine it'll end up in
the browsers eventually.
Rev Simon Rumble <simon(a)rumble.net>
The Tourist Engineer
Because geeks travel too.
"A conservative is a man who believes that nothing should
be done for the first time."
- Alfred E Wiggam
A decision has been made! The 5th anniversary meet will be in Oxford
on Saturday 21 June, starting at lunchtime and continuing into the
evening until people need to head home.
Dom and Socks are working on figuring out a suitable venue.
Please put this date in your diaries now! You can also start inviting
other people along - I think Ivor had some thoughts on this. I'll be
publicising it on the RGL livejournal community.