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
>>
>
>

Reply via email to