mysql.connect_timeout long
min: 2 max: 3600
The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
|
mysql.default_time_zone string
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.
|
mysql.group_concat_max_len long
min: 4 max: 18446744073709552000
The maximum permitted result length in bytes for the GROUP_CONCAT() function.
|
mysql.information_schema_stats_expiry long
min: 900 max: 31536000
The time, in seconds, before cached statistics expire.
|
mysql.innodb_change_buffer_max_size long
min: 0 max: 50
Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
|
mysql.innodb_flush_neighbors long
min: 0 max: 2
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.
|
mysql.innodb_ft_min_token_size long
min: 0 max: 16
Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service.
|
mysql.innodb_ft_server_stopword_table string
This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
|
mysql.innodb_lock_wait_timeout long
min: 1 max: 3600
The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
|
mysql.innodb_log_buffer_size long
min: 1048576 max: 4294967295
The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
|
mysql.innodb_online_alter_log_max_size long
min: 65536 max: 1099511627776
The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
|
mysql.innodb_print_all_deadlocks boolean
When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
|
mysql.innodb_read_io_threads long
min: 1 max: 64
The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
|
mysql.innodb_rollback_on_timeout boolean
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.
|
mysql.innodb_thread_concurrency long
min: 0 max: 1000
Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
|
mysql.innodb_write_io_threads long
min: 1 max: 64
The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
|
mysql.interactive_timeout long
min: 30 max: 604800
The number of seconds the server waits for activity on an interactive connection before closing it.
|
mysql.internal_tmp_mem_storage_engine string
values: MEMORY, TempTable
The storage engine for in-memory internal temporary tables.
|
mysql.log_output string
values: INSIGHTS, INSIGHTS,TABLE, NONE, TABLE
The slow log output destination when slow_query_log is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slow_log table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slow_log table, choose TABLE. To silence slow logs, choose NONE.
|
mysql.long_query_time double
min: 0 max: 3600
The slow_query_logs work as SQL statements that take more than long_query_time seconds to execute.
|
mysql.max_allowed_packet long
min: 102400 max: 1073741824
Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M)
|
mysql.max_heap_table_size long
min: 1048576 max: 1073741824
Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M)
|
mysql.net_buffer_length long
min: 1024 max: 1048576
Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service.
|
mysql.net_read_timeout long
min: 1 max: 3600
The number of seconds to wait for more data from a connection before aborting the read.
|
mysql.net_write_timeout long
min: 1 max: 3600
The number of seconds to wait for a block to be written to a connection before aborting the write.
|
mysql.slow_query_log boolean
Slow query log enables capturing of slow queries. Setting slow_query_log to false also truncates the mysql.slow_log table.
|
mysql.sort_buffer_size long
min: 32768 max: 1073741824
Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K)
|
mysql.sql_mode string
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.
|
mysql.sql_require_primary_key boolean
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.
|
mysql.tmp_table_size long
min: 1048576 max: 1073741824
Limits the size of internal in-memory tables. Also sets max_heap_table_size. Default is 16777216 (16M).
|
mysql.wait_timeout long
min: 1 max: 2147483
The number of seconds the server waits for activity on a non-interactive connection before closing it.
|
