0
According to the documentation of mysql for Nodejs, it is possible to configure a connection pool to limit the number of connections in Mysql
When running the following command on my Mysql server:
show variables like 'max_connections';
I got the following result
Variable_name | Value
max_connection | 151
Knowing that in Nodejs I can configure the pool as follows:
var mysql = require('mysql');
var pool = mysql.createPool({
connectionLimit : 10,
host : 'example.org',
user : 'bob',
password : 'secret',
database : 'my_db'
});
In that attribute connectionLimit : 10
, which is recommended to use?
The limit which is 151 or less?
Or I can increase in mysql?
Or how much I can raise?
Thank you for the clarification
According to this article the optimal number should be the number of threads, https://github.com/brettwooldridge/HikariCP the number that interests you is the value 3 Uncontended benchmark: 32 threads/32 Connections, but the ideal is to do performance analysis according to your input size.
– Danizavtz
I have to have some configuration to see these threads?
– adventistaam
You search your machine processor (or the cloud that is running your application) and make the configuration accordingly.
– Danizavtz