We sometimes hear from our customers that the client response is slow and the reports are taking longer time to get generated.

Database tuning:
The database parameters for NetFlow Analyzer are tuned to work well with 1 GB of RAM and in cases where you are running with more RAM on 32 Bit or 64 Bit server, 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 NetFlow_Home\bin directory (startDB.sh in case of Linux).

The 3 main parameters are the key_buffer_size and the innodb_buffer_pool_size.

These values are set to --key_buffer_size=360000000 --innodb_buffer_pool_size=424000000 --bulk_insert_buffer_size=16000000 by default

Note:

Please take a back up of this file before you make any changes. In case you are uncomfortable making these changes, please send a mail to nfs@manageengine.com so that we can assist you in doing this.

32 Bit Server :-

For a machine running with 2 GB of RAM or more, you can set these to
--key_buffer_size=720000000 --innodb_buffer_pool_size=848000000 --bulk_insert_buffer_size=32000000

For a machine running with 3 GB of RAM or more, you can set these to
--key_buffer_size=820000000 --innodb_buffer_pool_size=948000000 --bulk_insert_buffer_size=48000000

64 Bit Server :-

Normally 64 Bit machines will have more RAM when comparing to 32 Bit.

For a 64 machine running with 6 GB of RAM or more, you can set these to

--key_buffer_size=820000000 --innodb_buffer_pool_size=948000000 --bulk_insert_buffer_size=48000000

For a 64 machine running with 8 GB of RAM or more, you can set these to

--key_buffer_size=920000000 --innodb_buffer_pool_size=1048000000 --bulk_insert_buffer_size=48000000

For a 64 machine running with 16 GB of RAM or more, you can set these to

64 Bit machine running 6 GB of RAM or More :-

# Maximum Java Heap Size (in MB)
wrapper.java.maxmemory=2048

64 Bit machine running 8 GB of RAM or More :-

# Maximum Java Heap Size (in MB)
wrapper.java.maxmemory=4096

64 Bit machine running 16 GB of RAM or More :-
# Maximum Java Heap Size (in MB)
wrapper.java.maxmemory=8192

3. Open a command prompt and execute the following batch files one after the other

na_service.bat -r
na_service.bat -i


4. Open the file "run.bat" present under the NetFlow_Home/bin/ directory in a text editor. Find the following lines in the run.bat file

32 Bit Machine with 3 GB of RAM or more:

# Setup JBoss sepecific properties
JAVA_OPTS="$JAVA_OPTS -Xms128m -Xmx512m


Please change the "-Xmx512m" to -Xmx1024m.

64 Bit Machine with 6 GB of RAM or more:

Please change the "-Xmx512m" to -Xmx2048m.

64 Bit Machine with 8 GB of RAM or more:

Please change the "-Xmx512m" to -Xmx4096m.

64 Bit Machine with 16 GB of RAM or more:

Please change the "-Xmx512m" to -Xmx8192m.

Save the run.bat file

5. Start NetFlow Analyzer


Java Tuning for Linux:

Please follow these steps in case your machine is running with RAM of 3 GB or more.

1. Shutdown NetFlow Analyzer.
2. Open the file "wrapper.conf" present under the <NETFLOW_HOME>/conf/ directory in a text editor. Find the following line in the file
# Maximum Java Heap Size (in MB)
wrapper.java.maxmemory=256


Please change the value of "wrapper.java.maxmemory" from 256 to 1024.
Modified line will look like as the following.

# Maximum Java Heap Size (in MB)
wrapper.java.maxmemory=1024

64 Bit machine running 6 GB of RAM or More :-

# Maximum Java Heap Size (in MB)
wrapper.java.maxmemory=2048

64 Bit machine running 8 GB of RAM or More :-

# Maximum Java Heap Size (in MB)
wrapper.java.maxmemory=4096

64 Bit machine running 16 GB of RAM or More :-
# Maximum Java Heap Size (in MB)
wrapper.java.maxmemory=8192

Please save the wrapper.conf file.

3. Open the run.sh file present under the "<NetFlow_HOME>/bin" directory in a editor. Find the following line


# Setup JBoss sepecific properties
JAVA_OPTS="$JAVA_OPTS -Xms128m -Xmx512m

-Dprogram.name=$PROGNAME -Djboss.server.type=com.adventnet.j2ee.deployment.system.A
dventNetServerImpl -Djboss.deploy.localcopy=true -Djboss.boot.library.list=log4j-boot.jar,jboss-common.jar,jboss-system.jar
,AdventNetDeploymentSystem.jar,commons-logging.jar"


Please change the "-Xmx512m" to -Xmx1024m.

64 Bit Machine with 6 GB of RAM or more:

Please change the "-Xmx512m" to -Xmx2048m.

64 Bit Machine with 8 GB of RAM or more:

Please change the "-Xmx512m" to -Xmx4096m.

64 Bit Machine with 16 GB of RAM or more:

Please change the "-Xmx512m" to -Xmx8192m.

Save the run.sh file

4. Start NetFlow Analyzer

In case you are running with 1024 MB of RAM or less and experiencing slow respose, you may want to try upgrading the RAM.

In case you have any question, please feel free to put a post here or send a mail to nfs@manageengine.com

Assuring you the best support
Raghu