系统表介绍
replication_group_member_stats 描述了组复制状态信息
列名 | 含义 |
---|---|
CHANNEL_NAME | 通道名称 |
VIEW_ID | 组视图标识符 |
MEMBER_ID | 成员编号 |
COUNT_TRANSACTIONS_IN_QUEUE | 队列中的事务数量 |
COUNT_TRANSACTIONS_CHECKED | 已完成冲突检测事务的数量 |
COUNT_CONFLICTS_DETECTED | 未通过冲突检测的事务的数量 |
COUNT_TRANSACTIONS_ROWS_VALIDATING | 冲突监测数据库当前大小 |
TRANSACTIONS_COMMITTED_ALL_MEMBERS | 当前视图成员成功提交的事务数 |
LAST_CONFLICT_FREE_TRANSACTION | 显示最后一个检查无冲突的事务标识符 |
实例
ysql> select * from performance_schema.replication_group_members;
+---------------------------+--------------------------------------+-------------+-------------+--------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
+---------------------------+--------------------------------------+-------------+-------------+--------------+
| group_replication_applier | 533fe6ba-bcdf-11ea-9516-000c295111ae | mgr-node1 | 3306 | ONLINE |
| group_replication_applier | 5ca45641-bcdd-11ea-918e-000c29fa726d | mgr-node2 | 3306 | ONLINE |
| group_replication_applier | 62ad32e3-bcdd-11ea-9bbb-000c2978d7f6 | mgr-node3 | 3306 | ONLINE |
+---------------------------+--------------------------------------+-------------+-------------+--------------+
以上数据摘选自:https://blog.csdn.net/d6619309/article/details/70432640