Menu
Amazon Relational Database Service
User Guide (API Version 2014-10-31)

Appendix: 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. 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 5.6 parameters, go to the MySQL 5.6 documentation.

The MariaDB-specific DB parameter groups also contain the following modifiable parameters that are applicable to MariaDB only. Acceptable ranges for all modifiable parameters are the same as specified in the MariaDB documentation except where noted. Amazon RDS 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

    Amazon RDS 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.