> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/server-usage/storage-engines/legacy-storage-engines/cassandra/cassandra-system-variables.md).

# Cassandra System Variables

{% hint style="info" %}
The Cassandra storage engine was removed in MariaDB 10.6.
{% endhint %}

This page documents system variables related to the [Cassandra storage engine](/docs/server/server-usage/storage-engines/legacy-storage-engines/cassandra.md). See [Server System Variables](/docs/server/server-management/variables-and-modes/server-system-variables.md) 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](https://www.datastax.com/documentation/cassandra/2.0/cassandra/dml/dml_config_consistency_c.html) 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](https://www.datastax.com/documentation/cassandra/2.0/cassandra/dml/dml_config_consistency_c.html) for details.
* Scope: Global, Session
* Default Value: `ONE`
* Valid Values: `ONE`, `TWO`, `THREE`, `ANY`, `ALL`, `QUORUM`, `EACH_QUORUM`, `LOCAL_QUORUM`, \`\`

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}