Configure your Database Server(s)

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

Configuration Manager

https://app.skysql.com/settings/configuration-manager

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

lower_case_table_names

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: