{"id":1867,"date":"2019-06-19T18:27:29","date_gmt":"2019-06-19T12:57:29","guid":{"rendered":"http:\/\/blog.tenthplanet.in\/?p=1867"},"modified":"2026-03-03T10:14:13","modified_gmt":"2026-03-03T10:14:13","slug":"pentaho-performance-optimal-ram-setup-based-on-underlying-infra","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/blogs\/pentaho-performance-optimal-ram-setup-based-on-underlying-infra\/","title":{"rendered":"Pentaho+ Performance Optimal RAM setup based on underlying infra"},"content":{"rendered":"<h3>Pentaho+ Performance Optimal Steps<\/h3>\n<h3>Increase the Memory Limit in PDI<\/h3>\n<ul>\n<li>Exit Pentaho+ Spoon if it is currently running.<\/li>\n<li>Edit your Pentaho+ Spoon startup script and modify the -Xmx value so that it specifies a larger upper memory limit.<\/li>\n<\/ul>\n<pre style=\"padding-left: 30px\">PENTAHO_DI_JAVA_OPTIONS=\"-Xmx2g -XX:MaxPermSize=256m\"<\/pre>\n<ul>\n<li>Start Pentaho+ Spoon again.<\/li>\n<li>Instead of modifying the Pentaho Spoon startup script, you can also set the environment variable<\/li>\n<\/ul>\n<pre style=\"padding-left: 30px\">PENTAHO_DI_JAVA_OPTIONS equal to -Xmx2g -XX:MaxPermSize=256m on your client.<\/pre>\n<h3>Increase Pentaho+ Server Memory Limit<\/h3>\n<ul>\n<li>Go to \/pentaho\/server\/pentaho-server\/tomcat\/bin\/ directory and run the .\/shutdown.sh command to stop the appropriate server.<\/li>\n<li>Change the directory to pentaho-server\/scripts.<\/li>\n<li>Edit the ctl.sh file.<\/li>\n<li>Locate the line under start tomcat, which looks like this:<\/li>\n<\/ul>\n<pre style=\"padding-left: 30px\">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\"<\/pre>\n<ul>\n<li>Set the memory to a minimum of 4096 M and a maximum of 6144 M, depending on your computer&#8217;s memory capabilities.<\/li>\n<li>Start the Tomcat server or service.<\/li>\n<\/ul>\n<h3>Increase the Memory Limit in Weka<\/h3>\n<ul>\n<li>Exit Weka if it is currently running.<\/li>\n<li>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.<br \/>\njava -Xmx2g weka.jar<\/li>\n<li>If you are running Weka as part of a script, change your Java invocation so that it includes the above -Xmx setting.<\/li>\n<li>Start Weka and ensure that there are no memory-related exceptions<\/li>\n<\/ul>\n<h3>Increase the Memory Limit in Pentaho+ Report Designer<\/h3>\n<ul>\n<li>Exit Pentaho Plus Report Designer if it is currently running.<\/li>\n<li>Edit the report-designer script and modify the value of -Xmx to allocate more memory to Report Designer&#8217;s JVM instance.<\/li>\n<\/ul>\n<pre style=\"padding-left: 30px\">\"$_PENTAHO_JAVA\" \"-Dpentaho.installed.licenses.file=$PENTAHO_INSTALLED_LICENSE_PATH\" -XX:MaxPermSize=256m -Xmx2g -jar \"$DIR\/launcher.jar\" $@<\/pre>\n<ul>\n<li>Start Report Designer and ensure that there are no memory-related exceptions.<\/li>\n<\/ul>\n<h3>Increase the Memory Limit in Pentaho Plus Aggregation Designer<\/h3>\n<ul>\n<li>Exit Pentaho+ Aggregation Designer if it is currently running.<\/li>\n<li>Edit the start aggregation designer script and modify your Java command to include an -Xmx line that specifies a large upper memory limit.<\/li>\n<\/ul>\n<pre style=\"padding-left: 30px\">\"$_PENTAHO_JAVA\" $LICENSEPARAMETER -Xmx2g -jar \"$DIR\/lib\/launcher-1.0.0.jar\"<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Pentaho Performance Optimal RAM setup based on underlying infra<\/p>\n","protected":false},"author":23,"featured_media":1873,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[424],"tags":[545,430],"class_list":["post-1867","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pentaho","tag-pentaho-performance","tag-pentaho-server-optimization"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts\/1867","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/comments?post=1867"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts\/1867\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/media\/1873"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/media?parent=1867"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/categories?post=1867"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/tags?post=1867"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}