Not sure if it is just my configuration but often I have to wait 10 - 15 seconds, sometimes 30 - 45 seconds and sometimes even several minutes for a graph to render, my temperature monitors seem to take the longest but it also happens to speedtest, even lights on and off bar graph!
I attempted to solve it by renaming the home-assistant_v2.db file (it was 2.3gb) the replacement has since grown to 1.3gb
+1 to influxdb and grafana - configurable graphs and comparative analysis - nice!
after setting up a system myself, i can recommend NOT running grafana on a pi, 2, 3 or otherwise. 2 reasons;
compiling grafana for arm is moderately complicated. Plus i coundnāt get a recent version for arm. grafana x86 is on v4.1, if you compile on arm i couldnāt find a repo past v2
space/data size. my rpi2 hass 8gb lasted less than a month once i put grafana on it. grafana/influxdb (i never figured out which one it was) just soaked the sd card with data. to the point where hass couldnāt write its logs or dbs, and bombed. depending on your os, that could spell trouble.
i researched pointing grafana to external usb/sd/network for the db, but in the end just virtualised on my x86 main server.
now, with a fast sd card, home assistant runs very fast and responsive, and grafana can burp out all the data it wants onto my home server zfs array, and everybodys happy!
@molano - thanks for the info! iāll investigateā¦
@Stewface - influxdb and mysSQL are different in this context. influxdb is like a āpluginā almost to homeassistant, whereas if you use mySQL you fundamentally change/replace homeassisstantās back-end. HASS uses, by default, SQLite as its main databasing tool, and switching to mySQL replaces that. Influxdb is used in addition to whatever backend db tool HASS uses. I think.
@danpow you are right. I use mysql to store all data locally for 1 week (with the recorder), so I can have the data and some quick graphs by hand in the hass web UI.
Next to that I push everything to Influxdb and can create my own graphs in Grafana over time and when I need them.
So two seperate items. You can use them both or only one. Whatever you like.