v.21.10New Features

Added ExecutablePool Storage Engine for Long Running Processes

Added ExecutablePool storage engine. Similar to Executable but it's using a pool of long running processes. #28518 (Maksim Kita).
Added ExecutablePool storage engine, which is similar to Executable but utilizes a pool of long-running processes to handle queries.

Why it matters

The ExecutablePool storage engine improves performance and resource utilization by maintaining a pool of persistent external executables, reducing the overhead of repeatedly starting and stopping processes for each query execution.

How to use it

Users can enable the ExecutablePool storage engine by creating a table with the ENGINE set to ExecutablePool and configuring the parameters to specify the executable and its arguments, similar to the Executable engine, but benefiting from the process pool management for better efficiency.