Last Modified: Sep 13, 2023
Affected Product(s):
BIG-IP ASM, AVR
Known Affected Versions:
12.1.0, 12.1.1, 12.1.2, 12.1.3, 12.1.3.1, 12.1.3.2, 12.1.3.3, 12.1.3.4, 12.1.3.5, 12.1.3.6, 12.1.3.7, 12.1.4, 12.1.4.1, 12.1.5, 12.1.5.1, 12.1.5.2, 12.1.5.3, 12.1.6, 13.0.0, 13.0.0 HF1, 13.0.0 HF2, 13.0.0 HF3, 13.0.1, 13.1.0, 13.1.0.1
Fixed In:
14.0.0, 13.1.0.2
Opened: Oct 15, 2017 Severity: 2-Critical Related Article:
K23345645
/var/lib/mysql mount point gets full.
While other dimensions are being collapsed correctly, the Device ID field is not being collapsed causing the growth in size. -- High disk usage. -- Frequent need to clear AVR data.
Many combinations of IP addresses, Device IDs (and other ASM dimensions) in traffic over very long period of time (potentially weeks/months).
Manually delete AVR mysql partitions located in /var/lib/mysql/AVR.
Over time, no of the AVR_STAT_ASM_HTTP_CLIENT_IP_X#...MYD file exceeds 300 MB, so this problem no longer occurs.