Hi all, i’ve setup HA with a MySQL backend and for now, the size is 21GB. I have the config setup with this for now : recorder: purge_keep_days: 60 mainly, the states and state_attributes tables are out of control. [image] Any tricks I can use to reduce the database size? Thanks.

Big Database, info on how to reduce size needed

tom_l January 20, 2023, 2:34pm 2

But the biggest change you could make would be if you only kept 7 days of data. That would bring it under 2.5GB.

If you want to keep data for longer than that use InfluxDB.