[ 
https://issues.apache.org/jira/browse/CASSANDRA-18448?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17712482#comment-17712482
 ] 

Ekaterina Dimitrova commented on CASSANDRA-18448:
-------------------------------------------------

I guess in older branches the new output should be under a new flag, no?

The bug is from 3.8 and this means that it kept rolling with that output in 
newer major versions so it will be breaking the nodetool output for users. 3.11 
was here for many years already, that is what bothers me.

> Missing "SSTable Count" metric  when using nodetool with "--format" option
> --------------------------------------------------------------------------
>
>                 Key: CASSANDRA-18448
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-18448
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tool/nodetool
>            Reporter: Mohammad Aburadeh
>            Assignee: Andres de la Peña
>            Priority: Normal
>             Fix For: 3.11.x, 4.0.x, 4.1.x, 5.x
>
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> Hi, 
> I'm using "nodetool cfstats --format json" to gather some metrics/infomation 
> about our tables. 
> I noticed that the "SSTable Count" is missing when using "–format" option. 
> If I don't use "–format"  option, I can set "SSTable Count" in the output. 
> *Output of "nodetool cfstats --format json | jq":* 
> {code:java}
> {  "total_number_of_tables": 38,  "stress_test": {    "write_latency_ms": 
> 0.8536725334338424,    "tables": {      "res1": {        
> "average_tombstones_per_slice_last_five_minutes": null,        
> "bloom_filter_off_heap_memory_used": "159256",        
> "memtable_switch_count": 754,        
> "maximum_tombstones_per_slice_last_five_minutes": 0,        
> "memtable_cell_count": 0,        "memtable_data_size": "0",        
> "average_live_cells_per_slice_last_five_minutes": null,        
> "local_read_latency_ms": "NaN",        "local_write_latency_ms": "NaN",       
>  "pending_flushes": 0,        "compacted_partition_minimum_bytes": 785940,    
>     "local_read_count": 0,        "sstable_compression_ratio": 
> 0.6294161376582798,        "dropped_mutations": "52751",        
> "bloom_filter_false_positives": 0,        "off_heap_memory_used_total": 
> "58842196",        "memtable_off_heap_memory_used": "0",        
> "index_summary_off_heap_memory_used": "18972",        
> "bloom_filter_space_used": "159408",        "sstables_in_each_level": [],     
>    "compacted_partition_maximum_bytes": 4055269,        "space_used_total": 
> "302694398635",        "local_write_count": 297111,        
> "compression_metadata_off_heap_memory_used": "58663968",        
> "number_of_partitions_estimate": 99614,        
> "maximum_live_cells_per_slice_last_five_minutes": 0,        
> "space_used_live": "302694398635",        "compacted_partition_mean_bytes": 
> 3827283,        "bloom_filter_false_ratio": "0.00000",        
> "percent_repaired": 0,        "space_used_by_snapshots_total": "0"      }    
> },    "read_latency_ms": null,    "pending_flushes": 0,    "write_count": 
> 594308,    "read_latency": null,    "read_count": 0  }}
>  {code}
> *Output of "nodetool cfstats":* 
> {code:java}
> ----------------
> Keyspace : stress_test
>         Read Count: 0
>         Read Latency: NaN ms
>         Write Count: 594308
>         Write Latency: 0.8536725334338424 ms
>         Pending Flushes: 0
>                 Table: res1
>                 SSTable count: 19                
>                 Space used (live): 302694398635
>                 Space used (total): 302694398635
>                 Space used by snapshots (total): 0
>                 Off heap memory used (total): 58842196
>                 SSTable Compression Ratio: 0.6294161376582798
>                 Number of partitions (estimate): 99614
>                 Memtable cell count: 0
>                 Memtable data size: 0
>                 Memtable off heap memory used: 0
>                 Memtable switch count: 754
>                 Local read count: 0
>                 Local read latency: NaN ms
>                 Local write count: 297111
>                 Local write latency: NaN ms
>                 Pending flushes: 0
>                 Percent repaired: 0.0
>                 Bloom filter false positives: 0
>                 Bloom filter false ratio: 0.00000
>                 Bloom filter space used: 159408
>                 Bloom filter off heap memory used: 159256
>                 Index summary off heap memory used: 18972
>                 Compression metadata off heap memory used: 58663968
>                 Compacted partition minimum bytes: 785940
>                 Compacted partition maximum bytes: 4055269
>                 Compacted partition mean bytes: 3827283
>                 Average live cells per slice (last five minutes): NaN
>                 Maximum live cells per slice (last five minutes): 0
>                 Average tombstones per slice (last five minutes): NaN
>                 Maximum tombstones per slice (last five minutes): 0
>                 Dropped Mutations: 52751*  
> ----------------
>  {code}
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to