Return-Path: Delivered-To: apmail-incubator-cassandra-user-archive@minotaur.apache.org Received: (qmail 17902 invoked from network); 14 Nov 2009 16:57:02 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 14 Nov 2009 16:57:02 -0000 Received: (qmail 92171 invoked by uid 500); 14 Nov 2009 16:57:01 -0000 Delivered-To: apmail-incubator-cassandra-user-archive@incubator.apache.org Received: (qmail 92119 invoked by uid 500); 14 Nov 2009 16:57:01 -0000 Mailing-List: contact cassandra-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cassandra-user@incubator.apache.org Delivered-To: mailing list cassandra-user@incubator.apache.org Received: (qmail 92110 invoked by uid 99); 14 Nov 2009 16:57:01 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 14 Nov 2009 16:57:01 +0000 X-ASF-Spam-Status: No, hits=-2.2 required=5.0 tests=AWL,BAYES_00 X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of tuxracer69@gmail.com designates 74.125.78.150 as permitted sender) Received: from [74.125.78.150] (HELO ey-out-1920.google.com) (74.125.78.150) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 14 Nov 2009 16:56:57 +0000 Received: by ey-out-1920.google.com with SMTP id 3so577847eyh.4 for ; Sat, 14 Nov 2009 08:56:35 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=rtHOpHozLhHZtATbuI3N+NAd7jIIdUJIVdPqHhgoFBU=; b=C5El8OuiVrO1rEncJ41y/I3UuvlEWNQHiPgW78ybYEWbSTIsaTigQIUjbMBKKvHDA8 36+HsaGDwH4J60hcwlyMBWtlPDWs4MPf7BRuvsE+AKlP4VMDDOK3YiUdlfVzBR+eyVQO Vfu33qT2tm8ZTsPeBkbv6sIKcykxnegOYabdE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding; b=HMs+Q6solLmoEfCh7hc2TPbYd5wgY/4+pLLmCc5kKIn/oEZLT1z13wnkO8pEnoyZAF AS7mDGBhbuXRZ+OKf7ncNAq1g1HhOML/7nv0/m2sMfmjFncshTTVakvpAA2+cOCkqCmN tPyxqpt1jBWav8QFcUWTyq9TwfGzGgvLUdArk= Received: by 10.213.23.201 with SMTP id s9mr3613786ebb.72.1258217795679; Sat, 14 Nov 2009 08:56:35 -0800 (PST) Received: from ?192.168.1.66? (78-86-128-147.zone2.bethere.co.uk [78.86.128.147]) by mx.google.com with ESMTPS id 28sm3261732eyg.46.2009.11.14.08.56.34 (version=TLSv1/SSLv3 cipher=RC4-MD5); Sat, 14 Nov 2009 08:56:34 -0800 (PST) Message-ID: <4AFEE13C.1060903@gmail.com> Date: Sat, 14 Nov 2009 16:56:28 +0000 From: TuxRacer69 User-Agent: Mozilla-Thunderbird 2.0.0.22 (X11/20090701) MIME-Version: 1.0 To: cassandra-user@incubator.apache.org Subject: Re: Why cassandra single node so slow? References: <9b048d180911140347y5c28ff3fl7e155bb0f5e216cd@mail.gmail.com> <4AFE9BF5.4090404@gmail.com> <9b048d180911140428h4a8430d8q47e3e02e06930602@mail.gmail.com> In-Reply-To: <9b048d180911140428h4a8430d8q47e3e02e06930602@mail.gmail.com> Content-Type: text/plain; charset=KOI8-R; format=flowed Content-Transfer-Encoding: 8bit Looking at http://assets.en.oreilly.com/1/event/27/Cassandra_%20Open%20Source%20Bigtable%20+%20Dynamo%20Presentation.pdf page 26 Cassandra should make around 100 read per sec and around 10,000 writes per sec (on the data equivalent of a 50Gb mysql db) so your results seem OK How do your results scale with the database size? I'd say that with 4,000,000 records your mysql db is still much smaller than 50Gb. In you mail you did not mention the write results. Do you see a very fast write with Cassandra (assuming that Laziboy does a ZERO consistency level write)? Do you know the consistency level used by laziboy for reads? Did you try multi_gets? ruslan usifov wrote: > N�. But i think that all data will be in memory and gstat (FreeBSD > utility) show that no any disk activity. >