Hello Camunda Community ,
In our Camunda setup some of the BPM processes were deployed without mentioning history clean up interval (removal time ) this has generate huge data in the history tables (few hundreds of GB) . Later on we realized we need to set the time to live property for clean up job to remove records from history tables .
Cleanup after setting time to removal is happening fine but its not taking care of old process instances which were created before setting this property and having time to removal as null .
Queries to update time to removal is running for long time and getting failed due to timeout or other reasons .
As data volumes are growing daily it has become inevitable to clean up the history data . Do we have any smart way to do this clean up ?
Whats the impact of deleting all the records from history tables ?
Can I run a delete command on history table where time less than given date ?