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

Popular posts from this blog

python - How to insert QWidgets in the middle of a Layout? -

python - serve multiple gunicorn django instances under nginx ubuntu -

module - Prestashop displayPaymentReturn hook url -