System Variables for MariaDB Xpand 5.3
This page is part of MariaDB's Documentation.
The parent of this page is: Reference for MariaDB Xpand 5.3
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 5.3.
Reference material is available for MariaDB Xpand 5.3.
System Variables for MariaDB Xpand 5.3
Variable | Description |
---|---|
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. | |
Maximum number of bytes allowed to be used for temporary containers | |
Enable/Disable foreign key checks | |
Dummy variable for compatibility | |
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 | |
Time Zone. Must be set in Olson time zone format. See Guide. | |
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".