On Tue, May 28, 2013 at 9:14 AM, Jamie Thingelstad
<jamie(a)thingelstad.com> wrote:
I can — Nemo was referencing some dialog we had while
I was trying to figure out performance issues on my farm.
You can see the whole dialog, with graphs, here:
http://wikiapiary.com/wiki/WikiApiary_talk:Operations/2013/May#Banned_IP_ch…
Thanks for posting that Jamie, that does point out some serious issues
with that database. Although with less than 400k rows, it seems like
that data may just need some index and cach tuning. To me, using a
database like this feels like the right approach for smaller wikis.
Were you using something like Extension:Check_Spambots to integrate
the db with the wiki?
Actually, after rereading that Talk page I'll just
leave it at the link. All the gruesome details are there. :-)
TL:DR; Using this stopforumspam method caused me 4-5x slowdown in performance.
Jamie Thingelstad
jamie(a)thingelstad.com
mobile: 612-810-3699
find me on AIM Twitter Facebook LinkedIn
On May 28, 2013, at 10:48 AM, Al Johnson <alj62888(a)yahoo.com> wrote:
________________________________
From: Federico Leva (Nemo) <nemowiki(a)gmail.com>
To: mediawiki-l(a)lists.wikimedia.org
Sent: Tuesday, May 28, 2013 2:47 AM
Subject: Re: [MediaWiki-l] Wiki spam. Stronger fightback.
Al, the problem with stop forum spam is not memory but rather the CPU
usage and lag it creates, for an apparently limited amount of spam
blocked (at least on small wikis)
<https://www.mediawiki.org/wiki/Manual_talk:Combating_spam#CPU_usage.3B_IP_blacklists>
Hi Nemo. You didn't say why you would not recommend that approach. Can you
elaborate?
Nemo
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l