AnsweredAssumed Answered

Too many I/O exection with ACT_GE_BYTEARRAY table

Question asked by gichulhong on Apr 29, 2013
Latest reply on Apr 29, 2013 by trademak
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 :)

Outcomes