Hi !!
I’ve had some issues with a huge database even using the recorder integration with include option, selecting the entities of interest (mostly temperatures, humidity, automation histories, …).
I had to delete it.
Moved to MariaDB without any issue.
Added some more features.
The database is growing at about 80 MB/day.
I have noticed one Zigbee device generating a huge amount of data ( TS0601_smart_air_house_keeper with 7 sensors. At a point that I decided to disable the recording for 6 of them till I find a way.
I tried to call a service : Recorder: Purge Entities. But it does nothing. No trace in the logs too.
The database continue to grow.
Does this function work ?
That’s not much. Mine grows at 350MB/day, until the purge keep days is reached (7 days) the it levels off at just under 2.5GB. I use extensive excludes.
So yes it does work.
Try setting the repack option to true when doing a manual purge.
I have set now 7 days… It is to monitor the temperatures and my heater to optimize the settings.
I have started to move entities to InfluxDB as it may be less space consumming
I have removed 6 sensors that were recording about 20,000 entries in the DB. It should be better too.
Do you know if there is a possibility to reduce the interval between 2 records ?
Well, I can’t explain why I see it now, but the purge is working now. I see it on myphpadmin.
Just did the last update of HA… could be a coincidence. Yesterday it was not working