Configuration

3 minute read

The parameters listed in the table represent the specific configuration settings that we customize from the default configuration provided by MySQL. 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
binlog_cache_size	integer	32768	True	False	4096	18446744073709548000
binlog_expire_logs_auto_purge	string	ON	False	False			OFF ON
binlog_expire_logs_seconds	integer	86400	False	False	0	4294967295
binlog_format	string	ROW	False	False			ROW MIXED STATEMENT
binlog_gtid_simple_recovery	string	ON	False	True			OFF ON
connect_timeout	integer	10	True	False
enforce_gtid_consistency	string	ON	False	False			OFF ON WARN
gtid_mode	string	ON	False	False			OFF OFF_PERMISSIVE ON_PERMISSIVE ON
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 littlesync nosync 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_redo_log_capacity*	integer	104857600	True	False	8388608	137438953472
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	31536000	True	False	1	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	5000	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	ONLY_FULL_GROUP_BY STRICT_TRANS_TABLES NO_ZERO_IN_DATE NO_ZERO_DATE ERROR_FOR_DIVISION_BY_ZERO NO_ENGINE_SUBSTITUTION	True	False			ALLOW_INVALID_DATES ANSI ANSI_QUOTES ERROR_FOR_DIVISION_BY_ZERO HIGH_NOT_PRECEDENCE IGNORE_SPACE NO_AUTO_VALUE_ON_ZERO NO_BACKSLASH_ESCAPES NO_DIR_IN_CREATE NO_ENGINE_SUBSTITUTION NO_UNSIGNED_SUBTRACTION NO_ZERO_DATE NO_ZERO_IN_DATE ONLY_FULL_GROUP_BY PAD_CHAR_TO_FULL_LENGTH PIPES_AS_CONCAT REAL_AS_FLOAT STRICT_ALL_TABLES STRICT_TRANS_TABLES TIME_TRUNCATE_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.*

Please note that we are actively working on implementing a feature in our customer portal that will allow you to modify your DBaas configuration directly. However, this feature is not yet available. We appreciate your patience and understanding as we continue to enhance our services.

Last modified 03.05.2024: dos2unix mansvc files (d79b1ea)