RDS MySQL(default.mysql5.7) と Aurora MySQL(default.aurora-mysql5.7) のパラメータグループを比較してみた。
$ aws rds describe-db-parameters --db-parameter-group-name default.mysql5.7|jq -r '.Parameters[]|@text "\(.ParameterName)"'|sort > default.mysql5.7.txt $ aws rds describe-db-parameters --db-parameter-group-name default.aurora-mysql5.7|jq -r '.Parameters[]|@text "\(.ParameterName)"'|sort > default.aurora-mysql5.7.txt $ wc -l default.mysql5.7.txt 404 default.mysql5.7.txt $ wc -l default.aurora-mysql5.7.txt 293 default.aurora-mysql5.7.txt $ sdiff -s default.mysql5.7.txt default.aurora-mysql5.7.txt auto_generate_certs | aurora_disable_hash_join auto_increment_increment | aurora_lab_mode auto_increment_offset | aurora_parallel_query avoid_temporal_upgrade < binlog_checksum < binlog_error_action < binlog_format < binlog_group_commit_sync_delay < binlog_group_commit_sync_no_delay_count < binlog_gtid_simple_recovery < binlog_row_image < binlog_rows_query_log_events < block_encryption_mode < character-set-client-handshake < character_set_client < character_set_connection < character_set_database < character_set_filesystem < character_set_results < character_set_server < check_proxy_users < collation_connection < collation_server < completion_type < default_authentication_plugin < default_password_lifetime < default_storage_engine < disabled_storage_engines < disconnect_on_expired_password < enforce_gtid_consistency < gtid-mode < gtid_executed_compression_period < gtid_purged < innodb_adaptive_flushing_lwm < innodb_autoinc_lock_mode < innodb_buffer_pool_chunk_size < innodb_buffer_pool_dump_pct < innodb_buffer_pool_instances < innodb_change_buffering < innodb_checksum_algorithm < innodb_cmp_per_index_enabled < innodb_commit_concurrency < innodb_data_home_dir < innodb_deadlock_detect < innodb_default_row_format < innodb_disable_sort_file_cache < innodb_fast_shutdown < innodb_file_per_table < innodb_fill_factor < innodb_flush_log_at_trx_commit < innodb_flush_sync < innodb_ft_enable_diag_print < innodb_ft_max_token_size < innodb_ft_min_token_size < innodb_ft_num_word_optimize < innodb_ft_result_cache_limit < innodb_ft_sort_pll_degree < innodb_ft_total_cache_size < innodb_log_buffer_size < innodb_log_checksums < innodb_log_file_size < innodb_log_group_home_dir < innodb_log_write_ahead_size < innodb_max_dirty_pages_pct_lwm < innodb_max_undo_log_size < innodb_online_alter_log_max_size < innodb_optimize_fulltext_only < innodb_page_cleaners < innodb_page_size < innodb_purge_batch_size < innodb_purge_rseg_truncate_frequency < innodb_purge_threads < innodb_rollback_on_timeout < innodb_rollback_segments < innodb_spin_wait_delay < innodb_strict_mode < innodb_support_xa < innodb_sync_array_size < innodb_sync_spin_loops < innodb_table_locks < innodb_temp_data_file_path < innodb_undo_directory < innodb_undo_log_truncate < innodb_undo_logs < innodb_undo_tablespaces < lc_time_names < log_builtin_as_identified_by_password < log_statements_unsafe_for_binlog < log_syslog < log_syslog_facility < log_syslog_include_pid < log_syslog_tag < log_timestamps < lower_case_table_names < master-info-repository < master_verify_checksum < max_digest_length < mecab_rc_file < mysql_native_password_proxy_users < ngram_token_size < offline_mode < > performance-schema-consumer-events-waits-current > performance-schema-instrument > performance_schema_consumer_events_stages_current > performance_schema_consumer_events_stages_history > performance_schema_consumer_events_stages_history_long > performance_schema_consumer_events_statements_current > performance_schema_consumer_events_statements_history > performance_schema_consumer_events_statements_history_long > performance_schema_consumer_events_waits_history > performance_schema_consumer_events_waits_history_long > performance_schema_consumer_global_instrumentation > performance_schema_consumer_statements_digest > performance_schema_consumer_thread_instrumentation require_secure_transport < rpl_semi_sync_master_wait_for_slave_count < rpl_semi_sync_master_wait_point < rpl_stop_slave_timeout < server_id < session_track_gtids < session_track_schema < session_track_state_change < session_track_system_variables < session_track_transaction_info < sha256_password_auto_generate_rsa_keys < sha256_password_proxy_users < show_old_temporals < skip-character-set-client-handshake < skip_name_resolve < slave_allow_batching < slave_compressed_protocol < slave_net_timeout < slave_parallel_type < slave_preserve_commit_order < slave_rows_search_algorithms < slave_transaction_retries < slave_type_conversions < super_read_only < sync_frm < > table_cache_element_entry_ttl > thread_handling time_zone < tls_version < transaction_write_set_extraction <
参考
Amazon Aurora MySQLリファレンス - Amazon Aurora適切ではない MySQL パラメータおよびステータス変数
Aurora MySQL と MySQL ではアーキテクチャに違いがあるため、一部の MySQL パラメータおよびステータス変数は Aurora MySQL に適用されません。
以下の MySQL パラメータは Aurora MySQL には適用されません。
- innodb_adaptive_flushing
- innodb_adaptive_flushing_lwm
- innodb_change_buffering
- innodb_checksum_algorithm
- innodb_doublewrite
- innodb_flush_method
- innodb_flush_neighbors
- innodb_io_capacity
- innodb_io_capacity_max
- innodb_log_buffer_size
- innodb_log_file_size
- innodb_log_files_in_group
- innodb_max_dirty_pages_pct
- innodb_use_native_aio
- innodb_write_io_threads
- thread_cache_size
