Lists the Replication Master Activity metrics and provides a brief description of each.
Table 4.22 Replication Master Activity Metrics
| Name | Description |
|---|---|
| Binlog File (Total) | The name of the current binary log file. |
| Binlog File Position (Total) | 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 (Total) | The latest GTID set within the binary log files. |
| Semi Sync Master Clients (Total) | The number of semisynchronous slaves. |
| Semi Sync Master Net Avg Wait Time (Total) | The average time in microseconds the master waited for a slave reply. |
| Semi Sync Master Net Waits (Delta) | The total number of times the master waited for slave replies. |
| Semi Sync Master Net Wait Time (Delta) | The total time in microseconds the master waited for slave replies. |
| Semi Sync Master No Times (Delta) | The number of times the master turned off semisynchronous replication. |
| Semi Sync Master No Tx (Delta) | The number of commits that were not acknowledged successfully by a slave. |
| Semi Sync Master Status (Total) | Whether semisynchronous replication currently is operational on the master. |
| Semi Sync Master Timefunc Failures (Delta) | The number of times the master failed when calling time functions such as gettimeofday(). |
| Semi Sync Master Tx Avg Wait Time (Delta) | The average time in microseconds the master waited for each transaction. |
| Semi Sync Master Tx Waits (Delta) | The total number of times the master waited for transactions. |
| Semi Sync Master Tx Wait Time (Delta) | The total time in microseconds the master waited for transactions. |
| Semi Sync Master Wait Pos Backtraverse (Delta) | The total number of times the master waited for an event with binary coordinates lower than events waited for previously. |
| Semi Sync Master Wait Sessions (Total) | The number of sessions currently waiting for slave replies. |
| Semi Sync Master Yes Tx (Delta) | The number of commits that were acknowledged successfully by a slave. |
| Show Master Status (Delta) | The total number of SHOW MASTER STATUS statements executed. |
| Show New Master (Delta) | The total number of SHOW NEW MASTER statements executed. |
| Show Slave Hosts (Delta) | The total number of SHOW SLAVE HOSTS statements executed. |
| Status (Total) | 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. |