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:
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
- All
- Comments
- Work Log
- History
- Activity
- Transitions
I've added a mention of behavior with a slave SQL thread.