Last Modified: Apr 10, 2019
See more info
BIG-IP ASM, AVR
Known Affected Versions:
11.4.0, 11.4.1, 11.5.0
11.6.0, 11.5.1, 11.5.0 HF1, 11.4.1 HF4, 11.4.0 HF6
Opened: Feb 12, 2014
AVR DB grows to a huge size and fills up the /var and /var/lib/mysql partitions.
Machine will go to offline status.
Conditions leading to this issue include having a DoS profile with application DoS enabled on a virtual server that does not have an analytics profile with URL collection attached to it.
1. Provision AVR in addition to ASM (tmos)# modify sys provision avr level nominal 2. Turn on URL collection in an analytics profile and attach this profile to each virtual server that has a DoS application profile attached to it. 3. After 2 hours (aggregation/deletion of URL stats) the AVR_DIM_URL table size should be greatly reduced by running the following MySQL command from within the AVR DB: OPTIMIZE TABLE AVR_DIM_URL
The AVR_DIM_URL table size is now controlled and does not fill the /var/lib/mysql partition nor block /var/avr/loader files from being loaded.