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 AA4589DC4 for ; Tue, 11 Oct 2011 20:55:45 +0000 (UTC) Received: (qmail 56354 invoked by uid 500); 11 Oct 2011 20:55:43 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 56323 invoked by uid 500); 11 Oct 2011 20:55:43 -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 56315 invoked by uid 99); 11 Oct 2011 20:55:43 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Oct 2011 20:55:43 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [208.113.200.5] (HELO homiemail-a83.g.dreamhost.com) (208.113.200.5) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Oct 2011 20:55:35 +0000 Received: from homiemail-a83.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a83.g.dreamhost.com (Postfix) with ESMTP id 69B385E06E for ; Tue, 11 Oct 2011 13:55:08 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; c=nofws; d=thelastpickle.com; h=from :mime-version:content-type:subject:date:in-reply-to:to :references:message-id; q=dns; s=thelastpickle.com; b=TYLeLc7rlK 6J72UnQADtlxy2qV5pFIv4Hq190NVk3KVIiVrtBvfRNdNx0xZijGY16v9eyUoZmU 2Dcy8asc+g6RJeuJ5dj86L8GFo7ch7u+/KLU2Sc+yfpBkBocZR0SmjiNLnKm96lP BUko3jbDGXK9UhlcbwdgDbulB83nbnOAM= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=thelastpickle.com; h=from :mime-version:content-type:subject:date:in-reply-to:to :references:message-id; s=thelastpickle.com; bh=WJhXSNuxtM/fo7NM cbNpvy0/dT4=; b=r8aCDphVb+NC6x3lQBWvj23vsXdJ/FQGaa/NecXYd3bqkaKN rOVnW1dDuLfpRTj4QkJ4D9Qp8eIT5rgkmP163vy3sEewNic0aTJiLc6mNtmSSyhl xNGi5HxVfHa9L8ZPxmzXjIEGEd7zypzY04UvVkcQn4bwcB7lVbLa0uusWhM= Received: from [172.16.1.4] (125-236-193-159.adsl.xtra.co.nz [125.236.193.159]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: aaron@thelastpickle.com) by homiemail-a83.g.dreamhost.com (Postfix) with ESMTPSA id DCC295E06A for ; Tue, 11 Oct 2011 13:55:07 -0700 (PDT) From: aaron morton Mime-Version: 1.0 (Apple Message framework v1244.3) Content-Type: multipart/alternative; boundary="Apple-Mail=_3F4EE569-8D23-404D-AA37-7631BDF12196" Subject: Re: CompletedTasks attribute exposed via JMX Date: Wed, 12 Oct 2011 09:55:05 +1300 In-Reply-To: To: user@cassandra.apache.org References: Message-Id: <49C6D558-09B1-49E9-A53C-F53B2335C94C@thelastpickle.com> X-Mailer: Apple Mail (2.1244.3) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail=_3F4EE569-8D23-404D-AA37-7631BDF12196 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 Its the number of mutations, a mutation is a collection of changes for a = single row across one or more column families.=20 Take a look at the nodetool cfstats, this is where I assume Ops Centre = is getting it's data from.=20 Cheers =20 ----------------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 12/10/2011, at 3:44 AM, Alexandru Dan Sicoe wrote: > Hello everyone, > I was trying to get some cluster wide statistics of the total = insertions performed in my 3 node Cassandra 0.8.6 cluster. So I wrote a = nice little program that gets the CompletedTasks attribute of = org.apache.cassandra.db:type=3DCommitlog from every node, sums up the = values and records them in a .csv every 10 sec or so. Everything works = and I get my stats but later I found out that I am not really sure what = this measure means. I think it is the individual column insertions = performed! Am I correct? > In the meantime I installed the trial version of the DataStax = Operations Center. The cluster wide dashboard, showing Writes performed = as a function of time, gives me much smaller values of the rates, = compared to the measurement I described before. The Datastax writes/sec = are of the same order of magnitude as the batch writes I perform on the = cluster. But somehow I cannot relate between this rate and the rate of = my CompletedTasks measurement. >=20 > How do people usually measure insertion rates for their custers ? Per = batch, per single columns or is actual data rate more important to know? >=20 > Cheers, > Alexandru >=20 --Apple-Mail=_3F4EE569-8D23-404D-AA37-7631BDF12196 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1 Its = the number of mutations, a mutation is a collection of changes for a = single row across one or more column = families. 

Take a look at the nodetool cfstats, = this is where I assume Ops Centre is getting it's data = from. 

Cheers
 
http://www.thelastpickle.com

On 12/10/2011, at 3:44 AM, Alexandru Dan Sicoe = wrote:

Hello = everyone,
 I was trying to get some cluster wide statistics of = the total insertions performed in my 3 node Cassandra 0.8.6 cluster. So = I wrote a nice little program that gets the CompletedTasks attribute of = org.apache.cassandra.db:type=3DCommitlog from every node, sums up the = values and records them in a .csv every 10 sec or so. Everything works = and I get my stats but later I found out that I am not really sure what = this measure means. I think it is the individual column insertions = performed! Am I correct?
 In the meantime I installed the trial version of the DataStax = Operations Center. The cluster wide dashboard, showing Writes performed = as a function of time, gives me much smaller values of the rates, = compared to the measurement I described before. The Datastax writes/sec = are of the same order of magnitude as the batch writes I perform on the = cluster. But somehow I cannot relate between this rate and the rate of = my CompletedTasks measurement.

How do people usually measure insertion rates for their custers ? = Per batch, per single columns or is actual data rate more important to = know?

Cheers,
Alexandru


= --Apple-Mail=_3F4EE569-8D23-404D-AA37-7631BDF12196--