...
- It would be suggested to have a usable index for every query that we have. Slow queries can reduce the overall performance.
- Obtaining a list of queries would be ideal for index creation. The current indexes have not been designed with index intersection in mind.
- Common trend amongst slow queries is `count`
- All errors rates observed are due to the decrease in timeouts. https://github.com/edx/cs_comments_service/pull/146
- Index selectivity still needs some work.
Improvements:
After applying the index on Nov 11, 11:05, we can see a significant improvement as expected.
...