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

Show thread pool wait status in SHOW PROCESSLIST

    XMLWordPrintable

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

            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.