Details
-
Feature Request
-
Resolution: Unresolved
-
L3 - Default
-
None
-
None
Description
Problem:
- the engine can be configured to write metrics to ACT_RU_METER table regularly
- this table will grow slowly but steadily over time and there is currently no automatic cleanup mechanism
Ideas:
- Cleanup: delete date after interval X
- Compaction: select data for timerange (e.g. day / week / month), sum it up, write back the aggregated value and delete individual entries
Context:
- some of the metrics written to ACT_RU_METER_LOG are relevant for customers to report on FNI (Flow node instances) and EDE (Executed Decision Elements). In these situations it would be not so great if they were to be deleted
- In theory you can configure the interval with with Metrics get reported by setting a subclass of DbMetricsReporter (using a custom value for the reportingIntervalInSeconds) on the process engine configuration
- in case you do not need certain values for reporting FNIs (or after you have collected them somewhere else), you could truncate the table using SQL "DELETE from ACT_RU_METER_LOG where TIMESTAMP_ ...)"