Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-10599

Cleanup or compcation of Engine Metrics

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Unresolved
    • Icon: L3 - Default L3 - Default
    • None
    • None
    • engine

      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_ ...)"

        This is the controller panel for Smart Panels app

            [CAM-10599] Cleanup or compcation of Engine Metrics

            Daniel Meyer added a comment -

            Comment from Customer:

            I think compacting would be an excellent addition for that part. Maybe the compacting could also be configurable, as in "compact to a year, keeping at most 5 years" or "compact every month to at most 18 months"?

            Daniel Meyer added a comment - Comment from Customer: I think compacting would be an excellent addition for that part. Maybe the compacting could also be configurable, as in "compact to a year, keeping at most 5 years" or "compact every month to at most 18 months"?

            Thorben Lindhauer added a comment -

            This ticket was migrated to github: https://github.com/camunda/camunda-bpm-platform/issues/2269. Please use this link for any future references and continue any discussion there.

            Thorben Lindhauer added a comment - This ticket was migrated to github: https://github.com/camunda/camunda-bpm-platform/issues/2269 . Please use this link for any future references and continue any discussion there.

              Unassigned Unassigned
              meyer Daniel Meyer
              Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated: