Parameters for MariaDB - Amazon Relational Database Service

Parameters for MariaDB

By default, a MariaDB DB instance uses a DB parameter group that is specific to a MariaDB database. This parameter group contains some but not all of the parameters contained in the Amazon RDS DB parameter groups for the MySQL database engine. It also contains a number of new, MariaDB-specific parameters. For information about working with parameter groups and setting parameters, see Working with DB parameter groups.

The following MySQL parameters are not available in MariaDB-specific DB parameter groups:

  • bind_address

  • binlog_error_action

  • binlog_gtid_simple_recovery

  • binlog_max_flush_queue_time

  • binlog_order_commits

  • binlog_row_image

  • binlog_rows_query_log_events

  • binlogging_impossible_mode

  • block_encryption_mode

  • core_file

  • default_tmp_storage_engine

  • div_precision_increment

  • end_markers_in_json

  • enforce_gtid_consistency

  • eq_range_index_dive_limit

  • explicit_defaults_for_timestamp

  • gtid_executed

  • gtid-mode

  • gtid_next

  • gtid_owned

  • gtid_purged

  • log_bin_basename

  • log_bin_index

  • log_bin_use_v1_row_events

  • log_slow_admin_statements

  • log_slow_slave_statements

  • log_throttle_queries_not_using_indexes

  • master-info-repository

  • optimizer_trace

  • optimizer_trace_features

  • optimizer_trace_limit

  • optimizer_trace_max_mem_size

  • optimizer_trace_offset

  • relay_log_info_repository

  • rpl_stop_slave_timeout

  • slave_parallel_workers

  • slave_pending_jobs_size_max

  • slave_rows_search_algorithms

  • storage_engine

  • table_open_cache_instances

  • timed_mutexes

  • transaction_allow_batching

  • validate-password

  • validate_password_dictionary_file

  • validate_password_length

  • validate_password_mixed_case_count

  • validate_password_number_count

  • validate_password_policy

  • validate_password_special_char_count

For more information on MySQL parameters, go to the MySQL documentation.

The MariaDB-specific DB parameter groups also contain the following parameters that are applicable to MariaDB only. Acceptable ranges for the modifiable parameters are the same as specified in the MariaDB documentation except where noted. RDS for MariaDB parameters are set to the default values of the storage engine you have selected.

  • aria_block_size

  • aria_checkpoint_interval

  • aria_checkpoint_log_activity

  • aria_force_start_after_recovery_failures

  • aria_group_commit

  • aria_group_commit_interval

  • aria_log_dir_path

  • aria_log_file_size

  • aria_log_purge_type

  • aria_max_sort_file_size

  • aria_page_checksum

  • aria_pagecache_age_threshold

  • aria_pagecache_division_limit

  • aria_recover

    RDS for MariaDB supports the values of NORMAL, OFF, and QUICK, but not FORCE or BACKUP.

  • aria_repair_threads

  • aria_sort_buffer_size

  • aria_stats_method

  • aria_sync_log_dir

  • binlog_annotate_row_events

  • binlog_commit_wait_count

  • binlog_commit_wait_usec

  • binlog_row_image (MariaDB version 10.1 and later)

  • deadlock_search_depth_long

  • deadlock_search_depth_short

  • deadlock_timeout_long

  • deadlock_timeout_short

  • explicit_defaults_for_timestamp (MariaDB version 10.1 and later)

  • extra_max_connections

  • extra_port

  • feedback

  • feedback_send_retry_wait

  • feedback_send_timeout

  • feedback_url

  • feedback_user_info

  • gtid_domain_id

  • gtid_strict_mode

  • histogram_size

  • histogram_type

  • innodb_adaptive_hash_index_partitions

  • innodb_background_scrub_data_check_interval (MariaDB version 10.1 and later)

  • innodb_background_scrub_data_compressed (MariaDB version 10.1 and later)

  • innodb_background_scrub_data_interval (MariaDB version 10.1 and later)

  • innodb_background_scrub_data_uncompressed (MariaDB version 10.1 and later)

  • innodb_buf_dump_status_frequency (MariaDB version 10.1 and later)

  • innodb_buffer_pool_populate

  • innodb_cleaner_lsn_age_factor

  • innodb_compression_algorithm (MariaDB version 10.1 and later)

  • innodb_corrupt_table_action

  • innodb_defragment (MariaDB version 10.1 and later)

  • innodb_defragment_fill_factor (MariaDB version 10.1 and later)

  • innodb_defragment_fill_factor_n_recs (MariaDB version 10.1 and later)

  • innodb_defragment_frequency (MariaDB version 10.1 and later)

  • innodb_defragment_n_pages (MariaDB version 10.1 and later)

  • innodb_defragment_stats_accuracy (MariaDB version 10.1 and later)

  • innodb_empty_free_List_algorithm

  • innodb_fake_changes

  • innodb_fatal_semaphore_wait_threshold (MariaDB version 10.1 and later)

  • innodb_foreground_preflush

  • innodb_idle_flush_pct (MariaDB version 10.1 and later)

  • innodb_immediate_scrub_data_uncompressed (MariaDB version 10.1 and later)

  • innodb_instrument_semaphores (MariaDB version 10.1 and later)

  • innodb_locking_fake_changes

  • innodb_log_arch_dir

  • innodb_log_arch_expire_sec

  • innodb_log_archive

  • innodb_log_block_size

  • innodb_log_checksum_algorithm

  • innodb_max_bitmap_file_size

  • innodb_max_changed_pages

  • innodb_prefix_index_cluster_optimization (MariaDB version 10.1 and later)

  • innodb_sched_priority_cleaner

  • innodb_scrub_log (MariaDB version 10.1 and later)

  • innodb_scrub_log_speed (MariaDB version 10.1 and later)

  • innodb_show_locks_held

  • innodb_show_verbose_locks

  • innodb_simulate_comp_failures

  • innodb_stats_modified_counter

  • innodb_stats_traditional

  • innodb_use_atomic_writes

  • innodb_use_fallocate

  • innodb_use_global_flush_log_at_trx_commit

  • innodb_use_stacktrace

  • innodb_use_trim (MariaDB version 10.1 and later)

  • join_buffer_space_limit

  • join_cache_level

  • key_cache_file_hash_size

  • key_cache_segments

  • max_digest_length (MariaDB version 10.1 and later)

  • max_statement_time (MariaDB version 10.1 and later)

  • mysql56_temporal_format (MariaDB version 10.1 and later)

  • progress_report_time

  • query_cache_strip_comments

  • replicate_annotate_row_events

  • replicate_do_db

  • replicate_do_table

  • replicate_events_marked_for_skip

  • replicate_ignore_db

  • replicate_ignore_table

  • replicate_wild_ignore_table

  • slave_domain_parallel_threads

  • slave_parallel_max_queued

  • slave_parallel_mode (MariaDB version 10.1 and later)

  • slave_parallel_threads

  • slave_run_triggers_for_rbr (MariaDB version 10.1 and later)

  • sql_error_log_filename

  • sql_error_log_rate

  • sql_error_log_rotate

  • sql_error_log_rotations

  • sql_error_log_size_limit

  • thread_handling

  • thread_pool_idle_timeout

  • thread_pool_max_threads

  • thread_pool_min_threads

  • thread_pool_oversubscribe

  • thread_pool_size

  • thread_pool_stall_limit

  • transaction_write_set_extraction

  • use_stat_tables

  • userstat

For more information on MariaDB parameters, go to the MariaDB documentation.