[Labs-l] Max connections?

[Nuria Ruiz]

Thanks for the prompt answer sean, we shall set up concurrency to 24.

Nuria


On Thu, Sep 4, 2014 at 6:43 PM, Sean Pringle <springle at wikimedia.org> wrote:

> Labsdb has max_user_connections=512, however that is intended to be a
> safety limit to avoid DOS, not a target to aim for :-) We can apply
> max_user_connections per account or per host if necessary, but it would be
> nice to avoid draconian measures.
>
> Don't plan for 100s of concurrent connections. As a rule of thumb for slow
> queries, consider that the servers have 24 cores, so more than 24
> concurrent slow queries in mysqld will start to be painful for everyone.
>
>
> On Fri, Sep 5, 2014 at 6:15 AM, Nuria Ruiz <nuria at wikimedia.org> wrote:
>
>> Hello Labs People:
>>
>> In the analytics team we are working in some big changes for wikimetrics
>> and we have some questions about number of connections the wikimetrics user
>> can sustain on labs db .
>>
>> Is there a limit on database connections per labs instance? Is there an
>> additional limit on mysql db connections per database instance?
>>
>> Thanks,
>>
>> Nuria
>>
>> _______________________________________________
>> Labs-l mailing list
>> Labs-l at lists.wikimedia.org
>> https://lists.wikimedia.org/mailman/listinfo/labs-l
>>
>>
>
>
> --
> DBA @ WMF
>
> _______________________________________________
> Labs-l mailing list
> Labs-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/labs-l
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20140905/96a6be55/attachment.html>