I did some digging around on the reason why graphing is so terribly slow on my setup (Homeassistant 0.34, MySQL database 400+ megabyte). When trying to create a graph (by clicking on a sensor) I see that multiple get requests are fired towards the same url (http://192.168.1.5:8123/api/history/period?filter_entity_id=sensor.power_consumption) this seems to be not logical, right?
In my configuration.yaml I have the following for the recorder:
recorder:
db_url: mysql://root:[email protected]/hass?charset=utf8