Configuration Management

Overview

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

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:

  1. Log in to the Portal.

  2. Click the "Settings" link in the main menu (left navigation in the Portal).

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