cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 曹志富 <cao.zh...@gmail.com>
Subject Re: SStables can't compat automaticly
Date Mon, 26 Jan 2015 10:20:48 GMT
I read the CQL table properties again.This property could contorl the
compaction . Right now My C* cluster only write without any read.

--------------------------------------
曹志富
手机:18611121927
邮箱:caozf.zhifu@gmail.com
微博:http://weibo.com/boliza/

2015-01-26 17:41 GMT+08:00 Roland Etzenhammer <r.etzenhammer@t-online.de>:

>  Hi,
>
> are you running 2.1.2 evenutally? I had this problem recently and there
> were two topics here about this. Problem was, that my test cluster had
> almost no reads and did not compact sstables.
>
> Reason for me was that those minor compactions did not get triggered since
> there were almost no reads on that tables. Setting 'cold_reads_to_omit' to
> 0 did the job for me:
>
> ALTER TABLE <tablename> WITH compaction = {'class':
> 'SizeTieredCompactionStrategy', 'min_threshold': '4', 'max_threshold':
> '32', 'cold_reads_to_omit': 0.0};
>
> Credits to Tyler and Eric for the pointers.
>
>
> Maybe that could help.
>
> Cheers,
> Roland
>
> Am 26.01.2015 um 09:56 schrieb 曹志富:
>
> No,to confirm this I have run the command all my nodes:bin/nodetool
> enableautocompaction
>
>  --------------------------------------
> 曹志富
>  手机:18611121927
> 邮箱:caozf.zhifu@gmail.com
> 微博:http://weibo.com/boliza/
>
> 2015-01-26 16:49 GMT+08:00 Jason Wee <peichieh@gmail.com>:
>
>> Did you disable auto compaction through nodetool?
>>
>> disableautocompaction        Disable autocompaction for the given
>> keyspace and column family
>>
>>  Jason
>>
>> On Mon, Jan 26, 2015 at 11:34 AM, 曹志富 <cao.zhifu@gmail.com> wrote:
>>
>>>  Hi everybody:
>>>
>>>  I have 18 nodes using cassandra2.1.2.Every node has 4 core, 32 GB RAM,
>>> 2T hard disk,OS is CentOS release 6.2 (Final).
>>>
>>>  I have follow the <Recommended production settings> to config my
>>> system.such as disable SWAP,unlimited mem lock...
>>>
>>>  My heap size is:
>>>
>>>  MAX_HEAP_SIZE="8G"
>>> MIN_HEAP_SIZE="8G"
>>> HEAP_NEWSIZE="2G"
>>>
>>>   I use STCS,other config using default,using Datastax Java Driver
>>> 2.1.2. BatchStatment 100key commit per time.
>>>
>>>  When I run my cluster and insert data from kafka (10000 keys/s) after
>>> 2 days,every node can't compact  some there too many sstables.
>>>
>>>  I try to use major compact to compact the sstables , it cost a long
>>> long time .Also the new sstables can't compat automatic.
>>>
>>>
>>>  I trace the log , the CMS GC too often,almost 30 minute onetime.
>>>
>>>  Could someone help me to solve this problem.
>>>
>>>
>>>  --------------------------------------
>>>  曹志富
>>>  手 机:18611121927
>>> 邮箱:caozf.zhifu@gmail.com
>>> 微博:http://weibo.com/boliza/
>>>
>>
>>
>
>

Mime
View raw message