Uploaded image for project: 'EXASOL Roadmap'
  1. EXASOL Roadmap
  2. EXASOL-2914

Optimized background statistics historization

    Details

      Description

      Background

      The logserver collects and historizes statistics like profiling and monitoring data. This process happens regularly behind the scenes.

      On systems with very complex queries, that contain thousands of profile parts and subselects, this historization may take a long time and consume significant computing resources. While this process is running, FLUSH STATISTICS commands are blocked and must wait for the process to finish.

      Improvement

      The internal historization processes have been optimized, which improves the overall duration and resource usage of this process. Explicit FLUSH STATISTICS commands therefore are less likely to be blocked, and if they are, it is for a much shorter duration.

        Attachments

          Activity

            People

            • Assignee:
              CaptainEXA Captain EXASOL
              Reporter:
              CaptainEXA Captain EXASOL
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: