Configuration

2 minute read

The parameters listed in the table represent the specific configuration settings that we customize from the default configuration provided by MariaDB. These parameters are tailored to suit our platform’s requirements and are carefully selected to optimize performance and reliability.

Note: Parameters marked with an asterisk (*) are dynamically calculated based on available compute resources, allowing for seamless vertical scaling.

Parameter	Type	Default	Modifiable	Restart Required	Min	Max	Allowed Values
connect_timeout	integer	10	true	false
expire_logs_days	integer	1	false	false	0	99
innodb_buffer_pool_size*	integer	134217728	true	false	2097152	9223372036854776000
innodb_file_per_table	string	ON	false	false			ON, OFF
innodb_flush_method	string	O_DIRECT	false	true			fsync, O_DSYNC, O_DIRECT, O_DIRECT_NO_FSYNC
innodb_lock_wait_timeout	integer	50	true	false	0	100000000
innodb_log_buffer_size	integer	16777216	true	true	262144	4294967295
innodb_log_file_size	integer	100663296	true	true	1048576	549755813888
innodb_strict_mode	string	ON	true	false			ON, OFF
key_buffer_size*	integer	134217728	true	false	8
local_infile	string	OFF	false	false			ON, OFF
lock_wait_timeout	integer	86400	true	false	0	31536000
log_bin_trust_function_creators	string	OFF	true	false			ON, OFF
max_allowed_packet*	integer	16777216	false	false	1024	1073741824
max_binlog_size	integer	1073741824	true	false	4096	1073741824
max_connect_errors	integer	100	true	false	1	4294967295
max_connections*	integer	151	true	true	10	100000
open_files_limit	integer	0	true	true	0	4294967295
require_secure_transport	string	ON	false	false			ON, OFF
skip_name_resolve	string	ON	false	true			ON, OFF
ssl_cipher	string	ECDHE-ECDSA-AES128-GCM-SHA256: ECDHE-RSA-AES128-GCM-SHA256: ECDHE-ECDSA-AES256-GCM-SHA384: ECDHE-RSA-AES256-GCM-SHA384: ECDHE-ECDSA-CHACHA20-POLY1305: ECDHE-RSA-CHACHA20-POLY1305: DHE-RSA-AES128-GCM-SHA256: DHE-RSA-AES256-GCM-SHA384	true	true
sql_mode	string	STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION	true	false			ALLOW_INVALID_DATES, ANSI, ANSI_QUOTES, DB2, EMPTY_STRING_IS_NULL, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_BAD_TABLE_OPTIONS, IGNORE_SPACE, MAXDB, MSSQL, MYSQL323, MYSQL40, NO_AUTO_CREATE_USER, NO_AUTO_VALUE_ON_ZERO, NO_BACKSLASH_ESCAPES, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_FIELD_OPTIONS, NO_KEY_OPTIONS, NO_TABLE_OPTIONS, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, ORACLE, PAD_CHAR_TO_FULL_LENGTH, PIPES_AS_CONCAT, POSTGRESQL, REAL_AS_FLOAT, SIMULTANEOUS_ASSIGNMENT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES, TIME_ROUND_FRACTIONAL

table_open_cache*	integer	2000	true	true	1	1048576
tls_version	string	TLSv1.2,TLSv1.3	true	true

Column Explanation

Parameter: This column lists the configuration parameters.
Type: Indicates the data type of the configuration parameter (e.g., integer, string).
Default: Displays the default value for each parameter.
Modifiable: Indicates whether the parameter can be modified (true/false).
Restart Required: Specifies whether a server restart is required for changes to take effect (true/false).
Min: Shows the minimum permissible value for numeric parameters.
Max: Displays the maximum permissible value for numeric parameters.
Allowed Values: Lists the values allowed for string parameters.

For custom DBaaS configurations including parameters not listed above, please submit a support ticket to our team.

We’re working on a feature to let you directly change your DBaaS settings in our customer portal. Until then we thank you for your patience as we improve our services.

Last modified 15.03.2024: dbaas priv reg - korrekturen vom marketing (1a2ab64)