``` mysql max idle conns int Env KOLIDE MYSQL MAX IDLE CONNS

Question

``` mysql max idle conns int Env KOLIDE MYSQL MAX IDLE CONNS MySQL maximum idle connection handles default 50 mysql max open conns int Env KOLIDE MYSQL MAX OPEN CONNS MySQL maximum open connection handles default 50 ``` read up on your mysql config and set these values appropriately

pirxthepilot · Answer

Are these options for mysql itself or for fleet On our server I see 50 current connections on mysql bare metal host but `max connections` is actually 151

groob · Answer

fleet

groob · Answer

this is from `fleet serve h`

pirxthepilot · Answer

ah excellent i was looking here and didn t find the option <https github com kolide fleet blob master docs infrastructure configuring the fleet binary md>

pirxthepilot · Answer

i guess the yaml equivalent will be ``` mysql max idle conns max open conns ```

groob · Answer

i think so you can check through config dump

groob · Answer

yup

groob · Answer

``` victor kl ~ g s g k fleet gt build fleet config dump mysql address localhost 3306 username kolide password kolide database kolide tls cert tls key tls ca tls server name tls config max open conns 50 max idle conns 50 ```

pirxthepilot · Answer

confirmed seeing 100 connections now thanks slightly smiling face

groob · Answer

were you having performance issues

pirxthepilot · Answer

not really just wanted to test the option though i think i ll keep it at 100 as default