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

Last Modified: Jul 12, 2023

Affected Product(s):
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

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips