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 46CE89699 for ; Fri, 22 Feb 2013 17:29:50 +0000 (UTC) Received: (qmail 28810 invoked by uid 500); 22 Feb 2013 17:29:47 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 28784 invoked by uid 500); 22 Feb 2013 17:29:47 -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 28776 invoked by uid 99); 22 Feb 2013 17:29:47 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 22 Feb 2013 17:29:47 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [208.113.200.5] (HELO homiemail-a82.g.dreamhost.com) (208.113.200.5) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 22 Feb 2013 17:29:40 +0000 Received: from homiemail-a82.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a82.g.dreamhost.com (Postfix) with ESMTP id 35BEE282061 for ; Fri, 22 Feb 2013 09:29:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=thelastpickle.com; h=from :content-type:message-id:mime-version:subject:date:references:to :in-reply-to; s=thelastpickle.com; bh=G8yJkaIvHqtmE7utaPZPZYWtSH E=; b=Yz4pUhMODz4AOprrBGJgIehU4OmDn5YNI+FZJGOHdza5axNnWnm/M/L0WE 0LKYtxpUQqZtEIlFWZU1hCN4ItVy1LyKxlBvbiz+jVaR6c65Ce5QxJnvUxV5uQM5 fQUK4srbiQeQXswZ7bvC0Xp7oG0F9tMOlj+JnoOktysYNouZk= Received: from [172.16.1.8] (unknown [203.86.207.101]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: aaron@thelastpickle.com) by homiemail-a82.g.dreamhost.com (Postfix) with ESMTPSA id A9D5D28205F for ; Fri, 22 Feb 2013 09:29:18 -0800 (PST) From: aaron morton Content-Type: multipart/alternative; boundary="Apple-Mail=_151CC36D-93A7-4853-BEF1-DB90EB88E0EB" Message-Id: Mime-Version: 1.0 (Mac OS X Mail 6.2 \(1499\)) Subject: Re: disabling bloomfilter not working? or did I do this wrong? Date: Sat, 23 Feb 2013 06:29:20 +1300 References: To: user@cassandra.apache.org In-Reply-To: X-Mailer: Apple Mail (2.1499) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail=_151CC36D-93A7-4853-BEF1-DB90EB88E0EB Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 > Bloom Filter Space Used: 2318392048 Just to be sane do a quick check of the -Filter.db files on disk for = this CF.=20 If they are very small try a restart on the node.=20 > Number of Keys (estimate): 1249133696 Hey a billion rows on a node, what an age we live in :) Cheers ----------------- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 23/02/2013, at 4:35 AM, "Hiller, Dean" wrote: > So in the cli, I ran >=20 > update column family nreldata with bloom_filter_fp_chance=3D1.0; >=20 > Then I ran >=20 > nodetool upgradesstables databus5 nreldata; >=20 > But my bloom filter size is still around 2gig(and I want to free up = this heap)!!!! According to nodetool cfstats command=85 >=20 > Column Family: nreldata > SSTable count: 10 > Space used (live): 96841497731 > Space used (total): 96841497731 > Number of Keys (estimate): 1249133696 > Memtable Columns Count: 7066 > Memtable Data Size: 4286174 > Memtable Switch Count: 924 > Read Count: 19087150 > Read Latency: 0.595 ms. > Write Count: 21281994 > Write Latency: 0.013 ms. > Pending Tasks: 0 > Bloom Filter False Postives: 974393 > Bloom Filter False Ratio: 0.99998 > Bloom Filter Space Used: 2318392048 > Compacted row minimum size: 73 > Compacted row maximum size: 446 > Compacted row mean size: 143 >=20 >=20 --Apple-Mail=_151CC36D-93A7-4853-BEF1-DB90EB88E0EB Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=windows-1252 Bloom Filter Space Used: = 2318392048
Just to be sane do a quick check of the = -Filter.db files on disk for this CF. 
If they are very small = try a restart on the node. 

Number of Keys (estimate): 1249133696
Hey = a billion rows on a node, what an age we live in = :)

Cheers

http://www.thelastpickle.com

On 23/02/2013, at 4:35 AM, "Hiller, Dean" <Dean.Hiller@nrel.gov> = wrote:

So in the cli, I ran

update column family nreldata = with bloom_filter_fp_chance=3D1.0;

Then I ran

nodetool = upgradesstables databus5 nreldata;

But my bloom filter size is = still around 2gig(and I want to free up this heap)!!!! According to = nodetool cfstats command=85

Column Family: nreldata
SSTable = count: 10
Space used (live): 96841497731
Space used (total): = 96841497731
Number of Keys (estimate): 1249133696
Memtable Columns = Count: 7066
Memtable Data Size: 4286174
Memtable Switch Count: = 924
Read Count: 19087150
Read Latency: 0.595 ms.
Write Count: = 21281994
Write Latency: 0.013 ms.
Pending Tasks: 0
Bloom Filter = False Postives: 974393
Bloom Filter False Ratio: 0.99998
Bloom = Filter Space Used: 2318392048
Compacted row minimum size: = 73
Compacted row maximum size: 446
Compacted row mean size: = 143



= --Apple-Mail=_151CC36D-93A7-4853-BEF1-DB90EB88E0EB--