System Variables for MariaDB Xpand 6.0

This page is part of MariaDB's Documentation.

The parent of this page is: Reference for MariaDB Xpand 6.0

Topics on this page:

Overview
System Variables for MariaDB Xpand 6.0

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

Reference material is available for MariaDB Xpand 6.0.

System Variables for MariaDB Xpand 6.0

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
columnar_frame_size	Number of values per frame
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
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
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
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.
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".