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 <migh...@gmail.com> wrote: > 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 <rwi...@fold3.com> wrote: > >> 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 >> from compaction. >> >> On Apr 8, 2016, at 5:49 AM, Yatong Zhang <bluefl...@gmail.com> wrote: >> >> 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 <pedro.gordo1...@gmail.com> >> wrote: >> >>> 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 Zhang <bluefl...@gmail.com> wrote: >>> >>>> Hi there, >>>> I am wondering if it is possible to disable compaction when all my data >>>> are read-only? >>>> >>> >>> >> >>
