System Variables for MariaDB Xpand 5.3

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 5.3.

Reference material is available for MariaDB Xpand 5.3.

System Variables for MariaDB Xpand 5.3

Variable

Description

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.

device_temporary_space_limit_bytes

Maximum number of bytes allowed to be used for temporary containers

foreign_key_checks

Enable/Disable foreign key checks

interactive_timeout

Dummy variable for compatibility

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

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_use_def_systab_card

Use default system table cardinality

system_time_zone

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

wait_timeout

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

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