南京建站在线咨询,怎么做网站优化 s,网上商城如何推广,各网站提交入口前言
使用MySQL performance_schema数据库相关性能表监控组复制#xff0c;这些性能表显示特定于组复制的信息。
常用的表有#xff1a;
replication_group_membersreplication_group_member_stats
下面详细介绍这两个表。
1 replication_group_members
该表显示了复制…前言
使用MySQL performance_schema数据库相关性能表监控组复制这些性能表显示特定于组复制的信息。
常用的表有
replication_group_membersreplication_group_member_stats
下面详细介绍这两个表。
1 replication_group_members
该表显示了复制组成员的网络和状态信息所示的网络地址是用于将客户端连接到组的地址。
mysql select * from performance_schema.replication_group_members;
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
| group_replication_applier | 13fc049e-c133-11ee-a377-000c29df1f85 | 192.168.131.20 | 3306 | ONLINE | SECONDARY | 8.0.27 | XCom |
| group_replication_applier | 248563ac-c133-11ee-a387-000c29551477 | 192.168.131.30 | 3306 | ONLINE | SECONDARY | 8.0.27 | XCom |
| group_replication_applier | f40395ea-c132-11ee-9249-000c29c00092 | 192.168.131.10 | 3306 | ONLINE | PRIMARY | 8.0.27 | XCom |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
3 rows in set (0.00 sec)字段说明
CHANNEL_NAME组复制区域通道名称MEMBER_ID成员服务器UUID。对于组中的每个成员都有不同的值。这也可以作为键因为它对每个成员都是唯一的MEMBER_HOST该成员的网络地址主机名或IP地址。从成员的主机名变量中检索。这是客户端连接到的地址与用于内部组通信的group_replication_local_address不同MEMBER_PORT服务器正在侦听的端口MEMBER_STATE该成员的现状可以是以下任何一种: ONLINE成员处于功能完备的状态RECOVERING服务器已加入正在从中检索数据的组OFFLINE已安装组复制插件但尚未启动ERROR成员在应用事务期间或在恢复阶段遇到错误并且没有参与组的事务UNREACHABLE故障检测进程怀疑无法联系此成员因为组消息已超时 MEMBER_ROLE组中成员的角色可以是PRIMARY或SECONDARYMEMBER_VERSION成员的MySQL版本MEMBER_COMMUNICATION_STACK用于组的通信栈XCOM通信栈或MYSQL通信栈。这列是在MySQL 8.0.27中添加的。
2 replication_group_member_stats
此表提供了与认证过程相关的组级信息以及复制组的每个成员接收和发起的事务的统计信息
mysql select * from performance_schema.replication_group_member_stats\G
*************************** 1. row ***************************CHANNEL_NAME: group_replication_applierVIEW_ID: 17082578864394446:3MEMBER_ID: 13fc049e-c133-11ee-a377-000c29df1f85COUNT_TRANSACTIONS_IN_QUEUE: 0COUNT_TRANSACTIONS_CHECKED: 0COUNT_CONFLICTS_DETECTED: 0COUNT_TRANSACTIONS_ROWS_VALIDATING: 0TRANSACTIONS_COMMITTED_ALL_MEMBERS: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-24LAST_CONFLICT_FREE_TRANSACTION:
COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 1COUNT_TRANSACTIONS_REMOTE_APPLIED: 1COUNT_TRANSACTIONS_LOCAL_PROPOSED: 0COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
*************************** 2. row ***************************CHANNEL_NAME: group_replication_applierVIEW_ID: 17082578864394446:3MEMBER_ID: 248563ac-c133-11ee-a387-000c29551477COUNT_TRANSACTIONS_IN_QUEUE: 0COUNT_TRANSACTIONS_CHECKED: 0COUNT_CONFLICTS_DETECTED: 0COUNT_TRANSACTIONS_ROWS_VALIDATING: 0TRANSACTIONS_COMMITTED_ALL_MEMBERS: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-24LAST_CONFLICT_FREE_TRANSACTION:
COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 1COUNT_TRANSACTIONS_REMOTE_APPLIED: 0COUNT_TRANSACTIONS_LOCAL_PROPOSED: 0COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
*************************** 3. row ***************************CHANNEL_NAME: group_replication_applierVIEW_ID: 17082578864394446:3MEMBER_ID: f40395ea-c132-11ee-9249-000c29c00092COUNT_TRANSACTIONS_IN_QUEUE: 0COUNT_TRANSACTIONS_CHECKED: 0COUNT_CONFLICTS_DETECTED: 0COUNT_TRANSACTIONS_ROWS_VALIDATING: 0TRANSACTIONS_COMMITTED_ALL_MEMBERS: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-24LAST_CONFLICT_FREE_TRANSACTION:
COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0COUNT_TRANSACTIONS_REMOTE_APPLIED: 3COUNT_TRANSACTIONS_LOCAL_PROPOSED: 0COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
3 rows in set (0.01 sec)字段说明
CHANNEL_NAMEchannel名VIEW_ID组视图idMEMBER_ID成员uuidCOUNT_TRANSACTIONS_IN_QUEUE等待冲突检测检查的队列中的事务数COUNT_TRANSACTIONS_CHECKED已检查冲突的事务数COUNT_CONFLICTS_DETECTED未通过冲突检测检查的事务数COUNT_TRANSACTIONS_ROWS_VALIDATING冲突检测数据库当前的记录数TRANSACTIONS_COMMITTED_ALL_MEMBERS在组复制的所有成员上成功提交的事务显示为GTID集。这是以固定60s的时间间隔更新的LAST_CONFLICT_FREE_TRANSACTION最后一次检查的无冲突事务的GTIDCOUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE成员从复制组接收到等待应用的事务数COUNT_TRANSACTIONS_REMOTE_APPLIED成员从复制组接收到已经应用的事务数COUNT_TRANSACTIONS_LOCAL_PROPOSED由该成员发起并发送到组的事务数COUNT_TRANSACTIONS_LOCAL_ROLLBACK由该成员发起并由组回滚的事务数。
