Advanced configuration parameters
Check the advanced configuration parameters available for your database:
MySQL parameters
Parameter | Description |
---|---|
binlog_retention_period | Minimum number of seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default, for example the MySQL Debezium Kafka connector. |
mysql.connect_timeout * | Number of seconds the MySQL server waits for a connect packet before responding with the Bad Handshake error. |
mysql.default_time_zone * | 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 * | Maximum permitted result length in bytes for the GROUP_CONCAT() function. |
mysql.information_schema_stats_expiry * | Number of seconds before cached statistics expire. |
mysql.innodb_change_buffer_max_size * | Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. The default value is 25 . |
mysql.innodb_flush_neighbors * | Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent. Available values:- 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 extentThe default value is 1 . |
mysql.innodb_ft_min_token_size * | Minimum length of words to be stored in an InnoDB full-text index. Change of this parameter causes a restart of the MySQL service. |
mysql.innodb_ft_server_stopword_table * | Specifies your own InnoDB full-text index stopword list for all InnoDB tables. |
mysql.innodb_lock_wait_timeout * | Number of seconds an InnoDB transaction waits for a row lock before giving up. The default value is 120 . |
mysql.innodb_log_buffer_size * | Number of bytes of the buffer that InnoDB uses to write to the log files on disk. |
mysql.innodb_online_alter_log_max_size * | Upper limit in bytes of the size of the temporary log files used during online DDL operations for InnoDB tables. |
mysql.innodb_read_io_threads * | Number of I/O threads for read operations in InnoDB . The default value is 4 . Change of this parameter causes the restart of the MySQL service. |
mysql.innodb_rollback_on_timeout * | Whether a transaction timeout causes InnoDB to abort and roll back the entire transaction. Change of this parameter causes the restart of the MySQL service. |
mysql.innodb_thread_concurrency * | Maximum number of threads permitted inside of InnoDB . The default value is 0 , meaning infinite concurrency (no limit). |
mysql.innodb_write_io_threads * | Number of I/O threads for write operations in InnoDB . The default value is 4 . Change of this parameter causes the restart of the MySQL service. |
mysql.interactive_timeout * | Number of seconds the server waits for activity on an interactive connection before closing it. |
mysql.internal_tmp_mem_storage_engine * | Storage engine for in-memory internal temporary tables. |
mysql.max_allowed_packet * | Size of the largest message in bytes that can be received by the server. The default value is 67108864 (64M). |
mysql.max_heap_table_size * | Upper limit of the size of internal in-memory tables. The default value is 16777216 (16M). Combine this parameter with mysql.tmp_table_size . |
mysql.net_buffer_length * | Start sizes of the connection and result buffers. The default value is 16384 (16K). Change of this parameter causes the restart of the MySQL service. |
mysql.net_read_timeout * | Number of seconds to wait for more data from a connection before aborting the read. |
mysql.net_write_timeout * | Number of seconds to wait for a block to be written to a connection before aborting the write. |
mysql.sort_buffer_size * | Sort buffer size in bytes for the ORDER BY optimization. The default value is 262144 (256K). |
mysql.sql_mode * | Global SQL mode. To use MySQL server defaults, set it to empty. If this field is not set when creating a new service, the Aiven default SQL mode (strict, SQL standard compliant) is assigned. |
mysql.sql_require_primary_key * | Requires a primary key to be defined for new tables or old tables modified with ALTER TABLE and fails if missing. It's recommended to always have primary keys because various functionality may break if any large table is missing them. |
mysql.tmp_table_size * | Upper limit of the size of internal in-memory tables. The default value is 16777216 (16M). Combine this parameter with mysql.max_heap_table_size . |
mysql.wait_timeout * | Number of seconds the server waits for activity on a noninteractive connection before closing it. |
*mysql.conf
configuration values
PostgreSQL parameters
Parameter | Description |
---|---|
pg.autovacuum_analyze_scale_factor ** | Fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE . The default value is 0.2 (20% of the table size). |
pg.autovacuum_analyze_threshold ** | Minimum number of inserted, updated, or deleted tuples needed to trigger an ANALYZE in any one table. The default value is 50 . |
pg.autovacuum_max_workers ** | Maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default value is 3 . This parameter can only be set at server start. |
pg.autovacuum_naptime ** | Minimum delay in seconds between autovacuum runs on any given database. The default value is 60 . |
pg.autovacuum_vacuum_cost_delay ** | Cost delay in milliseconds to be used in automatic VACUUM operations. If it's set to -1 , the regular vacuum_cost_delay value is used. The default value is 20 . |
pg.autovacuum_vacuum_cost_limit ** | Cost limit that will be used in automatic VACUUM operations. If it's set to -1 , the regular vacuum_cost_limit value is used. The default value is -1 . |
pg.autovacuum_vacuum_scale_factor ** | Fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM . The default value is 0.2 (20% of table size). |
pg.autovacuum_vacuum_threshold ** | Minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default value is 50 . |
pg.bgwriter_delay ** | Delay between activity rounds for the background writer in milliseconds. The default value is 200 . |
pg.bgwriter_flush_after ** | Whenever more than this amount of data in kilobytes has been written by the background writer, attempt to force the OS to issue these writes to the underlying storage. The default value is 512 . Setting this to 0 disables forced writeback. |
pg.bgwriter_lru_maxpages ** | Number of buffers to be written by the background writer in each round. Setting this to zero disables background writing. The default value is 100 . |
pg.bgwriter_lru_multiplier ** | Number by which the average recent need for new buffers is multiplied by to arrive at an estimate of the number to be needed during the next round, (up to bgwriter_lru_maxpages ). 1.0 represents a just-in-time policy of writing exactly the number of buffers predicted to be needed. Larger values provide some cushion against spikes in demand. Smaller values intentionally leave writes to be done by server processes. The default value is 2.0 . |
pg.deadlock_timeout ** | Number of milliseconds to wait on a lock before checking to see if there is a deadlock condition. |
pg.default_toast_compression ** | Specifies the default TOAST compression method for values of compressible columns. The default value is lz4 . |
pg.idle_in_transaction_session_timeout ** | Number of milliseconds for sessions with open transactions to time out. |
pg.jit ** | Controls system-wide use of Just-in-Time Compilation (JIT). |
pg.max_files_per_process ** | Maximum number of files that can be open per process. |
pg.max_locks_per_transaction ** | Maximum number of locks per transaction. |
pg.max_logical_replication_workers ** | Maximum number of logical replication workers taken from the pool of max_parallel_workers . |
pg.max_parallel_workers ** | Maximum number of workers that the system can support for parallel queries. |
pg.max_parallel_workers_per_gather ** | Maximum number of workers that can be started by a single Gather or Gather Merge node. |
pg.max_pred_locks_per_transaction ** | Maximum number of prepared transactions. |
pg.max_replication_slots ** | Maximum number of replication slots. |
pg.max_slot_wal_keep_size ** | Maximum WAL size in megabytes reserved for replication slots. The default value is -1 , meaning unlimited. The wal_keep_size minimum WAL size setting takes precedence over this. |
pg.max_stack_depth ** | Maximum depth of the stack in bytes. |
pg.max_standby_archive_delay ** | Maximum standby archive delay in milliseconds. |
pg.max_standby_streaming_delay ** | Maximum standby streaming delay in milliseconds. |
pg.max_wal_senders ** | Maximum number of WAL senders. |
pg.max_worker_processes ** | Maximum number of background processes that the system can support. |
pg.password_encryption ** | Algorithm for encrypting passwords. |
pg.pg_partman_bgw.interval ** | Time interval to run pg_partman scheduled tasks. |
pg.pg_partman_bgw.role ** | Sets the role to use for pg_partman scheduled background tasks. |
pg.pg_stat_monitor.pgsm_enable_query_plan | Enables or disables query plan monitoring. |
pg.pg_stat_monitor.pgsm_max_buckets | Maximum number of buckets. |
pg.pg_stat_statements.track ** | Controls which statements are counted. Available values are: - top . Tracks top-level statements (issued directly by clients).- all . Tracks nested statements (such as statements invoked within functions).- none . Disables statement statistics collection.The default value is top . |
pg.temp_file_limit ** | Temporary file limit in kilobytes, -1 is for unlimited. |
pg.timezone ** | Service timezone. |
pg.track_activity_query_size ** | Number of bytes reserved to track the currently executing command for each active session. |
pg.track_commit_timestamp ** | Record commit time of transactions. |
pg.track_functions ** | Enables tracking of function call counts and time used. |
pg.track_io_timing ** | Enables timing of database I/O calls. By default, this parameter is off , because it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms. |
pg.wal_sender_timeout ** | Number of milliseconds for which replication connections need to be inactive to be terminated. Setting it to 0 disables the timeout. |
pg.wal_writer_delay ** | WAL flush interval in milliseconds. Setting this value to lower than the default 200 may negatively impact performance. |
pg_stat_monitor_enable | Enables the pg_stat_monitor extension. With the extension enabled, pg_stat_statements results for utility commands are unreliable. Use of this parameter causes restart of the cluster. |
pglookout.max_failover_replication_time_lag *** | Number of seconds of master unavailability before triggering database failover to standby. |
shared_buffers_percentage | Percentage of total RAM that the database server uses for shared memory buffers. Valid range is 20-60 (float), which corresponds to 20% - 60%. This setting adjusts the shared_buffers configuration value. |
work_mem | Maximum amount of memory in megabytes to be used by a query operation (such as a sort or hash table) before writing to temporary disk files. The default value is 1 + 0.075% of total RAM (up to 32MB). |
** - postgresql.conf
configuration values.
*** - System-wide settings for pglookout
.
Updated 21 days ago