MariaDB Server Single Node

Configuration Manager parameters for the MariaDB Server Single Node topology in MariaDB Cloud, including binlog format, autocommit, cache sizes, and replication-related settings.

For cloud databases with the MariaDB Server Single Node topology, the following Configuration Manager parameters are used to configure MariaDB 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	10.0.0.0/8
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

_{This page is: Copyright © 2026 MariaDB. All rights reserved.}