v.19.4New Features
Added Max_execution_speed and Max_execution_speed_bytes to Limit Resource Usage
Addedmax_execution_speedandmax_execution_speed_bytesto limit resource usage. Addedmin_execution_speed_bytessetting to complement themin_execution_speed. #4430 (Winter Zhang)
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 parametersmax_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.