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 <[email protected]> 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 <[email protected]> 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 >> [email protected] >> https://lists.wikimedia.org/mailman/listinfo/labs-l >> >> > > > -- > DBA @ WMF > > _______________________________________________ > Labs-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/labs-l > >
_______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
