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:

Name Default Value
auto_increment_increment 1
autocommit ON
binlog_cache_size 32768
binlog_format ROW
connect_timeout 5
cracklib_password_check OFF
default_password_lifetime 0
default_time_zone system
disconnect_on_expired_password OFF
div_precision_increment 4
eq_range_index_dive_limit 200
event_scheduler OFF
expire_logs_days 4
explicit_defaults_for_timestamp OFF
gtid_strict_mode ON
host_cache_size 248
idle_readonly_transaction_timeout 0
idle_transaction_timeout 0
idle_write_transaction_timeout 0
innodb_autoextend_increment 64
innodb_autoinc_lock_mode 2
innodb_buffer_pool_size AUTO_GENERATED
innodb_change_buffering none
innodb_flush_log_at_trx_commit 1
innodb_log_buffer_size 16777216
innodb_log_file_size 1073741824
innodb_strict_mode ON
interactive_timeout 3600
join_buffer_size 262144
local_infile ON
log_output FILE
log_slow_filter admin, filesort, filesort_on_disk, filesort_priority_queue, full_join, full_scan, query_cache, query_cache_miss, tmp_table, tmp_table_on_disk
log_slow_rate_limit 1
log_slow_verbosity
log_warnings 2
long_query_time 10.0
lower_case_table_names 0
max_allowed_packet 33554432
max_connections AUTO_GENERATED
max_heap_table_size 16777216
max_password_errors 4294967295
net_buffer_length 16384
net_write_timeout 60
open_files_limit 0
optimizer_search_depth 62
optimizer_switch AUTO_GENERATED
performance_schema OFF
performance_schema_accounts_size -1
performance_schema_digests_size -1
performance_schema_events_stages_history_long_size -1
performance_schema_events_stages_history_size -1
performance_schema_events_statements_history_long_size -1
performance_schema_events_statements_history_size -1
performance_schema_events_waits_history_long_size -1
performance_schema_events_waits_history_size -1
performance_schema_hosts_size -1
performance_schema_max_cond_classes 90
performance_schema_max_cond_instances -1
performance_schema_max_digest_length 1024
performance_schema_max_file_classes 80
performance_schema_max_file_handles 32768
performance_schema_max_file_instances -1
performance_schema_max_mutex_classes 200
performance_schema_max_mutex_instances -1
performance_schema_max_rwlock_classes 50
performance_schema_max_rwlock_instances -1
performance_schema_max_socket_classes 10
performance_schema_max_socket_instances 10
performance_schema_max_stage_classes 160
performance_schema_max_table_handles -1
performance_schema_max_table_instances -1
performance_schema_max_thread_classes 50
performance_schema_max_thread_instances -1
performance_schema_session_connect_attrs_size -1
performance_schema_users_size -1
proxy_protocol_networks
read_buffer_size 131072
read_only OFF
read_rnd_buffer_size 262144
require_secure_transport AUTO_GENERATED
server_audit ON
server_audit_file_rotate_size 1000000
server_audit_logging OFF
session_track_system_variables autocommit, character_set_client, character_set_connection, character_set_results, time_zone
simple_password_check_digits 1
simple_password_check_letters_same_case 1
simple_password_check_minimal_length 8
simple_password_check_other_characters 1
slow_query_log OFF
sort_buffer_size 2097152
sql_mode ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES
strict_password_validation ON
sync_binlog 1
system_versioning_alter_history ERROR
table_open_cache AUTO_GENERATED
thread_cache_size 256
thread_handling one-thread-per-connection
thread_pool_idle_timeout 60
thread_pool_max_threads 65536
thread_pool_priority auto
thread_stack 299008
tmp_table_size AUTO_GENERATED
transaction_isolation REPEATABLE-READ
wait_timeout 600