Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-14622

Run compaction on cluster

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Normal
    • Resolution: Invalid
    • None
    • Legacy/CQL
    • CentOS Linux release 7.1.1503 (Core)

    • Normal

    Description

      Dear Team,

      I have setup a cassandra cluster for 3 m/c.

      [root@ip-172-31-21-222 ~]# nodetool status
      Datacenter: datacenter1
      =======================
      Status=Up/Down

      / State=Normal/Leaving/Joining/Moving
      – Address Load Tokens Owns Host ID Rack
      UN 172.31.21.223 4.01 TB 256 ? 9d2a408a-264f-423f-8af2-e1d4cb608998 rack1
      UN 172.31.21.222 4.5 TB 256 ? c3d24437-3e03-41d7-a2af-2ed53bcf2dfc rack1
      UN 172.31.21.221 4.26 TB 256 ? aaf4fbaf-837b-44e2-98ba-5eb2b3e6b62b rack1

      Note: Non-system keyspaces don't have the same replication settings, effective ownership information is meaningless
      [root@ip-172-31-21-222 ~]#

       

      Now i have deleted around 40-45 GB data but space seems is not vacant.

      I'm using SizeTieredCompactionStrategy and below is my table defination.

       

      CREATE TABLE test.att_103 (
      md5 text PRIMARY KEY,
      arcsize int,
      att_str blob,
      attsize int,
      udate timestamp
      ) WITH bloom_filter_fp_chance = 0.01
      AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}'
      AND comment = ''
      AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'}
      AND compression = {'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}
      AND dclocal_read_repair_chance = 0.1
      AND default_time_to_live = 0
      AND gc_grace_seconds = 864000
      AND max_index_interval = 2048
      AND memtable_flush_period_in_ms = 0
      AND min_index_interval = 128
      AND read_repair_chance = 0.0
      AND speculative_retry = '99.0PERCENTILE';

      I have dumped data using sstable2json command to verify whether my column data is deleted or not.

      e.g

      {"key": "9b7937de43aa22fc3bf18ec72d86140b",  "cells": [["att_str",1533305633,1533305633552000,"d"],            ["udate","2018-08-03 14:13Z",1533305633552000]]}

       

      Now can you help me here regarding how to run compaction manually instead of waiting for 10 days of grace period.

       

      Thanks

      Wasil.

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            Wasil307 Wasil Shaikh
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: