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: domain of burtonator2011@gmail.com
 designates 209.85.215.51 as permitted sender)
MIME-Version: 1.0
Sender: burtonator2011@gmail.com
In-Reply-To: <C65D0834-8665-4A38-990F-A4586BF4459B@blackbirdit.com>
References: 
 <CAAZU44mjUSce_1ta0Zyvk5nyYxbo=vvOkbcaQmxV6kDZLabCFA@mail.gmail.com>
 <C65D0834-8665-4A38-990F-A4586BF4459B@blackbirdit.com>
From: Kevin Burton <burton@spinn3r.com>
Date: Fri, 16 May 2014 15:31:47 -0700
Message-ID: 
 <CAAZU44=Zh3=yhQ0bxaEVxO8N3=3bt4yq2=5DA4BpnzUFEqELfg@mail.gmail.com>
Subject: Re: Storing log structured data in Cassandra without compactions for
 performance boost.
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=047d7b5d91efd18f1c04f98bfb8c

--047d7b5d91efd18f1c04f98bfb8c
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

>
>
> If the data is read from a slice of a partition that has been added over
> time there will be a part of that row in every almost sstable. That would
> mean all of them (multiple disk seeks depending on clustering order per
> sstable) would have to be read from in order to service the query.  Data
> model can help or hurt a lot though.
>
>
Yes=E2=80=A6 totally agree, but we wouldn't do that.  The entire 'row' is i=
mmutable
and passes through the system and then expires due to TTL.

TTL is probably the way to go here, especially if Cassandra just drops the
whole SSTable on the TTL expiration which is what I think I"m hearing.


> If you set the TTL for the columns you added then C* will clean up
> sstables (if size tiered and post 1.2) once the datas been expired.  Sinc=
e
> you never delete set the gc_grace_seconds to 0 so the ttl expiration does=
nt
> result in tombstones.
>
>
Thanks!

Kevin
--=20

Founder/CEO Spinn3r.com
Location: *San Francisco, CA*
Skype: *burtonator*
blog: http://burtonator.wordpress.com
=E2=80=A6 or check out my Google+
profile<https://plus.google.com/102718274791889610666/posts>
<http://spinn3r.com>
War is peace. Freedom is slavery. Ignorance is strength. Corporations are
people.

--047d7b5d91efd18f1c04f98bfb8c
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_extra"><div class=3D"gmail_quote"><blo=
ckquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #c=
cc solid;padding-left:1ex"><div style=3D"word-wrap:break-word"><div><br></d=
iv><div>If the data is read from a slice of a partition that has been added=
 over time there will be a part of that row in every almost sstable. That w=
ould mean all of them (multiple disk seeks depending on clustering order pe=
r sstable) would have to be read from in order to service the query. =C2=A0=
Data model can help or hurt a lot though.</div>

<div><br></div></div></blockquote><div><br></div><div>Yes=E2=80=A6 totally =
agree, but we wouldn&#39;t do that. =C2=A0The entire &#39;row&#39; is immut=
able and passes through the system and then expires due to TTL. =C2=A0</div=
><div><br></div>

<div>TTL is probably the way to go here, especially if Cassandra just drops=
 the whole SSTable on the TTL expiration which is what I think I&quot;m hea=
ring.</div><div>=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"marg=
in:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

<div style=3D"word-wrap:break-word"><div></div><div>If you set the TTL for =
the columns you added then C* will clean up sstables (if size tiered and po=
st 1.2) once the datas been expired. =C2=A0Since you never delete set the g=
c_grace_seconds to 0 so the ttl expiration doesnt result in tombstones.</di=
v>

<div><br></div></div></blockquote><div><br></div><div>Thanks!</div><div><br=
></div><div>Kevin=C2=A0</div></div>-- <br><div><div><p style=3D"margin-top:=
0px;margin-right:0px;margin-bottom:12pt;margin-left:0px"></p><div>Founder/C=
EO=C2=A0<a href=3D"http://Spinn3r.com" target=3D"_blank">Spinn3r.com</a><br=
>

</div><div>Location:=C2=A0<b>San Francisco, CA</b><br>Skype:=C2=A0<b>burton=
ator</b></div><div><font color=3D"#2c2c2c" face=3D"Helvetica, Arial, sans-s=
erif"><span style=3D"line-height:19px">blog:<b>=C2=A0</b></span></font><a h=
ref=3D"http://burtonator.wordpress.com" target=3D"_blank">http://burtonator=
.wordpress.com</a></div>

<div>=E2=80=A6 or check out my <a href=3D"https://plus.google.com/102718274=
791889610666/posts" target=3D"_blank">Google+ profile</a></div><div><a href=
=3D"http://spinn3r.com" target=3D"_blank"><img src=3D"http://spinn3r.com/im=
ages/spinn3r.jpg"></a></div>

<div><span style=3D"color:rgb(0,0,0);font-family:verdana,arial,helvetica,sa=
ns-serif;font-size:small;font-style:normal;font-variant:normal;font-weight:=
normal;letter-spacing:normal;line-height:normal;text-align:start;text-inden=
t:0px;text-transform:none;white-space:normal;word-spacing:0px;background-co=
lor:rgb(255,255,255);display:inline!important;float:none">War is peace. Fre=
edom is slavery. Ignorance is strength. Corporations are people.</span></di=
v>

<p></p></div></div>
</div></div>

--047d7b5d91efd18f1c04f98bfb8c--