MySQL :: MySQL 5.7 Reference Manual :: 25.12.11.2 The replication_connection_status Table (original) (raw)

25.12.11.2 The replication_connection_status Table

This table shows the current status of the replication I/O thread that handles the replica's connection to the source.

Compared to thereplication_connection_configuration table,replication_connection_status changes more frequently. It contains values that change during the connection, whereasreplication_connection_configuration contains values which define how the replica connects to the source and that remain constant during the connection.

The replication_connection_status table has these columns:

• CHANNEL_NAME
  The replication channel which this row is displaying. There is always a default replication channel, and more replication channels can be added. SeeSection 16.2.2, “Replication Channels” for more information.
• GROUP_NAME
  If this server is a member of a group, shows the name of the group the server belongs to.
• SOURCE_UUID
  The server_uuid value from the source.
• THREAD_ID
  The I/O thread ID.
• SERVICE_STATE
ON (thread exists and is active or idle), OFF (thread no longer exists), or CONNECTING (thread exists and is connecting to the source).
• RECEIVED_TRANSACTION_SET
  The set of global transaction IDs (GTIDs) corresponding to all transactions received by this replica. Empty if GTIDs are not in use. SeeGTID Sets for more information.
• LAST_ERROR_NUMBER,LAST_ERROR_MESSAGE
  The error number and error message of the most recent error that caused the I/O thread to stop. An error number of 0 and message of the empty string mean “no error.” If theLAST_ERROR_MESSAGE value is not empty, the error values also appear in the replica's error log.
  Issuing RESET MASTER orRESET SLAVE resets the values shown in these columns.
• LAST_ERROR_TIMESTAMP
  A timestamp in YYMMDD hh:mm:ss format that shows when the most recent I/O error took place.
• LAST_HEARTBEAT_TIMESTAMP
  A timestamp in YYMMDD hh:mm:ss format that shows when the most recent heartbeat signal was received by a replica.
• COUNT_RECEIVED_HEARTBEATS
  The total number of heartbeat signals that a replica received since the last time it was restarted or reset, or a CHANGE MASTER TO statement was issued.

TRUNCATE TABLE is not permitted for thereplication_connection_status table.

The following table shows the correspondence betweenreplication_connection_status columns and SHOW SLAVE STATUS columns.