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

Documentation Update Request: Add more details about SHOW PROCESSLIST "time" column

    Details

    • Type: Task
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Fix Version/s: N/A
    • Component/s: None
    • Labels:
      None

      Description

      Documentation Update Request: Add more details about SHOW PROCESSLIST "time" column

      Currently, on this page:

      https://mariadb.com/kb/en/mariadb/documentation/sql-commands/administration-commands/show/show-processlist/

      The "TIME" column says: "The amount of time, in seconds, the process has been in its current state."

      While this is correct, it does not explain about the slave thread. For instance, consider the MySQL manual description for this same column:

      "The time in seconds that the thread has been in its current state. For a slave SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the slave machine. See Section 17.2.1, “Replication Implementation Details”."

      http://dev.mysql.com/doc/refman/5.6/en/show-processlist.html

      Which even has a link to another section, which contains even more info about this subject:

      "The value in the Time column can show how late the slave is compared to the master. See Section A.13, “MySQL 5.6 FAQ: Replication”. If sufficient time elapses on the master side without activity on the Binlog Dump thread, the master determines that the slave is no longer connected. As for any other client connection, the timeouts for this depend on the values of net_write_timeout and net_retry_count; for more information about these, see Section 5.1.4, “Server System Variables”."

      http://dev.mysql.com/doc/refman/5.6/en/replication-implementation-details.html

      So I'd like to see us elaborate on this, and at least add something about the slave thread, as this can be confusing when you see a command running for "116268" seconds, but uptime is only "415" seconds, for instance.

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            greenman Ian Gilfillan added a comment -

            I've added a mention of behavior with a slave SQL thread.

            Show
            greenman Ian Gilfillan added a comment - I've added a mention of behavior with a slave SQL thread.

              People

              • Assignee:
                greenman Ian Gilfillan
                Reporter:
                ccalender Chris Calender
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated: