MariaDB 的参数 - Amazon Relational Database Service
Amazon Web Services 文档中描述的 Amazon Web Services 服务或功能可能因区域而异。要查看适用于中国区域的差异,请参阅中国的 Amazon Web Services 服务入门

MariaDB 的参数

默认情况下,MariaDB 数据库实例使用特定于 MariaDB 数据库的数据库参数组。该参数组包含 MySQL 数据库引擎的 Amazon RDS 数据库参数组中所含的部分而非全部参数。它还包含一些新的特定于 MariaDB 的参数。有关使用参数组和设置参数的信息,请参阅使用数据库参数组

以下 MySQL 参数在 MariaDB 特定的数据库参数组中不可用:

  • 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

有关 MySQL 参数的更多信息,请转到 MySQL 文档

MariaDB 特定的数据库参数组还包含仅适用于 MariaDB 的以下参数。除非另有说明,否则可修改参数的可接受范围与 MariaDB 文档中指定的相同。RDS for MariaDB 参数设置为您已选择的存储引擎的默认值。

  • 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 支持值 NORMAL、OFF 和 QUICK,但不支持值 FORCE 或 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

  • deadlock_search_depth_long

  • deadlock_search_depth_short

  • deadlock_timeout_long

  • deadlock_timeout_short

  • explicit_defaults_for_timestamp

  • extra_max_connections

  • extra_port

  • 反馈

  • 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

  • innodb_background_scrub_data_compressed

  • innodb_background_scrub_data_interval

  • innodb_background_scrub_data_uncompressed

  • innodb_buf_dump_status_frequency

  • innodb_buffer_pool_populate

  • innodb_cleaner_lsn_age_factor

  • innodb_compression_algorithm

  • innodb_corrupt_table_action

  • innodb_defragment

  • innodb_defragment_fill_factor

  • innodb_defragment_fill_factor_n_recs

  • innodb_defragment_frequency

  • innodb_defragment_n_pages

  • innodb_defragment_stats_accuracy

  • innodb_empty_free_List_algorithm

  • innodb_fake_changes

  • innodb_fatal_semaphore_wait_threshold

  • innodb_foreground_preflush

  • innodb_idle_flush_pct

  • innodb_immediate_scrub_data_uncompressed

  • innodb_instrument_semaphores

  • 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

  • innodb_sched_priority_cleaner

  • innodb_scrub_log

  • innodb_scrub_log_speed

  • 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

  • join_buffer_space_limit

  • join_cache_level

  • key_cache_file_hash_size

  • key_cache_segments

  • max_digest_length

  • max_statement_time

  • mysql56_temporal_format

  • 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

  • slave_parallel_threads

  • slave_run_triggers_for_rbr

  • 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

有关 MariaDB 参数的更多信息,请转到 MariaDB 文档