Configuration

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.

ParameterTypeDefaultMinMaxAllowed Values
connect_timeoutinteger10231536000
innodb_buffer_pool_sizeinteger(*)20971529223372036854776000
innodb_file_per_tablestringONON, OFF
innodb_flush_methodstringO_DIRECTfsync, O_DSYNC, O_DIRECT, O_DIRECT_NO_FSYNC
innodb_lock_wait_timeoutinteger500100000000
innodb_log_buffer_sizeinteger167772162621444294967295
innodb_log_file_sizeinteger1006632961048576549755813888
innodb_strict_modestringONON, OFF
innodb_ft_aux_tablestring-
innodb_ft_cache_sizeinteger8000000160000080000000
innodb_ft_enable_diag_printstringOFFON, OFF
innodb_ft_enable_stopwordstringONON, OFF
innodb_ft_max_token_sizeinteger841084
innodb_ft_min_token_sizeinteger3016
innodb_ft_num_word_optimizeinteger2000100010000
innodb_ft_result_cache_limitinteger2000000000100000018446744073709551615
innodb_ft_server_stopword_tablestring-
innodb_ft_sort_pll_degreeinteger2132
innodb_ft_total_cache_sizeinteger640000000320000001600000000
innodb_ft_user_stopword_tablestring-
key_buffer_sizeinteger(*)8
local_infilestringOFFON, OFF
lock_wait_timeoutinteger86400031536000
log_bin_trust_function_creatorsstringOFFON, OFF
max_binlog_sizeinteger107374182440961073741824
max_connect_errorsinteger10014294967295
max_connectionsinteger(*)10100000
open_files_limitinteger004294967295
require_secure_transportstringONON, OFF
skip_name_resolvestringONON, OFF
table_open_cacheinteger(*)11048576
sql_modestringSTRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTIONALLOW_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

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.
  • 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.
Last modified 07.05.2025: Valkey (fd1bb7c)