Are you sure it was iniflux and not MariaDB?
You can’t use InfluxDB as a home assistant database, it does not have an SQL backend.
My strategy (there are many options):
-
Use MariaDB to store a weeks worth of data for home assistant, using lots of excludes to only store information that I am interested in short term.
-
Use InfluxDB to store long term (two years) data for graphing, using includes to only store information that I am interested in long term.
Prior to the recent optimisations my DB was about 1.6GB for a week, and I had many excludes.
After the optimisations it is averaging about 350MB. However I also systematically organised my excludes.
I estimate that two yeas of InfluxDB data that I’m interested in will run about 1.5GB.
