Juan Alvarez
09/06/2021, 1:34 PMFLEET_MYSQL_MAX_IDLE_CONNS
and FLEET_MYSQL_MAX_OPEN_CONNS
? I started to see Error 1040: Too Many Connections
along with Authentication Error: Finding Host
so i think that MySQL was dropping an excessive amount of connections coming from the FleetDM. Our configuration was FLEET_MYSQL_MAX_IDLE_CONNS=50
and Max Open FLEET_MYSQL_MAX_OPEN_CONNS=400
which i think it was overwhelming the mysql that has a max_connections
variable of 151. Once i lowered `FLEET_MYSQL_MAX_OPEN_CONNS=100`i stopped seeing the errors. The question is, what is a typical configuration for those parameters when having deployments of several thousands clients? Should we configure FLEET_MYSQL_MAX_OPEN_CONNS
close to the max_connections
value in MySQL? And what would be FleetDM's behavior if he needs to check in the database but the max amount of connections is reached? Any guidance is appreciated!Martavis Parker
09/07/2021, 7:27 PMJuan Alvarez
09/08/2021, 10:33 AMzwass
09/09/2021, 9:03 PMmax_connections
. So FLEET_MYSQL_MAX_OPEN_CONNS=max_connections/# of Fleet servers
.Juan Alvarez
09/10/2021, 3:10 PMJojoD
04/13/2022, 1:22 PMFLEET_MYSQL_MAX_OPEN_CONNS=max_connections
, it will automatically read the value stored in the max_connections
variable of the DB? .... what would be the case where the FLEET_MYSQL_MAX_OPEN_CONNS
is lower than the connections of the DB?