Too many I/O exection with ACT_GE_BYTEARRAY table

[gichulhong]

Hi.

My team is using the Activiti for our project, and doing performance test now. (Version 5.9.3)

Load generator made total 1200 transactions in 20 minutes (only 2TPS), and  system response time was getting worse..

I found that there were too many executions with ACT_GE_BYTEARRAY table.

And unfortunately there is a BLOB column(bytes_) in that table which is containing Process Definition (look like a bpmn file format)

There had been about 12000 executions for update, 14400 for delete, 52641 for select and 14400 for insert in 20 minutes.

      SQL   EXECUTIONS
   update ACT_GE_BYTEARRAY      set       REV_ = :1 ,       BYTES_ = :2      where ID_ = :3        and REV_ = :4    12000
   delete from ACT_GE_BYTEARRAY where ID_ = :1    14400
   select * from ACT_GE_BYTEARRAY where ID_ = :1    52641
   insert into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_)     values (       :1 ,       1,        :2 ,        :3 ,        :4      )   14400

So my questions are

1. Is the ACT_GE_BYTEARRAY table used in runtime, not deploy time?

2. If so, what is the ACT_GE_BYTEARRAY table for? Insert big data(process definition), select(use) and delete for each step?

3. How can I reduce I/O count for the table?

Thank you

[trademak]

Hi,

I don't think a version 5.9.3 exists of Activiti, so are you using Activiti 5.9? Any reason for using this older version?
How is the Activiti Engine configured? Which database are you using? How is this load generator communicating with the Activiti Engine?
The ACT_GE_BYTEARRAY is used to store complex content (non-primitives) such as deployment resources and non-primitive variables.

Before I can answer these questions you should first explain what you are testing. Are you doing a lot of deployments for example, then you all the deployment resources are stored in the ACT_GE_BYTEARRAY for example.

Best regards,