system.aggregated_zookeeper_log

包含按会话、路径、操作类型、组件和子请求标志分组的 ZooKeeper 操作聚合统计信息的系统表。

​

描述

此表包含 ZooKeeper 操作的聚合统计信息 (例如操作次数、平均延迟、错误数) ，按 (session_id, parent_path, operation, component, is_subrequest) 分组，并定期写入磁盘。

与会记录每个单独请求和响应的 system.zookeeper_log 不同，此表会将操作聚合到不同分组中，因此更加轻量，也更适合生产环境中的工作负载。

属于 Multi 或 MultiRead 批次的操作会通过 is_subrequest 列单独跟踪。子请求的延迟为零，因为总延迟归属于外层的 Multi/MultiRead 操作。

​

列

• hostname (LowCardinality(String)) — 服务器的主机名。
• event_date (Date) — 该组被写入磁盘时的日期。
• event_time (DateTime) — 该组被写入磁盘时的时间。
• session_id (Int64) — 会话 ID。
• parent_path (String) — 路径前缀。
• operation (Enum16(‘Close’ = -11, ‘Error’ = -1, ‘Watch’ = 0, ‘Create’ = 1, ‘Remove’ = 2, ‘Exists’ = 3, ‘Get’ = 4, ‘Set’ = 5, ‘GetACL’ = 6, ‘SetACL’ = 7, ‘SimpleList’ = 8, ‘Sync’ = 9, ‘Heartbeat’ = 11, ‘List’ = 12, ‘Check’ = 13, ‘Multi’ = 14, ‘Create2’ = 15, ‘Reconfig’ = 16, ‘CheckWatch’ = 17, ‘RemoveWatch’ = 18, ‘MultiRead’ = 22, ‘Auth’ = 100, ‘SetWatch’ = 101, ‘SetWatch2’ = 105, ‘AddWatch’ = 106, ‘FilteredList’ = 500, ‘CheckNotExists’ = 501, ‘CreateIfNotExists’ = 502, ‘RemoveRecursive’ = 503, ‘CheckStat’ = 504, ‘TryRemove’ = 505, ‘FilteredListWithStatsAndData’ = 506, ‘ListRecursive’ = 507, ‘SessionID’ = 997)) — ZooKeeper 操作类型。
• is_subrequest (UInt8) — 此操作是否是 Multi 或 MultiRead 操作中的子请求。
• count (UInt32) — (session_id, parent_path, operation, component, is_subrequest) 组中的操作数量。
• errors (Map(Enum8(‘ZNOWATCHER’ = -121, ‘ZNOTREADONLY’ = -119, ‘ZSESSIONMOVED’ = -118, ‘ZNOTHING’ = -117, ‘ZCLOSING’ = -116, ‘ZAUTHFAILED’ = -115, ‘ZINVALIDACL’ = -114, ‘ZINVALIDCALLBACK’ = -113, ‘ZSESSIONEXPIRED’ = -112, ‘ZNOTEMPTY’ = -111, ‘ZNODEEXISTS’ = -110, ‘ZNOCHILDRENFOREPHEMERALS’ = -108, ‘ZBADVERSION’ = -103, ‘ZNOAUTH’ = -102, ‘ZNONODE’ = -101, ‘ZAPIERROR’ = -100, ‘ZOUTOFMEMORY’ = -10, ‘ZINVALIDSTATE’ = -9, ‘ZBADARGUMENTS’ = -8, ‘ZOPERATIONTIMEOUT’ = -7, ‘ZUNIMPLEMENTED’ = -6, ‘ZMARSHALLINGERROR’ = -5, ‘ZCONNECTIONLOSS’ = -4, ‘ZDATAINCONSISTENCY’ = -3, ‘ZRUNTIMEINCONSISTENCY’ = -2, ‘ZSYSTEMERROR’ = -1, ‘ZOK’ = 0), UInt32)) — (session_id, parent_path, operation, component, is_subrequest) 组中的错误。
• average_latency (Float64) — (session_id, parent_path, operation, component, is_subrequest) 组中所有操作的平均延迟，单位为微秒。子请求的延迟为零，因为延迟归属于外层的 Multi 或 MultiRead 操作。
• component (LowCardinality(String)) — 触发该事件的组件。

​

另请参阅

• system.zookeeper_log — 按请求记录的详细 ZooKeeper 日志。
• ZooKeeper