You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by "qihuang.zheng" <qi...@fraudmetrix.cn> on 2015/10/26 07:54:34 UTC
Find partition row of Compacted partition maximum bytes
I use nodetool cfstats to see table’s status, and findCompacted 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
Re: Find partition row of Compacted partition maximum bytes
Posted by Tushar Agrawal <ag...@gmail.com>.
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 <do...@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 <qi...@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
>
Re: Find partition row of Compacted partition maximum bytes
Posted by DuyHai Doan <do...@gmail.com>.
>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.zheng@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
>