List MySQL Managed Database advanced parameters

get https://api.linode.com/{apiVersion}/databases/mysql/config

All advanced parameters you can apply to a MySQL Managed Database, via our partner Aiven.

📘
Aiven may offer other parameters, but Akamai Managed Databases only supports the ones listed in this operation.

OAuth scopes

databases:read_only

Learn more...

Responses

Response body

object

binlog_retention_period

object

Settings available to configure a binlog_retention_period, per Aiven's specifications.

description

string

The description for this parameter.

example

integer

An example value for this parameter.

maximum

integer

The maximum value allowed for this parameter.

minimum

integer

The minimum value allowed for this parameter.

requires_restart

boolean

Whether a change to this parameter requires a restart of the MySQL database.

type

string

The format of this object.

mysql

object

Parameters available to configure a MySQL Managed Database.

connect_timeout

object

Settings available to configure the connect_timeout, per Aiven's specifications.

default_time_zone

object

Settings available to configure the connect_timeout, per Aiven's specifications.

group_concat_max_len

object

Settings available to configure the group_concat_max_len, per Aiven's specifications.

information_schema_stats_expiry

object

Settings available to configure the information_schema_stats_expiry, per Aiven's specifications.

innodb_change_buffer_max_size

object

Settings available to configure the innodb_change_buffer_max_size, per Aiven's specifications.

innodb_flush_neighbors

object

Settings available to configure the innodb_flush_neighbors, per Aiven's specifications.

innodb_ft_min_token_size

object

Settings available to configure the innodb_ft_min_token_size, per Aiven's specifications.

innodb_ft_server_stopword_table

object | null

Settings available to configure your own innodb_ft_server_stopword_table, per Aiven's specifications. Set to null for no value.

innodb_lock_wait_timeout

object

Settings available to configure the innodb_lock_wait_timeout, per Aiven's specifications.

innodb_log_buffer_size

object

Settings available to configure the innodb_log_buffer_size, per Aiven's specifications.

innodb_online_alter_log_max_size

object

Settings available to configure the innodb_online_alter_log_max_size, per Aiven's specifications.

innodb_read_io_threads

object

Settings available to configure the innodb_read_io_threads, per Aiven's specifications.

innodb_rollback_on_timeout

object

Settings available to configure the innodb_rollback_on_timeout, per Aiven's specifications.

innodb_thread_concurrency

object

Settings available to configure the innodb_thread_concurrency, per Aiven's specifications.

innodb_write_io_threads

object

Settings available to configure the innodb_write_io_threads, per Aiven's specifications.

interactive_timeout

object

Settings available to configure the interactive_timeout, per Aiven's specifications.

internal_tmp_mem_storage_engine

object

Settings available to configure the internal_tmp_mem_storage_engine, per Aiven's specifications.

max_allowed_packet

object

Settings available to configure the max_allowed_packet, per Aiven's specifications.

max_heap_table_size

object

Settings available to configure the max_heap_table_size, per Aiven's specifications.

net_buffer_length

object

Settings available to configure the net_buffer_length, per Aiven's specifications.

net_read_timeout

object

Settings available to configure the net_read_timeout, per Aiven's specifications.

net_write_timeout

object

Settings available to configure the net_write_timeout, per Aiven's specifications.

sql_mode

object

Settings available to configure the sql_mode, per Aiven's specifications.

sql_require_primary_key

object

Settings available to configure the sql_require_primary_key, per Aiven's specifications.

tmp_table_size

object

Settings available to configure the tmp_table_size, per Aiven's specifications.

wait_timeout

object

Settings available to configure the wait_timeout, per Aiven's specifications.

Language

Credentials


xxxxxxxxxx
1
curl --request GET \
2
     --url https://api.linode.com/v4/databases/mysql/config \
3
     --header 'accept: application/json'


xxxxxxxxxx
230
}
1
{
2
  "binlog_retention_period": {
3
    "description": "The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector.",
4
    "example": 600,
5
    "maximum": 86400,
6
    "minimum": 600,
7
    "requires_restart": false,
8
    "type": "integer"
9
  },
10
  "mysql": {
11
    "connect_timeout": {
12
      "description": "The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake",
13
      "example": 10,
14
      "maximum": 3600,
15
      "minimum": 2,
16
      "requires_restart": false,
17
      "type": "integer"
18
    },
19
    "default_time_zone": {
20
      "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.",
21
      "example": "+03:00",
22
      "maxLength": 100,
23
      "minLength": 2,
24
      "pattern": "^([-+][\\d:]*|[\\w/]*)$",
25
      "requires_restart": false,

200MySQL Managed Database advanced parameters.

defaultSee Errors for the range of possible error response codes.