v.20.10Improvement

Add QueryMemoryLimitExceeded Event Counter

Add QueryMemoryLimitExceeded event counter. This closes #14589. #14647 (fastio).
Introduced the QueryMemoryLimitExceeded event counter to ClickHouse for tracking instances where queries exceed memory limits.

Why it matters

This feature enables users to monitor and identify queries that have been terminated due to exceeding memory limits, helping in diagnosing memory-related issues and optimizing resource usage.

How to use it

The QueryMemoryLimitExceeded event counter is automatically increased whenever a query exceeds its memory limit. Users can monitor this counter via system event logs or metrics to track memory limit violations.