说MGR-MGR的监控

表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.

当前标题：说MGR-MGR的监控
浏览地址：/article16/iisjgg.html

成都网站建设公司_创新互联，为您提供动态网站、服务器托管、网站收录、网站维护、网站设计公司、网站策划

广告

声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源： 创新互联