Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id DC07018B7B for ; Thu, 18 Feb 2016 07:35:54 +0000 (UTC) Received: (qmail 28214 invoked by uid 500); 18 Feb 2016 07:35:52 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 28177 invoked by uid 500); 18 Feb 2016 07:35:52 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 28167 invoked by uid 99); 18 Feb 2016 07:35:52 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Feb 2016 07:35:52 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 482761A092F for ; Thu, 18 Feb 2016 07:35:52 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.198 X-Spam-Level: * X-Spam-Status: No, score=1.198 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx2-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id TO-pllMy2VNq for ; Thu, 18 Feb 2016 07:35:51 +0000 (UTC) Received: from mail-io0-f174.google.com (mail-io0-f174.google.com [209.85.223.174]) by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with ESMTPS id AD55D5FAE5 for ; Thu, 18 Feb 2016 07:35:50 +0000 (UTC) Received: by mail-io0-f174.google.com with SMTP id 9so63856726iom.1 for ; Wed, 17 Feb 2016 23:35:50 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to:content-type; bh=XQp5UhqxfVorW0AK/q+ug/wuxfl7QjZRAjmMtZsPEWU=; b=lZdvR8a39uF15juyg69cQF99YtJVZeu5ZLzeZfVWVo4v0oSiKl3zVQW8ExiK37wvfH gmOWGpPSgUgUKshwbifCZtb6wdUW5eo59xYEqtu+B3RdIZKQrWwDVEFcheyM5w1Hg1DN 68bpt7qOPt/JJ5TDzWy30SnRADILStkSUQHa4qqlc26BQ5g24H5PswzUrvrPPwKTtX2H wqcT0bOa3nf1wwTvj8FVvH8B7FMsMvXy+c1v2YorIAFS6LaodZGaRwzzHwo0m0YEoL7j geltdi497+qX21ZJMj7oXLTZCE9/NORIOX7Ry7Y7L89Owx5vncMtkA4odBrTyhzsyNU4 6Nmg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:from:date:message-id:subject:to :content-type; bh=XQp5UhqxfVorW0AK/q+ug/wuxfl7QjZRAjmMtZsPEWU=; b=Mn59sZToiUUgWUztOvFSrPrVHTp4rheOK8I2Z2Nu9oBGrqZb3hBYapJ0Nu75x/ZkzD bGCdeDQX0kkWkJsKAgQi/XHWuSHBND1fbNqktRc1gDHCUpZ5DDIr5i78hDe+fiuMibTl XFem7MC2M4qAOvPqcCXfiOLMzPfimqWAZj3viz7EZWfsYcjOfqZGB1lDxjsyK/zJniir gHfU6jEqDOjSFqUH+n5el4lo/A0GXlPGttMeA42sE5FPFAwbxdbEd3lO59gHdHgcvmSH pFSAv6+BVROsknLrdaKzq5SLdJmDr44N62Jwy9Z8JIAvFibH2Z87yj3F6pJ/a4V1YG3P aPGg== X-Gm-Message-State: AG10YOS6B/+6Eqozr6xgOo/YGALYB81+qILIUbX3z9ySvS0PQ+kdQuRu2CMKREIqA8J7CKTHkgEE+2HrJa3x6A== X-Received: by 10.107.129.89 with SMTP id c86mr7992486iod.102.1455780949796; Wed, 17 Feb 2016 23:35:49 -0800 (PST) MIME-Version: 1.0 Received: by 10.79.128.28 with HTTP; Wed, 17 Feb 2016 23:35:10 -0800 (PST) From: Anishek Agarwal Date: Thu, 18 Feb 2016 13:05:10 +0530 Message-ID: Subject: High Bloom filter false ratio To: "user@cassandra.apache.org" Content-Type: multipart/alternative; boundary=001a113f943c622ba6052c066a2a --001a113f943c622ba6052c066a2a Content-Type: text/plain; charset=UTF-8 Hello, We have a table with composite partition key with humungous cardinality, its a combination of (long,long). On the table we have bloom_filter_fp_chance=0.010000. On doing "nodetool cfstats" on the 5 nodes we have in the cluster we are seeing "Bloom filter false ratio:" in the range of 0.7 -0.9. I thought over time the bloom filter would adjust to the key space cardinality, we have been running the cluster for a long time now but have added significant traffic from Jan this year, which would not lead to writes in the db but would lead to high reads to see if are any values. Are there any settings that can be changed to allow better ratio. Thanks Anishek --001a113f943c622ba6052c066a2a Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hello,

We have a table with composite p= artition key with humungous cardinality, its a combination of (long,long). = On the table we have bloom_filter_fp_chance=3D0.010000.

On doing "nodetool cfstats" on the 5 nodes we have in the c= luster we are seeing =C2=A0"Bloom filter false ratio:" in the ran= ge of 0.7 -0.9.=C2=A0

I thought over time the bloo= m filter would adjust to the key space cardinality, we have been running th= e cluster for a long time now but have added significant traffic from Jan t= his year, which would not lead to writes in the db but would lead to high r= eads to see if are any values.=C2=A0

Are there any= settings that can be changed to allow better ratio.

Thanks
Anishek
--001a113f943c622ba6052c066a2a--