Thank, I appreciate the correction to my understanding.
Sean Durity
From: Jeff Jirsa [mailto:jeff.ji...@crowdstrike.com]
Sent: Friday, January 22, 2016 1:04 PM
To: user@cassandra.apache.org
Subject: Re: Using TTL for data purge
"As I understand TTL, if there is a compaction of a cell (o
On second thought, If you are anyways reading the user table on each website
access and can afford extra IO, first option looks more appropriate as it will
ease out the pain of manual purging maintenance and wont need full table scans.
ThanksAnuj
Sent from Yahoo Mail on Android
On Sat, 23
Give a deep thought on your use case. Different user tables/types may have
different purge strategy based on how frequently a user account type is usually
accessed, whats the user count for each user type and so on.
ThanksAnuj
Sent from Yahoo Mail on Android
On Fri, 22 Jan, 2016 at 11:37 p
Hi Joseph,
I am personally in favour of Second approach because I dont want to do lot of
IO just because a user is accessing a site several times a day.
Options I see:
1.If you are on SSDs, Test LCS and update TTL of all columns at each access.
This will make sure that the system can tolerate
sean_r_dur...@homedepot.com"
Reply-To: "user@cassandra.apache.org"
Date: Friday, January 22, 2016 at 7:27 AM
To: "user@cassandra.apache.org"
Subject: RE: Using TTL for data purge
An upsert is a second insert. Cassandra’s sstables are immutable. There are no
real “overwrites” (of the
pdf>
From: Joseph TechMails [mailto:jaalex.t...@gmail.com]
Sent: Wednesday, December 30, 2015 3:59 AM
To: user@cassandra.apache.org
Subject: Re: Using TTL for data purge
Thanks, Sean. Our usecase is to delete records after few months of inactivity,
and that period is fixed, but the TTL cou
Thanks, Sean. Our usecase is to delete records after few months of
inactivity, and that period is fixed, but the TTL could get reset if the
record is accessed within that timeframe - similar to extending a session.
All reads are done based on the key, and there would be multiple upserts
(all column
If you know how long the records should last, TTL is a good way to go. Remember
that neither TTL or deletes are right-away purge strategies. Each inserts a
special record called a tombstone to indicate a deleted record. After
compaction (that is after gc_grace_seconds for the table, default 10 d
