[OGDev] URGENT Re: [OpenGuides-Dev] OG performance

[Bob Walker]

On Wed, 25 Jul 2007, Earle Martin wrote:

>
> I'm sorry to hear that, Paul. Afraid the mechanics of why this is
> happening is beyond me. Can anyone on the list suggest methods I can
> use to investigate? However, my sysadmin skills are weak to
> non-existent, so please speak slowly and with small words and plenty
> of explanation (i.e. "use valgrind, man!!1!" won't be of much use to
> me).
>

a) use the latest code. (then you can use spam blocking stuff which may 
help)(http://svn.randomness.org.uk/trunk/london.randomness.org.uk/scripts/lib/RGL/SpamFinder.pm 
is rgls)
b) provide us with a schema(no data) dump of the database. so we can check 
that the rigth indexes are in place.
c) openguides is now mostly mod_perl safe. however i think there might be 
an issue with closing postgres db connections. so mod_perl might be an 
option. althogh i think it will stop working once it runs out of 
conenctions which will then need a restart so may not be the answer. 
d) if its google tell it to back off a bit at the google webmasters tools 
stuff or indeed use robots.txt to block search crawlers.




> It could be waves of spam, rogue crawlers gone mad or who knows what,
> but unfortunately I do not have access to any Apache log files on
> stix, so trying to find out anything that way is a non-starter.

indeed the log files will help.

-- 
Bob Walker
http://london.randomness.org.uk/
For great beery Justice!