Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-2748

Show how many commands were executed by a session when using Persistent Connections

    XMLWordPrintable

Details

    • MXS-SPRINT-119, MXS-SPRINT-120, MXS-SPRINT-121, MXS-SPRINT-122, MXS-SPRINT-123

    Description

      Folks,

      For the sake of better tuning the max_sescmd_history and avoid it to be too large (wasting of memory) or even avoiding it to be too low, leading to inconsistencies, can we show up out of the maxctrl show sessions command how many session commands a session is running? The outcome here is to make sure we can have an average number + 10 to have a good measure for tunning the max_sescmd_history (also using the prune_sescmd_history to cap on the session's memory consumption).

      Currently, we have this as a return for the maxctrl show sessions:

      ┌────────────────┬───────────────────────────┐
      │ Id             │ 5900882
      ├────────────────┼───────────────────────────┤
      │ Service        │ Galera-Service            │
      ├────────────────┼───────────────────────────┤
      │ State          │ Session ready for routing │
      ├────────────────┼───────────────────────────┤
      │ User           │ demo02                    │
      ├────────────────┼───────────────────────────┤
      │ Host           │ ::ffff:10.4.0.32
      ├────────────────┼───────────────────────────┤
      │ Connected      │ Mon Oct 28 02:33:05 2019
      ├────────────────┼───────────────────────────┤
      │ Idle           │ 13.9
      ├────────────────┼───────────────────────────┤
      │ Connections    │ ms-db01                   │
      │                │ ms-db03                   │
      │                │ ms-db02                   │
      ├────────────────┼───────────────────────────┤
      │ Connection IDs │ 11253918
      │                │ 10478447
      │                │ 10501213
      ├────────────────┼───────────────────────────┤
      │ Queries        │                           │
      ├────────────────┼───────────────────────────┤
      │ Log            │                           │
      └────────────────┴───────────────────────────┘
      

      Maybe we can include the number of commands traffic'ed somewhere as we already have the Connection IDs being listed.

      What do you think? Thanks!

      Attachments

        Activity

          People

            nantti Niclas Antti
            wagnerbianchi Wagner Bianchi (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.