> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/mariadb-cloud/cloud-management/config/mariadb-server-single-node.md). # MariaDB Server Single Node 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](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md#auto_increment_increment) | 1 | | [autocommit](/docs/server/server-management/variables-and-modes/server-system-variables.md#autocommit) | ON | | [binlog\_cache\_size](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md#binlog_cache_size) | 32768 | | [binlog\_format](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md#binlog_format) | ROW | | [connect\_timeout](/docs/server/server-management/variables-and-modes/server-system-variables.md#connect_timeout) | 5 | | [cracklib\_password\_check](/docs/server/reference/plugins/password-validation-plugins/cracklib-password-check-plugin.md#cracklib_password_check) | OFF | | [default\_password\_lifetime](/docs/server/server-management/variables-and-modes/server-system-variables.md#default_password_lifetime) | 0 | | [default\_time\_zone](/docs/server/server-management/variables-and-modes/server-system-variables.md#time_zone) | system | | [disconnect\_on\_expired\_password](/docs/server/server-management/variables-and-modes/server-system-variables.md#disconnect_on_expired_password) | OFF | | [div\_precision\_increment](/docs/server/server-management/variables-and-modes/server-system-variables.md#div_precision_increment) | 4 | | [eq\_range\_index\_dive\_limit](/docs/server/server-management/variables-and-modes/server-system-variables.md#eq_range_index_dive_limit) | 200 | | [event\_scheduler](/docs/server/server-management/variables-and-modes/server-system-variables.md#event_scheduler) | OFF | | [expire\_logs\_days](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md#expire_logs_days) | 4 | | [explicit\_defaults\_for\_timestamp](/docs/server/server-management/variables-and-modes/server-system-variables.md#explicit_defaults_for_timestamp) | OFF | | [gtid\_strict\_mode](/docs/server/ha-and-performance/standard-replication/gtid.md#gtid_strict_mode) | ON | | [host\_cache\_size](/docs/server/server-management/variables-and-modes/server-system-variables.md#host_cache_size) | 248 | | [idle\_readonly\_transaction\_timeout](/docs/server/server-management/variables-and-modes/server-system-variables.md#idle_readonly_transaction_timeout) | 0 | | [idle\_transaction\_timeout](/docs/server/server-management/variables-and-modes/server-system-variables.md#idle_transaction_timeout) | 0 | | [idle\_write\_transaction\_timeout](/docs/server/server-management/variables-and-modes/server-system-variables.md#idle_write_transaction_timeout) | 0 | | [innodb\_autoextend\_increment](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_autoextend_increment) | 64 | | [innodb\_autoinc\_lock\_mode](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_autoinc_lock_mode) | 2 | | [innodb\_buffer\_pool\_size](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_buffer_pool_size) | AUTO\_GENERATED | | [innodb\_change\_buffering](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_change_buffering) | none | | [innodb\_flush\_log\_at\_trx\_commit](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_flush_log_at_trx_commit) | 1 | | [innodb\_log\_buffer\_size](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_log_buffer_size) | 16777216 | | [innodb\_log\_file\_size](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_log_file_size) | 1073741824 | | [innodb\_strict\_mode](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_strict_mode) | ON | | [interactive\_timeout](/docs/server/server-management/variables-and-modes/server-system-variables.md#interactive_timeout) | 3600 | | [join\_buffer\_size](/docs/server/server-management/variables-and-modes/server-system-variables.md#join_buffer_size) | 262144 | | [local\_infile](/docs/server/server-management/variables-and-modes/server-system-variables.md#local_infile) | ON | | [log\_output](/docs/server/server-management/variables-and-modes/server-system-variables.md#log_output) | FILE | | [log\_slow\_filter](/docs/server/server-management/variables-and-modes/server-system-variables.md#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](/docs/server/server-management/variables-and-modes/server-system-variables.md#log_slow_rate_limit) | 1 | | [log\_slow\_verbosity](/docs/server/server-management/variables-and-modes/server-system-variables.md#log_slow_verbosity) | | | [log\_warnings](/docs/server/server-management/variables-and-modes/server-system-variables.md#log_warnings) | 2 | | [long\_query\_time](/docs/server/server-management/variables-and-modes/server-system-variables.md#long_query_time) | 10.0 | | [lower\_case\_table\_names](/docs/server/server-management/variables-and-modes/server-system-variables.md#lower_case_table_names) | 0 | | [max\_allowed\_packet](/docs/server/server-management/variables-and-modes/server-system-variables.md#max_allowed_packet) | 33554432 | | [max\_connections](/docs/server/server-management/variables-and-modes/server-system-variables.md#max_connections) | AUTO\_GENERATED | | [max\_heap\_table\_size](/docs/server/server-management/variables-and-modes/server-system-variables.md#max_heap_table_size) | 16777216 | | [max\_password\_errors](/docs/server/server-management/variables-and-modes/server-system-variables.md#max_password_errors) | 4294967295 | | [net\_buffer\_length](/docs/server/server-management/variables-and-modes/server-system-variables.md#net_buffer_length) | 16384 | | [net\_write\_timeout](/docs/server/server-management/variables-and-modes/server-system-variables.md#net_write_timeout) | 60 | | [open\_files\_limit](/docs/server/server-management/variables-and-modes/server-system-variables.md#open_files_limit) | 0 | | [optimizer\_search\_depth](/docs/server/server-management/variables-and-modes/server-system-variables.md#optimizer_search_depth) | 62 | | [optimizer\_switch](/docs/server/server-management/variables-and-modes/server-system-variables.md#optimizer_switch) | AUTO\_GENERATED | | [performance\_schema](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema) | OFF | | [performance\_schema\_accounts\_size](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_accounts_size) | -1 | | [performance\_schema\_digests\_size](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_digests_size) | -1 | | [performance\_schema\_events\_stages\_history\_long\_size](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_events_stages_history_long_size) | -1 | | [performance\_schema\_events\_stages\_history\_size](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_events_stages_history_size) | -1 | | [performance\_schema\_events\_statements\_history\_long\_size](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_events_statements_history_long_size) | -1 | | [performance\_schema\_events\_statements\_history\_size](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_events_statements_history_size) | -1 | | [performance\_schema\_events\_waits\_history\_long\_size](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_events_waits_history_long_size) | -1 | | [performance\_schema\_events\_waits\_history\_size](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_events_waits_history_size) | -1 | | [performance\_schema\_hosts\_size](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_hosts_size) | -1 | | [performance\_schema\_max\_cond\_classes](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_cond_classes) | 90 | | [performance\_schema\_max\_cond\_instances](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_cond_instances) | -1 | | [performance\_schema\_max\_digest\_length](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_digest_length) | 1024 | | [performance\_schema\_max\_file\_classes](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_file_classes) | 80 | | [performance\_schema\_max\_file\_handles](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_file_handles) | 32768 | | [performance\_schema\_max\_file\_instances](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_file_instances) | -1 | | [performance\_schema\_max\_mutex\_classes](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_mutex_classes) | 200 | | [performance\_schema\_max\_mutex\_instances](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_mutex_instances) | -1 | | [performance\_schema\_max\_rwlock\_classes](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_rwlock_classes) | 50 | | [performance\_schema\_max\_rwlock\_instances](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_rwlock_instances) | -1 | | [performance\_schema\_max\_socket\_classes](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_socket_classes) | 10 | | [performance\_schema\_max\_socket\_instances](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_socket_instances) | 10 | | [performance\_schema\_max\_stage\_classes](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_stage_classes) | 160 | | [performance\_schema\_max\_table\_handles](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_table_handles) | -1 | | [performance\_schema\_max\_table\_instances](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_table_instances) | -1 | | [performance\_schema\_max\_thread\_classes](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_thread_classes) | 50 | | [performance\_schema\_max\_thread\_instances](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_thread_instances) | -1 | | [performance\_schema\_session\_connect\_attrs\_size](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_session_connect_attrs_size) | -1 | | [performance\_schema\_users\_size](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_users_size) | -1 | | [proxy\_protocol\_networks](/docs/server/server-management/variables-and-modes/server-system-variables.md#proxy_protocol_networks) | 10.0.0.0/8 | | [read\_buffer\_size](/docs/server/server-management/variables-and-modes/server-system-variables.md#read_buffer_size) | 131072 | | [read\_only](/docs/server/server-management/variables-and-modes/server-system-variables.md#read_only) | OFF | | [read\_rnd\_buffer\_size](/docs/server/server-management/variables-and-modes/server-system-variables.md#read_rnd_buffer_size) | 262144 | | [require\_secure\_transport](/docs/server/server-management/variables-and-modes/server-system-variables.md#require_secure_transport) | AUTO\_GENERATED | | [server\_audit](/docs/server/reference/plugins/mariadb-audit-plugin/mariadb-audit-plugin-options-and-system-variables.md#server_audit) | ON | | [server\_audit\_file\_rotate\_size](/docs/server/reference/plugins/mariadb-audit-plugin/mariadb-audit-plugin-options-and-system-variables.md#server_audit_file_rotate_size) | 1000000 | | [server\_audit\_logging](/docs/server/reference/plugins/mariadb-audit-plugin/mariadb-audit-plugin-options-and-system-variables.md#server_audit_logging) | OFF | | [session\_track\_system\_variables](/docs/server/server-management/variables-and-modes/server-system-variables.md#session_track_system_variables) | autocommit, character\_set\_client, character\_set\_connection, character\_set\_results, time\_zone | | [simple\_password\_check\_digits](/docs/server/reference/plugins/password-validation-plugins/simple-password-check-plugin.md#simple_password_check_digits) | 1 | | [simple\_password\_check\_letters\_same\_case](/docs/server/reference/plugins/password-validation-plugins/simple-password-check-plugin.md#simple_password_check_letters_same_case) | 1 | | [simple\_password\_check\_minimal\_length](/docs/server/reference/plugins/password-validation-plugins/simple-password-check-plugin.md#simple_password_check_minimal_length) | 8 | | [simple\_password\_check\_other\_characters](/docs/server/reference/plugins/password-validation-plugins/simple-password-check-plugin.md#simple_password_check_other_characters) | 1 | | [slow\_query\_log](/docs/server/server-management/variables-and-modes/server-system-variables.md#slow_query_log) | OFF | | [sort\_buffer\_size](/docs/server/server-management/variables-and-modes/server-system-variables.md#sort_buffer_size) | 2097152 | | [sql\_mode](/docs/server/server-management/variables-and-modes/server-system-variables.md#sql_mode) | ERROR\_FOR\_DIVISION\_BY\_ZERO, NO\_AUTO\_CREATE\_USER, NO\_ENGINE\_SUBSTITUTION, STRICT\_TRANS\_TABLES | | [strict\_password\_validation](/docs/server/server-management/variables-and-modes/server-system-variables.md#strict_password_validation) | ON | | [sync\_binlog](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md#sync_binlog) | 1 | | [system\_versioning\_alter\_history](/docs/server/reference/sql-structure/temporal-tables/system-versioned-tables.md#system_versioning_alter_history) | ERROR | | [table\_open\_cache](/docs/server/server-management/variables-and-modes/server-system-variables.md#table_open_cache) | AUTO\_GENERATED | | [thread\_cache\_size](/docs/server/server-management/variables-and-modes/server-system-variables.md#thread_cache_size) | 256 | | [thread\_handling](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables.md#thread_handling) | one-thread-per-connection | | [thread\_pool\_idle\_timeout](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables.md#thread_pool_idle_timeout) | 60 | | [thread\_pool\_max\_threads](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables.md#thread_pool_max_threads) | 65536 | | [thread\_pool\_priority](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables.md#thread_pool_priority) | auto | | [thread\_stack](/docs/server/server-management/variables-and-modes/server-system-variables.md#thread_stack) | 299008 | | [tmp\_table\_size](/docs/server/server-management/variables-and-modes/server-system-variables.md#tmp_table_size) | AUTO\_GENERATED | | [transaction\_isolation](/docs/server/server-management/variables-and-modes/server-system-variables.md#transaction_isolation) | REPEATABLE-READ | | [wait\_timeout](/docs/server/server-management/variables-and-modes/server-system-variables.md#wait_timeout) | 600 | --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://mariadb.com/docs/mariadb-cloud/cloud-management/config/mariadb-server-single-node.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.