v.19.4New Features

Added Max_execution_speed and Max_execution_speed_bytes to Limit Resource Usage

Added max_execution_speed and max_execution_speed_bytes to limit resource usage. Added min_execution_speed_bytes setting to complement the min_execution_speed. #4430 (Winter Zhang)
Added max_execution_speed and max_execution_speed_bytes settings to limit resource usage during query execution. Also introduced min_execution_speed_bytes as a complement to the existing min_execution_speed setting.

Why it matters

These settings allow users to control and limit the execution speed of queries in terms of rows and bytes processed per second, enabling better resource management and preventing excessively heavy queries from overwhelming the system.

How to use it

Users can set the parameters max_execution_speed and max_execution_speed_bytes to define upper limits on the query execution speed by rows and bytes respectively. Additionally, min_execution_speed_bytes can be set to specify the minimum speed threshold in bytes, complementing min_execution_speed. These settings can be applied globally or per query via configuration files or query settings.