I just joined a project, using activiti 5 and drools, which is getting a really huge DB.
The point is, almost 70% of the data is on act_ru_identitilink. It looks like this table is part of the core of the activity, but I cannot see how this table got 60GB size. I was playing with it, and looks like removing some rows on it, is not affecting the app itself, but, I would like to know:
What is this table for?
Is there any way to configure activiti, so it cleans automatically data which is old or deprecated?
Just to add to this, basically ACT_RU_IDENTITYLINK records all the relationships from tasks to users or groups, including which users/groups are candidates for a task or which are involved. Before you look at pruning this table you should check whether the tasks have completed (see
ACT_HI_TASKINST and ACT_RU_TASK) and whether you still need that data.