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 A4A7DE2B0 for ; Thu, 14 Feb 2013 00:44:18 +0000 (UTC) Received: (qmail 42085 invoked by uid 500); 14 Feb 2013 00:44:15 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 42053 invoked by uid 500); 14 Feb 2013 00:44:15 -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 42045 invoked by uid 99); 14 Feb 2013 00:44:15 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 14 Feb 2013 00:44:15 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of kadey@comcast.net designates 76.96.62.48 as permitted sender) Received: from [76.96.62.48] (HELO qmta05.westchester.pa.mail.comcast.net) (76.96.62.48) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 14 Feb 2013 00:44:07 +0000 Received: from omta21.westchester.pa.mail.comcast.net ([76.96.62.72]) by qmta05.westchester.pa.mail.comcast.net with comcast id 000z1l0031ZXKqc550jmd7; Thu, 14 Feb 2013 00:43:46 +0000 Received: from [192.168.10.103] ([75.67.42.48]) by omta21.westchester.pa.mail.comcast.net with comcast id 00jl1l00w12M5b73h0jmBc; Thu, 14 Feb 2013 00:43:46 +0000 Message-ID: <511C333E.5090205@comcast.net> Date: Wed, 13 Feb 2013 19:43:42 -0500 From: Ken Adey User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:12.0) Gecko/20120420 Thunderbird/12.0 MIME-Version: 1.0 To: user@cassandra.apache.org Subject: Re: Write performance expectations... References: <55317802.1179946.1360776913698.JavaMail.root@sz0080a.westchester.pa.mail.comcast.net> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=q20121106; t=1360802626; bh=SsCZPQk/tyNVDWrM2dXckTE+wmS362oUGweM8pdk418=; h=Received:Received:Message-ID:Date:From:MIME-Version:To:Subject: Content-Type; b=FhBtXAKr4EXedES83BE6ryHGK3Cfs7T1Q8hIBaSTX9Hk4XR3Lf1DWwHAFh8JgTxBw 5DdRzIECdQklB8hB3ucOSa50ihup3Wt8qIZFLHcPdRW0uuBjnSTEHDry5JEsHJZ8dm 8N00UNn7+AXsYlmCv0KjesPgz+b6jVdGgEYFRhUnRpiPNbY8FZTq0DCPlcDrvJll9Y 2mweWvjtkcxRdg5EtQsrepwz3IQHxU33T54UjJJ2mssZKniirSmFOw4G4YjubAduMo zT3A10tUARWoujP4T8VuBwQOaw4CBwY2SpY6jvlwx2y3fmDmKXaOAg3ylTkhJL61/Q 2ZUWO7JMTO5mA== X-Virus-Checked: Checked by ClamAV on apache.org On a single processor EC2 instance, however, multiprocessing would be useless. Ken.... On 2/13/2013 5:29 PM, Ben Bromhead wrote: > If you are using CPython (most likely) remember to use the > multiprocessing interface rather than multithreading to avoid the > global interpreter lock. > > Cheers > > Ben > > On Thu, Feb 14, 2013 at 4:35 AM, > wrote: > > I'm not using multi-threads/processes. I'll try multi-threading to > see if I get a boost. > > Thanks. > > Ken.... > > > ------------------------------------------------------------------------ > *From: *"Tyler Hobbs" > > *To: *user@cassandra.apache.org > *Sent: *Wednesday, February 13, 2013 11:06:30 AM > *Subject: *Re: Write performance expectations... > > > 2500 inserts per second is about what a single python thread using > pycassa can do against a local node. Are you using multiple > threads for the inserts? Multiple processes? > > > On Wed, Feb 13, 2013 at 8:21 AM, Alain RODRIGUEZ > > wrote: > > Is there a particular reason for you to use EBS ? Instance > Store are recommended because they improve performances by > reducing the I/O throttling. > > An other thing you should be aware of is that replicating the > data to all node reduce your performance, it is more or less > like if you had only one node (at performance level I mean). > > Also, writing to different datacenters probably induce some > network latency. > > You should give the EC2 instance type (m1.xlarge / m1.large / > ...) if you want some feedback about the 2500 w/s, and also > give the mean size of your rows. > > Alain > > > 2013/2/13 > > > Hello, > New member here, and I have (yet another) question on > write performance. > > I'm using Apache Cassandra version 1.1, Python 2.7 and > Pycassa 1.7. > > I have a cluster of 2 datacenters, each with 3 nodes, on > AWS EC2 using EBS and the RandomPartioner. I'm writing to > a column family in a keyspace that's replicated to all > nodes in both datacenters, with a consistency level of > LOCAL_QUORUM. > > I'm seeing write performance of around 2500 rows per second. > > Is this in the ballpark for this kind of configuration? > > Thanks in advance. > > Ken.... > > > > > > -- > Tyler Hobbs > DataStax > >