Re: Read latency is over 1 minute on a column family with 400,000 rows

[Teijo Holzer]

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-u...@incubator.apache.org mailing list archive at 
Nabble.com.