On 05/03/07, Peter M Dodge twicescorned@gmail.com wrote:
On 05/03/07, Alex Rowe alex.d.rowe@gmail.com wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
As far as I (and the silent members of #perl) can tell, the Perl Object Environment (Shadowbot's multitasking module) doesn't use fork or threads to run queries with the MySQL object in Shadowbot. So, the bot should only have one connection to the MySQL server at any point. And even if there is one MySQL object being established for each thread, ie each reversion, they would still be destroyed at the end of the revert.
Alex Rowe
On 17:04 Mon 05 Mar , Andrew Garrett wrote:
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@lists.wikimedia.org on behalf of Misza13 Sent: Sun 3/4/2007 8:57 PM To: toolserver-l@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@gmail.com >:
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@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l
Toolserver-l mailing list Toolserver-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFF7MXbSP+CFq0x+hYRAv9XAJwIAYOh9v5WOkmpBWewHU/cZRzujgCgpBBY /pb7fVBtfmyVoFnDWgNReZs= =CaH6 -----END PGP SIGNATURE-----
Toolserver-l mailing list Toolserver-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l
That's what has me confused, myself. It shouldn't be creating multiple connection instances.
Peter M Dodge aka Wizardry Dragon
It occurs to me - is the limit 15 *connections* or 15 *transactions* because if it is the latter that would be it right there.
Peter M Dodge aka Wizardry Dragon Wikipedia Editor sco.wikipedia.org