You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Nikolai Kopylov <ko...@gmail.com> on 2011/07/20 17:13:00 UTC
disable compaction
Hi everyone,
finding out recently that cassandra have no upper limit for sstable files to
grow, I decided to move to deletion of CF with obsolete data.
So that I will not remove columns and there is no need in compaction at all.
How can I completely disable the compaction process?
Thanx for your attention,
Nikolai
Re: disable compaction
Posted by Nikolai Kopylov <ko...@gmail.com>.
Thanx a lot Edward, will follow your advice.
On Wed, Jul 20, 2011 at 7:28 PM, Edward Capriolo <ed...@gmail.com>wrote:
>
>
> On Wed, Jul 20, 2011 at 11:13 AM, Nikolai Kopylov <ko...@gmail.com>wrote:
>
>> Hi everyone,
>>
>> finding out recently that cassandra have no upper limit for sstable files
>> to grow, I decided to move to deletion of CF with obsolete data.
>> So that I will not remove columns and there is no need in compaction at
>> all. How can I completely disable the compaction process?
>>
>> Thanx for your attention,
>> Nikolai
>>
>>
> This can be done from the CLI.
> [default@unknown] help update column family;
> update column family Bar;
> update column family Bar with <att1>=<value1>;
> update column family Bar with <att1>=<value1> and <att2>=<value2>...;
>
> - min_compaction_threshold: Avoid minor compactions of less than this
> number of sstable files
> - max_compaction_threshold: Compact no more than this number of sstable
> files at once
>
> update column family xxx with min_compaction_threshold=0 and
> max_compaction_threshold=0;
>
> Rolling over data into new column families is one extreme way to avoid
> compaction :)
>
> Edward
>
>
--
C уважением, Николай.
Re: disable compaction
Posted by Edward Capriolo <ed...@gmail.com>.
On Wed, Jul 20, 2011 at 11:13 AM, Nikolai Kopylov <ko...@gmail.com> wrote:
> Hi everyone,
>
> finding out recently that cassandra have no upper limit for sstable files
> to grow, I decided to move to deletion of CF with obsolete data.
> So that I will not remove columns and there is no need in compaction at
> all. How can I completely disable the compaction process?
>
> Thanx for your attention,
> Nikolai
>
>
This can be done from the CLI.
[default@unknown] help update column family;
update column family Bar;
update column family Bar with <att1>=<value1>;
update column family Bar with <att1>=<value1> and <att2>=<value2>...;
- min_compaction_threshold: Avoid minor compactions of less than this
number of sstable files
- max_compaction_threshold: Compact no more than this number of sstable
files at once
update column family xxx with min_compaction_threshold=0 and
max_compaction_threshold=0;
Rolling over data into new column families is one extreme way to avoid
compaction :)
Edward