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 0E71FCF7B for ; Fri, 25 May 2012 10:26:27 +0000 (UTC) Received: (qmail 88985 invoked by uid 500); 25 May 2012 10:26:23 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 88925 invoked by uid 500); 25 May 2012 10:26:21 -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 88892 invoked by uid 99); 25 May 2012 10:26:20 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 25 May 2012 10:26:20 +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 (athena.apache.org: domain of yanush51@gmail.com designates 209.85.160.172 as permitted sender) Received: from [209.85.160.172] (HELO mail-gh0-f172.google.com) (209.85.160.172) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 25 May 2012 10:26:14 +0000 Received: by ghbg16 with SMTP id g16so447344ghb.31 for ; Fri, 25 May 2012 03:25:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=RRJVcFz5lwZOAtd9RofWWlNxcQ0+3eJ7YnKzV/SmvgA=; b=NotwLYn9l+pFX4/RyPgBYl7fdaWipVuXdFPAcmv+KNFRH9BO0PSY+47eWYAy5seyCm qCvvdgRQOPU19yGWc2XlS9ifdmuSD3Qvzbao0INN3SPPGO9rJ23g/6ETO67CdwY2p+Dr BerZVzCUsiv7rBJ2J//nNtdpbCSLc3DHdWIwqmL1pQJVp+6Zda3jPodL1KzcipCUbb6w BnPWEdClSM7qAzG/g65fANOzPmVuAcd/6WGG89D2BeSS+BXSHy+e7zru5icRuvOAXWhu 8zXJTJlqGZix1MyfCMeKD5jGhXGhRBvf6awsoMRAdb7ZyUCPASNC4ge9Zi+aad1+UkPL 4Ujw== MIME-Version: 1.0 Received: by 10.50.46.228 with SMTP id y4mr19326103igm.10.1337941553522; Fri, 25 May 2012 03:25:53 -0700 (PDT) Received: by 10.64.19.69 with HTTP; Fri, 25 May 2012 03:25:53 -0700 (PDT) Date: Fri, 25 May 2012 13:25:53 +0300 Message-ID: Subject: Schema size From: Sasha Yanushkevich To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=14dae93410410726af04c0d9cb4f X-Virus-Checked: Checked by ClamAV on apache.org --14dae93410410726af04c0d9cb4f Content-Type: text/plain; charset=ISO-8859-1 Hi All, I have a question about schema cleaning in cassandra. I use cassandra version 1.0.9. I have 5 keyspaces and about 1500 column family per keyspace. After dynamically creating and deleting CF my schema's sstables size were very high. For example size of Migrations was 45 GB and Schema sstable size was 45 GB whereas all data size was about 10 GB. Why schema grow was so fast? And how may I cleanup schema or later schema cleanup itself? -- Best regards, Alexander --14dae93410410726af04c0d9cb4f Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

Hi All,

I have a question about schema cleani= ng in cassandra.

I use cassandra version 1.0.9. I = have 5 keyspaces and about 1500 column family per keyspace. After dynamical= ly creating and deleting CF my schema's sstables=A0 size were very high= . For example size of Migrations was 45 GB and Schema sstable size was 45 G= B whereas all data size was about 10 GB.

Why schema grow was so fast? And how may I cleanup schema or later sch= ema cleanup itself?

Best reg= ards,

Alexander

--14dae93410410726af04c0d9cb4f--