v.23.11Improvement

Improve ON CLUSTER Query Performance by Eliminating Heavy System Calls

Official CH changelog text
Improve performance of ON CLUSTER queries by removing heavy system calls to get all network interfaces when looking for local ip address in the DDL entry hosts list. #54909 (Duc Canh Le).
Improves the performance of ON CLUSTER queries by eliminating expensive system calls that retrieve all network interfaces when matching local IP addresses in DDL entry hosts.

Why it matters

This feature addresses the performance overhead caused by frequent and heavy system calls during ON CLUSTER query execution. By optimizing how local IP addresses are determined against the DDL entry hosts list, it reduces query latency and resource consumption, enhancing efficiency for distributed schema operations.

How to use it

Users do not need to change any configurations or query syntax. The optimization is applied internally, automatically improving the execution speed of ON CLUSTER queries without additional steps.

Related resources

PreviousNext