Toppartions provide the most active partitions. I am trying to do same thing. I was able to narrow down the largest partition by looking at warning in system.log.
Given that I have the key, how to see the entire data for that key? Thanks, Tushar > On Oct 26, 2015, at 4:21 AM, DuyHai Doan <doanduy...@gmail.com> wrote: > > From C* 2.2.x > > > nodetool help toppartitions > > NAME > nodetool toppartitions - Sample and print the most active partitions > for > a given column family > > > > On Mon, Oct 26, 2015 at 7:54 AM, qihuang.zheng <qihuang.zh...@fraudmetrix.cn> > wrote: >> I use nodetool cfstats to see table’s status, and find Compacted partition >> maximum bytes: 190G. >> Is there anyway to find this largest wide partition row? >> [qihuang.zheng@cass047202 cassandra]$ nodetool cfstats forseti.velocity >> Keyspace: forseti >> Read Count: 10470099 >> Read Latency: 1.3186399419909973 ms. >> Write Count: 146970362 >> Write Latency: 0.06062576270989929 ms. >> Pending Tasks: 0 >> Table: velocity >> SSTable count: 2144 >> SSTables in each level: [1, 10, 96, 723, 1314, 0, 0, 0, 0] >> Space used (live), bytes: 509031385679 >> Space used (total), bytes: 523815500936 >> Off heap memory used (total), bytes: 558210701 >> SSTable Compression Ratio: 0.23635049381008288 >> Number of keys (estimate): 269787648 >> Memtable cell count: 271431 >> Memtable data size, bytes: 141953019 >> Memtable switch count: 1713 >> Local read count: 10470099 >> Local read latency: 1.266 ms >> Local write count: 146970371 >> Local write latency: 0.053 ms >> Pending tasks: 0 >> Bloom filter false positives: 534721 >> Bloom filter false ratio: 0.13542 >> Bloom filter space used, bytes: 180529808 >> Bloom filter off heap memory used, bytes: 180512656 >> Index summary off heap memory used, bytes: 118613037 >> Compression metadata off heap memory used, bytes: 259085008 >> Compacted partition minimum bytes: 104 >> Compacted partition maximum bytes: 190420296972 >> Compacted partition mean bytes: 8656 >> Average live cells per slice (last five minutes): 0.0 >> Average tombstones per slice (last five minutes): 0.0 >> qihuang.zheng >
