Unlock this content
Enter your email to unlock this content for free
Engine Settings
TL;DR
MergeTree engines have hundreds of settings for tuning merges, parts, and replication. Understanding these settings helps optimize performance, but managed ClickHouse services provide sensible defaults and automatic tuning.
MergeTree engines have hundreds of settings controlling merge behavior, part management, replication, backups, and observability.
-- View all MergeTree-related settings
SELECT name, value, description
FROM system.settings
WHERE name LIKE '%merge%' OR name LIKE '%part%'
ORDER BY name;There are hundreds of settings; tens just to tune merges and avoid part explosions.