13518219792
表performance_schema.replication_group_member_stats可以顯示MGR成員的諸多統計信息。
成都創新互聯公司服務項目包括賽罕網站建設、賽罕網站制作、賽罕網頁制作以及賽罕網絡營銷策劃等。多年來，我們專注于互聯網行業，利用自身積累的技術優勢、行業經驗、深度合作伙伴關系等，向廣大中小型企業、政府機構等提供互聯網行業的解決方案，賽罕網站推廣取得了明顯的社會效益與經濟效益。目前，我們服務的客戶以成都為中心已經輻射到賽罕省份的部分城市，未來相信會繼續擴大服務區域并繼續獲得客戶的支持與信任！
[root@MySQL.sock][performance_schema]> select * from replication_group_member_stats\G
*************************** 1. row ***************************
? ? ? ? ? ? ? ? ? ? ? CHANNEL_NAME: group_replication_applier
? ? ? ? ? ? ? ? ? ? ? ? ? ?VIEW_ID: 15683632267713610:5
? ? ? ? ? ? ? ? ? ? ? ? ?MEMBER_ID: 77731d39-bc4c-11e9-956d-080027aa34ac
? ? ? ?COUNT_TRANSACTIONS_IN_QUEUE: 7
? ? ? ? COUNT_TRANSACTIONS_CHECKED: 209004
? ? ? ? ? COUNT_CONFLICTS_DETECTED: 0
COUNT_TRANSACTIONS_ROWS_VALIDATING: 174106
TRANSACTIONS_COMMITTED_ALL_MEMBERS: 27a60549-a643-11e9-bc30-080027f22add:1-4,
aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2465742
? ? LAST_CONFLICT_FREE_TRANSACTION: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2552795
1 row in set (0.00 sec)
重點字段的含義如下：
COUNT_TRANSACTIONS_IN_QUEUE - The number of transactions in the queue pending conflict detection checks. Once the transactions have been checked for conflicts, if they pass the check, they are queued to be applied as well.
COUNT_TRANSACTIONS_CHECKED - The number of transactions that have been checked for conflicts.
COUNT_CONFLICTS_DETECTED - The number of transactions that have not passed the conflict detection check.
COUNT_TRANSACTIONS_ROWS_VALIDATING - Number of transactions which can be used for certification, but have not been garbage collected. Can be thought of as the current size of the conflict detection database against which each transaction is certified.
TRANSACTIONS_COMMITTED_ALL_MEMBERS - The transactions that have been successfully committed on all members of the replication group, shown as GTID Sets. This is updated at a fixed time interval.
LAST_CONFLICT_FREE_TRANSACTION - The transaction identifier of the last conflict free transaction which was checked.
