[Toolserver-l] Raising the connection limit for tangotango

[Merlijn van Deen]

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

> Hi all!
>
> Apologies if this was already asked, but TangoTango wrote a very nifty
> search tool, mayflower.
> http://tools.wikimedia.de/~tangotango/mayflower/search.php?q=mayflower&t=n
>
> See it here on the test wiki:
> http://test.wikipedia.org/wiki/Special:Search
> (you may need to be logged in)
>
> It's really great, and it got added to commons
> http://commons.wikimedia.org/wiki/Special:Search
>
> But unfortunately it's bumping into the 15 connection limit already.
>
> ---
>   Advanced search
> Please wait, searching for "mayflower"...
>
> Warning: mysqli::mysqli() [function.mysqli-mysqli]: (42000/1226): User
> 'tangotango' has exceeded the 'max_user_connections' resource (current
> value: 15) in /home/tangotango/public_html/mayflower/search.php on line
> 258
>
> Warning: mysqli::query() [function.mysqli-query]: Couldn't fetch mysqli in
> /home/tangotango/public_html/mayflower/search.php on line 287
>
> Warning: main() [function.main]: Couldn't fetch mysqli in
> /home/tangotango/public_html/mayflower/search.php on line 469
>
> Error:
>
> Warning: mysqli::close() [function.mysqli-close]: Couldn't fetch mysqli in
> /home/tangotango/public_html/mayflower/search.php on line 472
>
> ----
>
> Please consider raising that limit, a lot. Not sure how much but a lot
> because commons searches are quite frequent.
>
> Thanks!
>
>
> Larry Pieniazek
> Work mail:   lpieniaz at us.ibm.com
> Hobby mail:  lar at miltontrainworks.com
>
>
>
>> Message: 1
>> Date: Sun, 18 Feb 2007 00:25:47 +0100
>> From: "DaB." <wp at daniel.baur4.info>
>> Subject: [Toolserver-l] New limitation of mysql-connections
>> To: Toolserver-ML <toolserver-l at lists.wikimedia.org>
>> Message-ID: <1171754747.3681.2.camel at DanielX.intern.baur4.info>
>> Content-Type: text/plain; charset="us-ascii"
>>
>> Hello all,
>>
>> I created a new limitation of 15 mysql-connections at the
>> same time by a user (after a user flooded mysql with a few
>> dutzend connection a few time ago).
>>
>> If someone need more connections, please mail me, the limit
>> can set per user.
>>
>> Have fun :).
>>
>> Sincerly,
>
>
>
> _______________________________________________
> Toolserver-l mailing list
> Toolserver-l at lists.wikimedia.org
> http://lists.wikimedia.org/mailman/listinfo/toolserver-l
>