System Variables for MariaDB Xpand

This page is part of MariaDB's Documentation.

The parent of this page is: Reference for MariaDB Xpand

Topics on this page:

Overview
Summary of Xpand System Variables

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.

Summary of Xpand System Variables

Variable	In 23.09?	In 6.1?	In 6.0?	In 5.3?
activate_all_roles_on_login	23.09
alter_hold_until_checkpoint	23.09	6.1
alter_lock	23.09	6.1
arp_period_ms	23.09
autocommit	23.09	6.1	6.0	5.3
column_table_def_card		6.1	6.0	5.3
columnar_frame_size			6.0
consistent_order	23.09	6.1	6.0	5.3
cost_node	23.09
cost_read_columnar	23.09
default_password_lifetime	23.09	6.1	6.0
default_storage_engine	23.09
device_temporary_space_limit_bytes	23.09	6.1	6.0	5.3
discourage_non_sarge_threshold	23.09	6.1
enable_rule_eliminate_inner_join_rule	23.09
enable_rule_filter_or_rewrite_to_and	23.09
enable_rule_join_commute_mtable_rule	23.09
foreign_key_checks	23.09	6.1	6.0	5.3
gtm_pc_max_per_node_mb	23.09
hash_aggregate_partial_skiplist_threshold	23.09
interactive_timeout	23.09	6.1	6.0	5.3
join_swap_threshold		6.1
ldap_cache_enabled	23.09
ldap_cache_entry_lifetime_s	23.09
ldap_cache_max_bytes	23.09
ldap_enabled	23.09
ldap_group_query	23.09
ldap_group_to_xpand_role	23.09
ldap_network_timeout_s	23.09
ldap_query_password	23.09
ldap_query_user	23.09
ldap_servers	23.09
ldap_tls_cacert	23.09
ldap_user_lookup	23.09
ldap_user_lookup_query	23.09
ldap_user_lookup_substitution	23.09
lockman_max_locks	23.09	6.1	6.0	5.3
lockman_max_transaction_locks	23.09	6.1	6.0	5.3
max_allowed_packet	23.09	6.1	6.0	5.3
max_connections	23.09	6.1	6.0	5.3
max_sierra_opt_mem_MiB	23.09	6.1	6.0	5.3
max_sierra_parse_mem_MiB	23.09	6.1	6.0	5.3
max_sierra_plan_s	23.09	6.1	6.0	5.3
max_sierra_tot_mem_MiB	23.09	6.1	6.0	5.3
max_sierra_working_mem_MiB	23.09	6.1	6.0	5.3
mysql_version	23.09	6.1	6.0	5.3
proc_vrels_disable	23.09	6.1
queue_daddy_replay_concurrency	23.09
queue_daddy_replay_limit_ms	23.09
rebalancer_optional_tasks_enabled	23.09	6.1	6.0	5.3
rebalancer_split_threshold_kb	23.09	6.1	6.0	5.3
session_log_slow_threshold_ms	23.09	6.1	6.0	5.3
sierra_flt_over_join_card_adj	23.09
sierra_join_swap_threshold	23.09
sierra_limit_join_swap	23.09
sierra_min_nlj_outer	23.09	6.1
sierra_new_card_override	23.09
sierra_systab_def_card	23.09
sierra_use_def_systab_card		6.1	6.0	5.3
simple_password_check_digits	23.09	6.1	6.0
simple_password_check_letters_same_case	23.09	6.1	6.0
simple_password_check_minimal_length	23.09	6.1	6.0
simple_password_check_other_characters	23.09	6.1	6.0
storage_engine	23.09
straight_join_threshold		6.1
strict_password_validation	23.09	6.1	6.0
system_time_zone	23.09	6.1	6.0	5.3
task_rebalancer_rebalance_regions_interval_ms	23.09
tracefile	23.09
vrel_enable_cache	23.09	6.1
vrel_timeout_ms	23.09	6.1
wait_timeout	23.09	6.1	6.0	5.3

Variable	In 6.0?	In 5.3?
autocommit	6.0	5.3
column_table_def_card	6.0	5.3
columnar_frame_size	6.0
consistent_order	6.0	5.3
default_password_lifetime	6.0
device_temporary_space_limit_bytes	6.0	5.3
foreign_key_checks	6.0	5.3
interactive_timeout	6.0	5.3
lockman_max_locks	6.0	5.3
lockman_max_transaction_locks	6.0	5.3
max_allowed_packet	6.0	5.3
max_connections	6.0	5.3
max_sierra_opt_mem_MiB	6.0	5.3
max_sierra_parse_mem_MiB	6.0	5.3
max_sierra_plan_s	6.0	5.3
max_sierra_tot_mem_MiB	6.0	5.3
max_sierra_working_mem_MiB	6.0	5.3
mysql_version	6.0	5.3
rebalancer_optional_tasks_enabled	6.0	5.3
rebalancer_split_threshold_kb	6.0	5.3
session_log_slow_threshold_ms	6.0	5.3
sierra_use_def_systab_card	6.0	5.3
simple_password_check_digits	6.0
simple_password_check_letters_same_case	6.0
simple_password_check_minimal_length	6.0
simple_password_check_other_characters	6.0
strict_password_validation	6.0
system_time_zone	6.0	5.3
wait_timeout	6.0	5.3

Variable	In 6.1?
alter_hold_until_checkpoint	6.1
alter_lock	6.1
autocommit	6.1
column_table_def_card	6.1
consistent_order	6.1
default_password_lifetime	6.1
device_temporary_space_limit_bytes	6.1
discourage_non_sarge_threshold	6.1
foreign_key_checks	6.1
interactive_timeout	6.1
join_swap_threshold	6.1
lockman_max_locks	6.1
lockman_max_transaction_locks	6.1
max_allowed_packet	6.1
max_connections	6.1
max_sierra_opt_mem_MiB	6.1
max_sierra_parse_mem_MiB	6.1
max_sierra_plan_s	6.1
max_sierra_tot_mem_MiB	6.1
max_sierra_working_mem_MiB	6.1
mysql_version	6.1
proc_vrels_disable	6.1
rebalancer_optional_tasks_enabled	6.1
rebalancer_split_threshold_kb	6.1
session_log_slow_threshold_ms	6.1
sierra_min_nlj_outer	6.1
sierra_use_def_systab_card	6.1
simple_password_check_digits	6.1
simple_password_check_letters_same_case	6.1
simple_password_check_minimal_length	6.1
simple_password_check_other_characters	6.1
straight_join_threshold	6.1
strict_password_validation	6.1
system_time_zone	6.1
vrel_enable_cache	6.1
vrel_timeout_ms	6.1
wait_timeout	6.1