Configuration Management

This page is part of MariaDB's Documentation.

The parent of this page is: Service Management

Topics on this page:

Overview
Compatibility
Access to Configuration Manager
What is configurable?

Overview

Database server configuration, including system variables, is managed through the Configuration Manager.

Configuration Manager
^{https://skysql.mariadb.com/settings/configuration-manager}

Compatibility

Enterprise Server Single Node
Enterprise Server With Replica(s)
ColumnStore Data Warehouse

Access to Configuration Manager

To access the Configuration Manager interface:

Log in to the Portal.
Click the "Settings" link in the main menu (left navigation in the Portal).
Click the "Configuration Manager" button.

What is configurable?

Available configuration parameters differ by cloud database topology.

Enterprise Server Single Node

For cloud databases with the Enterprise Server Single Node topology, the following Configuration Manager parameters are used to configure MariaDB Enterprise Server behavior:

Parameter
auto_increment_increment
autocommit
connect_timeout
cracklib_password_check
default_password_lifetime
default_time_zone
disconnect_on_expired_password
div_precision_increment
eq_range_index_dive_limit
event_scheduler
expire_logs_days
explicit_defaults_for_timestamp
idle_readonly_transaction_timeout
idle_transaction_timeout
idle_write_transaction_timeout
innodb_autoextend_increment
innodb_change_buffering
innodb_flush_log_at_trx_commit
innodb_log_file_size
innodb_strict_mode
interactive_timeout
local_infile
log_output
log_slow_filter
log_slow_rate_limit
log_slow_verbosity
log_warnings
long_query_time
lower_case_table_names
max_allowed_packet
max_connections
max_password_errors
net_buffer_length
net_write_timeout
optimizer_search_depth
performance_schema
performance_schema_accounts_size
performance_schema_digests_size
performance_schema_events_stages_history_long_size
performance_schema_events_stages_history_size
performance_schema_events_statements_history_long_size
performance_schema_events_statements_history_size
performance_schema_events_waits_history_long_size
performance_schema_events_waits_history_size
performance_schema_hosts_size
performance_schema_max_cond_classes
performance_schema_max_cond_instances
performance_schema_max_digest_length
performance_schema_max_file_classes
performance_schema_max_file_handles
performance_schema_max_file_instances
performance_schema_max_mutex_classes
performance_schema_max_mutex_instances
performance_schema_max_rwlock_classes
performance_schema_max_rwlock_instances
performance_schema_max_socket_classes
performance_schema_max_socket_instances
performance_schema_max_stage_classes
performance_schema_max_table_handles
performance_schema_max_table_instances
performance_schema_max_thread_classes
performance_schema_max_thread_instances
performance_schema_session_connect_attrs_size
performance_schema_users_size
proxy_protocol_networks
read_only
server_audit
server_audit_file_rotate_size
server_audit_logging
session_track_system_variables
simple_password_check_digits
simple_password_check_letters_same_case
simple_password_check_minimal_length
simple_password_check_other_characters
slow_query_log
sort_buffer_size
sql_mode
strict_password_validation
system_versioning_alter_history
thread_cache_size
thread_handling
thread_pool_idle_timeout
thread_pool_max_threads
thread_pool_priority
transaction_isolation
wait_timeout

Enterprise Server With Replica(s)

For cloud databases with the Enterprise Server With Replica(s) topology, Configuration Manager can be used to configure MariaDB Enterprise Server behavior and MariaDB MaxScale behavior.

The following Configuration Manager parameters are used to configure MariaDB Enterprise Server behavior:

Parameter
auto_increment_increment
autocommit
binlog_commit_wait_count
binlog_commit_wait_usec
connect_timeout
cracklib_password_check
default_password_lifetime
default_time_zone
disconnect_on_expired_password
div_precision_increment
eq_range_index_dive_limit
event_scheduler
expire_logs_days
explicit_defaults_for_timestamp
gtid_strict_mode
idle_readonly_transaction_timeout
idle_transaction_timeout
idle_write_transaction_timeout
innodb_autoextend_increment
innodb_change_buffering
innodb_flush_log_at_trx_commit
innodb_log_file_size
innodb_strict_mode
interactive_timeout
local_infile
log_output
log_slow_filter
log_slow_rate_limit
log_slow_verbosity
log_warnings
long_query_time
lower_case_table_names
max_allowed_packet
max_connections
max_password_errors
net_buffer_length
net_write_timeout
optimizer_search_depth
performance_schema
performance_schema_accounts_size
performance_schema_digests_size
performance_schema_events_stages_history_long_size
performance_schema_events_stages_history_size
performance_schema_events_statements_history_long_size
performance_schema_events_statements_history_size
performance_schema_events_waits_history_long_size
performance_schema_events_waits_history_size
performance_schema_hosts_size
performance_schema_max_cond_classes
performance_schema_max_cond_instances
performance_schema_max_digest_length
performance_schema_max_file_classes
performance_schema_max_file_handles
performance_schema_max_file_instances
performance_schema_max_mutex_classes
performance_schema_max_mutex_instances
performance_schema_max_rwlock_classes
performance_schema_max_rwlock_instances
performance_schema_max_socket_classes
performance_schema_max_socket_instances
performance_schema_max_stage_classes
performance_schema_max_table_handles
performance_schema_max_table_instances
performance_schema_max_thread_classes
performance_schema_max_thread_instances
performance_schema_session_connect_attrs_size
performance_schema_users_size
proxy_protocol_networks
read_only
rpl_semi_sync_master_enabled
rpl_semi_sync_master_timeout
rpl_semi_sync_master_wait_no_slave
rpl_semi_sync_master_wait_point
rpl_semi_sync_slave_delay_master
rpl_semi_sync_slave_enabled
rpl_semi_sync_slave_kill_conn_timeout
server_audit
server_audit_file_rotate_size
server_audit_logging
session_track_system_variables
simple_password_check_digits
simple_password_check_letters_same_case
simple_password_check_minimal_length
simple_password_check_other_characters
slave_compressed_protocol
slave_parallel_mode
slave_parallel_threads
slave_parallel_workers
slow_query_log
sort_buffer_size
sql_mode
strict_password_validation
sync_binlog
sync_master_info
sync_relay_log
sync_relay_log_info
system_versioning_alter_history
thread_cache_size
thread_handling
thread_pool_idle_timeout
thread_pool_max_threads
thread_pool_priority
transaction_isolation
wait_timeout

The following Configuration Manager parameters are used to configure MariaDB MaxScale behavior:

Parameter
causal_reads
causal_reads_timeout
delayed_retry
delayed_retry_timeout
failcount
master_accept_reads
master_reconnection
max_slave_connections
max_slave_replication_lag
monitor_interval
slave_selection_criteria
strict_multi_stmt
strict_sp_calls
transaction_replay
transaction_replay_attempts
transaction_replay_max_size
transaction_replay_retry_on_deadlock
use_sql_variables_in

ColumnStore Data Warehouse

For cloud databases with the ColumnStore Data Warehouse topology, the following Configuration Manager parameters are used to configure MariaDB Enterprise Server behavior:

Parameter
auto_increment_increment
autocommit
connect_timeout
cracklib_password_check
default_password_lifetime
disconnect_on_expired_password
div_precision_increment
eq_range_index_dive_limit
event_scheduler
expire_logs_days
explicit_defaults_for_timestamp
idle_readonly_transaction_timeout
idle_transaction_timeout
idle_write_transaction_timeout
innodb_autoextend_increment
innodb_change_buffering
innodb_flush_log_at_trx_commit
innodb_log_file_size
innodb_strict_mode
interactive_timeout
local_infile
log_output
log_slow_filter
log_slow_rate_limit
log_slow_verbosity
log_warnings
long_query_time
lower_case_table_names
max_allowed_packet
max_connections
max_password_errors
net_buffer_length
net_write_timeout
optimizer_search_depth
performance_schema
performance_schema_accounts_size
performance_schema_digests_size
performance_schema_events_stages_history_long_size
performance_schema_events_stages_history_size
performance_schema_events_statements_history_long_size
performance_schema_events_statements_history_size
performance_schema_events_waits_history_long_size
performance_schema_events_waits_history_size
performance_schema_hosts_size
performance_schema_max_cond_classes
performance_schema_max_cond_instances
performance_schema_max_digest_length
performance_schema_max_file_classes
performance_schema_max_file_handles
performance_schema_max_file_instances
performance_schema_max_mutex_classes
performance_schema_max_mutex_instances
performance_schema_max_rwlock_classes
performance_schema_max_rwlock_instances
performance_schema_max_socket_classes
performance_schema_max_socket_instances
performance_schema_max_stage_classes
performance_schema_max_table_handles
performance_schema_max_table_instances
performance_schema_max_thread_classes
performance_schema_max_thread_instances
performance_schema_session_connect_attrs_size
performance_schema_users_size
proxy_protocol_networks
read_only
server_audit
server_audit_file_rotate_size
server_audit_logging
session_track_system_variables
simple_password_check_digits
simple_password_check_letters_same_case
simple_password_check_minimal_length
simple_password_check_other_characters
slow_query_log
sort_buffer_size
strict_password_validation
system_versioning_alter_history
thread_cache_size
thread_handling
thread_pool_idle_timeout
thread_pool_max_threads
thread_pool_priority
transaction_isolation
wait_timeout

Xpand Distributed SQL

For cloud databases with the Xpand Distributed SQL topology, the following Configuration Manager parameters are used to configure MariaDB Xpand behavior:

Parameter
alter_hold_until_checkpoint
alter_lock
autocommit
default_password_lifetime
device_temporary_space_limit_bytes
foreign_key_checks
interactive_timeout
lockman_max_locks
lockman_max_transaction_locks
max_allowed_packet
max_connections
max_sierra_opt_mem_MiB
max_sierra_parse_mem_MiB
max_sierra_plan_s
max_sierra_tot_mem_MiB
max_sierra_working_mem_MiB
mysql_version
rebalancer_optional_tasks_enabled
rebalancer_split_threshold_kb
session_log_slow_threshold_ms
simple_password_check_digits
simple_password_check_letters_same_case
simple_password_check_minimal_length
simple_password_check_other_characters
strict_password_validation
system_time_zone
wait_timeout