My default DB (SQLite) is getting bigger and corrupted. Tried to setup InfluxDB but wondering why home-assistant_v2.db still growing. I checked from InfluxDB GUI and see the data is still coming to them. What’s mechanism they store data in database?. A few days in default and later in Influx?. I am confused here.
Below is my confing on Influx from configruation.yaml
You can not use influxDB as the home assistant recorder database. It can only be used as a parallel storage database, generally used for long term storage of history data, while the recorder DB is used for short term storage.
Try MariaDB instead. There’s an addon for it if you are running a supervised version of Home assistant.
Thanks!. I see. The SQLite is still there. My understanding is, we should limit the size of recorder database and let data grow in Influx DB instead. How should we do this?.
For Maria DB, can we use it to replace SQLite in this case?
Yes you can. It uses a bit more memory but is far less prone to corruption and is more responsive on lower spec’d hardware. Definitely worth doing. Read the documentation on how to do this.
Like this:
As well as only recording entities that I’m interested in short term data for I also only include the entities that I’m interested in long term data for in InfluxDB (it uses the same include/exclude system as the recorder).
I just installed it. However I have no idea how to check it’s up and running. There is side tab like Influx DB that I can check. Nothing related to MariaDB in configruation.yaml too. Basically, I need to know
How big of DB file?
How to check our data flowing in to Maria DB
Do I need to load in Portainer to check as I understand that it’s run on different container?