Osquery uses basic SQL commands to leverage a relational data-model to describe a device.

osquery

```
      --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

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.

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>

i guess the yaml equivalent will be
```
mysql:
  max_idle_conns:
  max_open_conns:
```

i think so. you can check through config dump

```
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
```

confirmed. seeing 100 connections now. thanks :slightly_smiling_face:

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