Enforce best practices to save yourself and your organization from system debt brought on by bad practices compounded by bad practices because some people are beyond reproach. See bad practices as they are and correct them.
TLDR; I still stick with my initial recommendations. What you are talking about is an administrative work around. A “simple” work around is empty strings. It’s not ideal but it saves from tombstones. If developers are not using technology properly enabling them to continue with a work around on the administrative end allows them to shrug responsibility and continue. It may be a very simple fix on their end to save from potential risks, extra ongoing work, and bad practices. This kind of “system debt” catches up. Better to nip it now. -- Rahul Singh rahul.si...@anant.us Anant Corporation On Mar 14, 2018, 7:31 PM -0400, Madhu B <odba.ma...@gmail.com>, wrote: > Thank you Kurt > > > On Mar 14, 2018, at 5:57 PM, kurt greaves <k...@instaclustr.com> wrote: > > > At least set GCGS == max_hint_window_in_ms that way you don't effectively > > disable hints for the table while your compaction is running. Might be > > preferable to use nodetool garbagecollect if you don't have enough disk > > space for a major compaction. Also worth noting you should do a splitting > > major compaction so you don't end up with one big SSTable when using STCS > > (also applicable for LCS) > > > > > On 14 March 2018 at 18:53, Jeff Jirsa <jji...@gmail.com> wrote: > > > > Can’t advise that without knowing the risk to your app if there’s data > > > > resurrected > > > > > > > > > > > > If there’s no risk, then sure - set gcgs to 0 and force / major compact > > > > if you have the room > > > > > > > > > > > > > > > > -- > > > > Jeff Jirsa > > > > > > > > > > > > On Mar 14, 2018, at 11:47 AM, Madhu-Nosql <odba.ma...@gmail.com> wrote: > > > > > > > > > Jeff, > > > > > > > > > > Thank you i got this- how about Dropping the existing Tombstones > > > > > right now can setting gc_grace time to zero per Table level would be > > > > > good or what would you suggest? > > > > > > > > > > > On Wed, Mar 14, 2018 at 1:41 PM, Jeff Jirsa <jji...@gmail.com> > > > > > > wrote: > > > > > > > What version of Cassandra? > > > > > > > > > > > > > > https://issues.apache.org/jira/browse/CASSANDRA-7304 sort of > > > > > > > addresses this in 2.2+ > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Wed, Mar 14, 2018 at 11:32 AM, Madhu-Nosql > > > > > > > > <odba.ma...@gmail.com> wrote: > > > > > > > > > Rahul, > > > > > > > > > > > > > > > > > > Tomstone caused is on the Application driver side so even > > > > > > > > > though they are not using some of the Columns in their logic > > > > > > > > > waht they did is that they mentioned in driver logic that > > > > > > > > > means if you are updateting one Column so the rest of the > > > > > > > > > Columns so the driver automatically > > > > > > > > > pick some nulls, internally behind the schnes cassandra > > > > > > > > > threat them as a Tombstones > > > > > > > > > > > > > > > > > > > On Wed, Mar 14, 2018 at 12:58 PM, Rahul Singh > > > > > > > > > > <rahul.xavier.si...@gmail.com> wrote: > > > > > > > > > > > Then don’t write nulls. That’s the root of the issue. > > > > > > > > > > > Sometimes they surface from prepared statements. > > > > > > > > > > > Othertimes they come because of default null values in > > > > > > > > > > > objects. > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > > Rahul Singh > > > > > > > > > > > rahul.si...@anant.us > > > > > > > > > > > > > > > > > > > > > > Anant Corporation > > > > > > > > > > > > > > > > > > > > > > On Mar 13, 2018, 2:18 PM -0400, Madhu-Nosql > > > > > > > > > > > <odba.ma...@gmail.com>, wrote: > > > > > > > > > > > > We assume that's becoz of nulls > > > > > > > > > > > > > > > > > > > > > > > > > On Tue, Mar 13, 2018 at 12:58 PM, Rahul Singh > > > > > > > > > > > > > <rahul.xavier.si...@gmail.com> wrote: > > > > > > > > > > > > > > Are you writing nulls or does the data cycle that > > > > > > > > > > > > > > way? > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > > > > > Rahul Singh > > > > > > > > > > > > > > rahul.si...@anant.us > > > > > > > > > > > > > > > > > > > > > > > > > > > > Anant Corporation > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Mar 13, 2018, 11:48 AM -0400, Madhu-Nosql > > > > > > > > > > > > > > <odba.ma...@gmail.com>, wrote: > > > > > > > > > > > > > > > Rahul, > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Nodetool scrub is good for rescue, what if its > > > > > > > > > > > > > > > happening all the time? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Tue, Mar 13, 2018 at 10:37 AM, Rahul Singh > > > > > > > > > > > > > > > > <rahul.xavier.si...@gmail.com> wrote: > > > > > > > > > > > > > > > > > Do you anticipate this happening all the time > > > > > > > > > > > > > > > > > or are you just trying to rescue? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Nodetool scrub can be useful too. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > > > > > > > > Rahul Singh > > > > > > > > > > > > > > > > > rahul.si...@anant.us > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Anant Corporation > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Mar 13, 2018, 11:29 AM -0400, Madhu-Nosql > > > > > > > > > > > > > > > > > <odba.ma...@gmail.com>, wrote: > > > > > > > > > > > > > > > > > > I got few ways to Drop Tombstones- Chos > > > > > > > > > > > > > > > > > > Monkey/Zombie Data mainly to avoid Data > > > > > > > > > > > > > > > > > > Resurrection (you deleted data it will > > > > > > > > > > > > > > > > > > comes back in future) > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > I am thinking of below options, let me know > > > > > > > > > > > > > > > > > > if you have any best practice for this > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 1.using nodetool garbagecollect > > > > > > > > > > > > > > > > > > 2.only_purge_repaired_tombstones > > > > > > > > > > > > > > > > > > 3.At Table level making GC_Grace_period to > > > > > > > > > > > > > > > > > > zero and compact > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Thanks, > > > > > > > > > > > > > > > > > > Madhu > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
