v.25.9Improvement
Add ability to tune pending signals
Add ability to tune pending signals in attempt to overcome CANNOT_CREATE_TIMER (for query profilers,query_profiler_real_time_period_ns/query_profiler_cpu_time_period_ns). And also collectSigQfrom the/proc/self/statusfor introspection (ifProcessSignalQueueSizeis near toProcessSignalQueueLimit, then you will likely getCANNOT_CREATE_TIMERerrors). #86760 (Azat Khuzhin).
Why it matters
This feature addresses the issue where excessive signals causeCANNOT_CREATE_TIMER errors during query profiling. By tuning the pending signal parameters and monitoring the signal queue size via SigQ, users can diagnose and mitigate timer creation failures, improving reliability and stability of query profiling.How to use it
Users can tune the signal period settings by configuringquery_profiler_real_time_period_ns and query_profiler_cpu_time_period_ns to reduce pending signals. Additionally, SigQ metrics from /proc/self/status are collected automatically for introspection. Monitoring the ProcessSignalQueueSize against ProcessSignalQueueLimit helps determine if tuning is needed to avoid CANNOT_CREATE_TIMER errors.