srch

Hi, I have a DB that is GB large, and wish to reduce its size, how to check the inside (I don't know much about DB)? Overall my devices are ...

Home Assistant uses database to store events and parameters for history and tracking. The default database used is SQLite and the database file is stored in your configuration directory (e.g., <path to config dir>/home-assistant_v2.db); however, other databases can be used.If you prefer to run a database server (e.g., PostgreSQL), use the recorder component.

May 29, 2019 · Hi, I have a DB that is GB large, and wish to reduce its size, how to check the inside (I don’t know much about DB)? Overall my devices are around 100 (although with lots of sensors and components) For the moment this is my configuration, any clue on how to reduce the size improving the config? recorder: # db_url: /backup purge_interval: 2 purge_keep_days: 3 include: domains: - sensor ...

When backing up my homeassistant installation I was surprised to ... my home-assistant_v2.db growing to be very large (4.2GB in my case).

The database is stored in your Home Assistant configuration directory ... a lot of entities in your system and your exclude lists possibly get very large, ...

29.05.2019 · Hi, I have a DB that is GB large, and wish to reduce its size, how to check the inside (I don’t know much about DB)? Overall my devices are around 100 (although with lots of sensors and components) For the moment this is my configuration, any clue on how to reduce the size improving the config? recorder: # db_url: /backup purge_interval: 2 purge_keep_days: 3 …

23.09.2016 · My HomeAssistant database files keep getting very large >100mb. When this happens, I can’t restart home assistant from the UI. I run HomeAssistant in a docker, so must do docker restart home-assistant. Restarting becomes really really slow. On the 16th of August, my home_assistant_v2.db file got to 244mb.

Though I've been fighting with DB size it was still large. Yes, I had configured recorder and logbook sections as suggested, ...

Jun 24, 2020 · Since Home Assistant does not collect data, we do not know how large the average database size is. Please complete the poll and post the size of your database below. # ls -lh /config/home-assistant_v2.db -rwxr-xr-x 1 root root 244.7M Mar 25 16:55 /config/home-assistant_v2.db. Using phpMyAdmin: Click on the homeassistant database and look for ...

Couple of things which really made the database large were: device trackers especially when using Ubiquiti Unifi. TP-Link smart switches. Weather data. Assuming you're using the default standard flat file database for Home Assistant get your hands on SQLite Browser. You can then look at the database and see what's taking up so much space.

I have recorder configured to keep just 7 days of data but my home-assistant_v2.db file is still over 1GB.

We are looking to improve database performance. Since Home Assistant does not collect data, we do not know how large the average database ...

The Home Assistant database can get huge! Luckily there is a tool you can use to purge the contents of the database. You can filter what you send to the database, and even change how long it stores the data with the purge_keep_days setting. Delete old backups.

12.10.2020 · Though I’ve been fighting with DB size it was still large. Yes, I had configured recorder and logbook sections as suggested, excluding things that appear in history or logs, but still, it was growing large which in turn increased reboot time and I suspect was also cause why my installation could become irresponsible after some time or after unlucky hard reboot (doing …

Oct 02, 2016 · I have noticed my home_assistant_v2 file being touched. But at the moment that was a week ago when the MySQL server crashed for some reason. Tyfoon 2016-10-05 16:56:19 UTC #23

I just noticed the v2 hass database has grown to gigantic 8GB and my ... then they disappeared and my home-assistant_v2.db is still as huge.

24.06.2020 · Since Home Assistant does not collect data, we do not know how large the average database size is. Please complete the poll and post the size of your database below. # ls -lh /config/home-assistant_v2.db -rwxr-xr-x 1 root root 244.7M Mar 25 16:55 /config/home-assistant_v2.db. Using phpMyAdmin: Click on the homeassistant database and look for ...

06.08.2019 · Hello, I have been researching this topic for a while here and have tried to adding the recorder option to my configuration.yaml file, but the database does not resize. I am currently using the default database ( home-assistant_v2.db). Having a large database has been causing poor performance with HA. Do you have any other suggestions? Have modified this to keep …

Home Assistant uses database to store events and parameters for history and tracking. The default database used is SQLite and the database file is stored in your configuration directory (e.g., <path to config dir>/home-assistant_v2.db); however, other databases can be used.

Sep 23, 2016 · Hey guys, Keep running into the following problem, even from older to current versions of HomeAssistant. My HomeAssistant database files keep getting very large >100mb. When this happens, I can’t restart home assistant from the UI. I run HomeAssistant in a docker, so must do docker restart home-assistant. Restarting becomes really really slow. On the 16th of August, my home_assistant_v2.db ...

Home Assistant stores a lot of data about events (example: light.office just ... The events table is now the largest part of my database.

My HomeAssistant database files keep getting very large >100mb. When this happens, I can't restart home assistant…

The larger the database, the slower Home Assistant will run, because SQLite will have to read/write more data (and more metadata, ...

Dec 29, 2019 · I use the influxdb webui page on the sidebar/influxdb admin/edit the ‘homeassistant autogen’ retention policy and save. Your db may be named home-assistant or similar (I named mine homeassistant). The important take is you modify the retention policy for your ha database, not the _internal database policy (which is by default set to 7d).