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

Show thread pool wait status in SHOW PROCESSLIST

Details

    • Task
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • Server
    • None

    Description

      Currently a connection that has issued a query, but which is still in the pool-of-threads wait queue waiting to be executed, just shows with status "Sleep" and no query text, just as if the client was idle and had not sent any query at all, and the time info does not even reflect the time at which the waiting query was sent to the server, but the time the previous query ended (which also leads to MDEV-21101).

      Features request:

      • add a query state like "Waiting"
      • let the time column show the actual "Time" the query so far spent waiting in the queue
      • show actual query in "Info"
      • optionally: show the queue position, to get an idea when the query might eventually get executed

      Attachments

        Issue Links

          Activity

            hholzgra Hartmut Holzgraefe created issue -
            hholzgra Hartmut Holzgraefe made changes -
            Field Original Value New Value
            julien.fritsch Julien Fritsch made changes -
            Fixing Priority 250
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 101295 ] MariaDB v4 [ 131188 ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 194203

            People

              Unassigned Unassigned
              hholzgra Hartmut Holzgraefe
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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