Documentation Home
Oracle Enterprise Manager for MySQL Database User's Guide
Related Documentation Download this Manual
PDF (US Ltr) - 1.1Mb
PDF (A4) - 1.1Mb


7.28 Replication Source Configuration Metrics

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

Table 7.28 Replication Source Configuration Metrics

NameDescription
Auto Increment IncrementControls the interval between successive column values within all AUTO_INCREMENT columns within the MySQL server.
Auto Increment OffsetDetermines the starting point for the AUTO_INCREMENT column values within the MySQL server.
Enforce Gtid Consistency EnabledAllows execution of only those statements that can be logged in a transactionally safe manner.
Gtid ExecutedContains a representation of the set of all transactions that are logged in the binary log.
Gtid Executed Compression PeriodCompress the mysql.gtid_executed table each time this many transactions have been processed. A setting of 0 means that this table is not compressed. Since no compression of the table occurs when using the binary log, setting the value of the variable has no effect unless binary logging is disabled.
Gtid ModeShows whether GTIDs are enabled.
Gtid NextSpecifies whether and how the next GTID is obtained.
Gtid OwnedHolds a list of all GTIDs along with their owners.
Gtid PurgedThe set of all transactions that have been purged from the binary log.
Info RepositoryThe setting of this variable determines whether the replica logs source status and connection information to a FILE (source.info), or to a TABLE (mysql.replica_source_info).
Recovery RankThe rank of a server when choosing which server should take over during recovery.
Repl UuidThe MySQL server's UUID.
Semi Sync Source EnabledWhether semi-synchronous replication is enabled on the source MySQL server.
Semi Sync Source TimeoutHow long the source waits on a commit (in milliseconds) for acknowledgment from a replica before timing out and reverting to asynchronous replication.
Semi Sync Source Trace LevelThe semi-synchronous replication debug trace level on the source.
Semi Sync Source Wait No Replica EnabledWhether the source waits for the timeout to expire before reverting to normal replication even if the replica count drops to zero during the timeout period.
Server IdThe server ID, used in replication to give each source and replica a unique identity.
Verify Checksum EnabledEnabling this option causes the source to verify events from the binary log using checksums, and to stop with an error in the event of a mismatch.