[erlang-questions] [HEADS UP] Emysql driver

[Jesper Louis Andersen]

On Fri, Jul 5, 2013 at 3:34 PM, Barco You <barcojie@REDACTED> wrote:

> Thank you all.
>
> Whats the maximum connections can it bear when add a pool? If I use Cowboy
> to provide a REST API for data query and I start up the http listener with
> 10000 acceptors and 10000 emysql connections, does that mean i can support
> 10000 concurrency?
>
MySQL will probably not handle 10000 simultaneous connections well. The
idea is to keep the connection count lower, around 100 perhaps, and then
use other methods if you need a higher concurrency count. Note that while
you have an HTTP connection, you might only be communicating with the
underlying database for a short amount of time. And then most of the time
is spent sending a result back to the client and so on. In other words, it
might not gain you much to have a high connection count to MySQL. Rather,
you should tune.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://erlang.org/pipermail/erlang-questions/attachments/20130705/a3f3d87f/attachment.htm>