Re: Purge data from repair_history table?

2017-03-20 Thread Jonathan Haddad
default_time_to_live is a convenience parameter that automatically applies a TTL to incoming data. Every field that's inserted can have a separate TTL. The TL;DR of all this is that changing default_time_to_live doesn't change any existing data retroactively. You'd have to truncate the table if

Re: Purge data from repair_history table?

2017-03-20 Thread Gábor Auth
Hi, On Fri, Mar 17, 2017 at 2:22 PM Paulo Motta wrote: > It's safe to truncate this table since it's just used to inspect repairs > for troubleshooting. You may also set a default TTL to avoid it from > growing unbounded (this is going to be done by default on CASSANDRA-12701). > I've made an a

Re: Purge data from repair_history table?

2017-03-17 Thread Gábor Auth
Oh, thanks! :) On Fri, 17 Mar 2017, 14:22 Paulo Motta, wrote: > It's safe to truncate this table since it's just used to inspect repairs > for troubleshooting. You may also set a default TTL to avoid it from > growing unbounded (this is going to be done by default on CASSANDRA-12701). > > 2017-0

Re: Purge data from repair_history table?

2017-03-17 Thread Paulo Motta
It's safe to truncate this table since it's just used to inspect repairs for troubleshooting. You may also set a default TTL to avoid it from growing unbounded (this is going to be done by default on CASSANDRA-12701). 2017-03-17 8:36 GMT-03:00 Gábor Auth : > Hi, > > I've discovered a relative hug

Purge data from repair_history table?

2017-03-17 Thread Gábor Auth
Hi, I've discovered a relative huge size of data in the system_distributed keyspace's repair_history table: Table: repair_history Space used (live): 389409804 Space used (total): 389409804 What is the purpose of this data? There is any safe method to p

Re: Purge Data

2011-06-09 Thread Jonathan Ellis
Remember that you should have many more rows of size X than you have cluster nodes for any value of X. So if you have a data model where a handful of rows may have > 2B columns but the rest will be much smaller, you should probably rethink that. On Thu, Jun 9, 2011 at 10:51 AM, Bahadur, Kamal wr

Re: Purge Data

2011-06-09 Thread Jeremy Hanna
Have you looked at the TTL column feature in 0.7? http://www.datastax.com/dev/blog/whats-new-cassandra-07-expiring-columns Those will automatically expire columns after a certain time period - not when you near the column limit, but might be helpful for you. On Jun 9, 2011, at 10:51 AM, Bahadur

Purge Data

2011-06-09 Thread Bahadur, Kamal
>From the documentation, I came to know that there is a limitation of maximum number (2 billion) of columns that a column family can have. My questions is, is there a way to purge the old columns when the number of columns is nearing the 2 billion mark? Thanks, Kamal