cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Todd Burruss <>
Subject Re: deleting rows and tombstones
Date Tue, 14 Feb 2012 21:29:42 GMT
do you 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: "<>" <<>>
Date: Tue, 14 Feb 2012 12:31:45 -0800
To: "<>" <<>>
Subject: Re: deleting rows and tombstones

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 to run repair really needs to be addressed urgently.

I proposed an alternative approach here
so vote it up if you share problems!


On 14 February 2012 19:54, Todd Burruss <<>>
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 the same holds for deleting the whole role.


View raw message