My disk is filling up on its own and very quickly!

Installation Home Assistant OS
1

My problem

I have had a problem for a few days: the disk is filling up visibly (10 GB every 8 hours, it can be faster). I have to restart HA to find some breath (about 10 GB found after reboot).
I can’t figure out where it’s coming from. I am updated to the latest version.
On the logs side, I only take critical notifications.
The data (which is certainly voluminous since I keep 1 year of history) represents 45 GB, is stored on MariaDB (in a Docker container on HA).

So I’m interested if you have any ideas because I’m dry!
THANKS

My setup

System Information

release core-2023.3.2
installation_type Home Assistant OS
dev false
hasio true
docker true
user root
virtualenv false
python_version 3.10.10
os_name linux
os_version 5.15.90
arch x86_64
time zone Europe/Paris
config_dir /config
Home Assistant Community Store
GitHub API OK
GitHub Content OK
GitHub Web OK
GitHub API Calls Remaining 4996
Installed Version 1.31.0
Internship running
Available Repositories 1242
Downloaded Repositories 27
Home Assistant Cloud
logged_in false
can_reach_cert_server OK
can_reach_cloud_auth OK
can_reach_cloud OK
Home Assistant Supervisor
host_os Home Assistant OS 9.5
update_channel steady
supervisor_version supervisor-2023.03.1
agent_version 1.4.1
docker_version 20.10.22
disk_total 117.4GB
disk_used 117.4GB
healthy true
supported true
board ova
supervisor_api OK
api_version OK
installed_addons Samba share (10.0.0), deCONZ (6.18.0), File editor (5.5.0), MariaDB (2.5.2), Mosquitto broker (6.1.3), NGINX Home Assistant SSL proxy (3.2.0), RPC Shutdown (2.2), AdGuard Home (4.8.2), Node-RED (14.0.4), SSH & Web Terminal (13.0.3), Z-Wave JS UI (1.7.1), Let’s Encrypt (4.12.8) , Grafana (8.2.0), InfluxDB (4.5.0), phpMyAdmin (0.8.3), Home Assistant Google Drive Backup (0.110.1), ESPHome (2023.2.4), Glances (0.17.2)
Dashboards
dashboards 3
resources 16
views 24
fashion storage
Recorder
oldest_recorder_run March 12, 2022 at 1:13 PM
current_recorder_run March 9, 2023 at 10:58 am
estimated_db_size 44778.22 MiB
database_engine mysql
database_version 10.6.10
___
2

Home Assistant backup files?

3

no, I deleted them.

4

Is it your logs? Any new errors?

I recently had my database get very bloated by some new temp sensors that stored temperatures to 4 decimal place causing them to change hundreds of times each minute

5

Have you any idea of what/how much you store in influxdb ?

I.E a single grafana-graph, with " every-second-plot-timestamp-value-value-reused-in-additional-summarizing-graph-for-comparization-with-initial-graph-to-show-variation-compared-to-last-year", will soon fill some :slight_smile: … ps: just an example

PS: As i noticed you also have Samba-Share, so it should be fairly easy to have an over-view of included files/folders there ( thou i assume you have/had an eye on that ) … if so, left is the container for Influx storage

PS2, i hope you have “Recorder” configured in configuration.yaml, as well as proper configured influx

6

Hello, FYI, I truncate the states, events and state_attributes tables which were large (in number of records and in weight). Everything seems to be back to normal with less data to manage. I put probes on the growth of the disc to monitor… Thanks for your good ideas.