Return-Path: Delivered-To: apmail-incubator-cassandra-commits-archive@minotaur.apache.org Received: (qmail 37768 invoked from network); 13 May 2009 21:20:16 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 13 May 2009 21:20:16 -0000 Received: (qmail 87354 invoked by uid 500); 13 May 2009 21:20:16 -0000 Delivered-To: apmail-incubator-cassandra-commits-archive@incubator.apache.org Received: (qmail 87326 invoked by uid 500); 13 May 2009 21:20:16 -0000 Mailing-List: contact cassandra-commits-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cassandra-dev@incubator.apache.org Delivered-To: mailing list cassandra-commits@incubator.apache.org Received: (qmail 87316 invoked by uid 99); 13 May 2009 21:20:16 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 13 May 2009 21:20:16 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.130] (HELO eos.apache.org) (140.211.11.130) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 13 May 2009 21:20:14 +0000 Received: from eos.apache.org (localhost [127.0.0.1]) by eos.apache.org (Postfix) with ESMTP id 50352118BC for ; Wed, 13 May 2009 21:19:54 +0000 (GMT) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: Apache Wiki To: cassandra-commits@incubator.apache.org Date: Wed, 13 May 2009 21:19:54 -0000 Message-ID: <20090513211954.22399.12753@eos.apache.org> Subject: [Cassandra Wiki] Update of "MemtableThresholds" by EricEvans X-Virus-Checked: Checked by ClamAV on apache.org Dear Wiki user, You have subscribed to a wiki page or wiki category on "Cassandra Wiki" for change notification. The following page has been changed by EricEvans: http://wiki.apache.org/cassandra/MemtableThresholds The comment on the change is: saving work in progress ------------------------------------------------------------------------------ in check, and memory usage in general with limits. == MemtableSizeInMB == + FIXME: finish this section! == MemtableObjectCountInMillions == + FIXME: finish this section! == Using Jconsole To Optimize Thresholds == Cassandra's column-family mbeans have a number of attributes that can @@ -24, +26 @@ you will need to connect remotely (the default startup scripts for Cassandra cause the VM to listen on port 8080). - [connect.png] + attachment:jconsole_connect.png - Once connected, select the ''MBeans'' tab, expand the ''org.apache.cassandra.db'' + Once connected, select the ''MBeans'' tab, expand the - section, and finally one of your column families. + ''org.apache.cassandra.db'' section, and finally one of your column families. - The interesting attributes here are: + There are three interesting attributes here. - * ''!MemtableColumnsCount:'' - * ''!MemtableDataSize:'' - * ''!MemtableSwitchCount:'' + 1. ''!MemtableColumnsCount'', representing the total number of column entries in this table. If you store 100 rows that each have 100 columns, expect to see this value increase by 10,000. + 1. ''!MemtableDataSize'', which is used to determine the total size of stored data. This is the sum of all the values stored and does not account for Memtable overhead, (i.e. it's not indicative of the actual memory used by the Memtable). + 1. Finally there is ''!MemtableSwitchCount'' which increases by one each time a column family flushes its Memtable to disk. - [attributes.png] + ''Note: You'll need to manually mash the `Refresh` button to update the values.'' - [operations.png] + attachment:jconsole_attributes.png + It is also possible to schedule an immediate flush using the `forceFlush()` operation. + + attachment:jconsole_operations.png +