Home-assistant_v2.db grows, despite setting up InfluxDB

Configuration
1

I have set up InfluxDB, and thought that would mean that home-assistant_v2.db would not continue to grow any larger. But it does. Is this normal? Or have i configured something wrong?

I know InfluxDB works, as I have Grafana pulling date from it.

2

Do you have a purge setup to run quite frequently and re-write the file to shrink it?

3

I have set influx thus:

#### Database
influxdb:
  host: 192.168.1.4

…and set up purge like this:

# Enable recorder and set days to purge DB
recorder:
  purge_interval: 1
  purge_keep_days: 1

-But i thought the whole reason for setting up an external database was (amongst other things) not to fill the SD-card on my Pi3/Hass.io installation with the native database?

4

InfluxDB runs in parallel to the recorder DataBase selected and not used by recorder or history.

For the recorder you can use a sql-lite or another DB like MariaDB, etc.

See this link, and specifically the repack option which should shrink the DB backing storage.

2 Likes
5

Thank you! I did not know it intentionally ran in parallel - now I’m off to learn new things!

6

Merci Vielma!