7.28 Replication Slave Configuration Metrics

Lists the Replication Slave configuration metrics and provides a brief description of each.

Table 7.28 Replication Slave Configuration Metrics

Name	Description
Allow Batching Enabled	Whether or not batched updates are enabled on replication slaves.
Auto Position Enabled	The set of global transaction IDs for all received transactions subsequently executed on this slave. Empty if GTIDs are not in use.
Checkpoint Group	Sets the maximum number of transactions that can be processed by a multi-threaded slave before a checkpoint operation is called to update its status as shown by SHOW SLAVE STATUS. Setting this option has no effect on slaves for which multi-threading is not enabled.
Checkpoint Period	Sets the maximum time (in milliseconds) that is allowed to pass before a checkpoint operation is called to update the status of a multi-threaded slave as shown by SHOW SLAVE STATUS. Setting this variable has no effect on slaves for which multi-threading is not enabled.
Compressed Protocol Enabled	Whether to use compression for the slave/master protocol if both the slave and the master support it.
Connect Retry	The number of seconds between connect retries to the master.
Exec Mode	Controls whether IDEMPOTENT or STRICT mode is used in replication conflict resolution and error checking.
Gtid Mode	Shows whether GTIDs are enabled.
Init Slave	A string to be executed by a slave server each time the SQL thread starts. The format of the string is the same as for the init_connect variable.
Load Tmpdir	The name of the directory where the slave creates temporary files for replicating LOAD DATA INFILE statements.
Log Slave Updates Enabled	Whether the slave logs the updates performed by its SQL thread to its own binary log.
Master Bind Address	When a replication slave has multiple network interfaces, determines which of the slave's network interfaces is chosen for connecting to the master.
Master Host	The master host that the slave is connected to.
Master Inet Address	The internet address as determined by the collecting agent, so as to mimic the DNS lookup as close as possible to what the mysql server would have done.
Master Info File	The name and location of the master.info file.
Master Port	The port used to connect to the master.
Master Retry Count	The number of times that the slave tries to connect to the master before giving up. Reconnects are attempted at intervals set by the MASTER_CONNECT_RETRY option of the CHANGE MASTER TO statement (default 60).
Master Server Id	The server_id variable value from the master.
Master Server Inv Uuid	The uuid from the master mysql.inventory table, generated by MySQL Enterprise Monitor.
Master Server Repl Uuid	The master servers server_uuid variable.
Master Ssl Allowed Enabled	Whether slave's the master server allows SSL connections.
Master Ssl Ca File	The path to a file that contains a list of trusted SSL CAs for use when connecting to the slave's master.
Master Ssl Ca Path	The path to a directory that contains trusted SSL CA certificates in PEM format for use when connecting to the slave's master.
Master Ssl Cert	The name of the SSL certificate file to use for establishing a secure connection to the slave's master.
Master Ssl Cipher	A list of permissible ciphers to use for SSL encryption when connecting to the slave's master.
Master Ssl Crl	The name of the file containing a Certificate Revocation List.
Master Ssl Crl Path	The path to a directory that contains Certificate Revocation List files.
Master Ssl Key	The name of the SSL key file to use for establishing a secure connection to the slave's master.
Master Ssl Verify Server Cert Enabled	Whether the slave verifies the Common Name value in the certificate that the master sends to it against the host name that the slave uses for connecting to the master. The connection is rejected if there is a mismatch.
Master User	The user name of the account used to connect to the master.
Max Allowed Packet	Sets the maximum packet size for the slave SQL and I/O threads, so that large updates using row-based replication do not cause replication to fail because an update exceeded max_allowed_packet.
Max Relay Log Size	The size at which the server rotates relay log files automatically.
Net Timeout	The number of seconds to wait for more data from a master/slave connection before aborting the read.
Parallel Type	Normally, transactions are applied in parallel only if they do not make any changes in the same database. Beginning with MySQL 5.7.2, it is possible to enable parallel execution on the slave of all uncommitted threads already in the prepare phase, without violating consistency, using this variable.
Parallel Workers	Sets the number of slave worker threads for executing replication events (transactions) in parallel. Setting this variable to 0 (the default) disables parallel execution.
Pending Jobs Size Max	For multi-Threaded slaves, this variable sets the maximum amount of memory (in bytes) available to slave worker queues holding events not yet applied.
Preserve Commit Order	For multi-threaded slaves, enabling this variable ensures that transactions are externalized on the slave in the same order as they appear in the slave's relay log. Setting this variable has no effect on slaves for which multi-threading is not enabled.
Read Only Enabled	When this property is enabled, the server permits no updates except from users that have the SUPER privilege.
Relay Log	The name of the relay log file.
Relay Log Basename	Holds the name and complete path to the relay log file.
Relay Log Index	The name to use for the slave relay log index file.
Relay Log Info File	The name to use for the file in which the slave records information about the relay logs.
Relay Log Info Repository	Determines whether the slave's position in the relay logs is written to a FILE (relay-log.info) or to a TABLE (mysql.slave_relay_log_info).
Relay Log Purge Enabled	Disables or enables automatic purging of relay log files as soon as they are not needed any more.
Relay Log Recovery Enabled	Enables automatic relay log recovery immediately following server startup, which means that the replication slave discards all unprocessed relay logs and retrieves them from the replication master.
Relay Log Space Limit	The maximum amount of space to use for all relay logs.
Replicate Do DB	Whether the slave SQL thread restricts replication to statements where the default database (the one selected by USE) is one of those listed.
Replicate Do Table	Whether the slave SQL thread restricts replication to the specified table(s).
Replicate Ignore DB	Whether the slave SQL thread does not replicate any statement where the default database (the one selected by USE) is one of those listed.
Replicate Ignore Server Ids	Whether the slave ignores events from 0 or more masters using the IGNORE_SERVER_IDS option in a CHANGE MASTER TO statement.
Replicate Ignore Table	Whether the slave SQL thread does not replicate any statement that updates the specified table(s), even if any other tables might be updated by the same statement.
Replicate Wild Do Table	Whether the slave thread restricts replication to statements where any of the updated tables match the specified database and table name patterns.
Replicate Wild Ignore Table	Whether the slave thread does not replicate a statement where any table matches the given wildcard pattern.
Report Host	The host name or IP address of the slave to be reported to the master during slave registration.
Report Password	The account password of the slave to be reported to the master during slave registration.
Report Port	The TCP/IP port number for connecting to the slave, to be reported to the master during slave registration.
Report User	The account user name of the slave to be reported to the master during slave registration.
Rows Search Algorithms	When preparing batches of rows for row-based logging and replication using slave_allow_batching, this option controls how the rows are searched for matches - that is, whether or not hashing is used for searches using a primary or unique key, some other key, or no key at all.
Semi Sync Slave Enabled	Whether semi-synchronous replication is enabled on the slave.
Semi Sync Slave Trace Level	The semi-synchronous replication debug trace level on the slave.
Server Id	The server ID, used in replication to give each master and slave a unique identity.
Skip Counter	The number of events from the master that a slave server skips.
Skip Errors	Tells the slave SQL thread to continue replication when a statement returns any of the errors listed in the variable value.
SQL Delay	The length of time the slave SQL thread delays applying events from the relay logs when using time delayed replication.
SQL Verify Checksum Enabled	When preparing batches of rows for row-based logging and replication using slave_allow_batching, this option controls how the rows are searched for matches - that is, whether or not hashing is used for searches using a primary or unique key, some other key, or no key at all.
Sync Master Info	If the value of this variable is greater than 0, a replication slave synchronizes its master.info file to disk (using fdatasync()) after every sync_master_info events.
Sync Relay Log	If the value of this variable is greater than 0, the MySQL server synchronizes its relay log to disk (using fdatasync()) after every sync_relay_log writes to the relay log.
Sync Relay Log Info	If the value of this variable is greater than 0, a replication slave synchronizes its relay-log.info file to disk (using fdatasync()) after every sync_relay_log_info transactions.
Transaction Retries	How many times the slave SQL thread retries a transaction because of an InnoDB deadlock or because the transaction's execution time exceeded InnoDB's innodb_lock_wait_timeout.
Type Conversions	Controls the type conversion mode in effect on the slave when using row-based replication.
Until Condition	Whether the slave was started with a START SLAVE UNTIL condition.
Until Log File	The master or relay log file that the slave will stop executing at, if started with a START SLAVE UNTIL condition.
Until Log Pos	The master or relay log position that the slave will stop executing at, if started with a START SLAVE UNTIL condition.