-----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