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 DA940989B for ; Tue, 22 May 2012 15:31:35 +0000 (UTC) Received: (qmail 4151 invoked by uid 500); 22 May 2012 15:31:33 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 4125 invoked by uid 500); 22 May 2012 15:31:33 -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 4115 invoked by uid 99); 22 May 2012 15:31:33 -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 15:31:33 +0000 X-ASF-Spam-Status: No, hits=1.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of zamith.28@gmail.com designates 209.85.212.178 as permitted sender) Received: from [209.85.212.178] (HELO mail-wi0-f178.google.com) (209.85.212.178) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 May 2012 15:31:26 +0000 Received: by wibhn6 with SMTP id hn6so2758711wib.7 for ; Tue, 22 May 2012 08:31:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:mime-version:content-type:subject:date:in-reply-to:to :references:message-id:x-mailer; bh=x7JQS2ptYGw4V4vnXa/vhfdeZecJ3+VTxtVQxh7aiYU=; b=ysOmi3ch8i60Z/AqxJJAgMo1weeiRNSxR2bPq39yIlh4wePEqVyzQV0s8Ps2WrQi/D 9I2bIXAKHEV9H4krRiFRQPTlm3bs9pZ8qcKAvRqH5xRY+X6g9WrAkIbtCq6xtWG5lUMb ax5OOQyemfmFJ3okSbONTYJ+XqQDBf9A0HMD4cEBjy0WoDn2sZUvgD9kxce6vf4kYsXk y8RHlacrMzX9YKEpzy1n+I+SxOoWDA/mo0LyiZ5velA46U4rWHhYoXOUiMO55LbAqVmL hwfy1/C7lv4ifrE2yw/vYba8f41S8cVighzNn4+cHL+K+OT/mPOsgabtF78djxqsSoZV KaEg== Received: by 10.180.107.101 with SMTP id hb5mr36237736wib.7.1337700666016; Tue, 22 May 2012 08:31:06 -0700 (PDT) Received: from [192.168.84.223] (gwdi.di.uminho.pt. [193.136.19.18]) by mx.google.com with ESMTPS id bn9sm33505279wib.5.2012.05.22.08.31.03 (version=TLSv1/SSLv3 cipher=OTHER); Tue, 22 May 2012 08:31:05 -0700 (PDT) From: =?iso-8859-1?Q?Lu=EDs_Ferreira?= Mime-Version: 1.0 (Apple Message framework v1084) Content-Type: multipart/alternative; boundary=Apple-Mail-5-763695021 Subject: Re: Number of keyspaces Date: Tue, 22 May 2012 16:31:04 +0100 In-Reply-To: To: user@cassandra.apache.org References: <8F37CFD0-F5B8-4F07-AE3B-9AB1ED8C8DA3@gmail.com> <9A5F91FD-CA77-4965-92CA-B3AB9B795CE1@thelastpickle.com> Message-Id: <9E2E7B16-BE39-4A25-A6A8-AAC6EA8C3C28@gmail.com> X-Mailer: Apple Mail (2.1084) --Apple-Mail-5-763695021 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 I have 24 keyspaces, each with a columns family and am considering = changing it to 1 keyspace with 24 CFs. Would this be beneficial? On May 22, 2012, at 12:56 PM, samal wrote: > Not ideally, now cass has global memtable tuning. Each cf correspond = to memory in ram. Year wise cf means it will be in read only state for = next year, memtable will still consume ram. >=20 > On 22-May-2012 5:01 PM, "Franc Carter" = wrote: > On Tue, May 22, 2012 at 9:19 PM, aaron morton = wrote: > It's more the number of CF's than keyspaces. >=20 > Oh - does increasing the number of Column Families affect performance = ? >=20 > 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. >=20 > cheers > =20 >=20 > Cheers >=20 > ----------------- > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com >=20 > On 22/05/2012, at 6:58 PM, R. Verlangen wrote: >=20 >> Yes, it does. However there's no real answer what's the limit: it = depends on your hardware and cluster configuration.=20 >>=20 >> You might even want to search the archives of this mailinglist, I = remember this has been asked before. >>=20 >> Cheers! >>=20 >> 2012/5/21 Lu=EDs Ferreira >> Hi, >>=20 >> Does the number of keyspaces affect the overall cassandra = performance? >>=20 >>=20 >> Cumprimentos, >> Lu=EDs Ferreira >>=20 >>=20 >>=20 >>=20 >>=20 >>=20 >> --=20 >> With kind regards, >>=20 >> Robin Verlangen >> www.robinverlangen.nl >>=20 >=20 >=20 >=20 >=20 > --=20 > Franc Carter | Systems architect | Sirca Ltd > franc.carter@sirca.org.au | www.sirca.org.au > Tel: +61 2 9236 9118=20 > Level 9, 80 Clarence St, Sydney NSW 2000 > PO Box H58, Australia Square, Sydney NSW 1215 >=20 Cumprimentos, Lu=EDs Ferreira --Apple-Mail-5-763695021 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1 I = have 24 keyspaces, each with a columns family and am considering = changing it to 1 keyspace with 24 CFs. Would this be = beneficial?
On May 22, 2012, at 12:56 PM, samal = wrote:

Not ideally, now cass has global memtable tuning. Each = cf correspond to memory  in ram. Year wise cf means it will be in = read only state for next year, memtable  will still consume = ram.

On 22-May-2012 5:01 PM, "Franc Carter" <franc.carter@sirca.org.au>= ; wrote:
On Tue, May 22, 2012 at 9:19 PM, aaron morton <aaron@thelastpickle.com> wrote:
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

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 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 = regards,

Robin Verlangen

=




--
Franc Carter = | Systems = architect | Sirca = Ltd
Level 9, 80 Clarence St, = Sydney NSW 2000
PO Box H58, Australia Square, = Sydney NSW 1215



= --Apple-Mail-5-763695021--