Rapidly growing database

Configuration
1

Since early May, my database is rapidly growing. Approximately 1MB per minute! The database used to be a few 100MB for 10 days. It was 7GB the other day.

I’m not sure what might have caused this, it’s not a core update, since it was running 2023.4.1 across backups.

Is there a way to see what specific data is added, so I can troubleshoot my config?

2

Try to remember what changes you have done around late March/early May…
Do you added any sensor or entity refreshing every seconds for instance ?

You can look inside the database if you know mysql commands…

To mitigate this, list the entities you need historical values and update the recorder accordinly… Here is an example from my configuration (FYI, I am using MariaDB):

recorder:
  db_url: !secret mariadb_url
  purge_keep_days: 7
  include:
    entities:
      - input_number.reseau_sfr 
      - input_number.reseau_orange
      - input_boolean.smappee_injected 
      - input_boolean.remote_montreal_smappee_injected 
    entity_globs:
      - sensor.*
      - device_tracker.*
      - switch.*
      - group.*
  exclude:
    entities:
      - sensor.message_header
      - sensor.sms_footer
3

Thanks for your prompt reply, I will consider your suggestion.

I have a suspect… The RFXTRX integration was adding devices automatically. It had ~40 smoke detectors from my neighbors. I deleted those manually and the database growth has stabilized. I will watch closely.

Other suggestions are still welcome.

4

That did not work out. Still growing…

5

How does one check the current database size?

6

sensor.home_assistant_v2_db_size

1 Like