产品概述
应用场景
产品架构
实例类型
兼容性说明
使用规范建议
INFORMATION_SCHEMA.LOGSERVICE_ELAPSED 视图用于监控和分析灾备环境下各复制组（Replication Group，RG）在 binlog 生成过程中的时耗表现。该视图详细展示了日志处理流水线中各个关键阶段的耗时情况，帮助您定位数据同步过程中的性能瓶颈，优化灾备链路 / binlog 生成的效率。字段名 | 类型 | 描述 |
sid | bigint unsigned | LogService 的唯一标识符 |
rep_group_id | bigint unsigned | 复制组（RG）的 ID |
IsRunning | bigint unsigned | Log Handler 处于运行状态的总耗时 |
DecodeKV | bigint unsigned | 解析 Key-Value 数据的耗时 |
SendLog | bigint unsigned | 发送 Binlog 到 peer Client 的耗时 |
GetUserRgList | bigint unsigned | 获取 User RG 列表的耗时 |
SendMsg | bigint unsigned | 向 peer Client 发送消息的耗时 |
UpdateCommitTsBarrier | bigint unsigned | 更新提交时间戳屏障的耗时 |
WaitParentRg | bigint unsigned | 等待父复制组数据就绪的耗时 |
WaitVanishedRgDispatch | bigint unsigned | 等待已移除复制组调度的耗时 |
WaitSysRgOrVanishedRgCommitTsAdvance | bigint unsigned | 等待系统复制组或已移除复制组提交时间戳推进的耗时 |
WaitUsrRgCommitTsAdvance | bigint unsigned | 等待用户复制组提交时间戳推进的耗时 |
GetVanishedRgMinBarrier | bigint unsigned | 获取已移除复制组最小屏障的耗时 |
WaitRaftLog | bigint unsigned | 等待 Raft 日志同步的耗时 |
GetMergeLogJobIdStat | bigint unsigned | 获取日志合并任务状态的耗时 |
WaitAllMergeLogApplied | bigint unsigned | 等待所有合并日志回放完成的耗时 |
GetRaftLogFromBackup | bigint unsigned | 【保留字段】当前版本未使用 |
WaitRaftNodeShutDown | bigint unsigned | 【保留字段】当前版本未使用 |
GetRaftLogFromBackupFinish | bigint unsigned | 【保留字段】当前版本未使用 |
RaftOnApply | bigint unsigned | 【保留字段】当前版本未使用 |
BackupRaftApply | bigint unsigned | 【保留字段】当前版本未使用 |
WaitCachedMsgConsumed | bigint unsigned | Binlog Dump 模式下，等待缓存消息被消费的耗时 |
WaitGlobalTsBarrierAdvanced | bigint unsigned | Binlog Dump 模式下，等待全局时间戳屏障推进的耗时 |
WaitAllRepGroupRun | bigint unsigned | Binlog Dump 模式下，等待所有复制组开始回放的耗时 |
GetRaftLogFromBackupInExitProcess | bigint unsigned | 【保留字段】当前版本未使用 |
BatchKVFlushToDisk | bigint unsigned | 内存占用过高时，批量将 Key-Value 数据刷盘产生的耗时 |
tdsql > SELECT * FROM INFORMATION_SCHEMA.LOGSERVICE_ELAPSED LIMIT 1\\G*************************** 1. row ***************************sid: 29629282460369180rep_group_id: 257IsRunning: 6DecodeKV: 13SendLog: 0GetUserRgList: 0SendMsg: 3UpdateCommitTsBarrier: 0WaitParentRg: 0WaitVanishedRgDispatch: 0WaitSysRgOrVanishedRgCommitTsAdvance: 10WaitUsrRgCommitTsAdvance: 0GetVanishedRgMinBarrier: 0WaitRaftLog: 1017GetMergeLogJobIdStat: 0WaitAllMergeLogApplied: 0GetRaftLogFromBackup: 0WaitRaftNodeShutDown: 0GetRaftLogFromBackupFinish: 0RaftOnApply: 0BackupRaftApply: 0WaitCachedMsgConsumed: 0WaitGlobalTsBarrierAdvanced: 0WaitAllRepGroupRun: 0GetRaftLogFromBackupInExitProcess: 0BatchKVFlushToDisk: 51 row in set (0.00 sec)
文档反馈