Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
MIME-Version: 1.0
References: <CAEdf6LfyZj3g=nNVXmWARKxzonPztWfu9OG53cyNiYpa1aUSew@mail.gmail.com>
 <CAGJhWaUgWzjSUmDAMdv9okg5mEfNOh7rVxG-pWuuLFMxyhkD6g@mail.gmail.com>
 <CAEdf6LcimyiFLqvWpkiS0fkws5rGX1HsQUzTbFvWkgAU+0R5gA@mail.gmail.com> <CACACo5ShrUCr4GLHrQLVjVF_1MtnNjvgFVUX+cq6jK+XVRea+g@mail.gmail.com>
In-Reply-To: <CACACo5ShrUCr4GLHrQLVjVF_1MtnNjvgFVUX+cq6jK+XVRea+g@mail.gmail.com>
From: =?UTF-8?Q?G=C3=A1bor_Auth?= <auth.gabor@gmail.com>
Date: Thu, 05 Oct 2017 06:14:02 +0000
Message-ID: <CAEdf6Ld5j1GioRb7p4K92fYhZaqj3FqU60sCW-u393yZ9ePYsA@mail.gmail.com>
Subject: Re: Alter table gc_grace_seconds
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary="001a11492534137c12055ac6a2a2"
archived-at: Thu, 05 Oct 2017 06:14:20 -0000

--001a11492534137c12055ac6a2a2
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

On Wed, Oct 4, 2017 at 8:39 AM Oleksandr Shulgin <
oleksandr.shulgin@zalando.de> wrote:

> If you have migrated ALL the data from the old CF, you could just use
> TRUNCATE or DROP TABLE, followed by "nodetool clearsnapshot" to reclaim t=
he
> disk space (this step has to be done per-node).
>

Unfortunately not all the data migrated, but to CFs came from one CF:
"only" the 80% for data migrated to another CF.

At the moment, the compaction works with:
compaction =3D {'class':
'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
'max_threshold': '32', 'min_threshold': '2'} AND gc_grace_seconds =3D 17280=
0

But I don't know why it did not work and why it works now... :)

Bye,
Auth G=C3=A1bor

--001a11492534137c12055ac6a2a2
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<br><br><div class=3D"gmail_quote"><div dir=3D"ltr">On =
Wed, Oct 4, 2017 at 8:39 AM Oleksandr Shulgin &lt;<a href=3D"mailto:oleksan=
dr.shulgin@zalando.de">oleksandr.shulgin@zalando.de</a>&gt; wrote:</div><bl=
ockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #=
ccc solid;padding-left:1ex"><div dir=3D"ltr"><div class=3D"gmail_extra"><di=
v class=3D"gmail_quote"><div>If you have migrated ALL the data from the old=
 CF, you could just use TRUNCATE or DROP TABLE, followed by &quot;nodetool =
clearsnapshot&quot; to reclaim the disk space (this step has to be done per=
-node).=C2=A0</div></div></div></div></blockquote><div><br></div><div>Unfor=
tunately not all the data migrated, but to CFs came from one CF: &quot;only=
&quot; the 80% for data migrated to another CF.</div><div><br></div><div>At=
 the moment, the compaction works with:</div><div><span style=3D"font-famil=
y:monospace">compaction =3D {&#39;class&#39;: &#39;org.apache.cassandra.db.=
compaction.SizeTieredCompactionStrategy&#39;, &#39;max_threshold&#39;: &#39=
;32&#39;, &#39;min_threshold&#39;: &#39;2&#39;}=C2=A0AND gc_grace_seconds =
=3D 172800<br></span></div><div><br></div><div>But I don&#39;t know why it =
did not work and why it works now... :)</div><div><br></div><div>Bye,</div>=
<div>Auth G=C3=A1bor</div><div><br></div></div></div>

--001a11492534137c12055ac6a2a2--