Slow busy server

Rolf Schaufelberger rs at
Thu Mar 7 23:49:54 CET 2013


Am 07.03.2013 um 22:10 schrieb Tina Müller <cpan2 at>:

> On Thu, 7 Mar 2013, Sébastien Aperghis-Tramoni wrote:
>> Andrew Shitov wrote:
>>> Hi,
>> Hello Andrew,
>>> During the last few days I experience problems with slow loading of
>>> the Act sites (mainly ye2013, of course, but others as well) and slow
>>> ssh connection. I looked at the top output and it says "load
>>> averages:
>>> 18.60, 18.18, 18.80" and lists the number of postgres processes with
>>> big CPU usage numbers.
>>> Is it something to look at in sense of system administration?

I had something like this some years ago, reason was an error in a stored procedure, leading to inserting an infinite loop of records in my database, 
writing tons of WAL files, filling my disk.   So, how about disk space ? Everything ok with this ?  Once your disk is full the problems get really nice :-)

>> Indeed. Tinita pinged me on IRC about that as well.
>> I took a look and tried different approaches, but I don't understand
>> yet what is the origin of the problem.
>> I first thought it was some crawlers, several were looking the wiki
>> diffs, which are known to be a bit costly (and probably hide some
>> deeper problems given they were a cause for crashing the Plack port).
>> So I completed the robots.txt to disallow this URL. No Effect.
>> Tinita suggested to completely disable the page when no logged in.
>> I live-added the few lines of code to do that. No effect (at least
>> I didn't break anything).
> It seems that the whole wiki can not be accessed now if one isn't logged
> in. I guess that was not intended?
> I just send out a last reminder for the participants, and now the first
> one asked why he can't see the wiki...
> _______________________________________________
> Act mailing list
> Act at

Mit freundlichen Grüßen
Rolf Schaufelberger

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4328 bytes
Desc: not available
URL: <>

More information about the Act mailing list