Hello, Is it possible to change/reduce the default ASM DB log size and the default number of entries. We are running BIG-IP 12.1.2 and I found on devcentral two answers from F5 saying that default values are 2 GB for the DB size or 3 million entries (depending on which one is reached first) https://devcentral.f5.com/questions/asm-request-event-correlation-differencies https://devcentral.f5.com/questions/asm-logging Thanks

The ASM event log is a MySQL database that is created when ASM is first provisioned on a BIG-IP system. As such, its size and capacity are fixed.

Why would you want to reduce it? it is not a 'default' size but a maximum one and its limits are defined by the fact that it is stored in mySQL database built-into ASM. I think you might be confusing it with asm.log file on the file system

JT, While it is possible to increase the amount of requests that can be stored in the mysql db (either the number of requests or the size of the db itself), it's not something that we'd recommend as it can cause performance impact (particularly with the GUI in loading all the requests). If you see more requests being logged than the specified limit, then we'd recommend going with using remote storage. Ashwin

Hello Ashwin, Thanks for you answer. Based on links that I shared in my question. other "F5 members" have already clarified the fact that it is not recommended to increase theses values. But my question was to decrease it. Indeed, my hope is to change these values for example from 2 GB to 1 GB and from 3 million events to 1.5. Please share the procedure. Regards

Changing the default ASM DB log size and the default number of entries

15 Replies

CharlesCS
Cirrus
Jul 20, 2017
The ASM event log is a MySQL database that is created when ASM is first provisioned on a BIG-IP system. As such, its size and capacity are fixed.
samstep
Cirrocumulus
Jul 20, 2017
Why would you want to reduce it? it is not a 'default' size but a maximum one and its limits are defined by the fact that it is stored in mySQL database built-into ASM. I think you might be confusing it with asm.log file on the file system
Ashwin_Venkat_1
Historic F5 Account
Jul 21, 2017
JT,

While it is possible to increase the amount of requests that can be stored in the mysql db (either the number of requests or the size of the db itself), it's not something that we'd recommend as it can cause performance impact (particularly with the GUI in loading all the requests). If you see more requests being logged than the specified limit, then we'd recommend going with using remote storage.

Ashwin
- Jad_Tabbara__J1
  Cirrostratus
  Jul 24, 2017
  Hello Ashwin,
  
  Thanks for you answer. Based on links that I shared in my question. other "F5 members" have already clarified the fact that it is not recommended to increase theses values.
  
  But my question was to decrease it. Indeed, my hope is to change these values for example from 2 GB to 1 GB and from 3 million events to 1.5.
  
  Please share the procedure.
  
  Regards
- Jad_Tabbara__J1
  Cirrostratus
  Jul 31, 2017
  Hello Ashwin,
  
  Please could you share how to do it ?
  
  Thanks
- Jerry_Lees
  Employee
  Jul 10, 2018
  I realize this is old, but could you clarify why you would like to decrease the size? Most people end up wanting to increase thee numbers when they ask about database sizes.
  
  I can't think of a reason to make it smaller other than a system is running low on disk space, honestly, that's a completely different problem too. One that an additional 1Gb isn't going to solve long term.
Ashwin_Venkat
Employee
Jul 21, 2017
JT,

While it is possible to increase the amount of requests that can be stored in the mysql db (either the number of requests or the size of the db itself), it's not something that we'd recommend as it can cause performance impact (particularly with the GUI in loading all the requests). If you see more requests being logged than the specified limit, then we'd recommend going with using remote storage.

Ashwin
- Jad_Tabbara__J1
  Cirrostratus
  Jul 24, 2017
  Hello Ashwin,
  
  Thanks for you answer. Based on links that I shared in my question. other "F5 members" have already clarified the fact that it is not recommended to increase theses values.
  
  But my question was to decrease it. Indeed, my hope is to change these values for example from 2 GB to 1 GB and from 3 million events to 1.5.
  
  Please share the procedure.
  
  Regards
- Jad_Tabbara__J1
  Cirrostratus
  Jul 31, 2017
  Hello Ashwin,
  
  Please could you share how to do it ?
  
  Thanks
- Jerry_Lees
  Employee
  Jul 10, 2018
  I realize this is old, but could you clarify why you would like to decrease the size? Most people end up wanting to increase thee numbers when they ask about database sizes.
  
  I can't think of a reason to make it smaller other than a system is running low on disk space, honestly, that's a completely different problem too. One that an additional 1Gb isn't going to solve long term.
Jeon_Byeong_Jun
Nimbostratus
Oct 10, 2018
how did you solve this case? i'm trying to change log size for asm. do you share soltion?