Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; c=nofws; d=thelastpickle.com; h=subject
	:references:from:content-type:in-reply-to:message-id:date:to
	:content-transfer-encoding:mime-version; q=dns; s=
	thelastpickle.com; b=b4Hcgi1RUYcIGnU5FA4HMFQAj7MGqlhxc/4PxM9GP+g
	2tMmONYkbiL4k+eODmwCmrJZL3VJKbA+gh1vTR9ve/15YOmQSK5gXimRUTQGxkJG
	KAeB4Uo6OI+ui3Xzyk7RXKhK11To/OH83UxdBcPWOC02rfVRpx8kBf8tIDvc1xxM
	=
Subject: Re: fix for repair causing a node load to double
References: 
 <CAGJGVOW-gWefFcxC8yuNG38Vy=YhW2PNQromAgD=5+xboZktcg@mail.gmail.com>
From: Aaron Morton <aaron@thelastpickle.com>
Content-Type: multipart/alternative;
	boundary=Apple-Mail-1--991049060
In-Reply-To: 
 <CAGJGVOW-gWefFcxC8yuNG38Vy=YhW2PNQromAgD=5+xboZktcg@mail.gmail.com>
Message-Id: <92EC2618-262F-48BB-8400-BCE26D9E1F2E@thelastpickle.com>
Date: Wed, 3 Aug 2011 10:19:53 +1200
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (iPad Mail 8L1)


--Apple-Mail-1--991049060
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii

Try dropping the min compaction threshold via node tool to 2, that should fo=
rce every compaction bucket to get processed.

Use nodetool flush to trigger minor compaction for all cf's.

Clean will only remove load if you have moved tokens.

Cheers

-----------------
Aaron Morton
Freelance Cassandra Developer
@aaronmorton
http://www.thelastpickle.com

On 3/08/2011, at 2:13 AM, Adi <adi.pandit@gmail.com> wrote:

> Cassandra 0.7.6 , 4 node cluster=20
>=20
> I ran a nodetool repair for a column family a week ago which caused the lo=
ad on that node to double. The diagnosis was that I had hit https://issues.a=
pache.org/jira/browse/CASSANDRA-2280
> and that minor compactions will get rid of the unnecessary data and reduce=
 the load. That node has finished doing a round of Minor compactions over th=
e weekend and still the load is 2x of what it is supposed to be.=20
>=20
> Is nodetool cleanup an option to remove the extra data. I am running a cle=
anup and it has gone through 50% of the data and retained all of it.
>=20
> Any suggestions?=20
>=20
> -Adi
>=20
>=20

--Apple-Mail-1--991049060
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html><body bgcolor=3D"#FFFFFF"><div>Try dropping the min compaction thresho=
ld via node tool to 2, that should force every compaction bucket to get proc=
essed.<br><br></div><div>Use nodetool flush to trigger minor compaction for a=
ll cf's.</div><div><br></div><div>Clean will only remove load if you have mo=
ved tokens.</div><div><br></div><div>Cheers</div><div><br><div>-------------=
----</div><div>Aaron Morton</div><div>Freelance Cassandra Developer</div><di=
v>@aaronmorton</div><div><a href=3D"http://www.thelastpickle.com">http://www=
.thelastpickle.com</a></div></div><div><br>On 3/08/2011, at 2:13 AM, Adi &lt=
;<a href=3D"mailto:adi.pandit@gmail.com">adi.pandit@gmail.com</a>&gt; wrote:=
<br><br></div><div></div><blockquote type=3D"cite"><div><div>Cassandra 0.7.6=
 , 4 node cluster&nbsp;</div><div><br></div>I ran a nodetool repair for a co=
lumn family a week ago which caused the load on that node to double. The dia=
gnosis was that I had hit&nbsp;<a href=3D"https://issues.apache.org/jira/bro=
wse/CASSANDRA-2280"><a href=3D"https://issues.apache.org/jira/browse/CASSAND=
RA-2280">https://issues.apache.org/jira/browse/CASSANDRA-2280</a></a><div>
and that minor compactions will get rid of the unnecessary data and reduce t=
he load. That node has finished doing a round of Minor compactions over the w=
eekend and still the load is 2x of what it is supposed to be.&nbsp;</div>
<div><br></div><div>Is nodetool cleanup an option to remove the extra data. I=
 am running a cleanup and it has gone through 50% of the data and retained a=
ll of it.</div><div><br></div><div>Any suggestions?&nbsp;</div><div><br></di=
v>
<div>-Adi</div><div><br><div><br></div></div>
</div></blockquote></body></html>=

--Apple-Mail-1--991049060--