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
>