cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Teijo Holzer <thol...@wetafx.co.nz>
Subject Re: Read latency is over 1 minute on a column family with 400,000 rows
Date Mon, 01 Aug 2011 03:55:33 GMT
Hi,

try

nodetool -h localhost compact

check progress with

nodetool -h localhost compactionstats

and check system.log

Cheers,

	T.

On 01/08/11 15:47, myreasoner wrote:
> Thanks.
>
> I did *./nodetool -h localhost compact keyspace columnfamily1 *.  But it
> came back really quick and the cfstats doesn't seem change much.
>
> 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
>
>
> --
> View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Read-latency-is-over-1-minute-on-a-column-family-with-400-000-rows-tp6639649p6639790.html
> Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.


Mime
View raw message