[Labs-l] Max connections?

Fri Sep 5 01:43:58 UTC 2014

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20140905/e7b7268b/attachment.html>