content_image/743732.jpg content_image/743738.jpg
servers is removed. If any server IDs have been set in this way, a comma-delimited list of one or more numbers is shown. If no server IDs have been set, the field is blank. 

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

## Note 

The Ignored_server_ids  value in the slave_master_info  table also shows the server IDs to be ignored, but as a space-delimited list, preceded by the total number of server IDs to be ignored. For example, if a CHANGE REPLICATION SOURCE TO  | CHANGE MASTER TO  statement containing the IGNORE_SERVER_IDS = (2,6,9)  option has been issued to tell a replica to ignore sources having the server ID 2, 6, or 9, that information appears as shown here: 

 Replicate_Ignore_Server_Ids: 2, 6, 9 

 Ignored_server_ids: 3, 2, 6, 9 

Replicate_Ignore_Server_Ids  filtering is performed by the I/O thread, rather than by the SQL thread, which means that events which are filtered out are not written to the relay log. This differs from the filtering actions taken by server options such --replicate-do-table , which apply to the SQL thread. 

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

• Source_Server_Id 

The server_id  value from the source. 

• Source_UUID 

The server_uuid  value from the source. 

• Source_Info_File 

## Note 

From MySQL 8.0, a deprecation warning is issued if SET GTID_MODE=ON  is issued when any channel has existing server IDs set with IGNORE_SERVER_IDS . Before starting GTID-based replication, use SHOW REPLICA | SLAVE STATUS to check for and clear all ignored server ID lists on the servers involved. You can clear a list by issuing a CHANGE REPLICATION SOURCE TO  | CHANGE MASTER TO  statement containing the IGNORE_SERVER_IDS  option with an empty list. 

The location of the master.info  file, the use of which is now deprecated. By default from MySQL 8.0, a table is used instead for the replica’s connection metadata repository. 

• SQL_Delay 

The number of seconds that the replica must lag the source. 

• SQL_Remaining_Delay 

When Replica_SQL_Running_State  is Waiting until MASTER_DELAY seconds after source executed event , this field contains the number of delay seconds remaining. At other times, this field is NULL . 

