Re: disable compaction in bootstrap process

2018-03-23 Thread Alain RODRIGUEZ
n bootstrap process > > Thanks Alain.We are using C* 2.1.18,7core/30G/1.5T ssd,as the cluster is > growing too fast,we are painful in bootstrap/rebuild/remove node. > > Thanks, > Peng Xiao > > -- 原始邮件 -- > *发件人:* "Alain RODRIGUEZ"; >

Re: disable compaction in bootstrap process

2018-03-22 Thread Alain RODRIGUEZ
Hello, > Is it reasonable to disable compaction on all the source node? I would say no, as a short answer. You can, I did it for some operations in the past. Technically no problem you can do that. It will most likely improve the response time of the queries immediately as it seems that in you

Re: disable compaction if all data are read-only?

2016-04-09 Thread Yatong Zhang
Thanks for all replies and Date Tiered strategy sounds good to me. I am still using 2.0x version and will consider updating to latest version. On Fri, Apr 8, 2016 at 11:20 PM, Eric Stevens wrote: > Append-only workloads are a good candidate for Date Tiered or better Time > Windowed compaction.

Re: disable compaction if all data are read-only?

2016-04-08 Thread Eric Stevens
Append-only workloads are a good candidate for Date Tiered or better Time Windowed compaction. Effectively depending on how you set it up, data in older SStables will eventually come to rest and never be compacted again. On Fri, Apr 8, 2016 at 7:42 AM Robert Wille wrote: > You still need compac

Re: disable compaction if all data are read-only?

2016-04-08 Thread Robert Wille
You still need compaction. Compaction is what organizes your data into levels. Without compaction, every query would have to look at every SSTable. Also, due to commit log rotation, your memtable may get flushed from time to time before it is full, resulting in small SSTables that would benefit

Re: disable compaction if all data are read-only?

2016-04-08 Thread Yatong Zhang
I am using leveled strategy. What if my data are 'append-only'? I mean there are always new data but will be never changed once written to cassandra? On Fri, Apr 8, 2016 at 6:33 PM, Pedro Gordo wrote: > Hi Yatong > > My understanding is that if you have a table whichi read-only and hence > doesn

Re: disable compaction if all data are read-only?

2016-04-08 Thread Pedro Gordo
Hi Yatong My understanding is that if you have a table whichi read-only and hence doesn't receive any writes, then no SSTables will be created, and hence, no compaction will happen. What compaction strategy do you have on your table? Best regards Pedro Gordo On 8 April 2016 at 10:42, Yatong Zha

Re: disable compaction node-wide

2012-10-27 Thread Edward Capriolo
If you are using sized teired set minCompactionThreshold to 0 and maxCompactionThreshold to 0. You can probably also use this https://issues.apache.org/jira/browse/CASSANDRA-2130 But if you do not compact the number of sstables gets high and then read performance can suffer. On Sat, Oct 27, 2012

Re: disable compaction

2011-07-20 Thread Nikolai Kopylov
Thanx a lot Edward, will follow your advice. On Wed, Jul 20, 2011 at 7:28 PM, Edward Capriolo wrote: > > > On Wed, Jul 20, 2011 at 11:13 AM, Nikolai Kopylov wrote: > >> Hi everyone, >> >> finding out recently that cassandra have no upper limit for sstable files >> to grow, I decided to move to de

Re: disable compaction

2011-07-20 Thread Edward Capriolo
On Wed, Jul 20, 2011 at 11:13 AM, Nikolai Kopylov wrote: > Hi everyone, > > finding out recently that cassandra have no upper limit for sstable files > to grow, I decided to move to deletion of CF with obsolete data. > So that I will not remove columns and there is no need in compaction at > all.