Action items:
- Discuss with DEVOPS to increase RAM.
- Figure out why count is causing slow queries
- Wait until mongo for forums is in house
- Get the list of most used queries
...
Notes:
- 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.
...