v.22.12Performance Improvement
Add Settings for MergeTree Performance Optimization
Add settingsmax_streams_for_merge_tree_readingandallow_asynchronous_read_from_io_pool_for_merge_tree. Settingmax_streams_for_merge_tree_readinglimits the number of reading streams for MergeTree tables. Settingallow_asynchronous_read_from_io_pool_for_merge_treeenables a background I/O pool to read fromMergeTreetables. This may increase performance for I/O bound queries if used together withmax_streams_to_max_threads_ratioormax_streams_for_merge_tree_reading. #43260 (Nikolai Kochetov). This improves performance up to 100 times in case of high latency storage, low number of CPU and high number of data parts.