Overview
Some widgets on our service dashboards were slow to load or timing out, and custom dashboards were also taking longer to load. The impact was limited to prod 2 customers only.
Timeline (PST)
Time
Event
3:20 AM
Incident declared and team got engaged.
4.00 AM
Issue got identified and working on mitigation.
5.00 AM
Mitigated and monitoring.
5:30 AM
Issue got resolved
RCA
Certain database queries were taking significant amount of time to complete, leading to a spike in CPU usage, with levels reaching nearly 100 percent. To address this issue, the following actions were taken as part of the resolution process:
- We terminated long-running queries and optimized database to address the issue.
- We added database CPU alerts in addition to our existing APM alerts to further improve our MTTD.
Follow up Action Items
- Set up a cron job to perform database optimization on a regular basis.
- Review and optimize other queries.