Keyboard users: Escape to exit.
MariaDB Documentation /
MariaDB ColumnStore (Analytics)MariaDB Server (SQL Database Server)MariaDB SkySQL previous releaseMariaDB SkySQL DBaaS /
Reference /
Reference for MariaDB Enterprise Server /
System Variables for MariaDB Enterprise Server /
columnstore_
MariaDB Documentation
::
MariaDB SkySQL
::
MariaDB SkySQL DBaaS
::
MariaDB SkySQL Observability
::
MariaDB SkySQL Cloud Backup
::
MariaDB Geospatial
::
MariaDB SkySQL previous release
::
MariaDB Server
::
MariaDB Xpand
::
MariaDB ColumnStore
Topics:
Available Documentation:
Topics on This Page
This page is part of MariaDB's Documentation.
The parent of this page is: System Variables for MariaDB Enterprise Server
Topics on this page:
In 10.6 ES, 10.6 CS, 10.5 ES, 10.5 CS:
Threshold on the number of rows in the cache to trigger a flush
In 10.6 ES, 10.5 ES:
Threshold on the number of rows in the cache to trigger a flush
In 10.4 ES, 10.4 CS, 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:
Not present
In 10.4 ES:
Not present
See also: System Variables for MariaDB Enterprise Server 10.6, in 10.5 ES, in 10.4 ES, in 10.3 ES, in 10.2 ES, in 10.6 CS, in 10.5 CS, in 10.4 CS, in 10.3 CS, and in 10.2 CS
See also: System Variables for MariaDB Enterprise Server 10.6, in 10.5 ES, and in 10.4 ES
Command-line | --columnstore_cache_flush_threshold=# |
Configuration file | Supported |
Dynamic | Yes |
Scope | Global, Session |
Data Type | BIGINT UNSIGNED |
Minimum Value | 1 |
Maximum Value | 1000000000 |
Product Default Value | 500000 |
Cloud | SkySQL Topology | ES Ver | Service Default |
|---|---|---|---|
AWS | Multi-Node Analytics | 10.6 | 500000 |
Single Node Analytics | 10.6 | 500000 | |
Replicated Transactions | 10.4 | Not present | |
10.5 | Not present | ||
10.6 | Not present | ||
Single Node Transactions | 10.4 | Not present | |
10.5 | Not present | ||
10.6 | Not present | ||
GCP | Multi-Node Analytics | 10.6 | 500000 |
Single Node Analytics | 10.6 | 500000 | |
Replicated Transactions | 10.4 | Not present | |
10.5 | Not present | ||
10.6 | Not present | ||
Single Node Transactions | 10.4 | Not present | |
10.5 | Not present | ||
10.6 | Not present |
Cloud | SkySQL Topology | ES Ver | Service Default |
|---|---|---|---|
AWS | ColumnStore Data Warehouse | 10.6 | 500000 |
Enterprise Server With Replica(s) | 10.4 | Not present | |
10.5 | Not present | ||
10.6 | Not present | ||
Enterprise Server Single Node | 10.4 | Not present | |
10.5 | Not present | ||
10.6 | Not present | ||
GCP | ColumnStore Data Warehouse | 10.6 | 500000 |
Enterprise Server With Replica(s) | 10.4 | Not present | |
10.5 | Not present | ||
10.6 | Not present | ||
Enterprise Server Single Node | 10.4 | Not present | |
10.5 | Not present | ||
10.6 | Not present |
See SkySQL details in MariaDB SkySQL previous release
See SkySQL details in MariaDB SkySQL new release
Release Series | History |
|---|---|
10.6 Enterprise |
|
10.6 Community |
|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
Release Series | History |
|---|---|
10.6 Enterprise |
|
10.5 Enterprise |
|
10.4 Enterprise |
|
