content_image/823607.jpg content_image/823606.jpg
( binlog_format=ROW ), log_slow_slave_statements  has no effect. Queries are only added to the replica’s slow query log when they are logged in statement format in the binary log, that is, when binlog_format=STATEMENT  is set, or when binlog_format=MIXED  is set and the statement is logged in statement format. Slow queries that are logged in row format when binlog_format=MIXED is set, or that are logged when binlog_format=ROW  is set, are not added to the replica’s slow query log, even if log_slow_slave_statements  is enabled. 

Setting log_slow_slave_statements  has no immediate effect. The state of the variable applies on all subsequent START REPLICA | SLAVE  statements. Also note that the global setting for long_query_time  applies for the lifetime of the SQL thread. If you change that setting, you must stop and restart the replication SQL thread to implement the change there (for example, by issuing STOP REPLICA | SLAVE  and START REPLICA | SLAVE  statements with the SQL_THREAD  option). 

• master_info_repository 

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

The use of this system variable is now deprecated. The setting TABLE  is the default, and is required when multiple replication channels are configured. The alternative setting FILE  was previously deprecated. 

With the default setting, the replica records metadata about the source, consisting of status and connection information, to an InnoDB  table in the mysql  system database named mysql.slave_master_info . For more information on the connection metadata repository, see Section 17.2.4, “Relay Log and Replication Metadata Repositories” . 

The FILE  setting wrote the replica’s connection metadata repository to a file, which was named master.info  by default. The name could be changed using the --master-info-file  option. 

• max_relay_log_size 

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

