From user-return-30121-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Wed Nov 14 10:40:02 2012 Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A84A3D88B for ; Wed, 14 Nov 2012 10:40:02 +0000 (UTC) Received: (qmail 44650 invoked by uid 500); 14 Nov 2012 10:40:00 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 44408 invoked by uid 500); 14 Nov 2012 10:40:00 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 44384 invoked by uid 99); 14 Nov 2012 10:39:59 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 Nov 2012 10:39:59 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of arodrime@gmail.com designates 209.85.220.172 as permitted sender) Received: from [209.85.220.172] (HELO mail-vc0-f172.google.com) (209.85.220.172) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 Nov 2012 10:39:51 +0000 Received: by mail-vc0-f172.google.com with SMTP id fl11so306541vcb.31 for ; Wed, 14 Nov 2012 02:39:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to:content-type; bh=Tjo4Dq+R+zwY4eCYIXfC9eJ4fIp1/0aDT4hDAxBGros=; b=maEuU+WlKVAtP5/3t7wy2FKSrofRFn92AmpTeY7LxNTK35k019W0cLevCulq16zC+L +1pxnCq+K/uAYbrw+XvZ96e/kLo7xyOdf+6hGv7hcJnUdRuRTo2SvCyW3F5x9s95nPvC FNrKbEI0RPniBCOLxc6VaGgHaHIdsfFbjVoq35texpHZcU15CYJtz4x3JjhT8FvIJ7ce dfbmKBg/RDaV1gOZN4JYT5xkaSxs/eYL3GdZijBA712pBGQGhJhe0brPUfLslYuVTXu6 tZo5QWH2eLx9iprYPZpTaAPFchwu4KLQMzaEF5WR7mkFaaWnDEDZ3fau3oPeSXA4iXfK QWUA== Received: by 10.220.153.78 with SMTP id j14mr10370096vcw.33.1352889570135; Wed, 14 Nov 2012 02:39:30 -0800 (PST) MIME-Version: 1.0 Received: by 10.220.249.3 with HTTP; Wed, 14 Nov 2012 02:39:09 -0800 (PST) From: Alain RODRIGUEZ Date: Wed, 14 Nov 2012 11:39:09 +0100 Message-ID: Subject: Enable compression Cassandra 1.1.2 To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=f46d0438eedd3f900904ce722697 X-Virus-Checked: Checked by ClamAV on apache.org --f46d0438eedd3f900904ce722697 Content-Type: text/plain; charset=ISO-8859-1 Hi, I am running C* 1.1.2 and there is no way to turn the compression on for a CF. Here is the command I ran in the CLI: UPDATE COLUMN FAMILY data_action WITH compression_options={sstable_compression:SnappyCompressor, chunk_length_kb : 64}; Show schema : create column family data_action with column_type = 'Standard' and comparator = 'UTF8Type' and default_validation_class = 'UTF8Type' and key_validation_class = 'UTF8Type' and read_repair_chance = 1.0 and dclocal_read_repair_chance = 0.0 and gc_grace = 864000 and min_compaction_threshold = 4 and max_compaction_threshold = 32 and replicate_on_write = true and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy' and caching = 'KEYS_ONLY'; I tried also through cqlsh without success ("ALTER TABLE data_action WITH compression_parameters:sstable_compression = 'SnappyCompressor' AND compression_parameters:chunk_length_kb = 64;") I have no error message just these few lines on system.log: INFO 10:17:12,051 Completed flushing /raid0/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-20-Data.db (1367 bytes) for commitlog position ReplayPosition(segmentId=721932060965088, position=116556860) INFO 10:17:12,052 Compacting [SSTableReader(path='/raid0/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-20-Data.db'), SSTableReader(path='/raid0/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-19-Data.db'), SSTableReader(path='/raid0/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-17-Data.db'), SSTableReader(path='/raid0/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-18-Data.db')] INFO 10:17:12,134 Compacted to [/raid0/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-21-Data.db,]. 50,928 to 46,827 (~91% of original) bytes for 3 keys at 0.544606MB/s. Time: 82ms. I also tried upgrading sstables but compression is definitely not enabled (same size of data + JMX show a CompressionRatio of 0.0). Does anyone already saw something similar ? Alain --f46d0438eedd3f900904ce722697 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi, I am running C* 1.1.2 and there is no way to turn the compression on fo= r a CF.

Here is the command I ran in the CLI:
=

UPDATE COLUMN FAMILY data_action WITH compression_optio= ns=3D{sstable_compression:SnappyCompressor, chunk_length_kb : 64};

Show schema :

creat= e column family data_action
=A0 with column_type =3D 'Standar= d'
=A0 and comparator =3D 'UTF8Type'
=A0 an= d default_validation_class =3D 'UTF8Type'
=A0 and key_validation_class =3D 'UTF8Type'
=A0 and = read_repair_chance =3D 1.0
=A0 and dclocal_read_repair_chance =3D= 0.0
=A0 and gc_grace =3D 864000
=A0 and min_compaction= _threshold =3D 4
=A0 and max_compaction_threshold =3D 32
=A0 and replicate_on= _write =3D true
=A0 and compaction_strategy =3D 'org.apache.c= assandra.db.compaction.SizeTieredCompactionStrategy'
=A0 and = caching =3D 'KEYS_ONLY';

I tried also through cqlsh without success ("= ;ALTER TABLE data_action WITH compression_parameters:sstable_compression = =3D 'SnappyCompressor' AND compression_parameters:chunk_length_kb = =3D 64;")

I have no error message just these few lines on system.= log:

INFO 10:17:12,051 Completed flushing /ra= id0/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilie= s-hd-20-Data.db (1367 bytes) for commitlog position ReplayPosition(segmentI= d=3D721932060965088, position=3D116556860)
=A0INFO 10:17:12,052 Compacting [SSTableReader(path=3D'/raid0/cass= andra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-20-= Data.db'), SSTableReader(path=3D'/raid0/cassandra/data/system/schem= a_columnfamilies/system-schema_columnfamilies-hd-19-Data.db'), SSTableR= eader(path=3D'/raid0/cassandra/data/system/schema_columnfamilies/system= -schema_columnfamilies-hd-17-Data.db'), SSTableReader(path=3D'/raid= 0/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-= hd-18-Data.db')]
=A0INFO 10:17:12,134 Compacted to [/raid0/cassandra/data/system/schema= _columnfamilies/system-schema_columnfamilies-hd-21-Data.db,]. =A050,928 to = 46,827 (~91% of original) bytes for 3 keys at 0.544606MB/s. =A0Time: 82ms.<= /div>

I also tried upgrading sstables but compression i= s definitely not enabled (same size of data + JMX show a CompressionRatio o= f 0.0).

Does anyone already saw something similar = ?

Alain
--f46d0438eedd3f900904ce722697--