This one time, at band camp, Kake L Pugh wrote:
Your recent changes are really really slow. I can't actually see them at all because I get timed out before the page loads. Have you got your indexes set up? (Explanation of that is somewhere in the list archives; I think in a conversation with jimbo.)
I think that's a combination of it being a pretty small-spec virtual machine and the motherlode of data created by the spammer. I seem to have index files, so I'm presuming I do have indexing. I'm using sqlite.
Ah, it's just managed to load. Nuke everything with 'supercasino' in the node name. In psql this is something like
delete from node where name like '%supercasino%'; delete from content where name like '%supercasino%'; delete from metadata where name like '%supercasino%';
That's done the job (in sqlite). Thanks!
A couple of improvements that this suggests: 1) Limit the number of categories and locales a node can have. 2) Allow regex matches of text in nodes and reject any edits that include them (in this case, ^Http.**) 3) I couldn't even see the root node that had auto-created all the "Http" categories and locales in the Recent Changes. Is there a limit in the number displayed?
Looking through the logs, here's the culprit. Note the referrer it's come in on:
81.213.173.173 - - [17/Jul/2005:22:19:57 +0100] "GET / HTTP/1.1" 200 8290 "http://www.google.com.tr/search?q=edit+this+page+wiki&hl=tr&lr=&..." "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)" 81.213.173.173 - - [17/Jul/2005:22:20:20 +0100] "GET /newpage.cgi HTTP/1.1" 200 4804 "http://engineer.openguides.org/" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)" 81.213.173.173 - - [17/Jul/2005:22:20:29 +0100] "POST /newpage.cgi HTTP/1.1" 302 325 "http://engineer.openguides.org/newpage.cgi" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)" 81.213.173.173 - - [17/Jul/2005:22:20:31 +0100] "GET /?action=edit;id=Kaleci HTTP/1.1" 200 6864 "http://engineer.openguides.org/newpage.cgi" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)" 81.213.173.173 - - [17/Jul/2005:22:26:08 +0100] "POST /?action=edit;id=Kaleci HTTP/1.1" 200 - "http://engineer.openguides.org/?action=edit;id=Kaleci" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)" 81.213.173.173 - - [17/Jul/2005:22:31:35 +0100] "POST /?action=edit;id=Kaleci HTTP/1.1" 200 - "http://engineer.openguides.org/?action=edit;id=Kaleci" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)"