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

TIme column in SHOW PROCESSLIST shows NULL for InnoDB service threads

    XMLWordPrintable

    Details

      Description

      MariaDB [(none)]> show processlist;
      +----+-------------+-----------------+------+---------+------+--------------------------+------------------+----------+
      | Id | User        | Host            | db   | Command | Time | State                    | Info             | Progress |
      +----+-------------+-----------------+------+---------+------+--------------------------+------------------+----------+
      |  1 | system user |                 | NULL | Daemon  | NULL | InnoDB purge worker      | NULL             |    0.000 |
      |  2 | system user |                 | NULL | Daemon  | NULL | InnoDB purge worker      | NULL             |    0.000 |
      |  4 | system user |                 | NULL | Daemon  | NULL | InnoDB purge coordinator | NULL             |    0.000 |
      |  3 | system user |                 | NULL | Daemon  | NULL | InnoDB purge worker      | NULL             |    0.000 |
      |  5 | system user |                 | NULL | Daemon  | NULL | InnoDB shutdown handler  | NULL             |    0.000 |
      |  9 | root        | localhost:55630 | NULL | Query   |    0 | init                     | show processlist |    0.000 |
      | 10 | root        | localhost:55632 | NULL | Sleep   |   12 |                          | NULL             |    0.000 |
      +----+-------------+-----------------+------+---------+------+--------------------------+------------------+----------+
      

      Time NULL instead of a numeric value breaks third-party tools, such as pt* toolkit, see https://bugs.launchpad.net/percona-toolkit/+bug/1680803 . Every individual tool should be easy to fix, but it doesn't make sense to bother, better just to show there something tool-friendly.

      SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST already shows zeros:

      *************************** 7. row ***************************
                 ID: 1
               USER: system user
               HOST: 
                 DB: NULL
            COMMAND: Daemon
               TIME: 0
              STATE: InnoDB purge worker
               INFO: NULL
            TIME_MS: 0.000
              STAGE: 0
          MAX_STAGE: 0
           PROGRESS: 0.000
        MEMORY_USED: 24592
      EXAMINED_ROWS: 0
           QUERY_ID: 0
        INFO_BINARY: NULL
                TID: 11765
      7 rows in set (0.01 sec)
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              wlad Vladislav Vaintroub
              Reporter:
              elenst Elena Stepanova
              Votes:
              1 Vote for this issue
              Watchers:
              6 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.