Optimal number of database connections (node-mysql)

Question

By default, node-mysql limits the maximum number of mysql connections in a connection pool to 10. This seems pretty conservative to me.

Is there an optimal number of connections I should set it to? ( is there a number beyond which performance is likely to degrade, instead of increasing? )

Thanks

Answer 1

There is no optimal configuration for maximum number of connections, and you shouldn't need to touch it unless there are noticeable bottlenecks in your application. The number of connections you require can vary on how your application is structured, your system's performance, and your network throughput.