Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19313

Threadpool : provide information schema tables for internals of generic threadpool

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.5.0
    • Server
    • None

    Description

      Currently, not much internals of the generic threadpool are shown to the user.
      However, there is some information that can be extracted from the internal structures, e.g

      • queue length for every group in the pool
      • queue contents, e.g high and low priority requests and their with corresponding connection ids
      • Currently not possible, but interesting - approximate queueing time(time spent in queue) for events
      • number of active, waiting, and idle threads per group
      • Currently not possible, but interesting - other statistics, like number of wakes, stalls, and thread creations per group.

      The information is rather complicated to be fit into status variables, so the proposal is to implement it using I_S tables, e.g

      • I_S.threadpool_groups - the stats per group
      • I_S.threadpool_queue - queue contents

      The overall statistics can be still calculated using SQL aggregation functions.

      Attachments

        Issue Links

          Activity

            wlad Vladislav Vaintroub created issue -
            wlad Vladislav Vaintroub made changes -
            Field Original Value New Value
            Assignee Vladislav Vaintroub [ wlad ]
            wlad Vladislav Vaintroub made changes -
            Description Currently, not much internals of the generic threadpool are shown to the user.
            However, there is some information that can be extracted from the internal structures, e.g

            * queue length for every group in the pool, the contents of the queue
            * queue contents, e.g high and low priority requests width corresponding connection ids
            * Currently not possible, but interesting - approximate queueing time(time spent in queue) for events
            * number of active, waiting, and idle threads per group
            * Currently not possible, but interesting - other statistics, like number of wakes, stalls, and thread creations per group.

            The information is rather complicated to be fit into status variables, so the proposal is to implement it using I_S tables, e.g
            * I_S.threadpool_groups - the stats per group
            * I_S.threadpool_queue - queue contents

            The overall statistics can be still calculated using SQL aggregation functions.
            Currently, not much internals of the generic threadpool are shown to the user.
            However, there is some information that can be extracted from the internal structures, e.g

            * queue length for every group in the pool
            * queue contents, e.g high and low priority requests and their with corresponding connection ids
            * Currently not possible, but interesting - approximate queueing time(time spent in queue) for events
            * number of active, waiting, and idle threads per group
            * Currently not possible, but interesting - other statistics, like number of wakes, stalls, and thread creations per group.

            The information is rather complicated to be fit into status variables, so the proposal is to implement it using I_S tables, e.g
            * I_S.threadpool_groups - the stats per group
            * I_S.threadpool_queue - queue contents

            The overall statistics can be still calculated using SQL aggregation functions.
            GeoffMontee Geoff Montee (Inactive) made changes -
            wlad Vladislav Vaintroub made changes -
            issue.field.resolutiondate 2019-05-26 17:23:54.0 2019-05-26 17:23:54.655
            wlad Vladislav Vaintroub made changes -
            Fix Version/s 10.5.0 [ 23709 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            GeoffMontee Geoff Montee (Inactive) made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 96298 ] MariaDB v4 [ 133937 ]
            rob.schwyzer@mariadb.com Rob Schwyzer (Inactive) made changes -
            rob.schwyzer@mariadb.com Rob Schwyzer (Inactive) made changes -

            People

              wlad Vladislav Vaintroub
              wlad Vladislav Vaintroub
              Votes:
              1 Vote for this issue
              Watchers:
              3 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.