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 C814290DC for ; Thu, 27 Oct 2011 15:31:13 +0000 (UTC) Received: (qmail 73801 invoked by uid 500); 27 Oct 2011 15:31:11 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 73745 invoked by uid 500); 27 Oct 2011 15:31:11 -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 73737 invoked by uid 99); 27 Oct 2011 15:31:11 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Oct 2011 15:31:11 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of jakers@gmail.com designates 209.85.216.172 as permitted sender) Received: from [209.85.216.172] (HELO mail-qy0-f172.google.com) (209.85.216.172) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Oct 2011 15:31:05 +0000 Received: by qyk34 with SMTP id 34so862960qyk.10 for ; Thu, 27 Oct 2011 08:30:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=YXeBgfe/eqn9DtrXUHnIAvTMS55oNYyez8+HX06qjH4=; b=YsceRrr4sLZShe22xrcBFGn6RbkF6Py7epg62fl2NDd+2q9ddUOIaeRunMFqzO9YP5 bVcZ6MDWMFOY5il7tYcFdMMA0NhCA6d7EzzhelsFhuiKvKftYNOGSAOPqVN6vAofsKsM zg7Aw5jMkxnfwWb3aTBBlSfqN4G6q2qGAI+RI= Received: by 10.68.1.229 with SMTP id 5mr30609285pbp.88.1319729444172; Thu, 27 Oct 2011 08:30:44 -0700 (PDT) MIME-Version: 1.0 Received: by 10.142.172.7 with HTTP; Thu, 27 Oct 2011 08:30:23 -0700 (PDT) In-Reply-To: References: From: Jake Luciani Date: Thu, 27 Oct 2011 11:30:23 -0400 Message-ID: Subject: Re: Counter Experience (Performance)? To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=bcaec53042a1b8339e04b0497466 X-Virus-Checked: Checked by ClamAV on apache.org --bcaec53042a1b8339e04b0497466 Content-Type: text/plain; charset=ISO-8859-1 What's your bottleneck? http://spyced.blogspot.com/2010/01/linux-performance-basics.html On Thu, Oct 27, 2011 at 9:37 AM, Joe Stein wrote: > Hey folks, I am interested in what others have seen in regards to their > experience in the amount of depth and width (CF, Rows & Columns) that they > can/do write per batch and simultaneously and what is the inflection point > where performance degrades. I have been expanding my use of counters and > am finding some interesting nuances some in my code and implementation > related but others I can't yet quantify. > > My batches are 1x5x5 (1 row for each of 5 column families and 5 columns for > each of those 1 rows within each of the 5 column families). I have 3 nodes > each with 100 connections and another thread pool of 100 threads rolling > through 6,000,000 rows off data sending data out to Cassandra (the 1x5x5 > matrice is constructed from each line). I am finding this to be my sweet > spot right now but still not really performing fantastically (or at least > what I had hoped) and I am wondering what else (if anything) I can be doing > to tweak settings or what to be able to push in more columns or rows. I > find changing my pool settings very much froms this causes error on client > lib but I will send email to that list separately though I think I have that > figured out on my own for now. > > Thanks in advance!!! I hope to get more work going on this in the next day > or so in a more methodic way to find the right count so I can build a sparse > matrice that will perform best for system and business. > > /* > Joe Stein > http://www.linkedin.com/in/charmalloc > Twitter: @allthingshadoop > */ > -- http://twitter.com/tjake --bcaec53042a1b8339e04b0497466 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable What's your bottleneck?=A0http://spyced.blogspot.com/2010/01/linux-pe= rformance-basics.html

On Thu, Oct 27,= 2011 at 9:37 AM, Joe Stein <cryptcom@gmail.com> wrote:
Hey folks, I am interested in what others h= ave seen in regards to their experience in the amount of depth and width (C= F, Rows & Columns) that they can/do write per batch and=A0simultaneousl= y and what is the inflection point where performance degrades. =A0 I have b= een expanding my use of counters and am finding some=A0interesting=A0nuance= s some in my code and implementation related but others I can't yet qua= ntify.

My batches are 1x5x5 (1 row for each of 5 column families an= d 5 columns for each of those 1 rows within each of the 5 column families).= =A0I have 3 nodes each with 100 connections and another thread pool of 100= threads rolling through 6,000,000 rows off data sending data out to=A0Cass= andra=A0(the 1x5x5 matrice is constructed from each line). =A0I am finding = this to be my sweet spot right now but still not really performing fantasti= cally (or at least what I had hoped) and I am wondering what else (if anyth= ing) I can be doing to=A0tweak=A0settings or what to be able to push in mor= e columns or rows. =A0 I find changing my pool settings very much froms thi= s causes error on client lib but I will send email to that list=A0separatel= y though I think I have that figured out on my own for now.

Thanks in advance!!! =A0I hope to get more work go= ing on this in the next day or so in a more methodic way to find the right = count so I can build a sparse matrice that will perform best for system and= business.

/*
Joe Stein
http://www.linkedin.com/= in/charmalloc
Twitter: @allthingshadoop
*/



--
http://twitter.com/tjake
--bcaec53042a1b8339e04b0497466--