System Variables for MariaDB Xpand 6.1

Overview

MariaDB Xpand supports system variables for configuration and monitoring. Many of the system variables are intended to function like the system variables in MariaDB Enterprise Server, but MariaDB Xpand also supports its own unique system variables.

System variables can be used to configure and monitor MariaDB Xpand 6.1.

Reference material is available for MariaDB Xpand 6.1.

System Variables for MariaDB Xpand 6.1

Variable

Description

alter_hold_until_checkpoint

Hold alter statement completion until all transactions prior to alter have committed

alter_lock

Specifies the implicit locking strategy for ALTER when the LOCK syntax is omitted. WARNING: changing this variable can result in unexpected table locks. Choices: NONE, SHARED, AUTO

autocommit

Each statement will be its own transaction, and automatically applied to the database

column_table_def_card

Default cardinality of columnar table before PDs available

consistent_order

Force consistent ordering. See Guide.

default_password_lifetime

Number of days before passwords expire by default. Zero means automatic password expiration is disabled.

device_temporary_space_limit_bytes

Maximum number of bytes allowed to be used for temporary containers

discourage_non_sarge_threshold

Discourage a non sarged plan if the table cardinality is less than or equal to this threshold

foreign_key_checks

Enable/Disable foreign key checks

interactive_timeout

Dummy variable for compatibility

join_swap_threshold

If number of tables_exceeds - swap filtering tables only

lockman_max_locks

The maximum number of locks the lock manager will hold on each node in the cluster

lockman_max_transaction_locks

The maximum number of locks a single transaction can hold on each node in the cluster

max_allowed_packet

Maximum allowed query size

max_connections

The maximum number of connections allowed per node

max_sierra_opt_mem_MiB

Cease Sierra planner optimization attempts once we have used this many total MiB and attempt to continue with the best plan found so far

max_sierra_parse_mem_MiB

Halt the Sierra planner and return an error to the user if this many MiB have been consumed during the initial parse phase. This variable is independent of the other max_sierra_%_mem_MiB variables.

max_sierra_plan_s

Stop the sierra planner once the planner has been working this long on a plan. Specify 0 to disable this check.

max_sierra_tot_mem_MiB

Halt the Sierra planner and return an error to the user once this many total MiB have been used. This value should always be at least 50MiB greater than max_sierra_opt_mem_MiB.

max_sierra_working_mem_MiB

Halt the Sierra planner and return an error to the user if the working set memory exceeds this many MiB limit. This variable is independent of the other max_sierra_%_mem_MiB variables.

mysql_version

The reported MySQL server version

proc_vrels_disable

rebalancer_optional_tasks_enabled

Controls whether non-essential rebalancer tasks should be running

rebalancer_split_threshold_kb

Default size at which the rebalancer splits slices

session_log_slow_threshold_ms

Query duration threshold in milliseconds before logging this query

sierra_min_nlj_outer

sierra_use_def_systab_card

Use default system table cardinality

simple_password_check_digits

Number of digits that passwords must contain

simple_password_check_letters_same_case

Passwords must contain this number of upper-case letters and this number of lower-case letters

simple_password_check_minimal_length

Number of total characters that passwords must contain

simple_password_check_other_characters

Number of non-letter and non-digit characters that passwords must contain

straight_join_threshold

If number of tables exceeds - use straight_join internally

strict_password_validation

Passwords may not be set with hashes if password validation is enabled

system_time_zone

Time Zone. Must be set in Olson time zone format. See Guide.

vrel_enable_cache

enable caching for certain virtual relations

vrel_timeout_ms

timeout for timeout-enabled virtual relations

wait_timeout

Number of seconds to wait for activity on a connection before closing it

The following System Variables are not present in MariaDB Xpand 6.1.2 but are present in one or more older 6.1 versions. Click on an item to see its details, including when it was removed.

Variable

Description

columnar_frame_size

Number of values per frame

To see system variables supported in other versions, see "System Variables by Xpand Version".