[EXASOL-2604] Improved system usability in case of heavy load and swapping Created: 18.12.2019  Updated: 02.04.2020  Resolved: 04.03.2020

Status: Resolved
Project: EXASOL Roadmap
Component/s: None
Fix Version/s: Exasol 7.0.0, Exasol 7.0.alpha1

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

Issue Links:
Blocking
Causing

 Description   

Background

In case of high load on a system (many sessions, lots of HDD_READ) the database executes some expensive management operations to cope with the load (heap memory resize, DBRAM defragmentation). For those operations all running sessions on a node need to stop for a short time until the operation is completed.

Problem

Sometimes a session stops very slowly which defers the execution of the management operation, and hence, defers all other sessions as well. Usability impression in such situation is often not good.

Improvement

Session stopping has been optimized to have all sessions stop in a shorter time. The time waiting for management operations will be reduced, and hence, the usability impression in load situations improved.


Generated at Mon Jun 21 14:22:50 CEST 2021 using Jira 7.13.18#713018-sha1:e1230154f8ff8cc9272975bf568fc732e806fd68.