Configuration
bloom_filter_fp_chance per table. Default 0.01 (STCS) / 0.1 (LCS). Lower FP = larger filter (RAM) = fewer wasted reads.
Advertisement
RAM cost
~10 bits per key at 1% FP. Wide partition = few keys = small filter. Many small partitions = many keys = larger filters.
Advertisement
Tuning strategy
Read-heavy on wide partitions → don't touch. Read-heavy on point queries → lower FP (0.001) if RAM available.