v.21.2Improvements

Add Option to Disable Checksum Validation for MergeTree Tables

Official CH changelog text
Add an option to disable validation of checksums on reading. Should never be used in production. Please do not expect any benefits in disabling it. It may only be used for experiments and benchmarks. The setting only applicable for tables of MergeTree family. Checksums are always validated for other table engines and when receiving data over network. In my observations there is no performance difference or it is less than 0.5%. #19588 (alexey-milovidov).
Added an option to disable checksum validation when reading data from MergeTree family tables.

Why it matters

This feature allows users to disable checksum validation on read operations for MergeTree tables, primarily for experimental and benchmarking purposes. It helps in exploring performance characteristics without checksum overhead, although in practice the performance impact is minimal (less than 0.5%). It is not recommended for production use due to data integrity risks.

How to use it

Users can disable checksum validation by setting the appropriate setting for MergeTree tables. Note that this setting only applies to tables of the MergeTree family, and checksum validation remains enabled for other table engines and during data receiving over the network.

Related resources

PreviousNext