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

Improved session and resource management for WAIT FOR COMMIT

    Details

    • Category 1:
      Database Administration - Performance
    • Category 2:
      Database Administration - Transactions

      Description

      Improved session and resource management for WAIT FOR COMMIT

      • Sessions which are in state WAIT FOR COMMIT (WFC) are not counted among the active sessions. In addition to the 100 active session slots there are 100 slots for WFC sessions available. If the number of WFC sessions exceeds 100, these sessions will use an active session slot.
      • If 80% of the active sessions are in use, an EXAoperation warning is generated. If a login request can't be processed and has to wait because the limit of active sessions has been reached, an EXAoperation warning will be periodically logged until all requests have been processed.
      • In case of out of memory EXASolution will kill sessions with high memory usage. But if in this situation the limit of active sessions has been reached, WFC sessions will be terminated first. This behaviour can be disabled by using the command line parameter: {{ -killBlockedConnectionsFirst=0 }}.

      For more information about the session management see SOL-296.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: