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.zh...@gmail.com <mailto:caozf.zh...@gmail.com>
微博:http://weibo.com/boliza/

2015-01-26 16:49 GMT+08:00 Jason Wee <peich...@gmail.com <mailto:peich...@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.zh...@gmail.com
    <mailto:cao.zh...@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.zh...@gmail.com <mailto:caozf.zh...@gmail.com>
        微博:http://weibo.com/boliza/




Reply via email to