See some of the supported advanced parameters that allow you to configure your Managed Databases (also called Cloud Databases) for MySQL according to your use cases.
Requirements
- a Public Cloud project in your OVHcloud account
- a database running on your OVHcloud Cloud Databases (this guide can help you to meet this requirement)
- access to your OVHcloud Control Panel or the OVHcloud API
Instructions
The management of advanced parameters is not supported via Terraform.
Using the OVHcloud Control Panel
Please refer to the Using the OVHcloud Control Panel section of this guide to find out how to change your advanced parameters from the OVHcloud Control Panel.
Using API
Please refer to the Using API section of this guide to find out how to change your advanced parameters from the OVHcloud API.
Advanced parameters for MySQL
You can find a complete list of configuration options via OVHcloud API. Below are some configuration options available for MySQL service:
| Parameter | mysql.connect_timeout |
| Value type | long |
| Minimum | 2 |
| Maximum | 3600 |
| Values | |
| Description | The number of seconds that the MySQL server waits for a connect packet before responding with Bad handshake. |
| Parameter | mysql.default_time_zone |
| Value type | string |
| Minimum | |
| Maximum | |
| Values | |
| Description | Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or 'SYSTEM' to use the MySQL server default. |
| Parameter | mysql.group_concat_max_len |
| Value type | long |
| Minimum | 4 |
| Maximum | 18446744073709552000 |
| Values | |
| Description | The maximum permitted result length in bytes for the GROUP_CONCAT() function. |
| Parameter | mysql.information_schema_stats_expiry |
| Value type | long |
| Minimum | 900 |
| Maximum | 31536000 |
| Values | |
| Description | The time, in seconds, before cached statistics expire. |
| Parameter | mysql.innodb_change_buffer_max_size |
| Value type | long |
| Minimum | 0 |
| Maximum | 50 |
| Values | |
| Description | Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. The default is 25. |
| Parameter | mysql.innodb_flush_neighbors |
| Value type | long |
| Minimum | 0 |
| Maximum | 2 |
| Values | |
| Description | Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent. |
| Parameter | mysql.innodb_ft_min_token_size |
| Value type | long |
| Minimum | 0 |
| Maximum | 16 |
| Values | |
| Description | Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service. |
| Parameter | mysql.innodb_ft_server_stopword_table |
| Value type | string |
| Minimum | |
| Maximum | |
| Values | |
| Description | This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. |
| Parameter | mysql.innodb_lock_wait_timeout |
| Value type | long |
| Minimum | 1 |
| Maximum | 3600 |
| Values | |
| Description | The length of time in seconds an InnoDB transaction waits for a row lock before giving up. |
| Parameter | mysql.innodb_log_buffer_size |
| Value type | long |
| Minimum | 1048576 |
| Maximum | 4294967295 |
| Values | |
| Description | The size in bytes of the buffer that InnoDB uses to write to the log files on disk. |
| Parameter | mysql.innodb_online_alter_log_max_size |
| Value type | long |
| Minimum | 65536 |
| Maximum | 1099511627776 |
| Values | |
| Description | The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. |
| Parameter | mysql.innodb_print_all_deadlocks |
| Value type | boolean |
| Minimum | |
| Maximum | |
| Values | |
| Description | When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default. |
| Parameter | mysql.innodb_read_io_threads |
| Value type | long |
| Minimum | 1 |
| Maximum | 64 |
| Values | |
| Description | The number of I/O threads for read operations in InnoDB. The default is 4. Changing this parameter will lead to a restart of the MySQL service. |
| Parameter | mysql.innodb_rollback_on_timeout |
| Value type | boolean |
| Minimum | |
| Maximum | |
| Values | |
| Description | When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service. |
| Parameter | mysql.innodb_thread_concurrency |
| Value type | long |
| Minimum | 0 |
| Maximum | 1000 |
| Values | |
| Description | Defines the maximum number of threads permitted inside of InnoDB. The default is 0 (infinite concurrency - no limit). |
| Parameter | mysql.innodb_write_io_threads |
| Value type | long |
| Minimum | 1 |
| Maximum | 64 |
| Values | |
| Description | The number of I/O threads for write operations in InnoDB. The default is 4. Changing this parameter will lead to a restart of the MySQL service. |
| Parameter | mysql.interactive_timeout |
| Value type | long |
| Minimum | 30 |
| Maximum | 604800 |
| Values | |
| Description | The number of seconds the server waits for activity on an interactive connection before closing it. |
| Parameter | mysql.internal_tmp_mem_storage_engine |
| Value type | string |
| Minimum | |
| Maximum | |
| Values | "MEMORY", "TempTable" |
| Description | The storage engine for in-memory internal temporary tables. |
| Parameter | mysql.long_query_time |
| Value type | double |
| Minimum | 0 |
| Maximum | 3600 |
| Values | |
| Description | The slow_query_logs work as SQL statements that take more than long_query_time seconds to execute. Default is 10s |
| Parameter | mysql.max_allowed_packet |
| Value type | long |
| Minimum | 102400 |
| Maximum | 1073741824 |
| Values | |
| Description | Size of the largest message in bytes that can be received by the server. The default is 67108864 (64M). |
| Parameter | mysql.max_heap_table_size |
| Value type | long |
| Minimum | 1048576 |
| Maximum | 1073741824 |
| Values | |
| Description | Limits the size of internal in-memory tables. Also set tmp_table_size. The default is 16777216 (16M). |
| Parameter | mysql.net_buffer_length |
| Value type | long |
| Minimum | 1024 |
| Maximum | 1048576 |
| Values | |
| Description | Start sizes of connection buffer and result buffer. The default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service. |
| Parameter | mysql.net_read_timeout |
| Value type | long |
| Minimum | 1 |
| Maximum | 3600 |
| Values | |
| Description | The number of seconds to wait for more data from a connection before aborting the read. |
| Parameter | mysql.net_write_timeout |
| Value type | long |
| Minimum | 1 |
| Maximum | 3600 |
| Values | |
| Description | The number of seconds to wait for a block to be written to a connection before aborting the write. |
| Parameter | mysql.slow_query_log |
| Value type | boolean |
| Minimum | |
| Maximum | |
| Values | |
| Description | Slow query log enables the capturing of slow queries. Setting slow_query_log to false also truncates the mysql.slow_log table. The default is off. |
| Parameter | mysql.sort_buffer_size |
| Value type | long |
| Minimum | 32768 |
| Maximum | 1073741824 |
| Values | |
| Description | Sort buffer size in bytes for ORDER BY optimization. The default is 262144 (256K). |
| Parameter | mysql.sql_mode |
| Value type | string |
| Minimum | |
| Maximum | |
| Values | |
| Description | Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned. |
| Parameter | mysql.sql_require_primary_key |
| Value type | boolean |
| Minimum | |
| Maximum | |
| Values | |
| Description | Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionalities may break if any large table is missing them. |
| Parameter | mysql.tmp_table_size |
| Value type | long |
| Minimum | 1048576 |
| Maximum | 1073741824 |
| Values | |
| Description | Limits the size of internal in-memory tables. Also set max_heap_table_size. The default is 16777216 (16M). |
| Parameter | mysql.wait_timeout |
| Value type | long |
| Minimum | 1 |
| Maximum | 2147483 |
| Values | |
| Description | The number of seconds the server waits for activity on a non-interactive connection before closing it. |
Go further
For more information and tutorials, please see our other Cloud Databases support guides or explore the guides for other OVHcloud products and services.