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