What is the Relations between the tables where we are storing camunda meta data

Hi,

I am trying to move all the completed/cancelled Records of camunda meta data into archiving tables including the child records and later when the data ages out, thinking to drop the old data after getting confirmation from business. Is there any other way to reduce the DB space without drooping the data

Also Can you someone help me in understanding the Relations ship between the tables where we are storing the camunda metadata.

Some of the tables:
ACT_RU_EXECUTION
ACT_HI_PROCINST
ACT_RE_PROCDEF
ACT_HI_INCIDENT

There is nice documentation with pictures
https://docs.camunda.org/manual/7.15/user-guide/process-engine/database/database-schema/

Hello @Thanuja_Vadlamudi!

Manually deleting records is quite dangerous if you don’t know the schema structure.
I recommend to read our docs regarding history cleanup.
https://docs.camunda.org/manual/7.16/reference/rest/history/history-cleanup/post-history-cleanup/
https://docs.camunda.org/manual/7.16/user-guide/process-engine/history/#history-cleanup

Best, McAlm

1 Like

Thanks @McAlm for the sharing the above info.

I don’t see the rest call in the version which we are using(Camunda BPM V7.11.0 - Community Version).

/history/cleanup
/process-definition/{id}/history-time-to-live.

Could you please let me know what is method It is internally calling and Is it available in V7.11.0?

HELLO @Thanuja_Vadlamudi: What you’re looking for is this here:
https://docs.camunda.org/manual/7.11/reference/rest/history/history-cleanup/post-history-cleanup/

To see what’s behind this service you can have a look into the sources yourself. (That’s the beauty of OpenSource :wink: )

Best, McAlm

1 Like