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

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

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • N/A
    • 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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            ccalender Chris Calender (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.