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.

Permissions and scopes

To call this operation, you need the following:

Identity and access permissions. Your user needs these roles assigned. Learn more.
- Roles: database_viewer
OAuth scopes. Your user needs these scopes assigned. Learn more.
- Scopes: databases:read_only

CLI

linode-cli databases mysql-config

Learn more

Responses

Response body

object

Available advanced parameters for a MySQL Managed Database.

binlog_retention_period

integer

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

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": 9007199254740991,
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,
26
      "type": "string"
27
    },
28
    "group_concat_max_len": {
29
      "description": "The maximum permitted result length in bytes for the GROUP_CONCAT() function.",
30
      "example": 1024,
31
      "maximum": 18446744073709552000,
32
      "minimum": 4,
33
      "requires_restart": false,
34
      "type": "integer"
35
    },
36
    "information_schema_stats_expiry": {
37
      "description": "The time, in seconds, before cached statistics expire",
38
      "example": 86400,
39
      "maximum": 31536000,
40
      "minimum": 900,
41
      "requires_restart": false,
42
      "type": "integer"
43
    },
44
    "innodb_change_buffer_max_size": {
45
      "description": "Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25",
46
      "example": 30,
47
      "maximum": 50,
48
      "minimum": 0,
49
      "requires_restart": false,

200MySQL Managed Database advanced parameters.

defaultSee Errors for the range of possible error response codes.