On Tue, May 28, 2013 at 9:14 AM, Jamie Thingelstad <[email protected]> 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_check_causing_slowness_and_removed_.28aka_Performance_victory.21.29
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 > [email protected] > mobile: 612-810-3699 > find me on AIM Twitter Facebook LinkedIn > > On May 28, 2013, at 10:48 AM, Al Johnson <[email protected]> wrote: > >>> ________________________________ >>> From: Federico Leva (Nemo) <[email protected]> >>> To: [email protected] >>> 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 >>> [email protected] >>> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l >>> >>> >>> >> >> _______________________________________________ >> MediaWiki-l mailing list >> [email protected] >> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > _______________________________________________ > MediaWiki-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
