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 C5F1D91F1 for ; Tue, 22 May 2012 11:31:03 +0000 (UTC) Received: (qmail 89327 invoked by uid 500); 22 May 2012 11:31:01 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 89298 invoked by uid 500); 22 May 2012 11:31:01 -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 89279 invoked by uid 99); 22 May 2012 11:31:00 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 May 2012 11:31:00 +0000 X-ASF-Spam-Status: No, hits=0.6 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [74.125.149.151] (HELO na3sys009aog124.obsmtp.com) (74.125.149.151) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 22 May 2012 11:30:54 +0000 Received: from mail-yx0-f175.google.com ([209.85.213.175]) (using TLSv1) by na3sys009aob124.postini.com ([74.125.148.12]) with SMTP ID DSNKT7t41hMOdlRIqTELedhqPSCeZxc+IaZ1@postini.com; Tue, 22 May 2012 04:30:33 PDT Received: by yenl13 with SMTP id l13so5503068yen.20 for ; Tue, 22 May 2012 04:30:29 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type:x-gm-message-state; bh=yPC4Y2jLpfjZamUVF6cBBD3d0Hsk+UJKwesHQsoWBAs=; b=cVWRI+OBUorkjSN65ewPHGfD1IUtueBWT8Riz5krDNLbkx9Lt7ucRUTr+A8Dv3D/W1 Nn9nMqEy3cOL3GBhEL2z5evgh40W7JgkvKwtJ4VMYUj9tzUHEls1XMg+QjEuh1iyVTDn /h4Si4XqAtMfWIY9bBIFBir4lHtqmkOQ+hfr1gsGI6VAwwn7mPdR00FqLDyY110FcGLW 0uWrAVm0OvzYIoCzIG0tBZApp+wZ1izfZaErv4awOQDRm+3+kMhRQ723pFQBjuBfKI5p DKpYLdSP5Ue80jVcpvBcQYp21nnurCsTNZ7Tqavewt0fJ/zsFNy4FZvFwmtJ1bmUeX5m C6ew== Received: by 10.101.187.2 with SMTP id o2mr8215031anp.32.1337686229627; Tue, 22 May 2012 04:30:29 -0700 (PDT) MIME-Version: 1.0 Received: by 10.147.181.2 with HTTP; Tue, 22 May 2012 04:30:09 -0700 (PDT) In-Reply-To: <9A5F91FD-CA77-4965-92CA-B3AB9B795CE1@thelastpickle.com> References: <8F37CFD0-F5B8-4F07-AE3B-9AB1ED8C8DA3@gmail.com> <9A5F91FD-CA77-4965-92CA-B3AB9B795CE1@thelastpickle.com> From: Franc Carter Date: Tue, 22 May 2012 21:30:09 +1000 Message-ID: Subject: Re: Number of keyspaces To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=001636ed6e4c89b4ed04c09e584d X-Gm-Message-State: ALoCoQmkENXPxs/6p+gLOOPWLOCk2vbJBxIBONyZv6LaetxEe9xMFxkREplv2YH6wVdSEOgHaxXv --001636ed6e4c89b4ed04c09e584d Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On Tue, May 22, 2012 at 9:19 PM, aaron morton wrot= e: > It's more the number of CF's than keyspaces. > Oh - does increasing the number of Column Families affect performance ? The design we are working on at the moment is considering using a Column Family per year. We were thinking this would isolate compactions to a more manageable size as we don't update previous years. cheers > > Cheers > > ----------------- > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 22/05/2012, at 6:58 PM, R. Verlangen wrote: > > Yes, it does. However there's no real answer what's the limit: it depends > on your hardware and cluster configuration. > > You might even want to search the archives of this mailinglist, I remembe= r > this has been asked before. > > Cheers! > > 2012/5/21 Lu=EDs Ferreira > >> Hi, >> >> Does the number of keyspaces affect the overall cassandra performance? >> >> >> Cumprimentos, >> Lu=EDs Ferreira >> >> >> >> > > > -- > With kind regards, > > Robin Verlangen > www.robinverlangen.nl > > > --=20 *Franc Carter* | Systems architect | Sirca Ltd franc.carter@sirca.org.au | www.sirca.org.au Tel: +61 2 9236 9118 Level 9, 80 Clarence St, Sydney NSW 2000 PO Box H58, Australia Square, Sydney NSW 1215 --001636ed6e4c89b4ed04c09e584d Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On Tue, May 22, 2012 at 9:19 PM, aaron morton <aaron@thelastpickle.c= om> wrote:
It's more the number of CF's th= an keyspaces.

Oh - does increasing th= e number of Column Families affect performance ?

The design we are working on at the moment is considering using a Column Fa= mily per year. We were thinking this would isolate=A0compactions=A0to a mor= e manageable size as we don't update previous years.

cheers
=A0

Cheers

<= div style=3D"word-wrap:break-word">
-----------------
Aaron Morton
Freelance Deve= loper
@aaronmorton

On 22/05/2012, at 6:58 PM, R. Verlangen wrote:

Yes, it does. However there's no real answer what&= #39;s the limit: it depends on your hardware and cluster configuration.=A0<= div>
You might even want to search the archives of this mailingli= st, I remember this has been asked before.

Cheers!

2012/5/21 Lu= =EDs Ferreira <zamith.28@gmail.com>
Hi,

Does the number of keyspaces affect the overall cassandra performance?


Cumprimentos,
Lu=EDs Ferreira






--
With kind re= gards,

Robin Verlangen





--

Franc Carter<= /b> |<= /span> Systems architect | Sirca Ltd

franc.carter@sirca.org.au=A0|=A0www.sirca.org.au

Tel:= =A0+61 2 9236 9118

Level 9, 80 Clarence St, Sydney=A0NSW 2000

PO Box H58, Australia Square, Sydney NSW 1215<= /span>


--001636ed6e4c89b4ed04c09e584d--