Modifies configuration parameters for a Vultr managed database instance to optimize performance and behavior settings.
The vultr-cli database advanced-option update command modifies configuration parameters for a Vultr managed database instance, allowing you to tune performance and behavior settings.
$ vultr-cli database advanced-option update <Database ID> [flags]
| Shorthand | Long Version | Description |
|---|---|---|
| - | --auto-create-topics-enable | set the managed kafka configuration value for auto_create_topics_enable |
| - | --autovacuum-analyze-scale-factor | set the managed postgresql configuration value for autovacuum_analyze_scale_factor |
| - | --autovacuum-analyze-threshold | set the managed postgresql configuration value for autovacuum_analyze_threshold |
| - | --autovacuum-freeze-max-age | set the managed postgresql configuration value for autovacuum_freeze_max_age |
| - | --autovacuum-max-workers | set the managed postgresql configuration value for autovacuum_max_workers |
| - | --autovacuum-naptime | set the managed postgresql configuration value for autovacuum_naptime |
| - | --autovacuum-vacuum-cost-delay | set the managed postgresql configuration value for autovacuum_vacuum_cost_delay |
| - | --autovacuum-vacuum-cost-limit | set the managed postgresql configuration value for autovacuum_vacuum_cost_limit |
| - | --autovacuum-vacuum-scale-factor | set the managed postgresql configuration value for autovacuum_vacuum_scale_factor |
| - | --autovacuum-vacuum-threshold | set the managed postgresql configuration value for autovacuum_vacuum_threshold |
| - | --bgwriter-delay | set the managed postgresql configuration value for bgwriter_delay |
| - | --bgwriter-flush-after | set the managed postgresql configuration value for bgwriter_flush_after |
| - | --bgwriter-lru-maxpages | set the managed postgresql configuration value for bgwriter_lru_maxpages |
| - | --bgwriter-lru-multiplier | set the managed postgresql configuration value for bgwriter_lru_multiplier |
| - | --compression-type | set the managed kafka configuration value for compression_type |
| - | --connect-timeout | set the managed mysql configuration value for connect_timeout |
| - | --connections-max-idle-ms | set the managed kafka configuration value for connections_max_idle_ms |
| - | --deadlock-timeout | set the managed postgresql configuration value for deadlock_timeout |
| - | --default-replication-factor | set the managed kafka configuration value for default_replication_factor |
| - | --default-toast-compression | set the managed postgresql configuration value for default_toast_compression |
| - | --group-concat-max-len | set the managed mysql configuration value for group_concat_max_len |
| - | --group-initial-rebalance-delay-ms | set the managed kafka configuration value for group_initial_rebalance_delay_ms |
| - | --group-max-session-timeout-ms | set the managed kafka configuration value for group_max_session_timeout_ms |
| - | --group-min-session-timeout-ms | set the managed kafka configuration value for group_min_session_timeout_ms |
| - | --idle-in-transaction-session-timeout | set the managed postgresql configuration value for idle_in_transaction_session_timeout |
| - | --innodb-change-buffer-max-size | set the managed mysql configuration value for innodb_change_buffer_max_size |
| - | --innodb-flush-neighbors | set the managed mysql configuration value for innodb_flush_neighbors |
| - | --innodb-ft-min-token-size | set the managed mysql configuration value for innodb_ft_min_token_size |
| - | --innodb-ft-server-stopword-table | set the managed mysql configuration value for innodb_ft_server_stopword_table |
| - | --innodb-lock-wait-timeout | set the managed mysql configuration value for innodb_lock_wait_timeout |
| - | --innodb-log-buffer-size | set the managed mysql configuration value for innodb_log_buffer_size |
| - | --innodb-online-alter-log-max-size | set the managed mysql configuration value for innodb_online_alter_log_max_size |
| - | --innodb-print-all-deadlocks | set the managed mysql configuration value for innodb_print_all_deadlocks |
| - | --innodb-read-io-threads | set the managed mysql configuration value for innodb_read_io_threads |
| - | --innodb-rollback-on-timeout | set the managed mysql configuration value for innodb_rollback_on_timeout |
| - | --innodb-thread-concurrency | set the managed mysql configuration value for innodb_thread_concurrency |
| - | --innodb-write-io-threads | set the managed mysql configuration value for innodb_write_io_threads |
| - | --interactive-timeout | set the managed mysql configuration value for interactive_timeout |
| - | --internal-tmp-mem-storage-engine | set the managed mysql configuration value for internal_tmp_mem_storage_engine |
| - | --jit | set the managed postgresql configuration value for jit |
| - | --log-autovacuum-min-duration | set the managed postgresql configuration value for log_autovacuum_min_duration |
| - | --log-cleaner-delete-retention-ms | set the managed kafka configuration value for log_cleaner_delete_retention_ms |
| - | --log-cleaner-max-compaction-lag-ms | set the managed kafka configuration value for log_cleaner_max_compaction_lag_ms |
| - | --log-cleaner-min-cleanable-ratio | set the managed kafka configuration value for log_cleaner_min_cleanable_ratio |
| - | --log-cleaner-min-compaction-lag-ms | set the managed kafka configuration value for log_cleaner_min_compaction_lag_ms |
| - | --log-cleanup-policy | set the managed kafka configuration value for log_cleanup_policy |
| - | --log-error-verbosity | set the managed postgresql configuration value for log_error_verbosity |
| - | --log-flush-interval-messages | set the managed kafka configuration value for log_flush_interval_messages |
| - | --log-flush-interval-ms | set the managed kafka configuration value for log_flush_interval_ms |
| - | --log-index-interval-bytes | set the managed kafka configuration value for log_index_interval_bytes |
| - | --log-index-size-max-bytes | set the managed kafka configuration value for log_index_size_max_bytes |
| - | --log-line-prefix | set the managed postgresql configuration value for log_line_prefix |
| - | --log-local-retention-bytes | set the managed kafka configuration value for log_local_retention_bytes |
| - | --log-local-retention-ms | set the managed kafka configuration value for log_local_retention_ms |
| - | --log-message-downconversion-enable | set the managed kafka configuration value for log_message_downconversion_enable |
| - | --log-message-timestamp-difference-max-ms | set the managed kafka configuration value for log_message_timestamp_difference_max_ms |
| - | --log-message-timestamp-type | set the managed kafka configuration value for log_message_timestamp_type |
| - | --log-min-duration-statement | set the managed postgresql configuration value for log_min_duration_statement |
| - | --log-preallocate | set the managed kafka configuration value for log_preallocate |
| - | --log-retention-bytes | set the managed kafka configuration value for log_retention_bytes |
| - | --log-retention-hours | set the managed kafka configuration value for log_retention_hours |
| - | --log-retention-ms | set the managed kafka configuration value for log_retention_ms |
| - | --log-roll-jitter-ms | set the managed kafka configuration value for log_roll_jitter_ms |
| - | --log-roll-ms | set the managed kafka configuration value for log_roll_ms |
| - | --log-segment-bytes | set the managed kafka configuration value for log_segment_bytes |
| - | --log-segment-delete-delay-ms | set the managed kafka configuration value for log_segment_delete_delay_ms |
| - | --max-allowed-packet | set the managed mysql configuration value for max_allowed_packet |
| - | --max-connections-per-ip | set the managed kafka configuration value for max_connections_per_ip |
| - | --max-files-per-process | set the managed postgresql configuration value for max_files_per_process |
| - | --max-heap-table-size | set the managed mysql configuration value for max_heap_table_size |
| - | --max-incremental-fetch-session-cache-slots | set the managed kafka configuration value for max_incremental_fetch_session_cache_slots |
| - | --max-locks-per-transaction | set the managed postgresql configuration value for max_locks_per_transaction |
| - | --max-logical-replication-workers | set the managed postgresql configuration value for max_logical_replication_workers |
| - | --max-parallel-workers | set the managed postgresql configuration value for max_parallel_workers |
| - | --max-parallel-workers-per-gather | set the managed postgresql configuration value for max_parallel_workers_per_gather |
| - | --max-pred-locks-per-transaction | set the managed postgresql configuration value for max_pred_locks_per_transaction |
| - | --max-prepared-transactions | set the managed postgresql configuration value for max_prepared_transactions |
| - | --max-replication-slots | set the managed postgresql configuration value for max_replication_slots |
| - | --max-stack-depth | set the managed postgresql configuration value for max_stack_depth |
| - | --max-standby-archive-delay | set the managed postgresql configuration value for max_standby_archive_delay |
| - | --max-standby-streaming-delay | set the managed postgresql configuration value for max_standby_streaming_delay |
| - | --max-wal-senders | set the managed postgresql configuration value for max_wal_senders |
| - | --max-worker-processes | set the managed postgresql configuration value for max_worker_processes |
| - | --message-max-bytes | set the managed kafka configuration value for message_max_bytes |
| - | --min-insync-replicas | set the managed kafka configuration value for min_insync_replicas |
| - | --net-buffer-length | set the managed mysql configuration value for net_buffer_length |
| - | --net-read-timeout | set the managed mysql configuration value for net_read_timeout |
| - | --net-write-timeout | set the managed mysql configuration value for net_write_timeout |
| - | --num-partitions | set the managed kafka configuration value for num_partitions |
| - | --offsets-retention-minutes | set the managed kafka configuration value for offsets_retention_minutes |
| - | --pg-partman-bgw-interval | set the managed postgresql configuration value for pg_partman_bgw.interval |
| - | --pg-partman-bgw-role | set the managed postgresql configuration value for pg_partman_bgw.role |
| - | --pg-stat-statements-track | set the managed postgresql configuration value for pg_stat_statements.track |
| - | --producer-purgatory-purge-interval-requests | set the managed kafka configuration value for producer_purgatory_purge_interval_requests |
| - | --replica-fetch-max-bytes | set the managed kafka configuration value for replica_fetch_max_bytes |
| - | --replica-fetch-response-max-bytes | set the managed kafka configuration value for replica_fetch_response_max_bytes |
| - | --sasl-oauthbearer-expected-audience | set the managed kafka configuration value for sasl_oauthbearer_expected_audience |
| - | --sasl-oauthbearer-expected-issuer | set the managed kafka configuration value for sasl_oauthbearer_expected_issuer |
| - | --sasl-oauthbearer-jwks-endpoint-url | set the managed kafka configuration value for sasl_oauthbearer_jwks_endpoint_url |
| - | --sasl-oauthbearer-sub-claim-name | set the managed kafka configuration value for sasl_oauthbearer_sub_claim_name |
| - | --socket-request-max-bytes | set the managed kafka configuration value for socket_request_max_bytes |
| - | --sort-buffer-size | set the managed mysql configuration value for sort_buffer_size |
| - | --temp-file-limit | set the managed postgresql configuration value for temp_file_limit |
| - | --tmp-table-size | set the managed mysql configuration value for tmp_table_size |
| - | --track-activity-query-size | set the managed postgresql configuration value for track_activity_query_size |
| - | --track-commit-timestamp | set the managed postgresql configuration value for track_commit_timestamp |
| - | --track-functions | set the managed postgresql configuration value for track_functions |
| - | --track-io-timing | set the managed postgresql configuration value for track_io_timing |
| - | --transaction-partition-verification-enable | set the managed kafka configuration value for transaction_partition_verification_enable |
| - | --transaction-remove-expired-transaction-cleanup-interval-ms | set the managed kafka configuration value for transaction_remove_expired_transaction_cleanup_interval_ms |
| - | --transaction-state-log-segment-bytes | set the managed kafka configuration value for transaction_state_log_segment_bytes |
| - | --wait-timeout | set the managed mysql configuration value for wait_timeout |
| - | --wal-sender-timeout | set the managed postgresql configuration value for wal_sender_timeout |
| - | --wal-writer-delay | set the managed postgresql configuration value for wal_writer_delay |
No comments yet.