ColumnStore System Variables
You are viewing an old version of this article. View
the current version here.
| Name | Cmd-Line | Scope | Data type | Default Value | Range |
|---|---|---|---|---|---|
| infinidb_compression_type | Yes | Both | enumeration | 2 | 0,2 |
| infinidb_decimal_scale | Yes | Both | numeric | 8 | |
| infinidb_diskjoin_bucketsize | Yes | Both | numeric | 100 | |
| infinidb_diskjoin_largesidelimit | Yes | Both | numeric | 0 | |
| infinidb_diskjoin_smallsidelimit | Yes | Both | numeric | 0 | |
| infinidb_double_for_decimal_math | Yes | Both | enumeration | OFF | OFF, ON |
| infinidb_import_for_batchinsert_delimiter | Yes | Both | numeric | 7 | |
| infinidb_import_for_batchinsert_enclosed_by | Yes | Both | numeric | 17 | |
| infinidb_local_query | Yes | Both | enumeration | 0 | 0,1 |
| infinidb_ordered_only | Yes | Both | enumeration | OFF | OFF, ON |
| infinidb_string_scan_threshold | Yes | Both | numeric | 10 | |
| infinidb_stringtable_threshold | Yes | Both | numeric | 20 | |
| infinidb_um_mem_limit | Yes | Both | numeric | 0 | |
| infinidb_use_decimal_scale | Yes | Both | enumeration | OFF | OFF, ON |
| infinidb_use_import_for_batchinsert | Yes | Both | enumeration | ON | OFF, ON |
| infinidb_varbin_always_hex | Yes | Both | enumeration | ON | OFF, ON |
| infinidb_vtable_mode | Yes | Both | enumeration | 1 | 0,1,2 |
Compression Mode:
infinidb_compression_type:
MariaDB ColumnStore has the ability to compress data and is controlled through a compression mode. This compression mode may be set as a default Golbally or set at the session level.
To set the compression mode at the session level, the following command is used. Once the session has ended, any subsequent session will return to the default for the instance.
set infinidb_compression_type = n
where n is:
- 0) compression is turned off. Any subsequent table create statements run will have compression turned off for that table unless any statement overrides have been performed. Any alter statements run to add a column will have compression turned off for that column unless any statement override has been performed.
- 2) compression is turned on. Any subsequent table create statements run will have compression turned on for that table unless any statement overrides have been performed. Any alter statements run to add a column will have compression turned on for that column unless any statement override has been performed.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
