incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mina Naguib <mina.nag...@bloomdigital.com>
Subject Re: Read latency is over 1 minute on a column family with 400,000 rows
Date Mon, 01 Aug 2011 03:57:19 GMT

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.
> 
> 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


Mime
View raw message