6.26 Replication Source Activity Metrics

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

Table 6.26 Replication Source Activity Metrics

Name	Description
Binlog File	The name of the current binary log file.
Binlog File Position	The file position of the current binary log file.
Cache Disk Use (Delta)	The number of transactions that used the binary log cache but that exceeded the value of binlog_cache_size and used a temporary file to store changes from the transaction.
Cache Use (Delta)	The number of transactions that used the binary log cache.
Executed Gtid Set	The latest GTID set within the binary log files.
Semi Sync Source Clients	The number of semisynchronous replicas.
Semi Sync Source Net Avg Wait Time	The average time in microseconds the source waited for a replica reply.
Semi Sync Source Net Waits (Delta)	The total number of times the source waited for replica replies.
Semi Sync Source Net Wait Time (Delta)	The total time in microseconds the source waited for replica replies.
Semi Sync Source No Times (Delta)	The number of times the source turned off semisynchronous replication.
Semi Sync Source No Tx (Delta)	The number of commits that were not acknowledged successfully by a replica.
Semi Sync Source Status	Whether semisynchronous replication currently is operational on the source.
Semi Sync Source Timefunc Failures (Delta)	The number of times the source failed when calling time functions such as gettimeofday().
Semi Sync Source Tx Avg Wait Time (Delta)	The average time in microseconds the source waited for each transaction.
Semi Sync Source Tx Waits (Delta)	The total number of times the source waited for transactions.
Semi Sync Source Tx Wait Time (Delta)	The total time in microseconds the source waited for transactions.
Semi Sync Source Wait Pos Backtraverse (Delta)	The total number of times the source waited for an event with binary coordinates lower than events waited for previously.
Semi Sync Source Wait Sessions	The number of sessions currently waiting for replica replies.
Semi Sync Source Yes Tx (Delta)	The number of commits that were acknowledged successfully by a replica.
Show Source Status (Delta)	The total number of SHOW SOURCE STATUS statements executed.
Show New Source (Delta)	The total number of SHOW NEW SOURCE statements executed.
Show Replica Hosts (Delta)	The total number of SHOW REPLICA HOSTS statements executed.
Status	The status of fail-safe replication.
Exceeded Binary Log Space Limit (Rate)	When binary log usage exceeds the binary log cache memory limits, it is performing excessive disk operations. For optimal performance, transactions that move through the binary log should be contained within the binary log cache.