If a connection pool were to be implemented, this problem should be fixed, too. It would just make searches a bit slower, as the 16th search would have to wait for an earlier search to finish. --valhallasw

On a side point, this is an extremely impressive tool. I've noticed that MediaWiki's search isn't great, and I was wondering if there is any particular reason for this that has been documented somewhere. It'd make an interesting read. Thanks. On 2/20/07, Larry Pieniazek <lar(a)miltontrainworks.com> wrote: http://tools.wikimedia.de/~tangotango/mayflower/search.php?q=mayflower&… http://test.wikipedia.org/wiki/Special:Search 258 in in -- —Sean Whitton (Xyrael/xyr) sean(a)silentflame.com http://xyrael.net/ _______________________________________________ Toolserver-l mailing list Toolserver-l(a)lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l

The connection limit is really killing Shadow1's Shadowbot that is an essential spamfighting tool on the English wikipedia. Is there no better way we can limit traffic? Can it not be throttled to a certain throughput, for example?

You'd have to ask Shadow1, I'm not privvy to the inner workings of the bot, but ever since that limit was put in place the bot's been repeatedly stalling. Peter M Dodge aka Wizardry Dragon Wikipedia Editor, CheckUser Clerk, en.wikipedia.org On 01/03/07, Gregory Maxwell <gmaxwell(a)gmail.com> wrote: > >On 3/1/07, Peter M Dodge <twicescorned(a)gmail.com> wrote: >> The connection limit is really killing Shadow1's Shadowbot that is an >> essential spamfighting tool on the English wikipedia. Is there no >better >> way we can limit traffic? Can it not be throttled to a certain >throughput, >> for example? > >Why does a bot need many simultaneous connections? > >_______________________________________________ >Toolserver-l mailing list >Toolserver-l(a)lists.wikimedia.org >http://lists.wikimedia.org/mailman/listinfo/toolserver-l >

_______________________________________________ Toolserver-l mailing list Toolserver-l(a)lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l

Nonetheless we cannot deny that it has started acting up since then. Of course tightening the MySQL code will help, but ultimately I think that realising that the connection limits may need to be a little more flexible isn't a bad thing. -- Peter M Dodge aka Wizardry Dragon Wikipedia Editor, CheckUser Clerk, en.wikipedia.org _______________________________________________ Toolserver-l mailing list Toolserver-l(a)lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l

Right. The solution is better code, not more permissive systems administration. --- Andrew Garrett aka Werdna ex-Wikipedia Editor, Developer, ate muesli bar for breakfast, currently drinking a Coke, got elected to SRC when he was 10. www.mediawiki.org -----Original Message----- From: toolserver-l-bounces(a)lists.wikimedia.org on behalf of Misza13 Sent: Sun 3/4/2007 8:57 PM To: toolserver-l(a)lists.wikimedia.org Subject: Re: [Toolserver-l] Raising the connection limit for tangotango While I don't know much about how the bot works, but as I understand it is one continuously running IRC bot. The only situation I can image when the bot is hitting the limit is when it establishes a new connection every time it runs a query, which would be a Bad Thing (TM). But if that's the case, a better solution (both for the database server's and bot's efficiency) would be to create and maintain only one mysql connection for the entire bot's operating time (or one per running thread). Regards, Misza 2007/3/4, Peter M Dodge <twicescorned(a)gmail.com>om>: > > Nonetheless we cannot deny that it has started acting up since then. Of > course tightening the MySQL code will help, but ultimately I think that > realising that the connection limits may need to be a little more flexible > isn't a bad thing. > -- > Peter M Dodge aka Wizardry Dragon > Wikipedia Editor, CheckUser Clerk, > en.wikipedia.org > > _______________________________________________ > Toolserver-l mailing list > Toolserver-l(a)lists.wikimedia.org > http://lists.wikimedia.org/mailman/listinfo/toolserver-l > >

_______________________________________________ Toolserver-l mailing list Toolserver-l(a)lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l

On 05/03/07, Alex Rowe <alex.d.rowe(a)gmail.com> wrote: That's what has me confused, myself. It shouldn't be creating multiple connection instances. Peter M Dodge aka Wizardry Dragon