search

mozilla / missioncontrol

Real-time monitoring of Firefox release health
Mozilla Public License 2.0
21 stars 18 forks source link

Relative release view is broken #258

Closed wlach closed 6 years ago

wlach commented 6 years ago

It appears that the relative release view I added a while back (and discussed at some length here: https://wlach.github.io/blog/2018/02/derived-versus-direct/) is no longer working. E.g. this link isn't working for me:

https://data-missioncontrol.dev.mozaws.net/#/beta/windows/content_crashes?timeInterval=0&relative=1&percentile=99&normalized=1&disabledVersions=&versionGrouping=version

I imagine this is due to some slow queries which probably got slower as we added more data to the db. This may or may not be easy to fix.

wlach commented 6 years ago

This is actually still a problem. I have some changes coming to simplify the db, I'm hoping that will magically just fix this. If not, hopefully it's just a matter of adding some more indexes.

wlach commented 6 years ago

Still a problem, I believe the issue is that the db is loaded down. Part of the issue is inefficient sql queries (which I'm trying to fix), we should also use at least a medium instance for the db instead of a micro.

wlach commented 6 years ago

This is working, after some further query optimization and upgrading our db instance from a micro to a medium.