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 | ||
| federated | string | OFF | True | True | OFF ON | ||
| 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.