表performance_schema.replication_group_member_stats可以顯示MGR成員的諸多統(tǒng)計(jì)信息。

成都創(chuàng)新互聯(lián)公司服務(wù)項(xiàng)目包括賽罕網(wǎng)站建設(shè)、賽罕網(wǎng)站制作、賽罕網(wǎng)頁(yè)制作以及賽罕網(wǎng)絡(luò)營(yíng)銷策劃等。多年來(lái)，我們專注于互聯(lián)網(wǎng)行業(yè)，利用自身積累的技術(shù)優(yōu)勢(shì)、行業(yè)經(jīng)驗(yàn)、深度合作伙伴關(guān)系等，向廣大中小型企業(yè)、政府機(jī)構(gòu)等提供互聯(lián)網(wǎng)行業(yè)的解決方案，賽罕網(wǎng)站推廣取得了明顯的社會(huì)效益與經(jīng)濟(jì)效益。目前，我們服務(wù)的客戶以成都為中心已經(jīng)輻射到賽罕省份的部分城市，未來(lái)相信會(huì)繼續(xù)擴(kuò)大服務(wù)區(qū)域并繼續(xù)獲得客戶的支持與信任！

[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)

重點(diǎn)字段的含義如下：

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.

當(dāng)前標(biāo)題：說MGR-MGR的監(jiān)控
瀏覽地址：http://jinyejixie.com/article16/iisjgg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供動(dòng)態(tài)網(wǎng)站、服務(wù)器托管、網(wǎng)站收錄、網(wǎng)站維護(hù)、網(wǎng)站設(shè)計(jì)公司、網(wǎng)站策劃

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)