Pentaho Performance Optimal RAM setup based on underlying infra

- Pentaho

Increase the Memory Limit in PDI

  • Exit Spoon if it is currently running.
  • Edit your Spoon startup script and modify the -Xmx value so that it specifies a larger upper memory limit.
PENTAHO_DI_JAVA_OPTIONS="-Xmx2g -XX:MaxPermSize=256m"
  • Start Spoon again.
  • Instead of modifying the Spoon startup script, you can also set the environment variable
PENTAHO_DI_JAVA_OPTIONS equal to -Xmx2g -XX:MaxPermSize=256m on your client.

Increase Pentaho Server Memory Limit

  • Go to /pentaho/server/pentaho-server/tomcat/bin/ directory and run the ./shutdown.sh command to stop the appropriate server.
  • Change the directory to pentaho-server/scripts.
  • Edit the ctl.sh file.
  • Locate the line under start tomcat, which looks like this:
export JAVA OPTS="-Dpentaho.installed.licenses.file=/opt/pentaho/.installedLicenses.xml -Xms128m Xmx768m -XX-MaxPermSize=256m -Dsun.rmi.dyc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000"
  • Set the memory to a minimum of 4096 M and a maximum of 6144 M, depending on your computer’s memory capabilities.
  • Start the Tomcat server or service.

Increase the Memory Limit in Weka

  • Exit Weka if it is currently running.
  • If you are running Weka standalone from the command line, modify your Java command to include an -Xmx line that specifies a large upper memory limit.
    java -Xmx2g weka.jar
  • If you are running Weka as part of a script, change your Java invocation so that it includes the above -Xmx setting.
  • Start Weka and ensure that there are no memory-related exceptions

Increase the Memory Limit in Report Designer

  • Exit Report Designer if it is currently running.
  • Edit the report-designer script and modify the value of -Xmx to allocate more memory to Report Designer’s JVM instance.
"$_PENTAHO_JAVA" "-Dpentaho.installed.licenses.file=$PENTAHO_INSTALLED_LICENSE_PATH" -XX:MaxPermSize=256m -Xmx2g -jar "$DIR/launcher.jar" $@
  • Start Report Designer and ensure that there are no memory-related exceptions.

Increase the Memory Limit in Aggregation Designer

  • Exit Aggregation Designer if it is currently running.
  • Edit the startaggregationdesigner script and modify your Java command to include an -Xmx line that specifies a large upper memory limit.
"$_PENTAHO_JAVA" $LICENSEPARAMETER -Xmx2g -jar "$DIR/lib/launcher-1.0.0.jar"

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>