Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Message-ID: <4E91AB18.8000706@sendmail.cz>
Date: Sun, 09 Oct 2011 16:09:28 +0200
From: Radim Kolar <hsn@sendmail.cz>
User-Agent: Mozilla/5.0 (Windows NT 5.1;
 rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1
MIME-Version: 1.0
To: user@cassandra.apache.org
Subject: Re: how to reduce disk read? (and bloom filter performance)
References: 
 <CAAnh3_-J8zfEQaTuMQ7A2UR8iOAGG16qS346Due0dUWJfe3NnQ@mail.gmail.com>
 <4E8EA5B3.2020601@sendmail.cz>
 <B6F7ACF0-CDE9-4DAE-9F2F-3A27C4ACED00@thelastpickle.com>
 <4E8EBBD4.7030206@sendmail.cz>
 <CAOT3TWrmL2WodrH=38=VjnXZh549ca6YcP=AsoSnY2K3ptzfHw@mail.gmail.com>
 <4E8F6908.7020107@sendmail.cz>
 <CAOT3TWpGnUTGtxWqQTLK8rmMcUsoAQE3hf=EtjmDeaCEXRBiXg@mail.gmail.com>
In-Reply-To: 
 <CAOT3TWpGnUTGtxWqQTLK8rmMcUsoAQE3hf=EtjmDeaCEXRBiXg@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Dne 7.10.2011 23:16, Mohit Anchlia napsal(a):
> You'll see output like:
>
> Offset      SSTables
> 1                  8021
> 2                  783
>
> Which means 783 read operations accessed 2 SSTables
thank you for explaining it to me. I see this:

Offset      SSTables
1              59323
2                857
3                  56

it means bloom filter failure ratio over 1%. Cassandra in unit tests 
expects bloom filter false positive less than 1.05%. HBase has 
configurable bloom filters. You can choose 1% or 0.5% - it can make 
difference for large cache.

But result is that my poor read performance should not be caused by 
bloom filters.