From user-return-63045-archive-asf-public=cust-asf.ponee.io@cassandra.apache.org Tue Jan 22 17:21:24 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 44E7F180634 for ; Tue, 22 Jan 2019 17:21:24 +0100 (CET) Received: (qmail 79568 invoked by uid 500); 22 Jan 2019 16:21:22 -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 79558 invoked by uid 99); 22 Jan 2019 16:21:22 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Jan 2019 16:21:22 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 26062C88B9 for ; Tue, 22 Jan 2019 16:21:22 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.798 X-Spam-Level: * X-Spam-Status: No, score=1.798 tagged_above=-999 required=6.31 tests=[DKIMWL_WL_MED=-0.001, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id uuymXrhoq-BZ for ; Tue, 22 Jan 2019 16:21:20 +0000 (UTC) Received: from mail-lj1-f179.google.com (mail-lj1-f179.google.com [209.85.208.179]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 0A8265F6BF for ; Tue, 22 Jan 2019 16:21:19 +0000 (UTC) Received: by mail-lj1-f179.google.com with SMTP id g11-v6so21161635ljk.3 for ; Tue, 22 Jan 2019 08:21:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=K/MVKZTamoiOVlwgnmXwSmgA5Jn9dVnl323dxFTCGmg=; b=LAC2SCxFI2qFkqa/GygUzhYpdaIW0iNFYLLhZlmXm8CPaacGOYSZyW0sjncpGwfAo2 h9hW0XcUPP7lQOgZ3AVZ93yQNkueXbATnpaKBXgaNa+T2Z/k/QYvUDnrmDe2vNiMgO3s EtDxugK9We8O4lV51PVPeTp0XnMpGaCuc2kHpsJx4tdlZ4vnP5ae+Xs6R0ab5JG/p8yR L/QUjUuJxBno5Ia8dzQAKb3NwPmO7pA7DYMeNk1gF+Ck8X18VkkD/EdgcWpw93R6oOrj FtDzRyOLd//K90Pu90B3IpC8CoKaa6jpZtoChNZKYkI8elkSTz8Gm3aUYgJZL9bHjJFL AUEA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=K/MVKZTamoiOVlwgnmXwSmgA5Jn9dVnl323dxFTCGmg=; b=fE4z9umfiPOhKNQlbvGn0V6fbgdUsaTuJoLptilxMxfSAZv21CVBy6iL8LB6O+bHak t0XUwqbE/TDbAeFAXf1T8kdMUHDKNZ+G5/oH0WBYw78Isk0f7ukoM87X5Oywpb2aBvci 1Pq+IftX2NzOSAYMoyNetyBkm5VTXAvNu7kKWpwmyheAcnT2LMnoy/8y1TIoWzqp9NAb +Kcg4ydMRbdzkxjGicV7BVO5gP6LrZdjnqzW0FUJHE9okKQdE0fZUcCvakL+bmhsVvtx pDr8p1FuYZYpo0xNgqR4ez6gKO7qggoPe38mXA1DMJjI3tHSa41AG8UPGPbzfC8Nzaub XjMw== X-Gm-Message-State: AJcUukeOmyeVu3l9NCVpzPM3mbqJDnOj9vFOA6YL6ZTSAFNZPOvYIcsE hhLC3tVDFxa6lJotpt1LPu9bATpGCa48C/w/0CBWIP9c X-Google-Smtp-Source: ALg8bN58f2O9Tm8Gf/SLr4wCJ3ly0KJWDeqRyAtAtB8MtX2rZHyocw6AtiERFeEsqWNtgFAgGYJXNtOZXxPhbyvMneM= X-Received: by 2002:a2e:4a19:: with SMTP id x25-v6mr20501835lja.19.1548174072853; Tue, 22 Jan 2019 08:21:12 -0800 (PST) MIME-Version: 1.0 References: <60A2E896-40E9-4793-ACB4-8735F888249C@apple.com> In-Reply-To: <60A2E896-40E9-4793-ACB4-8735F888249C@apple.com> From: Nitan Kainth Date: Tue, 22 Jan 2019 10:21:01 -0600 Message-ID: Subject: Re: Compact storage removal effect To: user Content-Type: multipart/alternative; boundary="000000000000a9baee05800e5d94" --000000000000a9baee05800e5d94 Content-Type: text/plain; charset="UTF-8" hey Chris, We upgraded form 3.0.4 to 3.11. yes, I did run upgradesstables -a to migrate sstables. Here is the table structure: CREATE TABLE ks.cf1 ( key text, column1 timestamp, value blob, PRIMARY KEY (key, column1) ) WITH COMPACT STORAGE CREATE TABLE ks.cf2 ( key bigint, column1 text, value blob, PRIMARY KEY (key, column1) ) WITH COMPACT STORAGE CREATE TABLE ks.cf3 ( key text, column1 timestamp, value int, PRIMARY KEY (key, column1) ) WITH COMPACT STORAGE On Tue, Jan 22, 2019 at 10:07 AM Chris Lohfink wrote: > What version are you running? Did you include an upgradesstables -a or > something to rebuild without the compact storage in your migration? > > After 3.0 the new format can be more or less the same size as the 2.x > compact storage tables depending on schema (which can impact things a lot). > > Chris > > > On Jan 22, 2019, at 9:58 AM, Nitan Kainth wrote: > > > > Hi, > > > > We are testing to migrate off from compact storage. After removing > compact storage, we were hoping to see an increase in disk usage but > nothing changed. > > any feedback, why didn't we see an increase in storage? > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org > For additional commands, e-mail: user-help@cassandra.apache.org > > --000000000000a9baee05800e5d94 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
hey Chris,

We upgraded form 3.0.4 to 3.= 11. yes, I did run upgradesstables -a to migrate sstables.=C2=A0
= Here is the table structure:

CREATE TABLE ks.cf1 = ( key text, column1 timestamp, value blob, PRIMARY KEY (key, column1) ) WITH COMPACT STORAGE CREATE TABLE ks.cf2 ( key bigint, column1 text, value blob, PRIMARY KEY (key, column1) ) WITH COMPACT STORAGE CREATE TABLE ks.cf3 ( key text, column1 timestamp, value int, PRIMARY KEY (key, column1) ) WITH COMPACT STORAGE=C2=A0=C2=A0

On Tue, Jan 22, 2019 at 10:07 AM Chris Lohfin= k <clohfink@apple.com.invalid> wrote:
What version are you running? Did you include a= n upgradesstables -a or something to rebuild without the compact storage in= your migration?

After 3.0 the new format can be more or less the same size as the 2.x compa= ct storage tables depending on schema (which can impact things a lot).

Chris

> On Jan 22, 2019, at 9:58 AM, Nitan Kainth <nitankainth@gmail.com> wrote:
>
> Hi,
>
> We are testing to migrate off from compact storage. After removing com= pact storage, we were hoping to see an increase in disk usage but nothing c= hanged.
> any feedback, why didn't we see an increase in storage?


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
For additional commands, e-mail: user-help@cassandra.apache.org

--000000000000a9baee05800e5d94--