Thanks, Marcus.

Regards
Parag

From: Marcus Eriksson <[email protected]<mailto:[email protected]>>
Reply-To: "[email protected]<mailto:[email protected]>" 
<[email protected]<mailto:[email protected]>>
Date: Friday, October 10, 2014 at 10:59 AM
To: "[email protected]<mailto:[email protected]>" 
<[email protected]<mailto:[email protected]>>
Subject: Re: Disabling compaction

this is fixed in 2.0.8; 
https://issues.apache.org/jira/browse/CASSANDRA-7187<https://urldefense.proofpoint.com/v2/url?u=https-3A__issues.apache.org_jira_browse_CASSANDRA-2D7187&d=AAMFaQ&c=Vxt5e0Osvvt2gflwSlsJ5DmPGcPvTRKLJyp031rXjhg&r=Zm-paw4L-LBldtJybEWfBLLjvC5axjko2vu-eqkngMI&m=7buRq9Dt25OaWjoEDHVcOqu1FQ4kYiNX3BLqnGNXYXI&s=cGXvzXOISsNR4t-L5pm837TZYO5fk4uRra8MzdoD7Us&e=>

/Marcus

On Fri, Oct 10, 2014 at 7:11 PM, Parag Shah 
<[email protected]<mailto:[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]<mailto:[email protected]>>
Reply-To: "[email protected]<mailto:[email protected]>" 
<[email protected]<mailto:[email protected]>>
Date: Thursday, October 9, 2014 at 11:56 PM
To: "[email protected]<mailto:[email protected]>" 
<[email protected]<mailto:[email protected]>>
Subject: Re: Disabling compaction

what version are you on?

On Thu, Oct 9, 2014 at 10:33 PM, Parag Shah 
<[email protected]<mailto:[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<tel:18122816990>     35814893020     bytes    50.60%
               Compaction ids_high_awslab blob_2014_12_31     
18576750966<tel: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