replication_applier_configuration - xiaoboluo768/mysql-system-schema GitHub Wiki

• 该表中记录从库线程延迟复制的配置参数，该表中的记录在运行可以使用CHANGE MASTER TO语句进行更改

• replication_applier_configuration表各字段含义及与show slave status输出字段对应关系如下：

replication_applier_configuration表列名	含义	对应show slave status输出字段名
CHANNEL_NAME	显示复制通道名称	Channel_Name
DESIRED_DELAY	该通道下从库复制SQL线程必须滞后于主库的秒数	MASTER_DELAY

• 对于replication_applier_configuration表，不允许执行TRUNCATE TABLE语句

• 表记录内容示例

admin@localhost : performance_schema 02:49:12> select * from replication_applier_configuration;
+--------------+---------------+
| CHANNEL_NAME | DESIRED_DELAY |
+--------------+---------------+
|              |            0 |
+--------------+---------------+
1 row in set (0.00 sec)

• 表结构定义

CREATE TABLE `replication_applier_configuration` (
  `CHANNEL_NAME` char(64) NOT NULL,
  `DESIRED_DELAY` int(11) NOT NULL
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8

• 参考链接：https://dev.mysql.com/doc/refman/5.7/en/replication-applier-configuration-table.html

---

上一篇： replication tables | 下一篇： replication_applier_status表