Lists the Replication Master configuration metrics and provides a brief description of each.
Table 5.24 Replication Master Configuration Metrics
Name | Description |
---|---|
Auto Increment Increment (Total) | Controls the interval between successive column values withinall AUTO_INCREMENT columns within the MySQL server. |
Auto Increment Offset (Total) | Determines the starting point for the AUTO_INCREMENT column values within the MySQL server. |
Enforce Gtid Consistency Enabled (Total) | Allows execution of only those statements that can be logged in a transactionally safe manner. |
Gtid Executed (Total) | Contains a representation of the set of all transactions that are logged in the binary log. |
Gtid Mode (Total) | Shows whether GTIDs are enabled. |
Gtid Next (Total) | Specifies whether and how the next GTID is obtained. |
Gtid Owned (Total) | Holds a list of all GTIDs along with their owners. |
Gtid Purged (Total) | The set of all transactions that have been purged from the binary log. |
Info Repository (Total) | The setting of this variable determines whether the slave logs master status and connection information to a FILE (master.info), or to a TABLE (mysql.slave_master_info). |
Recovery Rank (Total) | null |
Repl Uuid (Total) | The MySQL server's UUID, this variable is only available on versions > 5.6.1. |
Semi Sync Master Enabled (Total) | Whether semisynchronous replication is enabled on the master MySQL server. |
Semi Sync Master Timeout (Total) | How long the master waits on a commit (in milliseconds) for acknowledgment from a slave before timing out and reverting to asynchronous replication. |
Semi Sync Master Trace Level (Total) | The semisynchronous replication debug trace level on the master. |
Semi Sync Master Wait No Slave Enabled (Total) | Whether the master waits for the timeout to expire before reverting to normal replication even if the slave count drops to zero during the timeout period. |
Server Id (Total) | The server ID, used in replication to give each master and slave a unique identity. |
Verify Checksum Enabled (Total) | Enabling this option causes the master to verify events from the binary log using checksums, and to stop with an error in the event of a mismatch. |