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:

Fixed In:

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.

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