You can delete everything in the statistics_… tables if you don’t use statistics. Apparently those are never purged. Not a huge gain, but every little bit helps.
The biggest bang for the buck is to ruthlessly exclude every entity you don’t need history for, as described in the thread linked above.
But most people find some things they need to keep longer than 7 days (or whatever they set it to.) It’s been an ongoing frustration for many here. Feel free to add your vote to this FR, if you think this is a good idea. Meanwhile, I’ve resorted to saving run-time statistics about my heating system to a text file, and just keep those forever.
yeah… I see… mainly, i’d like to keep my energy & device_tracker stats… those are useful to me… the switch states… less…
I need to find a way to put the important stats into influxdb (long terms data) and the rest into mysql where i can shrink the table size with a less meaningful timeline.