replication_connection_status 详解

系统表介绍

replication_connection_status 表描述了连接是变更的值

列名	含义
CHANNEL_NAME	通道名称
GROUP_NAME	组复制组名
SOURCE_UUID	原库UUID
THREAD_ID	线程编号
SERVICE_STATE	服务状态
COUNT_RECEIVED_HEARTBEATS	心跳信号量
LAST_HEARTBEAT_TIMESTAMP	最近收到的心跳信号的时间
RECEIVED_TRANSACTION_SET	接收到的事务ID集合
LAST_ERROR_NUMBER	最后IO进程错误编号
LAST_ERROR_MESSAGE	最后IO进程错误信息
LAST_ERROR_TIMESTAMP	最后IO进程报错时间

实例

mysql> select * from replication_connection_status \G ;
*************************** 1. row ***************************
             CHANNEL_NAME: 
               GROUP_NAME: 
              SOURCE_UUID: 089a60e4-7972-11eb-9439-000c2904afbb
                THREAD_ID: 36
            SERVICE_STATE: ON
COUNT_RECEIVED_HEARTBEATS: 153
 LAST_HEARTBEAT_TIMESTAMP: 2021-08-08 09:45:36
 RECEIVED_TRANSACTION_SET: 
        LAST_ERROR_NUMBER: 0
       LAST_ERROR_MESSAGE: 
     LAST_ERROR_TIMESTAMP: 0000-00-00 00:00:00
1 row in set (0.01 sec)

ERROR: 
No query specified

登录主库查看UUID

mysql> show variables like '%uuid%' ;
+---------------+--------------------------------------+
| Variable_name | Value                                |
+---------------+--------------------------------------+
| server_uuid   | 089a60e4-7972-11eb-9439-000c2904afbb |
+---------------+--------------------------------------+
1 row in set (0.00 sec)

从库线程编号

mysql> select * from performance_schema.threads where thread_id = 36 \G;
*************************** 1. row ***************************
          THREAD_ID: 36
               NAME: thread/sql/slave_io
               TYPE: FOREGROUND
     PROCESSLIST_ID: 10
   PROCESSLIST_USER: root
   PROCESSLIST_HOST: localhost
     PROCESSLIST_DB: NULL
PROCESSLIST_COMMAND: Connect
   PROCESSLIST_TIME: 65418
  PROCESSLIST_STATE: Waiting for master to send event
   PROCESSLIST_INFO: NULL
   PARENT_THREAD_ID: 30
               ROLE: NULL
       INSTRUMENTED: YES
            HISTORY: YES
    CONNECTION_TYPE: NULL
       THREAD_OS_ID: 3773
1 row in set (0.00 sec)