Production performance tuning

2 posts / 0 new
Last post
Last seen: 2 years 5 months ago
Joined: 03/25/2011 - 00:45
Posts: 26
Production performance tuning

We're planning production resources and are wondering if there are any sizing/tuning guidelines specifically for Activiti.

I'm guessing that the guidelines for things like database connection and thread pool sizes for the app server it's running in are pretty standard (basically, at least one thread and connection per required concurrent execution), but what about tuning settings for things like the internal job execution thread for timers, ..., etc?

Any estimates on the memory footprint for a process engine and process instances? Is memory usage growth tied to any run time activity that we can use to estimate memory requirements.

I do see some indexes on the database tables, which I assume cover the most frequent/expensive queries. Our usage is performing queries for processes and tasks based on variables set on the workflow processes. Should we be adding indexes to make these queries efficient as the data set size grows (if that's not already covered)?

Thanks in advance for any guidance.


Last seen: 11 months 6 days ago
Joined: 01/07/2011 - 14:03
Posts: 1319

Your analysis is good.

The jobexecutor might need tuning to but check if it is a bottleneck first since afaik configuring it not exposed (yet?) in the config (see) modules/activiti-engine/src/main/java/org/activiti/engine/impl/cfg/ but harcoded in modules/activiti-engine/src/main/java/org/activiti/engine/impl/jobexecutor/

The engine itself has a low fairly low footprint, so I'd not care about that. Each process instances that is in a waitstate (usertask, receivetask etc) does not occupy any memory. A process instance only occupies memory if it is actually loaded from the db because it has to 'run'. How much is dependend on e.g. variables loaded etc, but it is not high either.

Adding indexes should indeed be done according to your needs since the default engine cannot cater for all usecases. A query analyzer helps a lot here.
Adding to many howeve can lead to performance degradation since the index has to be updated each time a record is added but I suspect you already know that.