replication_applier_status 详解

Posted by 道行尚浅 on September 4, 2021

系统表介绍

replication_applier_status 显示当前复制的事务执行状态

列名 含义
CHANNEL_NAME 通道名称
SERVICE_STATE 应用线程状态
REMAINING_DELAY 显示延迟应用剩余时间(秒)
COUNT_TRANSACTIONS_RETRIES 显示事务应用失败后重试的次数

实例


mysql> select * from  replication_applier_status ;
+--------------+---------------+-----------------+----------------------------+
| CHANNEL_NAME | SERVICE_STATE | REMAINING_DELAY | COUNT_TRANSACTIONS_RETRIES |
+--------------+---------------+-----------------+----------------------------+
|              | ON            |            NULL |                          0 |
+--------------+---------------+-----------------+----------------------------+