Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id CF2B0CD6 for ; Fri, 22 Jun 2012 03:59:27 +0000 (UTC) Received: (qmail 48900 invoked by uid 500); 22 Jun 2012 03:59:25 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 48754 invoked by uid 500); 22 Jun 2012 03:59:24 -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 48719 invoked by uid 500); 22 Jun 2012 03:59:23 -0000 Delivered-To: apmail-incubator-cassandra-user@incubator.apache.org Received: (qmail 48716 invoked by uid 99); 22 Jun 2012 03:59:23 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 22 Jun 2012 03:59:23 +0000 X-ASF-Spam-Status: No, hits=2.0 required=5.0 tests=FSL_RCVD_USER,SPF_NEUTRAL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: 216.139.236.26 is neither permitted nor denied by domain of codevally@gmail.com) Received: from [216.139.236.26] (HELO sam.nabble.com) (216.139.236.26) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 22 Jun 2012 03:59:16 +0000 Received: from jim.nabble.com ([192.168.236.80]) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1Shv1M-0000XD-0C for cassandra-user@incubator.apache.org; Thu, 21 Jun 2012 20:58:56 -0700 Date: Thu, 21 Jun 2012 20:58:55 -0700 (PDT) From: Roshan To: cassandra-user@incubator.apache.org Message-ID: <1340337535995-7580733.post@n2.nabble.com> Subject: Cassandra 1.0.6 data flush query MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi I am using Cassandra 1.0.6 version in our production system and noticed that Cassandra flushing the data to SSTable and the file size is < 10MB. With under moderate write load, the Cassandra flushing lots of memtables with small sizes. With this compaction doing lots of compactions. O/S - Centos 64bit Sun Java 1.6_31 VM size - 2.4GB Following parameters change on cassandra.yaml file. flush_largest_memtables_at: 0.45 (reduce it from .75) reduce_cache_sizes_at: 0.55 (reduce it from .85) reduce_cache_capacity_to: 0.3 (reduce it from .6) concurrent_compactors: 1 memtable_total_space_in_mb: 200 in_memory_compaction_limit_in_mb: 16 (from 64MB) Key cache = 10000 Row cache = 0 Could someone please help me on this. Thanks /Roshan -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Cassandra-1-0-6-data-flush-query-tp7580733.html Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.