Cassandra System Variables

This page documents system variables related to the Cassandra storage engine. See Server System Variables for a complete list of system variables and instructions on setting them.

cassandra_default_thrift_host

• Description: Host to connect to, if not specified on per-table basis.
• Scope: Global
• Dynamic: Yes
• Data Type: string

cassandra_failure_retries

• Description: Number of times to retry on timeout/unavailable failures.
• Scope: Global, Session
• Dynamic: Yes
• Data Type: numeric
• Default Value: 3
• Valid Values: 1 to 1073741824

cassandra_insert_batch_size

• Description: INSERT batch size.
• Scope: Global, Session
• Dynamic: Yes
• Data Type: numeric
• Default Value: 100
• Valid Values: 1 to 1073741824

cassandra_multiget_batch_size

• Description: Batched Key Access batch size.
• Scope: Global, Session
• Dynamic: Yes
• Data Type: numeric
• Default Value: 100
• Valid Values: 1 to 1073741824

cassandra_read_consistency

• Description: Consistency to use for reading. See Datastax's documentation for details.
• Scope: Global, Session
• Default Value: ONE
• Valid Values: ONE, TWO, THREE, ANY, ALL, QUORUM, EACH_QUORUM, LOCAL_QUORUM,

cassandra_rnd_batch_size

• Description: Full table scan batch size.
• Scope: Global, Session
• Default Value: 10000
• Valid Values: 1 to 1073741824

cassandra_write_consistency

• Description: Consistency to use for writing. See Datastax's documentation for details.
• Scope: Global, Session
• Default Value: ONE
• Valid Values: ONE, TWO, THREE, ANY, ALL, QUORUM, EACH_QUORUM, LOCAL_QUORUM,