[jira] [Updated] (CASSANDRA-14538) Add virtual table to view cache information
[ https://issues.apache.org/jira/browse/CASSANDRA-14538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Yeschenko updated CASSANDRA-14538: -- Resolution: Fixed Status: Resolved (was: Ready to Commit) > Add virtual table to view cache information > --- > > Key: CASSANDRA-14538 > URL: https://issues.apache.org/jira/browse/CASSANDRA-14538 > Project: Cassandra > Issue Type: Improvement >Reporter: Chris Lohfink >Assignee: Chris Lohfink >Priority: Minor > Labels: virtual-tables > Fix For: 4.0 > > > Add a table for displaying the general cache information (like in {{nodetool > info}}) > {code} > cqlsh> SELECT * FROM system_views.caches; > name| entries | hit_ratio | hits | recent_hits_per_sec | > recent_requests_per_sec | requests | size_max | size_used > -+-+---+--+-+-+--+--+--- > counter | 0 | NaN |0 | 0 | > 0 |0 | 12582912 | 0 > key | 19 | 0.922509 | 250 | 11 | > 13 | 271 | 25165824 | 1728 > row | 0 | NaN |0 | 0 | > 0 |0 | 16777216 | 0 > (3 rows) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Updated] (CASSANDRA-14538) Add virtual table to view cache information
[ https://issues.apache.org/jira/browse/CASSANDRA-14538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Yeschenko updated CASSANDRA-14538: -- Status: Ready to Commit (was: Patch Available) > Add virtual table to view cache information > --- > > Key: CASSANDRA-14538 > URL: https://issues.apache.org/jira/browse/CASSANDRA-14538 > Project: Cassandra > Issue Type: Improvement >Reporter: Chris Lohfink >Assignee: Chris Lohfink >Priority: Minor > Labels: virtual-tables > Fix For: 4.0 > > > Add a table for displaying the general cache information (like in {{nodetool > info}}) > {code} > cqlsh> SELECT * FROM system_views.caches; > name| entries | hit_ratio | hits | recent_hits_per_sec | > recent_requests_per_sec | requests | size_max | size_used > -+-+---+--+-+-+--+--+--- > counter | 0 | NaN |0 | 0 | > 0 |0 | 12582912 | 0 > key | 19 | 0.922509 | 250 | 11 | > 13 | 271 | 25165824 | 1728 > row | 0 | NaN |0 | 0 | > 0 |0 | 16777216 | 0 > (3 rows) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Updated] (CASSANDRA-14538) Add virtual table to view cache information
[ https://issues.apache.org/jira/browse/CASSANDRA-14538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Yeschenko updated CASSANDRA-14538: -- Reviewer: Aleksey Yeschenko Fix Version/s: 4.0 Status: Patch Available (was: Open) > Add virtual table to view cache information > --- > > Key: CASSANDRA-14538 > URL: https://issues.apache.org/jira/browse/CASSANDRA-14538 > Project: Cassandra > Issue Type: Improvement >Reporter: Chris Lohfink >Assignee: Chris Lohfink >Priority: Minor > Labels: virtual-tables > Fix For: 4.0 > > > Add a table for displaying the general cache information (like in {{nodetool > info}}) > {code} > cqlsh> SELECT * FROM system_views.caches; > name| entries | hit_ratio | hits | recent_hits_per_sec | > recent_requests_per_sec | requests | size_max | size_used > -+-+---+--+-+-+--+--+--- > counter | 0 | NaN |0 | 0 | > 0 |0 | 12582912 | 0 > key | 19 | 0.922509 | 250 | 11 | > 13 | 271 | 25165824 | 1728 > row | 0 | NaN |0 | 0 | > 0 |0 | 16777216 | 0 > (3 rows) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Updated] (CASSANDRA-14538) Add virtual table to view cache information
[ https://issues.apache.org/jira/browse/CASSANDRA-14538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benjamin Lerer updated CASSANDRA-14538: --- Reviewer: (was: Benjamin Lerer) > Add virtual table to view cache information > --- > > Key: CASSANDRA-14538 > URL: https://issues.apache.org/jira/browse/CASSANDRA-14538 > Project: Cassandra > Issue Type: Improvement >Reporter: Chris Lohfink >Assignee: Chris Lohfink >Priority: Minor > Labels: virtual-tables > > Add a table for displaying the general cache information (like in {{nodetool > info}}) > {code} > cqlsh> SELECT * FROM system_views.caches; > name| entries | hit_ratio | hits | recent_hits_per_sec | > recent_requests_per_sec | requests | size_max | size_used > -+-+---+--+-+-+--+--+--- > counter | 0 | NaN |0 | 0 | > 0 |0 | 12582912 | 0 > key | 19 | 0.922509 | 250 | 11 | > 13 | 271 | 25165824 | 1728 > row | 0 | NaN |0 | 0 | > 0 |0 | 16777216 | 0 > (3 rows) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Updated] (CASSANDRA-14538) Add virtual table to view cache information
[ https://issues.apache.org/jira/browse/CASSANDRA-14538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chris Lohfink updated CASSANDRA-14538: -- Description: Add a table for displaying the general cache information (like in {{nodetool info}}) {code} cqlsh> SELECT * FROM system_views.caches; name| entries | hit_ratio | hits | recent_hits_per_sec | recent_requests_per_sec | requests | size_max | size_used -+-+---+--+-+-+--+--+--- counter | 0 | NaN |0 | 0 | 0 |0 | 12582912 | 0 key | 19 | 0.922509 | 250 | 11 | 13 | 271 | 25165824 | 1728 row | 0 | NaN |0 | 0 | 0 |0 | 16777216 | 0 (3 rows) {code} was: Add a table for displaying the general cache information (like in {{nodetool info}}) {code} cqlsh> SELECT * FROM system_views.caches; name| entries | hit_ratio | hits | recent_hits_per_sec | recent_requests_per_sec | requests | size_max | size_used -+-+---+--+-+-+--+--+--- counter | 0 | NaN |0 | 0 | 0 |0 | 12582912 | 0 key | 19 | 0.922509 | 250 | 11 | 13 | 271 | 25165824 | 1728 row | 0 | NaN |0 | 0 | 0 |0 | 16777216 | 0 (3 rows) > Add virtual table to view cache information > --- > > Key: CASSANDRA-14538 > URL: https://issues.apache.org/jira/browse/CASSANDRA-14538 > Project: Cassandra > Issue Type: Improvement >Reporter: Chris Lohfink >Assignee: Chris Lohfink >Priority: Minor > Labels: virtual-tables > > Add a table for displaying the general cache information (like in {{nodetool > info}}) > {code} > cqlsh> SELECT * FROM system_views.caches; > name| entries | hit_ratio | hits | recent_hits_per_sec | > recent_requests_per_sec | requests | size_max | size_used > -+-+---+--+-+-+--+--+--- > counter | 0 | NaN |0 | 0 | > 0 |0 | 12582912 | 0 > key | 19 | 0.922509 | 250 | 11 | > 13 | 271 | 25165824 | 1728 > row | 0 | NaN |0 | 0 | > 0 |0 | 16777216 | 0 > (3 rows) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Updated] (CASSANDRA-14538) Add virtual table to view cache information
[ https://issues.apache.org/jira/browse/CASSANDRA-14538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chris Lohfink updated CASSANDRA-14538: -- Description: Add a table for displaying the general cache information (like in {{nodetool info}}) {code} cqlsh> SELECT * FROM system_views.caches; name| entries | hit_ratio | hits | recent_hits_per_sec | recent_requests_per_sec | requests | size_max | size_used -+-+---+--+-+-+--+--+--- counter | 0 | NaN |0 | 0 | 0 |0 | 12582912 | 0 key | 19 | 0.922509 | 250 | 11 | 13 | 271 | 25165824 | 1728 row | 0 | NaN |0 | 0 | 0 |0 | 16777216 | 0 (3 rows) was: Add a couple tables, one for displaying the general cache information (like in {{nodetool info}}) and another to view the contents (ish) of keycache. This would be pretty useful in tests to tell if things are in the cache and in finding wide partitions and performance issues. Possibility to discuss: DELETE on the key cache to evict specific records, I wrote the code to do it but im not sure if its valuable or worth complexity. TRUNCATE support on virtual tables might be nice as a way to clear the keycache as well. These can be followup tickets though if it seems like a good idea as truncate and delete are currently disabled in virtual tables and that behavior should maybe be its own ticket/discussion. {code} cqlsh> SELECT * FROM system_views.caches; name| entries | hit_ratio | hits | recent_hits_per_sec | recent_requests_per_sec | requests | size_max | size_used -+-+---+--+-+-+--+--+--- counter | 0 | NaN |0 | 0 | 0 |0 | 12582912 | 0 key | 19 | 0.922509 | 250 | 11 | 13 | 271 | 25165824 | 1728 row | 0 | NaN |0 | 0 | 0 |0 | 16777216 | 0 (3 rows) cqlsh> SELECT * FROM system_views.key_cache; keyspace_name | table_name | key | sstable | size ---+--+-+-+-- basic | wide |row1 | 5 | 64 basic | wide |row1 | 6 | 64 system |local | local | 15 | 24 system |local | local | 16 | 24 system |local | local | 17 | 24 system | sstable_activity | system_auth:roles:1 | 13 | 24 system_auth |roles | cassandra | 1 | 24 system_schema | tables | basic | 13 | 24 system_schema | tables | system_auth | 13 | 24 system_schema | tables | system_distributed | 13 | 24 system_schema | tables | system_traces | 13 | 24 system_schema | columns | basic | 13 | 24 system_schema | columns | system_auth | 13 | 24 system_schema | columns | system_distributed | 13 | 24 system_schema | columns | system_traces | 13 | 24 system_schema |keyspaces | basic | 13 | 24 system_schema |keyspaces | system_auth | 13 | 24 system_schema |keyspaces | system_distributed | 13 | 24 system_schema |keyspaces | system_traces | 13 | 24 (19 rows) {code} > Add virtual table to view cache information > --- > > Key: CASSANDRA-14538 > URL: https://issues.apache.org/jira/browse/CASSANDRA-14538 > Project: Cassandra > Issue Type: Improvement >Reporter: Chris Lohfink >Assignee: Chris Lohfink >Priority: Minor > Labels: virtual-tables > > Add a table for displaying the general cache information (like in {{nodetool > info}}) > {code} > cqlsh> SELECT * FROM system_views.caches; > name| entries | hit_ratio | hits | recent_hits_per_sec | > recent_requests_per_sec | requests | size_max | size_used > -+-+---+--+-+-+--+--+--- > counter | 0 | NaN |0 | 0 | > 0 |0 | 12582912 | 0 > key | 19 | 0.922509 | 250 | 11 | >
[jira] [Updated] (CASSANDRA-14538) Add virtual table to view cache information
[ https://issues.apache.org/jira/browse/CASSANDRA-14538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benjamin Lerer updated CASSANDRA-14538: --- Reviewer: Benjamin Lerer > Add virtual table to view cache information > --- > > Key: CASSANDRA-14538 > URL: https://issues.apache.org/jira/browse/CASSANDRA-14538 > Project: Cassandra > Issue Type: Improvement >Reporter: Chris Lohfink >Assignee: Chris Lohfink >Priority: Minor > Labels: virtual-tables > > Add a couple tables, one for displaying the general cache information (like > in {{nodetool info}}) and another to view the contents (ish) of keycache. > This would be pretty useful in tests to tell if things are in the cache and > in finding wide partitions and performance issues. > Possibility to discuss: DELETE on the key cache to evict specific records, I > wrote the code to do it but im not sure if its valuable or worth complexity. > TRUNCATE support on virtual tables might be nice as a way to clear the > keycache as well. These can be followup tickets though if it seems like a > good idea as truncate and delete are currently disabled in virtual tables and > that behavior should maybe be its own ticket/discussion. > > {code} > cqlsh> SELECT * FROM system_views.caches; > name| entries | hit_ratio | hits | recent_hits_per_sec | > recent_requests_per_sec | requests | size_max | size_used > -+-+---+--+-+-+--+--+--- > counter | 0 | NaN |0 | 0 | > 0 |0 | 12582912 | 0 > key | 19 | 0.922509 | 250 | 11 | > 13 | 271 | 25165824 | 1728 > row | 0 | NaN |0 | 0 | > 0 |0 | 16777216 | 0 > (3 rows) > cqlsh> SELECT * FROM system_views.key_cache; > keyspace_name | table_name | key | sstable | size > ---+--+-+-+-- > basic | wide |row1 | 5 | 64 > basic | wide |row1 | 6 | 64 > system |local | local | 15 | 24 > system |local | local | 16 | 24 > system |local | local | 17 | 24 > system | sstable_activity | system_auth:roles:1 | 13 | 24 >system_auth |roles | cassandra | 1 | 24 > system_schema | tables | basic | 13 | 24 > system_schema | tables | system_auth | 13 | 24 > system_schema | tables | system_distributed | 13 | 24 > system_schema | tables | system_traces | 13 | 24 > system_schema | columns | basic | 13 | 24 > system_schema | columns | system_auth | 13 | 24 > system_schema | columns | system_distributed | 13 | 24 > system_schema | columns | system_traces | 13 | 24 > system_schema |keyspaces | basic | 13 | 24 > system_schema |keyspaces | system_auth | 13 | 24 > system_schema |keyspaces | system_distributed | 13 | 24 > system_schema |keyspaces | system_traces | 13 | 24 > (19 rows) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org