...
4. Corrective Actions (Fixes for this instance)
Action | Owner | Target Date | Status |
Suggested Operations team not to extract bulk report data from Primary production servers Enabled General log in Production to analyze further server performance impacted queries #general-log=1 #general_log_file="ASSAM-ECD.log" Analyzed slowquery log queries and optimized with required indexes. | Anil | 2025-05-06 | Closed |
Immediate actions to resolve the issue and restore service.
...
5. Preventive Actions (To prevent recurrence)
Action | Owner | TargetDate | Status |
|---|---|---|---|
We can plan dump the frequently used monthly reports into tables through db events at non-peak production hours. Extract data from replication server | Anil |
Systemic changes, monitoring, alerting, process updates, or automation.
...
6. Verification of Effectiveness
Describe how you'll verify that the corrective and preventive actions have worked (e.g., logs, metrics, test cases, recurrence check).Will monitor Server impacted queries in “SlowQueryLog”&”General Logs”
...
7. Lessons Learned
Summarize learnings and recommendations to share with team or org-wideNot to extract Bulk reports from Production server at peak hours .
...