This is what I have in cassandra.yaml
prepared_statements_cache_size_mb: 500MB
Is it possible to see the actual value of that variable once you're in cqlsh?
How to see the actual configuration values for apache cassandra in cqlsh?
Viewed 657
2 Answers
Since Cassandra 4.0 you'll able to do that by reading from system_views.settings table.
Because CQL statements are sent to the cluster (which should be three or more nodes), you can't use CQL to read settings on an individual node. The value for prepared_statements_cache is just for that node.
You could use JMX to read org.apache.cassandra.config.Config on a node, including prepared_statements_cache_size_mb.
Related