MySQL MGR篇

查看MGR secondary 节点延迟

select 
    t1.SERVICE_STATE as IO_RUNNING,
    t2.SERVICE_STATE as SQL_RUNNING,
    t1.LAST_ERROR_NUMBER as LAST_IO_ERRNO,
    t2.LAST_ERROR_NUMBER as LAST_SQL_ERRNO,
    t1.LAST_ERROR_MESSAGE as LAST_IO_ERROR,
    t2.LAST_ERROR_MESSAGE as LAST_SQL_ERROR,
    date_format(t1.LAST_ERROR_TIMESTAMP,'%Y-%m-%d %H:%i:%s') as LAST_IO_ERROR_TIMESTAMP,
    date_format(t2.LAST_ERROR_TIMESTAMP,'%Y-%m-%d %H:%i:%s') as LAST_SQL_ERROR_TIMESTAMP,
    t1.RECEIVED_TRANSACTION_SET as retrieved_gtid_set,
    t2.LAST_PROCESSED_TRANSACTION as executed_gtid_set,
    round(t1.LAST_QUEUED_TRANSACTION_END_QUEUE_TIMESTAMP-t1.LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP) as master2RelaylogDelay,
    date_format(t2.LAST_PROCESSED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP,'%Y-%m-%d %H:%i:%s') retrieved_gtid_timestamp,
    date_format(t2.LAST_PROCESSED_TRANSACTION_END_BUFFER_TIMESTAMP,'%Y-%m-%d %H:%i:%s') executed_gtid_timestamp,
    trim(LPAD(sys.format_time(POWER(10,12) * (UNIX_TIMESTAMP(t2.PROCESSING_TRANSACTION_START_BUFFER_TIMESTAMP) - UNIX_TIMESTAMP(t2.PROCESSING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP))), 10, ' ')) as totalDelay
from replication_connection_status t1 
inner join replication_applier_status_by_coordinator t2 
on t1.CHANNEL_NAME=t2.CHANNEL_NAME 
and t1.CHANNEL_NAME='group_replication_applier';