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