srch

If you prefer to run a database server (e.g., PostgreSQL), use the recorder component. To work with SQLite database manually from the command-line, you will need an installation of sqlite3. Alternatively DB Browser for SQLite provides a viewer for exploring the database data and an editor for executing SQL commands. First load your database ...

The default, and recommended, database engine is SQLite which does not require any configuration. The database is stored in your Home Assistant configuration directory (’/config/’) and is named home-assistant_v2.db. To change the defaults for the recorder integration in your installation, add the following to your configuration.yaml file:

02.12.2019 · I have HA 0.96.5. It’s running on an old, but very competent laptop. I rarely see CPU usage above about 5%, never seem memory usage over 50% and the hard drive is almost empty. When the home-assistant_v2.db file reaches about 2Gb, updates to my tabs get very slow. It can take 10 seconds to refresh. I have only about 20 sensors, on 5 minute updates.

Aug 29, 2020 · Stop HA first. The database is the file with _v2 In the name and it is in the same folder as your config file (config folder). 1 Like. 123 (Taras) August 29, 2020, 8:17pm #3. For Home Assistant OS, login via ssh and then: ha core stop rm /config/home-assistant_v2.db ha core start. 4 Likes.

One-liner to convert an existing Home-Assistant SQLite database to MySQL ... and reload into mysql , then cleanup crap sql files and exit the container.

MariaDB · auto_purge: Automatically purge the database every night at 04:12 local time. · purge_keep_days: Specify the number of history days to ...

Automatically purge the database every night at 04:12 local time. Purging keeps the database from growing indefinitely, which takes up disk ...

Open the Home Assistant UI and go to Settings > System > Backups, here you will see all your backups, these can be downloaded and placed somewhere safe. When you have done that, you can delete them in the UI and it will free up some space for you. Uninstall unused add-ons

Some commands to investigate and cleanup my Home Assistant database. ... First show all databases, and delete unused, if you install and add-on ...

Delete the database file and then use the recorder setting in your config.yaml to reduce what is logged or purge every week or so.

Mar 05, 2018 · The easiest way out of this situation is indeed to delete the database and just start over. Recent versions of Home Assistant periodically purge the database by default, hopefully avoiding many of the cases where the database grows too big. Mariusthvdb (Marius) March 25, 2018, 8:57pm #7. amelchio:

Database - Home Assistant Database 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.

The database is stored in your Home Assistant configuration directory ... The purge task runs every 2 days, starting from when Home Assistant is started if ...

Dec 02, 2019 · My understanding is that rather than trying to remove entries, repack creates a fresh file, then deletes the old database, replacing it with the new. Sure enough, I spot home-assistant_v2.db-wal ramping up in size until about 4Gb, then going back to zero. So, I considered that 4Gb must simply be the size for 14 days worth of data for my sensors.

Delete old backups Open the Home Assistant UI and go to Settings > System > Backups, here you will see all your backups, these can be downloaded and placed somewhere safe. When you have done that, you can delete them in the UI and it will free up …

29.08.2020 · If you just updated to 114, that explains why it no longer has errors. A new feature was introduced that detects if the database is corrupted, HA will archive the database, create a new one, and continue loading. So your old database is there, just malformed and not in a recoverable state HA can do anything with.