Activiti DB queries causing some max spikes of CPU in production environment

cancel
Showing results for 
Search instead for 
Did you mean: 
gopal_patil
Member II

Activiti DB queries causing some max spikes of CPU in production environment

Please take a look at the below findings. In summary, the problem is in the query itself due to the datatypes that are defined in the ACTIVITI V6.0 tables.

The following tests were conducted on ACTIVITI V6.0 DB
Existing query took 9 minutes 53 seconds with (50 eDTUs)!
select *
from ACT_RU_VARIABLE
where EXECUTION_ID_ = 10000074
and NAME_= 'abccd'
and TASK_ID_ is null;

New query took 3 milliseconds with (50 eDTUs)! No index was created.
select *
from ACT_RU_VARIABLE
where EXECUTION_ID_ = '10000074'
and NAME_= 'abccd'
and TASK_ID_ is null;

Since the DB tables and queries are managed by Activiti itself, Can you guys please suggest how should be address this?

We thought of changing the datatype but we are not sure how this is going to impact on functional Activiti workflows, so wanted to have your insights as well on it.