How do I allocate more or less memory to Mysql in NFA after upgrading system memory?

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

How to change the memory allocation to MySql after upgrading system memory? 

 

Environment

NFA 9.3.2 and later versions

Resolution

 

Starting with NFA 9.3.2 there is a setting in the my.ini file located in the \CA\NFA\Mysql\ directory called "innodb_buffer_pool_size".
By default, this is set to half of your system's physical memory in megabytes.

If you increase RAM on the server you can increase this to be just under half of your system's RAM.

For example, if you have 16 GB's of RAM, you could set the value to "8191M"

Below is an example of how it looks in the file: 

#*** InnoDB Specific options
# You can set .._buffer_pool_size up to 50 - 80 % of RAM but beware of 
# setting memory usage too high. This value is set by the installer.
innodb_buffer_pool_size=8191M

Note that you should not set this to more than half of the system memory.

Additional Information

CA strongly not recommend making changes to this variable, as there will be an impact on Performance.