Enabling and configuring caching
Using CQL to enable or disable caching.
Use CQL to enable or disable caching by configuring the caching table property. Set parameters in the
cassandra.yaml file to configure global caching
properties:
- Partition key cache size
- Row cache size
- How often DataStax Distribution of Apache Cassandra™ (DDAC) saves partition key caches to disk
- How often Cassandra saves row caches to disk
Configuring the row_cache_size_in_mb (in the cassandra.yaml configuration file) determines how much space in memory the database allocates to store rows from the most frequently read partitions of the table.
cassandra.yaml
- The cassandra.yaml file is located in the installation_location/conf directory.
Procedure
Set the table caching property that configures the partition key cache and the
row cache.
CREATE TABLE users (
userid text PRIMARY KEY,
first_name text,
last_name text,
)
WITH caching = { 'keys' : 'NONE', 'rows_per_partition' : '120' };