MySQL Recorder Issue: Creating sort index | Home Assistant | Page 1

https://gist.github.com/thenoid/1e8e91231508d31381d1413d9bbb152f

Something is doing a horrible select of doom, no clue where to start or how to trace this down in HA. it's killing the recorder however. I assume this falls into "related tech" since it's the mariadb/mysql recorder? didn't seem to be a better place.

Gist

gist:1e8e91231508d31381d1413d9bbb152f

GitHub Gist: instantly share code, notes, and snippets.

@rocky horizon i saw you help with a similar issue, about a year ago, but supposedly a guard was put in place to prevent this.

#MySQL Recorder Issue: Creating sort index