v.20.5New Feature
Add system.asynchronous_metric_log table for historical metrics logging
Add thesystem.asynchronous_metric_logtable that logs historical metrics fromsystem.asynchronous_metrics. #11588 (Alexander Kuzmenkov).
Why it matters
This feature enables users to analyze historical asynchronous metrics over time, solving the problem of only having current snapshot metrics available insystem.asynchronous_metrics. It adds value by allowing trend analysis, troubleshooting, and performance monitoring using past metric data.How to use it
Users can query thesystem.asynchronous_metric_log table directly with SELECT statements to retrieve historical asynchronous metrics logged by ClickHouse. No special configuration is required to enable it as it is a built-in system table.