How to change the memory allocation to MySql after upgrading system memory?
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.
Note that you should not set this to more than half of the system memory.