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 33AD17426 for ; Mon, 1 Aug 2011 03:58:13 +0000 (UTC) Received: (qmail 22218 invoked by uid 500); 1 Aug 2011 03:58:10 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 21537 invoked by uid 500); 1 Aug 2011 03:57:59 -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 21528 invoked by uid 99); 1 Aug 2011 03:57:53 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Aug 2011 03:57:53 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of mina.naguib@bloomdigital.com designates 209.85.216.179 as permitted sender) Received: from [209.85.216.179] (HELO mail-qy0-f179.google.com) (209.85.216.179) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Aug 2011 03:57:43 +0000 Received: by qyk29 with SMTP id 29so3334507qyk.10 for ; Sun, 31 Jul 2011 20:57:22 -0700 (PDT) Received: by 10.224.200.132 with SMTP id ew4mr2915709qab.340.1312171042251; Sun, 31 Jul 2011 20:57:22 -0700 (PDT) Received: from host.lan (modemcable108.79-23-96.mc.videotron.ca [96.23.79.108]) by mx.google.com with ESMTPS id b6sm2880684qcb.23.2011.07.31.20.57.21 (version=TLSv1/SSLv3 cipher=OTHER); Sun, 31 Jul 2011 20:57:21 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Apple Message framework v1084) Subject: Re: Read latency is over 1 minute on a column family with 400,000 rows From: Mina Naguib In-Reply-To: <1312170451093-6639790.post@n2.nabble.com> Date: Sun, 31 Jul 2011 23:57:19 -0400 Content-Transfer-Encoding: quoted-printable Message-Id: <621A3169-BE43-4FC8-B20C-A0D9E7ED7632@bloomdigital.com> References: <1312165382278-6639649.post@n2.nabble.com> <4E361554.30608@wetafx.co.nz> <1312169479782-6639774.post@n2.nabble.com> <4E361EEF.5080000@wetafx.co.nz> <1312170451093-6639790.post@n2.nabble.com> To: user@cassandra.apache.org X-Mailer: Apple Mail (2.1084) X-Virus-Checked: Checked by ClamAV on apache.org Did you run that verbatim ? Or you appropriately substituted "keyspace" = and "columnfamily1" ? Also, anything in cassandra's log file (system.log) ? Compacting 150Gb = over 2057 SSTables should take a reasonable bit of time... On 2011-07-31, at 11:47 PM, myreasoner wrote: > Thanks. >=20 > I did *./nodetool -h localhost compact keyspace columnfamily1 *. But = it > came back really quick and the cfstats doesn't seem change much. >=20 > After compaction: > Column Family: Fingerprint > SSTable count: 2057 > Space used (live): 164351343468 > Space used (total): 164742957014 > Memtable Columns Count: 33224 > Memtable Data Size: 22410133 > Memtable Switch Count: 378 > Read Count: 7 > Read Latency: NaN ms. > Write Count: 30972 > Write Latency: 1.579 ms. > Pending Tasks: 0 > Key cache capacity: 200000 > Key cache size: 8157 > Key cache hit rate: 0.0 > Row cache: disabled > Compacted row minimum size: 104 > Compacted row maximum size: 315852 > Compacted row mean size: 33846