[EXASOL-2914] Optimized background statistics historization Created: 29.06.2021  Updated: 16.08.2021  Resolved: 05.07.2021

Status: Resolved
Project: EXASOL Roadmap
Component/s: None
Fix Version/s: Exasol 6.2.16, Exasol 7.1.rc1, Exasol 7.0.11

Type: Improvement Priority: Minor
Reporter: Captain EXASOL Assignee: Captain EXASOL
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocking
Causing
Related

 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.


Generated at Sun Oct 17 09:26:38 CEST 2021 using Jira 7.13.18#713018-sha1:e1230154f8ff8cc9272975bf568fc732e806fd68.