System Variables for MariaDB Xpand 6.1
This page is part of MariaDB's Documentation.
The parent of this page is: Reference for MariaDB Xpand 6.1
Topics on this page:
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 |
---|---|
Hold alter statement completion until all transactions prior to alter have committed | |
Specifies the implicit locking strategy for | |
Each statement will be its own transaction, and automatically applied to the database | |
Default cardinality of columnar table before PDs available | |
Force consistent ordering. See Guide. | |
Number of days before passwords expire by default. Zero means automatic password expiration is disabled. | |
Maximum number of bytes allowed to be used for temporary containers | |
Discourage a non sarged plan if the table cardinality is less than or equal to this threshold | |
Enable/Disable foreign key checks | |
Dummy variable for compatibility | |
If number of tables_ | |
The maximum number of locks the lock manager will hold on each node in the cluster | |
The maximum number of locks a single transaction can hold on each node in the cluster | |
Maximum allowed query size | |
The maximum number of connections allowed per node | |
Cease Sierra planner optimization attempts once we have used this many total MiB and attempt to continue with the best plan found so far | |
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_ | |
Stop the sierra planner once the planner has been working this long on a plan. Specify 0 to disable this check. | |
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_ | |
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_ | |
The reported MySQL server version | |
Controls whether non-essential rebalancer tasks should be running | |
Default size at which the rebalancer splits slices | |
Query duration threshold in milliseconds before logging this query | |
Use default system table cardinality | |
Number of digits that passwords must contain | |
Passwords must contain this number of upper-case letters and this number of lower-case letters | |
Number of total characters that passwords must contain | |
Number of non-letter and non-digit characters that passwords must contain | |
If number of tables exceeds - use straight_ | |
Passwords may not be set with hashes if password validation is enabled | |
Time Zone. Must be set in Olson time zone format. See Guide. | |
enable caching for certain virtual relations | |
timeout for timeout-enabled virtual relations | |
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 |
---|---|
Number of values per frame |
To see system variables supported in other versions, see "System Variables by Xpand Version".