[CASSANDRA-14538] Add virtual table to view cache information

• Type: Improvement
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 4.0-alpha1, 4.0
• Labels: virtual-tables
• Assignee: Chris Lohfink
• Reporter: Chris Lohfink

Authors

Chris Lohfink

Reviewers

Aleksey Yeschenko

• Created: 22/Jun/18 15:10
• Updated: 16/Mar/22 11:46
• Resolved: 03/Aug/18 17:18

Description

 Add a table for displaying the general cache information (like in nodetool info)

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)

Issue Links

• links to: GitHub Pull Request #238