When you find that the client response is slow and the reports
are taking longer time to get generated, you can tune a few
database parameters to improve the performance of the system.
The database parameters for NetFlow Analyzer are tuned to
work well with 512 MB of RAM and in cases where you are running
with more RAM, you can easily tune the MySQL parameters to
extract better performance. This can result in significant
improvements in the client response. These parameters can
be set in startDB.bat file present in <NetFlow Analyzer
Home>/bin directory (startDB.sh in case of Linux).
The 2 main parameters are the key_buffer_size and
the innodb_buffer_pool_size. These values are set to
--key_buffer_size=180000000 --innodb_buffer_pool_size=212000000
by default
For a machine running with 1 GB of RAM, you can
set these to
--key_buffer_size=360000000 --innodb_buffer_pool_size=424000000
For a machine running with 2 GB of RAM, you can
set these to
--key_buffer_size=720000000 --innodb_buffer_pool_size=848000000
