20.03.2019 · I was able to get my db size sensor working using the doc: sensor: - platform: sql db_url: mysql://user:password@localhost/hass queries: - name: DB size query: 'SELECT table_schema "database", Round(Sum(data_length + index_length) / 1024, 1) "value" FROM information_schema.tables WHERE table_schema="hass" GROUP BY table_schema;' column: …
21.12.2021 · Home Assistant - Setup MariaDB Database Size Sensor Last updated on December 21, 2021 Here I describe how to create a sensor for Home Assistant that will monitor the size of the MariaDB database with a scan interval of one hour. Dependencies. Make ...
MariaDB is an implementation of MySQL that can handle a lot more data a lot more efficiently than SQLite. If you are having unknown slowdowns with your Home Assistant Instance, or if you are having the display of sensors disappear, this may well be the fix for you. A good way to tell is for you to look at your ‘home-assistant_v2. db’ file.
Dec 19, 2019 · MariaDB; size almost 2GB... How to limit? - Configuration - Home Assistant Community. I have excluded all ‘domains’ from ‘data-base’ but the ‘data-base’ is still growing. Now almost 2GB size.
A good way to tell is for you to look at your ‘home-assistant_v2. db’ file. If it is over 800mb, you are a candidate to replace the internal database with MariaDB Addon or some other external database. Update as of Home Assistant 2021.7 version. If using @ inside your db_url as I did below, the @ sign now needs to be represented as %40. See HA Documentation for the breaking change related to recorder:
Mar 20, 2019 · I was able to get my db size sensor working using the doc: sensor: - platform: sql db_url: mysql://user:password@localhost/hass queries: - name: DB size query: 'SELECT table_schema "database", Round(Sum(data_length + index_length) / 1024, 1) "value" FROM information_schema.tables WHERE table_schema="hass" GROUP BY table_schema;' column: 'value ...
19.12.2019 · I have excluded all ‘domains’ from ‘data-base’ but the ‘data-base’ is still growing. Now almost 2GB size. I also have some automation - to purge the DB, but looks like it is poorly working. What I have wrong set-up? A…
Dec 21, 2021 · Home Assistant - Setup MariaDB Database Size Sensor Last updated on December 21, 2021 Here I describe how to create a sensor for Home Assistant that will monitor the size of the MariaDB database with a scan interval of one hour.
Mar 08, 2020 · Using MariaDB and the database has now grown passing 9 Gb. I’ve added some exludes to recoder: recorder: db_url: !secret urlMariaDB purge_keep_days: 14 exclude: domains: - weblink - updater - input_boolean - input_number - input_select - input_text - light - media_player - sun - timer - weather - camera entities: ... a bunch of entities also... Also, I’ve got an automation to purge the ...