正文

mysql MGR 延迟状态查询

/13 浏览量
0214 
SELECT 
    MEMBER_ID AS id,
    COUNT_TRANSACTIONS_IN_QUEUE AS trx_tobe_certified,
    COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE AS relaylog_tobe_applied,
    COUNT_TRANSACTIONS_CHECKED AS trx_chkd,
    COUNT_TRANSACTIONS_REMOTE_APPLIED AS trx_done,
    COUNT_TRANSACTIONS_LOCAL_PROPOSED AS proposed
FROM 
    performance_schema.replication_group_member_stats;
-- 展开阅读全文 --