10.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 the replication_connection_configuration table, replication_connection_status changes more frequently. It contains values that change during the connection, whereas replication_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. See 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. See GTID 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 the LAST_ERROR_MESSAGE value is not empty, the error values also appear in the replica's error log.

  Issuing RESET MASTER or RESET 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 the replication_connection_status table.

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

replication_connection_status Column	SHOW SLAVE STATUS Column
SOURCE_UUID	Master_UUID
THREAD_ID	None
SERVICE_STATE	Slave_IO_Running
RECEIVED_TRANSACTION_SET	Retrieved_Gtid_Set
LAST_ERROR_NUMBER	Last_IO_Errno
LAST_ERROR_MESSAGE	Last_IO_Error
LAST_ERROR_TIMESTAMP	Last_IO_Error_Timestamp