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 E839A11F1E for ; Mon, 4 Aug 2014 19:43:06 +0000 (UTC) Received: (qmail 74692 invoked by uid 500); 4 Aug 2014 19:43:03 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 74655 invoked by uid 500); 4 Aug 2014 19:43:03 -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 74639 invoked by uid 99); 4 Aug 2014 19:43:03 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Aug 2014 19:43:03 +0000 X-ASF-Spam-Status: No, hits=3.1 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_IMAGE_ONLY_16,HTML_MESSAGE,HTML_SHORT_LINK_IMG_2,RCVD_IN_DNSWL_LOW,SPF_PASS,T_REMOTE_IMAGE X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of burtonator2011@gmail.com designates 209.85.217.179 as permitted sender) Received: from [209.85.217.179] (HELO mail-lb0-f179.google.com) (209.85.217.179) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Aug 2014 19:42:59 +0000 Received: by mail-lb0-f179.google.com with SMTP id v6so5755681lbi.10 for ; Mon, 04 Aug 2014 12:42:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:sender:from:date:message-id:subject:to:content-type; bh=mF3pseusiMJDNRlYm1O4PRXmx0pwEuIzWJhsoBOKcrE=; b=CBYQtiVziqXISh4ergHH6/Os4GT5z3RiyNuuNsWaHoUYdnHFi7OaRqLhC6SQowu0xu KyDGzuTvRg6iwfaU1ZNl+9cG5qlu79N1rbyJIbr4AiFh1LY1y7oArxnJWfkmBfr1m+cj bgMpbsMrQ1RhFNBpRBY63U9FJL0OhcxGTuzeGSkCT7qbc7FpUwiDlCQp8W5WMLkVnJQF dAV/3rgbj8e9ymnyspNvP7xHLac+o9Ty9P+4UAdtcHUiLVahyZvUBZ2yd4svN8T7Q213 ptyDP3ussW6yY47qyz/CwyQpWs+oVl96CXyVqmaT8fMqbfxf3AzHojeOrb5CDkFFBIGc e2Jg== X-Received: by 10.112.98.140 with SMTP id ei12mr24722050lbb.6.1407181358099; Mon, 04 Aug 2014 12:42:38 -0700 (PDT) MIME-Version: 1.0 Sender: burtonator2011@gmail.com Received: by 10.112.140.196 with HTTP; Mon, 4 Aug 2014 12:42:18 -0700 (PDT) From: Kevin Burton Date: Mon, 4 Aug 2014 12:42:18 -0700 X-Google-Sender-Auth: s7mdshyo_H0icDZozZsmwD3btIw Message-ID: Subject: Reasonable range for the max number of tables? To: "user@cassandra.apache.org" Content-Type: multipart/alternative; boundary=001a1134604afbf24a04ffd2f07e X-Virus-Checked: Checked by ClamAV on apache.org --001a1134604afbf24a04ffd2f07e Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable What's a reasonable range for the max number of tables? We have an append-only table system and I've been thinking of moving them to using hourly / partitioned tables. This means I can do things like easily drop older tables if I run out of disk space. It also means that I can fadvise the most recent tables and force them into table cache. But what's the max number of tables? If I'm doing hourly tables and have 30 days of them this would be 720 individual tables. That sounds reasonable=E2=80=A6 but what's the upper bound here? Kevin --=20 Founder/CEO Spinn3r.com Location: *San Francisco, CA* blog: http://burtonator.wordpress.com =E2=80=A6 or check out my Google+ profile --001a1134604afbf24a04ffd2f07e Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
What's a reasonable range for the max number of tables= ? =C2=A0We have an append-only table system and I've been thinking of m= oving them to using hourly / partitioned tables.

This me= ans I can do things like easily drop older tables if I run out of disk spac= e. =C2=A0It also means that I can fadvise the most recent tables and force = them into table cache.

But what's the max number of tables? =C2=A0If I'= ;m doing hourly tables and have 30 days of them this would be 720 individua= l tables. =C2=A0

That sounds reasonable=E2=80=A6 b= ut what's the upper bound here?

Kevin

--

Founder/CEO=C2=A0Spinn3r.com
Location:=C2=A0San Francisco, CA
=E2=80=A6 or check out my Google+ profile

--001a1134604afbf24a04ffd2f07e--