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 5BE4B10873 for ; Thu, 18 Jul 2013 22:48:10 +0000 (UTC) Received: (qmail 82999 invoked by uid 500); 18 Jul 2013 22:48:07 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 82935 invoked by uid 500); 18 Jul 2013 22:48:07 -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 82927 invoked by uid 99); 18 Jul 2013 22:48:07 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Jul 2013 22:48:07 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of kohlisankalp@gmail.com designates 209.85.216.50 as permitted sender) Received: from [209.85.216.50] (HELO mail-qa0-f50.google.com) (209.85.216.50) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Jul 2013 22:48:03 +0000 Received: by mail-qa0-f50.google.com with SMTP id l18so2022683qak.9 for ; Thu, 18 Jul 2013 15:47:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=T9EdoCYcm6LotK8EPygpT/ep/qMdXLTFVFbpdH1TuoQ=; b=FNYgq9xG7dAHh4+PoQev6XBrGEe8xgyi+5c62umjPdOnPH1CQU6u3C5Sotg+nn0qTL L6MmyF+yd4vIF6Ycx/AZQgxAwr7EYaTZdaOVE4VFdUD3DKDIWzWJBpXVMNFCFJHtPPU5 coXqx6aZtnGKbG2rzLyJu0kMGZogOovxEj80bEfmZc/DKhCZtl2cowTEjOSa0+Z9Nafg n6/+WlpBoyxsXGCY2c3dwn9119QPGBXCeWQurptf31k6vc01/DoaLXXrE1erb+TZIXBH ybDrgEHe4R87ceee3c2jyoBloT68PiS+xHCmwg4M3h3jHIHR7Ufp8j4hM6uScGWglbnV PMWA== X-Received: by 10.224.129.65 with SMTP id n1mr16037515qas.81.1374187662777; Thu, 18 Jul 2013 15:47:42 -0700 (PDT) MIME-Version: 1.0 Received: by 10.49.0.171 with HTTP; Thu, 18 Jul 2013 15:47:01 -0700 (PDT) In-Reply-To: <57C7C3CBDCB04F45A57AEC4CB21C0CCD1DBDEA22@mbx024-e1-nj-6.exch024.domain.local> References: <57C7C3CBDCB04F45A57AEC4CB21C0CCD1DBDEA22@mbx024-e1-nj-6.exch024.domain.local> From: sankalp kohli Date: Thu, 18 Jul 2013 15:47:01 -0700 Message-ID: Subject: Re: MailBox Impl To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=001a11c1de307ea54e04e1d0ff20 X-Virus-Checked: Checked by ClamAV on apache.org --001a11c1de307ea54e04e1d0ff20 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Conter wont be updated when the old data is TTLed. I am not sure whether you can use triggers https://issues.apache.org/jira/browse/CASSANDRA-1311 On Thu, Jul 18, 2013 at 2:30 PM, Kanwar Sangha wrote: > Hi - We are planning on using Cassandra for an IMAP based > implementation. There are some questions that we are stuck with =96**** > > ** ** > > **1) **Each user will have a pre-defined mailbox size (say 10 MB). > We need to maintain a field to check if the mail-box size exceeds the > predefined size. Will using the counter family be appropriate ?**** > > **2) **Also, we need to have retention for only 10 days. After 10 > days, the previous days data will be removed. We plan to have TTL defined > per message. But if we do that, how does the counter in question 1 get > updated with the space cleaned due to deletion ?**** > > **3) **Do we NOT have TTL and manage the deletions within the > application itself ? **** > > ** ** > > Thanks,**** > > Kanwar**** > > **** > --001a11c1de307ea54e04e1d0ff20 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable
Conter wont be updated when the old data is TTLed. I am no= t sure whether you can use triggers=A0https://issues.apache.org/jira/browse/CASSANDRA= -1311


On Thu, Jul 1= 8, 2013 at 2:30 PM, Kanwar Sangha <kanwar@mavenir.com> wrot= e:

Hi=A0 - We are planning on usin= g Cassandra for an IMAP based implementation. There are some questions that= we are stuck with =96

=A0

1)=A0=A0=A0=A0=A0 Each user will have a pre-= defined mailbox size (say 10 MB). We need to maintain a field to check if t= he mail-box size exceeds the predefined size. Will using the counter family= be appropriate ?

2)=A0=A0=A0=A0=A0 Also, we need to have rete= ntion for only 10 days. After 10 days, the previous days data will be remov= ed. We plan to have TTL defined per message. But if we do that, how does th= e counter in question 1 get updated with the space cleaned due to deletion ?

3)=A0=A0=A0=A0=A0 Do we NOT have TTL and man= age the deletions within the application itself ?

=A0

Thanks,

Kanwar

=A0=A0


--001a11c1de307ea54e04e1d0ff20--