Last Modified: Nov 22, 2021
Opened: Aug 13, 2013
Severity: 3-Major
Related Article:
K22029939
The customer is seeing high CPU related to mySQL. The following query was observed by Support to heavily consume MySQL resources: ---------------------------------------------------------------------- DELETE FROM INCIDENTS WHERE status = 3 AND incident_id IN (SELECT incident_id FROM INCIDENT_REQUESTS WHERE request_id = 4105372201156407197) ----------------------------------------------------------------------
Performance system impact.
Performing DELETE query within Event Correlation.
This issue has no workaround at this time.
Event Correlation: Heavy MySQL resources are no longer used when a potential incident is converted into an actual incident.