v.21.8New Feature

Collect System Metrics on CPU, Disk, Memory, and More in ClickHouse

Official CH changelog text
Collect common system metrics (in system.asynchronous_metrics and system.asynchronous_metric_log) on CPU usage, disk usage, memory usage, IO, network, files, load average, CPU frequencies, thermal sensors, EDAC counters, system uptime; also added metrics about the scheduling jitter and the time spent collecting the metrics. It works similar to atop in ClickHouse and allows access to monitoring data even if you have no additional tools installed. Close #9430. #24416 (alexey-milovidov, Yegor Levankov).
Collects common system metrics such as CPU usage, disk usage, memory, IO, network, files, load average, CPU frequencies, thermal sensors, EDAC counters, system uptime, scheduling jitter, and data collection time into system.asynchronous_metrics and system.asynchronous_metric_log tables.

Why it matters

This feature enables built-in monitoring of essential system parameters directly within ClickHouse, similar to the atop utility, providing valuable insights without requiring any additional external monitoring tools. It helps users track system resource usage and performance efficiently using ClickHouse-native data structures.

How to use it

Users can access the collected asynchronous system metrics by querying the system.asynchronous_metrics and system.asynchronous_metric_log system tables. No extra installation or configuration is needed, as the metrics collection works automatically.

Related resources

PreviousNext