This leads to about 120 events being logged / minute, when I scale it for the whole house, that would grow to over 600 events / minute. In order for HA to reflect changes made by a hardwired switch, and to do so in a timely manner, I publish a MQTT status message every 10 seconds or so. I can control the panel with HA using MQTT, but someone can also turn a light ON or OFF with a hard wired switch. I’m working on a gateway between the lighting control panel and HA. Our house has a lighting control panel, where each lighting circuit is controlled by a latching relay. In my case, the reason is my current implementation of my lighting control. The growth has to do with the way HA logs events in the database. My database grows over 2Mb / hour, so right now I’m at 27Mb since the database was created about 12 hours ago.
Tiny mysql server vdi windows#
I run HomeAssistant in a docker, so must do docker restart home-assistant. When this happens, I can’t restart home assistant from the UI. My HomeAssistant database files keep getting very large >100mb. Keep running into the following problem, even from older to current versions of HomeAssistant.