Bug ID 427769: Event Correlation query causes heavy MySQL resource usage

Last Modified: Nov 22, 2021

Bug Tracker

Affected Product:  See more info
BIG-IP ASM(all modules)

Known Affected Versions:
11.3.0

Fixed In:
11.5.0

Opened: Aug 13, 2013
Severity: 3-Major
Related Article:
K22029939

Symptoms

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) ----------------------------------------------------------------------

Impact

Performance system impact.

Conditions

Performing DELETE query within Event Correlation.

Workaround

This issue has no workaround at this time.

Fix Information

Event Correlation: Heavy MySQL resources are no longer used when a potential incident is converted into an actual incident.

Behavior Change