Deleting the entire row at once only creates a row-level tombstone.
This is almost free. "Tombstone buildup" happens when performing
column-level deletes, then inserting more (different) columns. The
classic example is modeling a queue in a row.
On Tue, Feb 14, 2012 at 1:54 PM, Todd Burruss wro
e.org<mailto:user@cassandra.apache.org>"
mailto:user@cassandra.apache.org>>
Subject: Re: deleting rows and tombstones
Hi that's a good question. Maybe we are hanging on to lessons we shouldn't need
but...
Currently even on 1.07 we still get significant deleted data
find that repair is still as necessary now since hinted handoffs
> are stored anytime a node does not ACK successfully?
>
> From: Dominic Williams
> Reply-To: "user@cassandra.apache.org"
> Date: Tue, 14 Feb 2012 12:31:45 -0800
>
> To: "user@cassandra.apac
r@cassandra.apache.org>>
Date: Tue, 14 Feb 2012 12:31:45 -0800
To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>"
mailto:user@cassandra.apache.org>>
Subject: Re: deleting rows and tombstones
Hi Todd,
Our systems do a lot of deletions and it does cause prob
cassandra.apache.org<mailto:user@cassandra.apache.org>"
mailto:user@cassandra.apache.org>>
Subject: Re: deleting rows and tombstones
Are you planning to insert rows with keys that existed before?
If that's true, there will be no tombstones (as far as I understand Cassandra).
Hi Todd,
Our systems do a lot of deletions and it does cause problems.
Your best bet is to bring GCSeconds low and run repair religiously. The
issue you can run into though is repair overloading your servers when your
data load gets high, repair falling over and related problems.
IMHO the need t
Are you planning to insert rows with keys that existed before?
If that's true, there will be no tombstones (as far as I understand
Cassandra).
It that's not, then you will get tombstones that might slow down the reads
because they have to be skipped until the next compaction.
2012/2/14 Todd Burr
my design calls for deleting a row (by key, not individual columns) and
re-inserting it a lot and I'm concerned about tombstone build up slowing down
reads. I know if I delete a lot of individual columns the tombstones will
build up and slow down reads until they are cleaned up, but not sure if