系统表介绍
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 |
+--------------+---------------+-----------------+----------------------------+