I use MySQL for running some analytics in my project. I thought on switching to a time series database, but haven't done because I could see it would give me a lot of trouble. I also end up with your same solution. Running a worker that caches the different data for the dashboard plots. If you make the change, I would be happy to read about your implementation.