incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andras Szerdahelyi <>
Subject bloom filter fp ratio of 0.98 with fp_chance of 0.01
Date Mon, 25 Mar 2013 17:16:01 GMT
Hello list,

Could anyone shed some light on how an FP chance of 0.01 coexist with a measured FP ratio
of .. 0.98 ? Am I reading this wrong or are 98% of the requests hitting the bloom filter create
a false positive while the "target" false ratio is 0.01?
( Also key cache hit ratio is around 0.001 and sstables read is in the skies ( non-exponential
(non-) drop off  for LCS )  but that should be filed under "effect" and not "cause"? )

[default@unknown] use KS;
Authenticated to keyspace: KS
[default@KS] describe CF;
    ColumnFamily: CF
      Key Validation Class: org.apache.cassandra.db.marshal.BytesType
      Default column value validator: org.apache.cassandra.db.marshal.BytesType
      Columns sorted by: org.apache.cassandra.db.marshal.BytesType
      GC grace seconds: 691200
      Compaction min/max thresholds: 4/32
      Read repair chance: 0.1
      DC Local Read repair chance: 0.0
      Replicate on write: true
      Caching: ALL
      Bloom Filter FP chance: 0.01
      Built indexes: []
      Compaction Strategy: org.apache.cassandra.db.compaction.LeveledCompactionStrategy
      Compaction Strategy Options:
        sstable_size_in_mb: 5
      Compression Options:

Keyspace: KS
        Read Count: 628950
        Read Latency: 93.19921121869784 ms.
        Write Count: 1219021
        Write Latency: 0.14352380885973254 ms.
        Pending Tasks: 0
                Column Family: CF
                SSTable count: 22682
                Space used (live): 119771434915
                Space used (total): 119771434915
                Number of Keys (estimate): 203837952
                Memtable Columns Count: 13125
                Memtable Data Size: 33212827
                Memtable Switch Count: 15
                Read Count: 629009
                Read Latency: 88.434 ms.
                Write Count: 1219038
                Write Latency: 0.095 ms.
                Pending Tasks: 0
                Bloom Filter False Positives: 37939419
                Bloom Filter False Ratio: 0.97928
                Bloom Filter Space Used: 261572784
                Compacted row minimum size: 104
                Compacted row maximum size: 263210
                Compacted row mean size: 3041

I upgraded sstables after changing the FP chance


View raw message