License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
For production deployment on a server, the Java Virtual Machine (JVM), application server, database and operating systems should be tuned for performance. Actual real world performance depends on many factors. These include the deployment architecture, server and network specifications, complexity of the processes/apps, actual usage patterns by different users, etc.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
This document presents some of the best practices in terms of performance tuning and optimization to get the best out of your deployment.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Important Note: These recommendations help to serve as general tips and guidelines, but in actual practice it would depend on each deployment’s unique environment. There are also many resources available online to help tune performance for Java, application servers and databases.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Installation as a Service
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
For production deployments, you may want to install the web application server, e.g., Apache Tomcat, as a service. Please refer to the documentation on the relevant operating system to do so. A guide to install Tomcat as a Windows service is available at
Installing Joget as a Windows Service.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Java VM Configuration
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Java VM Tuning
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
An important configuration would be the JVM memory allocation. If this is too low, the system will run out of memory. However if the setting is too high, there might be quite a large overhead in garbage collection. To get an optimum setting might require a bit of trial and error sometimes, depending on the usage environment.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Here are the steps to get started. You may want to start with a 1GB max heap setting and increase if the need arises.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
1. Stop Joget.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
2. Open and edit Joget Installation Directory/joget-start.bat.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
3. Modify
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
set JAVA_OPTS=-XX:MaxPermSize=128m -Xmx512M -Dwflow.home=./wflow/ -javaagent:./wflow/aspectjweaver-1.8.5.jar
on line 13 to
set JAVA_OPTS=-XX:MaxPermSize=256m -Xmx1024M -Dwflow.home=./wflow/ -XX:+UseConcMarkSweepGC -javaagent:./wflow/aspectjweaver-1.8.5.jar
4. Save and start Joget.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
NOTE:
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Please take note should you encounter any of the following OutOfMemory errors:
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
java.lang.OutOfMemoryError: Java heap space | Increase the maximum heap size -Xmx License Error The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license. License Error The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license. |
java.lang.OutOfMemoryError: PermGen space | Increase the maximum permgen size -XX:MaxPermSize License Error The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license. License Error The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license. |
java.lang.OutOfMemoryError: GC overhead limit exceeded | Enable the concurrent garbage collector -XX:+UseConcMarkSweepGC License Error The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license. License Error The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license. |
There are many online resources for further tuning, e.g., http://www.oracle.com/technetwork/java/performance-138178.html.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Web Application Server Configuration
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Apache Tomcat Configuration
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
For Apache Tomcat, try setting the maxThreads Connector thread pool settings based on the estimated request load. For example, to set the maximum number of threads to 1000, edit tomcat_directory/conf/server.xml. Locate the line
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
<Connector URIEncoding="UTF-8" port="8080" protocol="HTTP/1.1"
connectionTimeout="20000"
redirectPort="8443" />
and add a maxThreads="" such as
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
<Connector URIEncoding="UTF-8" port="8080" protocol="HTTP/1.1" maxThreads="1000"
connectionTimeout="20000"
redirectPort="8443" />
This would require a Tomcat restart to take effect.
There are many resources available online, e.g., http://www.itworld.com/networking/83035/tomcat-performance-tuning-tips.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Linux Configuration
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Linux / Unix systems have a limit on the number of files that can be concurrently opened by a process. When the limit is reached, there will be an exception "Too many open files". The default for most distributions is 1024, which will not be enough for high traffic deployments. In Linux, increasing the ulimit
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
works as a workaround but this is only valid for the session. For permanent configuration, please refer to documentation for the specific distribution, e.g., http://posidev.com/blog/2009/06/04/set-ulimit-parameters-on-ubuntu/.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Database Configuration
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Database Indexing
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Form data tables generated and managed by Joget are prefixed with
app_fd. By default, primary keys and foreign keys are automatically generated for these tables where necessary.
However, in more complex apps, there would be more complex database queries that make use of these tables. As such, it is recommended for indexes to be added manually into table columns when required.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
MySQL Configuration
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
When using InnoDB in MySQL, setting an appropriate InnoDB Buffer Pool is important for large-scale performance. Details can be found here: http://dev.mysql.com/doc/refman/5.0/en/innodb-buffer-pool.html.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
In environments with large data and queries, one way to improve performance is to use the query cache. This can help speed up query performance tremendously. Details can be found at http://dev.mysql.com/doc/refman/5.0/en/query-cache.html.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
You may need to increase the number of maximum connections allowed if there are a lot of concurrent requests. https://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
It is possible to identify slow queries in MySQL by enabling the slow query log. This helps to identify areas for possible indexing and optimization.
http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Microsoft SQL Server Configuration
In MSSQL, adaptive buffering is designed to retrieve any kind of large-value data without the overhead of server cursors. You can configure the JDBC URL to use SelectMethod=direct in the database property file ".\wflow\app_datasource-mssql.properties" [Rename the "mssql" according to your environment].
For example, the current string is:
workflowUrl=jdbc\:sqlserver\://localhost\:1433;SelectMethod\=cursor;DatabaseName\=jwdb
Change it to:
workflowUrl=jdbc\:sqlserver\://docker\:1433;SelectMethod\=direct;DatabaseName\=jwdb
Please remember to perform full testing on the SelectMethod option in your development or staging servers before implementing it in production server.
Reading: https://docs.microsoft.com/en-us/sql/connect/jdbc/using-adaptive-buffering?view=sql-server-ver15
Clustering and Load Balancing
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
For large scale and high-availability deployments, clustering and load balancing may need to be implemented using the Large Enterprise Edition. A high-level description is as follows:
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
The main configuration is actually done at the web application server, in this case Tomcat. There's a quite comprehensive documentation for this at http://tomcat.apache.org/tomcat-6.0-doc/cluster-howto.html.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
You'll need a load balancer as well. This could be hardware or software, and it's possible to use Apache web server for this purpose. Using the mod_proxy_balancer module (http://httpd.apache.org/docs/2.2/mod/mod_proxy_balancer.html), traffic is directed to various Tomcat nodes. Depending on configuration, the approach could be load balanced or failover, and sticky sessions are recommended.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
The database and wflow files (configuration/uploaded files) would also have to be shared from a centralized server.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Logging and Troubleshooting
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
When running Apache Tomcat, logs are stored in the tomcat_directory/logs directory. In particular, the files joget.log, catalina.out, and localhost.yyyy-MM-dd.log capture information and errors that are generated.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Should you encounter any issues or errors, it is best that the following information is provided when reporting the issue to Enterprise Support or the community forums:
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Steps to reproduce the issue
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Error messages (including any possible JavaScript errors) in the browser
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Copy of the log files mentioned above
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Screenshot(s) showing the problem
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Sample app that produces the issue
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
The more information provided, the faster an issue can be identified and resolved.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Backup and Restore
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Backup Data
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
To backup an installation:
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Backup all configuration files and uploaded data files stored in joget_directory/wflow.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Backup the database. e.g., in MySQL you can use the mysqldump utility.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Restoring Data
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
To restore data to an installation:
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.