Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of krummas@gmail.com designates
 209.85.192.175 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAMR1f-cafBK=kGR57ypczLdtT0Gy-xKRf6sg=J06YmJr-hqkKg@mail.gmail.com>
References: 
 <CAMR1f-cafBK=kGR57ypczLdtT0Gy-xKRf6sg=J06YmJr-hqkKg@mail.gmail.com>
Date: Wed, 10 Jul 2013 19:28:34 +0200
Message-ID: 
 <CA+1dbhNwuuWxW81J1ekN2tAYySzN9cGwEF1NZimRmamb1tRELg@mail.gmail.com>
Subject: Re: manually removing sstable
From: Marcus Eriksson <krummas@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=047d7b15b1f57240f104e12b9bca

--047d7b15b1f57240f104e12b9bca
Content-Type: text/plain; charset=ISO-8859-1

yep that works, you need to remove all components of the sstable though,
not just -Data.db

and, in 2.0 there is this:
https://issues.apache.org/jira/browse/CASSANDRA-5228

/Marcus


On Wed, Jul 10, 2013 at 2:09 PM, Theo Hultberg <theo@iconara.net> wrote:

> Hi,
>
> I think I remember reading that if you have sstables that you know contain
> only data that whose ttl has expired, it's safe to remove them manually by
> stopping c*, removing the *-Data.db files and then starting up c* again. is
> this correct?
>
> we have a cluster where everything is written with a ttl, and sometimes c*
> needs to compact over a 100 gb of sstables where we know ever has expired,
> and we'd rather just manually get rid of those.
>
> T#
>

--047d7b15b1f57240f104e12b9bca
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">yep that works, you need to remove all components of the s=
stable though, not just -Data.db<div><br></div><div style>and, in 2.0 there=
 is this:</div><div style><a href=3D"https://issues.apache.org/jira/browse/=
CASSANDRA-5228">https://issues.apache.org/jira/browse/CASSANDRA-5228</a><br=
>
</div><div style><br></div><div style>/Marcus</div></div><div class=3D"gmai=
l_extra"><br><br><div class=3D"gmail_quote">On Wed, Jul 10, 2013 at 2:09 PM=
, Theo Hultberg <span dir=3D"ltr">&lt;<a href=3D"mailto:theo@iconara.net" t=
arget=3D"_blank">theo@iconara.net</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex"><div dir=3D"ltr">Hi,<div><br></div><div>I th=
ink I remember reading that if you have sstables that you know contain only=
 data that whose ttl has expired, it&#39;s safe to remove them manually by =
stopping c*, removing the *-Data.db files and then starting up c* again. is=
 this correct?</div>

<div><br></div><div>we have a cluster where everything is written with a tt=
l, and sometimes c* needs to compact over a 100 gb of sstables where we kno=
w ever has expired, and we&#39;d rather just manually get rid of those.</di=
v>
<span class=3D"HOEnZb"><font color=3D"#888888">
<div><br></div><div>T#</div></font></span></div>
</blockquote></div><br></div>

--047d7b15b1f57240f104e12b9bca--