this is fixed in 2.0.8; https://issues.apache.org/jira/browse/CASSANDRA-7187
/Marcus On Fri, Oct 10, 2014 at 7:11 PM, Parag Shah <[email protected]> wrote: > Cassandra Version: 2.0.7 > > In my application, I am using Cassandra Java Driver 2.0.2 > > Thanks > Parag > > From: Marcus Eriksson <[email protected]> > Reply-To: "[email protected]" <[email protected]> > Date: Thursday, October 9, 2014 at 11:56 PM > To: "[email protected]" <[email protected]> > Subject: Re: Disabling compaction > > what version are you on? > > On Thu, Oct 9, 2014 at 10:33 PM, Parag Shah <[email protected]> wrote: > >> Hi all, >> >> I am trying to disable compaction for a few select tables. Here is >> a definition of one such table: >> >> CREATE TABLE blob_2014_12_31 ( >> blob_id uuid, >> blob_index int, >> blob_chunk blob, >> PRIMARY KEY (blob_id, blob_index) >> ) WITH >> bloom_filter_fp_chance=0.010000 AND >> caching='KEYS_ONLY' AND >> comment='' AND >> dclocal_read_repair_chance=0.000000 AND >> gc_grace_seconds=864000 AND >> index_interval=128 AND >> read_repair_chance=0.100000 AND >> replicate_on_write='true' AND >> populate_io_cache_on_flush='false' AND >> default_time_to_live=0 AND >> speculative_retry='99.0PERCENTILE' AND >> memtable_flush_period_in_ms=0 AND >> compaction={'enabled': 'false', 'class': >> 'SizeTieredCompactionStrategy'} AND >> compression={'sstable_compression': 'LZ4Compressor’}; >> >> I have set compaction ‘enabled’ : ‘false’ on the above table. >> >> However, I do see compactions being run for this node: >> >> -bash-3.2$ nodetool compactionstats >> pending tasks: 55 >> compaction type keyspace table completed >> total unit progress >> Compaction ids_high_awslab blob_2014_11_15 18122816990 >> 35814893020 bytes 50.60% >> Compaction ids_high_awslab blob_2014_12_31 18576750966 >> 34242866468 bytes 54.25% >> Compaction ids_high_awslab blob_2014_12_15 19213914904 >> 35956698600 bytes 53.44% >> Active compaction remaining time : 0h49m46s >> >> Can you someone tell me why this is happening? Do I need to set the >> compaction threshold to 0 0? >> >> Regards >> Parag >> > >
