Hi!
I have a problem with MariaDB and I don’t know if is because a new OS update or something else, maybe someone knows how to solve it.
Till few days ago, lets say 2 weeks, the size of mariaDB was everytime around 1.5GB and knowing this I have not checked every day, but for about 2-3 days, I see that mariaDB it is around 12GB and it is growing.
I have an automation which execute a purge every day at 4 o clock, but I see no big change.
This is what I have configured as recorder, and it is like this for at least 1-2 years…
recorder:
db_url: !secret mariadb_url
purge_keep_days: 7
commit_interval: 30
exclude:
entity_globs:
- sensor.watchman*
And this is what I have as automation purge:
alias: Auto - Database purge (purge database every day at 04:00)
description: ""
trigger:
- platform: time
at: "04:00"
condition: []
action:
- service: recorder.purge
data:
keep_days: 7
repack: true
mode: single
Any idea how to solve this issue? Or at least, how to delete the entire database and start from scratch?
If it helps, this is a history of the database growing in 7 days
Thank you all, in advance!