Performance Tuning

While the default configuration works well on desktops with limited resource, if the data volume is exceeding 50 GB, the following parameters needs to be set for optimal performance.

• Turning off SELinux, i.e. Security-Enhanced Linux. SELinux sometimes blocks file access, causing expected error in AntsDB.

• Optimize kernel parameters for data heavy loads. It can be done with following commands on CentOS 7 sudo yum install tuned-profiles-oracle; sudo tuned-adm profile oracle

• Increase the AntsDB JVM heap size to 4 GB. Set wrapper.java.maxmemory=4096 in file antsdb/conf/wrapper.conf

• Set the JVM to server mode. Set wrapper.java.additional.1=-server in file antsdb/conf/wrapper.conf

• Increase the size of local cache. Set cache.size=100g or more in file antsdb/conf/conf.properties