Max size for keys in cassandra table with cfstats -
problem:
i know max size (and average size) of data partitionkey in cassandra table.
what did far:
cfstats gives many information.
keyspace: my_keyspace read count: 0 read latency: nan ms. write count: 1 write latency: 0.289 ms. pending flushes: 0 table: my_table sstable count: 1 space used (live): 63915 space used (total): 63915 space used snapshots (total): 0 off heap memory used (total): 258 sstable compression ratio: 0.21345907193641897 number of keys (estimate): 24 memtable cell count: 13 memtable data size: 406 memtable off heap memory used: 0 memtable switch count: 0 local read count: 0 local read latency: nan ms local write count: 1 local write latency: 0,289 ms pending flushes: 0 bloom filter false positives: 0 bloom filter false ratio: 0,00000 bloom filter space used: 176 bloom filter off heap memory used: 168 index summary off heap memory used: 50 compression metadata off heap memory used: 40 compacted partition minimum bytes: 925 compacted partition maximum bytes: 29521 compacted partition mean bytes: 12935
for avg size think "space used"/"number of keys" right thing do.
but how more détails each key ? (at least max size)
you can find lot more statistics using java visualvm. need add remote jmx connection cassandra nodes (default port 7199). , go org.apache.cassandra.db/columnfamilies/my_keyspace/my_table
. there there attribute livecellsperslice
may find usefull.
Comments
Post a Comment