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

Arun Ganesh edited comment on CASSANDRA-19671 at 6/3/24 4:58 AM:
-----------------------------------------------------------------

[~bschoeni],

For the keyspace space-used metric, is it just a sum of the space-used values 
of all the tables under it?

And, I already see a {{localReadWriteRatio}} for the tables in 
{{StatsTable.java}}. Do you mean something else?

{code:java}
...
Speculative retries: 0
Local read count: 2
Local read latency: 8.774 ms
Local write count: 1
Local write latency: 2.759 ms
Local read/write ratio: 2.000
Pending flushes: 0
Percent repaired: 0.0
Bytes repaired: 0
Bytes unrepaired: 37
...
{code}



was (Author: JIRAUSER303038):
[~bschoeni],

For the keyspace space-used metric, is it just a sum of the space-used values 
of all the tables under it?

And, I already see a {{localReadWriteRatio}} for the tables in 
{{StatsTable.java}}. Do you mean something else?

{code:java}
...
Speculative retries: 0
Local read count: 2
Local read latency: 8.774 ms
Local write count: 1
Local write latency: 2.759 ms
{color:#FF8B00}Local read/write ratio: 2.000{color}
Pending flushes: 0
Percent repaired: 0.0
Bytes repaired: 0
Bytes unrepaired: 37
...
{code}


> Nodetool tabestats: add keyspace space used and table r/w ratio
> ---------------------------------------------------------------
>
>                 Key: CASSANDRA-19671
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-19671
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: Tool/nodetool
>            Reporter: Brad Schoening
>            Priority: Normal
>
> Nodetool tabestats reports the space used live and total per table, but not 
> for the entire keyspace.  This would be useful information.
> Also, in the table level stats, it would be useful to have the read/write 
> ratio. This metric is important in choosing compaction strategies such as 
> LCS. 



--
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