replication_group_member_stats - xiaoboluo768/mysql-system-schema GitHub Wiki
-
该表中记录了MySQL组复制成员数据同步相关的统计信息。仅在组复制运行时才会有记录
-
replication_group_member_stats表列名及其含义如下：
- CHANNEL_NAME：组成员所在组所使用的复制通道名称
- VIEW_ID：组成员所在组的当前视图标识符
- MEMBER_ID：显示当前组成员server的UUID，组成员实例的UUID相同。组中的每个节点具有不同的值（因为是使用的组成员实例的UUID，该UUID随机生成，保证全局唯一）且唯一
- COUNT_TRANSACTIONS_IN_QUEUE：表示当前队列中等待冲突检查的事务数，一旦冲突检测通过，他们将排队等待应用
- COUNT_TRANSACTIONS_CHECKED：表示已通过冲突检查机制检查的事务数
- COUNT_CONFLICTS_DETECTED：表示未通过冲突检测机制检查的事务数
- COUNT_TRANSACTIONS_ROWS_VALIDATING：表示冲突检测数据库的当前大小（用于存放每个经过验证的事务的数据库），可用于认证新事务，但尚未被垃圾回收的可用行数
- TRANSACTIONS_COMMITTED_ALL_MEMBERS：显示已在当前视图中的所有成员上成功提交的事务，该值固定时间间隔更新
- LAST_CONFLICT_FREE_TRANSACTION：显示左后一次无冲突校验检查的事务标识符
- 对于replication_group_member_stats表，不允许执行TRUNCATE TABLE语句
-
表记录内容示例
root@localhost : performance_schema 02:41:16> select * from replication_group_member_stats\G;
*************************** 1. row ***************************
CHANNEL_NAME: group_replication_applier
VIEW_ID:
MEMBER_ID: 19f71b6a-30d3-11e8-a724-525400c33752
COUNT_TRANSACTIONS_IN_QUEUE: 0
COUNT_TRANSACTIONS_CHECKED: 0
COUNT_CONFLICTS_DETECTED: 0
COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
TRANSACTIONS_COMMITTED_ALL_MEMBERS:
LAST_CONFLICT_FREE_TRANSACTION:
1 row in set (0.00 sec)
# 在MySQL 8.0中记录的信息会更假详细，类似如下
root@localhost : (none):28: > select * from performance_schema.replication_group_member_stats\G
*************************** 1. row ***************************
CHANNEL_NAME: group_replication_applier
VIEW_ID: 15692965051216743:7
MEMBER_ID: 2d283e92-de7b-11e9-a14d-525400c33752
COUNT_TRANSACTIONS_IN_QUEUE: 0
COUNT_TRANSACTIONS_CHECKED: 752
COUNT_CONFLICTS_DETECTED: 0
COUNT_TRANSACTIONS_ROWS_VALIDATING: 2002826
TRANSACTIONS_COMMITTED_ALL_MEMBERS: 320675e6-de7b-11e9-b3a9-5254002a54f2:1-4,
aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-8
LAST_CONFLICT_FREE_TRANSACTION: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:760
COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 1
COUNT_TRANSACTIONS_REMOTE_APPLIED: 752
COUNT_TRANSACTIONS_LOCAL_PROPOSED: 0
COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
*************************** 2. row ***************************
CHANNEL_NAME: group_replication_applier
VIEW_ID: 15692965051216743:7
MEMBER_ID: 2e33b2a7-de7b-11e9-9a21-525400bdd1f2
COUNT_TRANSACTIONS_IN_QUEUE: 0
COUNT_TRANSACTIONS_CHECKED: 742
COUNT_CONFLICTS_DETECTED: 0
COUNT_TRANSACTIONS_ROWS_VALIDATING: 1976086
TRANSACTIONS_COMMITTED_ALL_MEMBERS: 320675e6-de7b-11e9-b3a9-5254002a54f2:1-4,
aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-8
LAST_CONFLICT_FREE_TRANSACTION: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:213
COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 1
COUNT_TRANSACTIONS_REMOTE_APPLIED: 741
COUNT_TRANSACTIONS_LOCAL_PROPOSED: 0
COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
*************************** 3. row ***************************
CHANNEL_NAME: group_replication_applier
VIEW_ID: 15692965051216743:7
MEMBER_ID: 320675e6-de7b-11e9-b3a9-5254002a54f2
COUNT_TRANSACTIONS_IN_QUEUE: 0
COUNT_TRANSACTIONS_CHECKED: 748
COUNT_CONFLICTS_DETECTED: 0
COUNT_TRANSACTIONS_ROWS_VALIDATING: 1984108
TRANSACTIONS_COMMITTED_ALL_MEMBERS: 320675e6-de7b-11e9-b3a9-5254002a54f2:1-4,
aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-8
LAST_CONFLICT_FREE_TRANSACTION: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:753
COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0
COUNT_TRANSACTIONS_REMOTE_APPLIED: 4
COUNT_TRANSACTIONS_LOCAL_PROPOSED: 748
COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
3 rows in set (0.00 sec
- 表结构定义
CREATE TABLE `replication_group_member_stats` (
`CHANNEL_NAME` char(64) NOT NULL,
`VIEW_ID` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`MEMBER_ID` char(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`COUNT_TRANSACTIONS_IN_QUEUE` bigint(20) unsigned NOT NULL,
`COUNT_TRANSACTIONS_CHECKED` bigint(20) unsigned NOT NULL,
`COUNT_CONFLICTS_DETECTED` bigint(20) unsigned NOT NULL,
`COUNT_TRANSACTIONS_ROWS_VALIDATING` bigint(20) unsigned NOT NULL,
`TRANSACTIONS_COMMITTED_ALL_MEMBERS` longtext NOT NULL,
`LAST_CONFLICT_FREE_TRANSACTION` text NOT NULL
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
上一篇： replication_connection_status表 | 下一篇： replication_group_members表