[
https://issues.apache.org/jira/browse/CASSANDRA-18448?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mohammad Aburadeh updated CASSANDRA-18448:
------------------------------------------
Description:
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}
was:
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}
> 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
> Priority: Normal
>
> 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: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
