Disable unused history/recorder to speed up Pi install

Installation
1

I’ve googled this and not managed to find what i was looking for…

I have a brand new PI3B+ manual install (not HASSIO) and everything is working great but i don’t really use the history collection. I had tuned the recorder component so that i only keep two days and purge every day to this:

# Enables support for tracking state changes over time
history:

recorder:
  purge_interval: 1
  purge_keep_days: 2

Touble is that i have alot of zwave devices (which i’m tuning too) but thought as a quick win on performance if i could completely disable history and recorder i would get some gains. I tried rem-ing out “#” all of the above in the configuration.yaml file and restarting HA but i still see datestamp updates on the “home-assistant_v2.db” file. I even tried stopping HA, deleting the .db file and restarting it and it seems to get recreated.

How can i make HA faster by tuning this / disabling it ?

Thanks!

Mark

p.s. this is the install method i used:

2

#faceplam# lol

i found it - rem’ed out:

# View all events in a logbook
logbook:
  • stop HA + deleted the .db file + restarted HA and noticed no new database etc

I might switch it back on in the future - anyone any recommendations for a PI database, i’m sure i read MySQL was faster on the PI ?

3

So have you noticed any performance improvement?

1 Like
4

I think so yes, the time lag between a ZWave remote and a switch getting switched seems snappier

5

I found moving to MariaDB (MySQL fork by original devs.) seemed better for me, reload times were much better than using the SQLite default. I currently use the MariaDB Hassio addon however an considering moving the DB off to another Pi as the addon doesnt give me quite what I am after for data management (I want replication to another server for a data analysis/warehousing project my other half is working on etc.

1 Like