content_image/795195.jpg
• Last_Errno , Last_Error 

These columns are aliases for Last_SQL_Errno  and Last_SQL_Error . 

Issuing RESET MASTER  or RESET REPLICA | SLAVE  resets the values shown in these columns. 

<img src='content_image/795195.jpg'>

• Skip_Counter 

## Note 

When the replication SQL thread receives an error, it reports the error first, then stops the SQL thread. This means that there is a small window of time during which SHOW REPLICA | SLAVE STATUS  shows a nonzero value for Last_SQL_Errno  even though Replica_SQL_Running  still displays Yes . 

The current value of the sql_slave_skip_counter  system variable. See SET GLOBAL sql_slave_skip_counter Statement. 

• Exec_Source_Log_Pos 

The position in the current source binary log file to which the replication SQL thread has read and executed, marking the start of the next transaction or event to be processed. You can use this value with the CHANGE REPLICATION SOURCE TO  statement’s SOURCE_LOG_POS  option (from MySQL 8.0.23) or the CHANGE MASTER TO  statement’s MASTER_LOG_POS  option (before MySQL 8.0.23) when starting a new replica from an existing replica, so that the new replica reads from this point. The coordinates given by ( Relay_Source_Log_File , Exec_Source_Log_Pos ) in the source’s binary log correspond to the coordinates given by ( Relay_Log_File , Relay_Log_Pos ) in the relay log. 

Inconsistencies in the sequence of transactions from the relay log which have been executed can cause this value to be a “low-water mark” . In other words, transactions appearing before the position are guaranteed to have committed, but transactions after the position may have committed or not. If these gaps need to be corrected, use START REPLICA | SLAVE UNTIL SQL_AFTER_MTS_GAPS . See Section 17.5.1.34, “Replication and Transaction Inconsistencies”  for more information. 

• Relay_Log_Space 

The total combined size of all existing relay log files. 

• Until_Condition , Until_Log_File , Until_Log_Pos 

The values specified in the UNTIL  clause of the START REPLICA | SLAVE  statement. 

Until_Condition  has these values: 

• None  if no UNTIL  clause was specified. 

• Source  if the replica is reading until a given position in the source’s binary log. 

• Relay  if the replica is reading until a given position in its relay log. 

• SQL_BEFORE_GTIDS  if the replication SQL thread is processing transactions until it has reached the first transaction whose GTID is listed in the gtid_set . 

• SQL_AFTER_GTIDS  if the replication threads are processing all transactions until the last transaction in the gtid_set  has been processed by both threads. 

• SQL_AFTER_MTS_GAPS  if a multithreaded replica’s SQL threads are running until no more gaps are found in the relay log. 

