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

    • Type: New Feature
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.3.12
    • Fix Version/s: 2.6
    • Component/s: readwritesplit
    • Labels:
      None

      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

            Assignee:
            toddstoffel Todd Stoffel
            Reporter:
            wagnerbianchi Wagner Bianchi
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated: