Amazon Aurora MySQL 5.7 オプショングループ DB Cluster Parameter Groupのデフォルトパラメータを確認する場合は以下URLを参照ください。
https://inab818.site/amazon-web-services/aurora-mysql5-7-optiongroup-dbcluster-parametergroup-default-parameterlist/
| 名前 | 値 | 許可された値 | 変更可能 | 送信元 | 適用タイプ | データ型 |
| allow-suspicious-udfs | 0, 1 | FALSE | engine-default | static | boolean | |
| aurora_disable_hash_join | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| aurora_lab_mode | 0 | 0, 1 | TRUE | engine-default | static | boolean |
| autocommit | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| automatic_sp_privileges | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| binlog_order_commits | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| core-file | 0, 1 | FALSE | engine-default | static | boolean | |
| end_markers_in_json | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| explicit_defaults_for_timestamp | 1 | 0, 1 | TRUE | system | static | boolean |
| flush | 0, 1 | FALSE | engine-default | dynamic | boolean | |
| general_log | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| innodb_adaptive_flushing | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| innodb_adaptive_hash_index | 0 | 0, 1 | TRUE | system | dynamic | boolean |
| innodb_buffer_pool_dump_at_shutdown | 0 | 0, 1 | FALSE | engine-default | dynamic | boolean |
| innodb_buffer_pool_dump_now | 0, 1 | FALSE | engine-default | dynamic | boolean | |
| innodb_buffer_pool_load_abort | 0, 1 | FALSE | engine-default | dynamic | boolean | |
| innodb_buffer_pool_load_at_startup | 0 | 0, 1 | FALSE | engine-default | static | boolean |
| innodb_buffer_pool_load_now | 0, 1 | FALSE | engine-default | dynamic | boolean | |
| innodb_force_load_corrupted | 0, 1 | FALSE | engine-default | static | boolean | |
| innodb_ft_enable_stopword | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| innodb_large_prefix | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| innodb_log_compressed_pages | 0, 1 | FALSE | engine-default | dynamic | boolean | |
| innodb_print_all_deadlocks | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| innodb_random_read_ahead | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| innodb_read_only | 0, 1 | FALSE | engine-default | static | boolean | |
| innodb_stats_auto_recalc | 0, 1 | TRUE | system | dynamic | boolean | |
| innodb_stats_on_metadata | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| innodb_stats_persistent | OFF, ON, 0, 1 | TRUE | system | dynamic | boolean | |
| innodb_status_output | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| innodb_status_output_locks | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| innodb_use_native_aio | 0, 1 | FALSE | engine-default | static | boolean | |
| keep_files_on_create | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| local_infile | 1 | 0, 1 | TRUE | system | dynamic | boolean |
| log_bin_trust_function_creators | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| log_bin_use_v1_row_events | 0, 1 | TRUE | engine-default | static | boolean | |
| log_queries_not_using_indexes | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| log_slave_updates | 1 | 0, 1 | FALSE | system | static | boolean |
| log_slow_admin_statements | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| log_slow_slave_statements | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| low_priority_updates | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| myisam_use_mmap | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| old-style-user-limits | 0, 1 | TRUE | engine-default | static | boolean | |
| optimizer_prune_level | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| performance_schema | 0 | 0, 1 | TRUE | system | static | boolean |
| performance_schema_consumer_events_stages_current | 0, 1 | TRUE | engine-default | static | boolean | |
| performance_schema_consumer_events_stages_history | 0, 1 | TRUE | engine-default | static | boolean | |
| performance_schema_consumer_events_stages_history_long | 0, 1 | TRUE | engine-default | static | boolean | |
| performance_schema_consumer_events_statements_current | 0, 1 | TRUE | engine-default | static | boolean | |
| performance_schema_consumer_events_statements_history | 0, 1 | TRUE | engine-default | static | boolean | |
| performance_schema_consumer_events_statements_history_long | 0, 1 | TRUE | engine-default | static | boolean | |
| performance_schema_consumer_events_waits_history | 0, 1 | TRUE | engine-default | static | boolean | |
| performance_schema_consumer_events_waits_history_long | 0, 1 | TRUE | engine-default | static | boolean | |
| performance_schema_consumer_global_instrumentation | 0, 1 | TRUE | engine-default | static | boolean | |
| performance_schema_consumer_statements_digest | 0, 1 | TRUE | engine-default | static | boolean | |
| performance_schema_consumer_thread_instrumentation | 0, 1 | TRUE | engine-default | static | boolean | |
| query_cache_wlock_invalidate | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| read_only | {TrueIfReplica} | 0, 1, {TrueIfReplica} | TRUE | system | dynamic | boolean |
| relay_log_recovery | 1 | 0, 1 | FALSE | system | dynamic | boolean |
| safe-user-create | 0, 1 | TRUE | engine-default | static | boolean | |
| secure_auth | 1 | 1 | TRUE | engine-default | dynamic | boolean |
| show_compatibility_56 | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| skip_external_locking | 0, 1 | FALSE | engine-default | static | boolean | |
| skip_show_database | 0, 1 | TRUE | engine-default | static | boolean | |
| skip-slave-start | 1 | 0, 1 | FALSE | system | static | boolean |
| slave_sql_verify_checksum | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| slow_query_log | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| sysdate-is-now | 0, 1 | TRUE | engine-default | static | boolean | |
| temp-pool | 0, 1 | TRUE | engine-default | static | boolean | |
| updatable_views_with_limit | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| long_query_time | 0-31536000 | TRUE | engine-default | dynamic | float | |
| back_log | 1-65535 | TRUE | engine-default | static | integer | |
| binlog_cache_size | 32768 | 4096-18446744073709547520 | TRUE | system | dynamic | integer |
| binlog_max_flush_queue_time | 0-100000 | TRUE | engine-default | dynamic | integer | |
| binlog_stmt_cache_size | 4096-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| bulk_insert_buffer_size | 0-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| concurrent_insert | 0-2 | TRUE | engine-default | dynamic | integer | |
| connect_timeout | 2-31536000 | TRUE | engine-default | dynamic | integer | |
| default_week_format | 0-7 | TRUE | engine-default | dynamic | integer | |
| delayed_insert_limit | 1-9223372036854775807 | TRUE | engine-default | dynamic | integer | |
| delayed_insert_timeout | 1-31536000 | TRUE | engine-default | dynamic | integer | |
| delayed_queue_size | 1-9223372036854775807 | TRUE | engine-default | dynamic | integer | |
| div_precision_increment | 0-30 | TRUE | engine-default | dynamic | integer | |
| eq_range_index_dive_limit | 0-4294967295 | TRUE | engine-default | dynamic | integer | |
| flush_time | 0-31536000 | TRUE | engine-default | dynamic | integer | |
| ft_max_word_len | 10-84 | TRUE | engine-default | static | integer | |
| ft_min_word_len | 1-84 | TRUE | engine-default | static | integer | |
| ft_query_expansion_limit | 0-1000 | TRUE | engine-default | static | integer | |
| group_concat_max_len | 4-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| host_cache_size | 0-65536 | TRUE | engine-default | dynamic | integer | |
| innodb_adaptive_hash_index_parts | 1-512 | TRUE | engine-default | static | integer | |
| innodb_adaptive_max_sleep_delay | 0-1000000 | TRUE | engine-default | dynamic | integer | |
| innodb_autoextend_increment | 1-1000 | TRUE | engine-default | dynamic | integer | |
| innodb_buffer_pool_size | {DBInstanceClassMemory*3/4} | 67108864-9223372036854775807 | TRUE | system | static | integer |
| innodb_change_buffer_max_size | 0-50 | FALSE | engine-default | dynamic | integer | |
| innodb_compression_failure_threshold_pct | 0-100 | TRUE | engine-default | dynamic | integer | |
| innodb_compression_level | 0-9 | TRUE | engine-default | dynamic | integer | |
| innodb_compression_pad_pct_max | 0-75 | TRUE | engine-default | dynamic | integer | |
| innodb_concurrency_tickets | 1-4294967295 | TRUE | engine-default | dynamic | integer | |
| innodb_flushing_avg_loops | 1-1000 | FALSE | engine-default | dynamic | integer | |
| innodb_flush_log_at_timeout | 0-2700 | FALSE | engine-default | dynamic | integer | |
| innodb_flush_neighbors | 0-2 | FALSE | engine-default | dynamic | integer | |
| innodb_ft_cache_size | 0-4294967295 | TRUE | engine-default | static | integer | |
| innodb_io_capacity | 100-18446744073709551615 | FALSE | engine-default | dynamic | integer | |
| innodb_io_capacity_max | 2000-18446744073709547520 | FALSE | engine-default | dynamic | integer | |
| innodb_lock_wait_timeout | 1-1073741824 | TRUE | engine-default | dynamic | integer | |
| innodb_lru_scan_depth | 100-18446744073709551615 | TRUE | engine-default | dynamic | integer | |
| innodb_max_dirty_pages_pct | 0-99 | TRUE | engine-default | dynamic | integer | |
| innodb_max_purge_lag | 0-4294967295 | TRUE | engine-default | dynamic | integer | |
| innodb_max_purge_lag_delay | 0-18446744073709551615 | TRUE | engine-default | dynamic | integer | |
| innodb_old_blocks_pct | 5-95 | TRUE | engine-default | dynamic | integer | |
| innodb_old_blocks_time | 0-4294967295 | TRUE | engine-default | dynamic | integer | |
| innodb_open_files | -1, 10-4294967295 | TRUE | engine-default | static | integer | |
| innodb_read_ahead_threshold | 0-64 | TRUE | engine-default | dynamic | integer | |
| innodb_read_io_threads | 1-64 | FALSE | engine-default | static | integer | |
| innodb_replication_delay | 0-4294967295 | TRUE | engine-default | dynamic | integer | |
| innodb_sort_buffer_size | 65536-67108864 | TRUE | engine-default | static | integer | |
| innodb_stats_persistent_sample_pages | 0-18446744073709551615 | TRUE | engine-default | dynamic | integer | |
| innodb_stats_transient_sample_pages | 0-18446744073709551615 | TRUE | engine-default | dynamic | integer | |
| innodb_thread_concurrency | 0-1000 | FALSE | engine-default | dynamic | integer | |
| innodb_thread_sleep_delay | 0-9223372036854775807 | TRUE | engine-default | dynamic | integer | |
| innodb_write_io_threads | 1-64 | FALSE | engine-default | static | integer | |
| interactive_timeout | 1-31536000 | TRUE | engine-default | dynamic | integer | |
| join_buffer_size | 128-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| key_buffer_size | 16777216 | 4096-4294967295 | TRUE | system | dynamic | integer |
| key_cache_age_threshold | 100-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| key_cache_block_size | 512-16384 | TRUE | engine-default | dynamic | integer | |
| key_cache_division_limit | 1-100 | TRUE | engine-default | dynamic | integer | |
| lock_wait_timeout | 1-31536000 | TRUE | engine-default | dynamic | integer | |
| log_error_verbosity | 1月3日 | TRUE | engine-default | dynamic | integer | |
| log_throttle_queries_not_using_indexes | 0-4294967295 | TRUE | engine-default | dynamic | integer | |
| log_warnings | 0-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| max_allowed_packet | 1024-1073741824 | TRUE | engine-default | dynamic | integer | |
| max_binlog_cache_size | 4096-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| max_binlog_size | 1.34E+08 | 4096-1073741824 | FALSE | system | dynamic | integer |
| max_binlog_stmt_cache_size | 4096-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| max_connect_errors | 1-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| max_connections | GREATEST({log(DBInstanceClassMemory/805306368)*45},{log(DBInstanceClassMemory/8187281408)*1000}) | 1-16000 | TRUE | system | dynamic | integer |
| max_delayed_threads | 0-16384 | TRUE | engine-default | dynamic | integer | |
| max_error_count | 0-65535 | TRUE | engine-default | dynamic | integer | |
| max_execution_time | 0-18446744073709551615 | TRUE | engine-default | dynamic | integer | |
| max_heap_table_size | 16384-1844674407370954752 | TRUE | engine-default | dynamic | integer | |
| max_insert_delayed_threads | 0-16384 | TRUE | engine-default | dynamic | integer | |
| max_join_size | 1-18446744073709551615 | TRUE | engine-default | dynamic | integer | |
| max_length_for_sort_data | 4-8388608 | TRUE | engine-default | dynamic | integer | |
| max_points_in_geometry | 3-1048576 | FALSE | engine-default | dynamic | integer | |
| max_prepared_stmt_count | 0-1048576 | TRUE | engine-default | dynamic | integer | |
| max_seeks_for_key | 1-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| max_sort_length | 4-8388608 | TRUE | engine-default | dynamic | integer | |
| max_sp_recursion_depth | 0-255 | TRUE | engine-default | dynamic | integer | |
| max_tmp_tables | 1-9223372036854775807 | TRUE | engine-default | dynamic | integer | |
| max_user_connections | 0-4294967295 | TRUE | engine-default | dynamic | integer | |
| max_write_lock_count | 1-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| metadata_locks_cache_size | 1-1048576 | TRUE | engine-default | static | integer | |
| min_examined_row_limit | 0-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| myisam_data_pointer_size | 2月7日 | TRUE | engine-default | dynamic | integer | |
| myisam_max_sort_file_size | 0-9223372036853727232 | TRUE | engine-default | dynamic | integer | |
| myisam_mmap_size | 7-922337203685477807 | TRUE | engine-default | static | integer | |
| myisam_sort_buffer_size | 4-9223372036854775807 | TRUE | engine-default | dynamic | integer | |
| net_buffer_length | 1024-1048576 | TRUE | engine-default | dynamic | integer | |
| net_read_timeout | 1-31536000 | TRUE | engine-default | dynamic | integer | |
| net_retry_count | 1-9223372036854775807 | TRUE | engine-default | dynamic | integer | |
| net_write_timeout | 1-31536000 | TRUE | engine-default | dynamic | integer | |
| old_passwords | 0, 2 | TRUE | engine-default | dynamic | integer | |
| optimizer_search_depth | 0-62 | TRUE | engine-default | dynamic | integer | |
| optimizer_trace_limit | 1-9223372036854775807 | TRUE | engine-default | dynamic | integer | |
| optimizer_trace_max_mem_size | 0-18446744073709551615 | TRUE | engine-default | dynamic | integer | |
| optimizer_trace_offset | -1.8E+19 | TRUE | engine-default | dynamic | integer | |
| performance_schema_accounts_size | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_digests_size | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_events_stages_history_long_size | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_events_stages_history_size | -1025 | TRUE | engine-default | static | integer | |
| performance_schema_events_statements_history_long_size | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_events_statements_history_size | -1025 | TRUE | engine-default | static | integer | |
| performance_schema_events_transactions_history_long_size | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_events_transactions_history_size | -1025 | TRUE | engine-default | static | integer | |
| performance_schema_events_waits_history_long_size | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_events_waits_history_size | -1025 | TRUE | engine-default | static | integer | |
| performance_schema_hosts_size | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_max_cond_classes | 0-256 | TRUE | engine-default | static | integer | |
| performance_schema_max_cond_instances | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_max_digest_length | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_max_file_classes | 0-256 | TRUE | engine-default | static | integer | |
| performance_schema_max_file_handles | 0-1048576 | TRUE | engine-default | static | integer | |
| performance_schema_max_file_instances | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_max_index_stat | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_max_memory_classes | -1025 | TRUE | engine-default | static | integer | |
| performance_schema_max_metadata_locks | -1E+08 | TRUE | engine-default | static | integer | |
| performance_schema_max_mutex_classes | 0-256 | TRUE | engine-default | static | integer | |
| performance_schema_max_mutex_instances | -1E+08 | TRUE | engine-default | static | integer | |
| performance_schema_max_prepared_statements_instances | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_max_program_instances | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_max_rwlock_classes | 0-256 | TRUE | engine-default | static | integer | |
| performance_schema_max_rwlock_instances | -1E+08 | TRUE | engine-default | static | integer | |
| performance_schema_max_socket_classes | 0-256 | TRUE | engine-default | static | integer | |
| performance_schema_max_socket_instances | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_max_sql_text_length | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_max_stage_classes | 0-256 | TRUE | engine-default | static | integer | |
| performance_schema_max_statement_classes | 0-256 | TRUE | engine-default | static | integer | |
| performance_schema_max_statement_stack | 1-256 | TRUE | engine-default | static | integer | |
| performance_schema_max_table_handles | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_max_table_instances | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_max_table_lock_stat | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_max_thread_classes | 0-256 | TRUE | engine-default | static | integer | |
| performance_schema_max_thread_instances | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_session_connect_attrs_size | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_setup_actors_size | 0-1024 | TRUE | engine-default | static | integer | |
| performance_schema_setup_objects_size | -1048577 | TRUE | engine-default | static | integer | |
| performance_schema_users_size | -1048577 | TRUE | engine-default | static | integer | |
| port | {EndPointPort} | FALSE | system | static | integer | |
| preload_buffer_size | 1024-1073741824 | TRUE | engine-default | dynamic | integer | |
| profiling_history_size | 0-100 | TRUE | engine-default | dynamic | integer | |
| query_alloc_block_size | 1024-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| query_cache_limit | 0-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| query_cache_min_res_unit | 512-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| query_cache_size | {DBInstanceClassMemory/24} | 0-9223372036854774784 | TRUE | system | dynamic | integer |
| query_cache_type | 1 | 0-2 | TRUE | system | static | integer |
| query_prealloc_size | 8192-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| range_alloc_block_size | 4096-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| range_optimizer_max_mem_size | 0-18446744073709551615 | TRUE | engine-default | dynamic | integer | |
| read_buffer_size | 262144 | 8200-2147479552 | TRUE | system | dynamic | integer |
| read_rnd_buffer_size | 524288 | 8200-2147479552 | TRUE | system | dynamic | integer |
| slave_checkpoint_group | 32-524280 | TRUE | engine-default | dynamic | integer | |
| slave_checkpoint_period | 1-4294967295 | TRUE | engine-default | dynamic | integer | |
| slave_parallel_workers | 0-1024 | TRUE | engine-default | dynamic | integer | |
| slave_pending_jobs_size_max | 1024-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| slow_launch_time | 0-31536000 | TRUE | engine-default | dynamic | integer | |
| sort_buffer_size | 32768-18446744073709551615 | TRUE | engine-default | dynamic | integer | |
| sql_select_limit | 0-18446744073709551615 | TRUE | engine-default | dynamic | integer | |
| stored_program_cache | 256-524288 | TRUE | engine-default | dynamic | integer | |
| sync_binlog | 1 | 0-18446744073709547520 | FALSE | system | dynamic | integer |
| sync_master_info | 0-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| sync_relay_log | 0-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| sync_relay_log_info | 0-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| table_cache_element_entry_ttl | 5 | FALSE | engine-default | static | integer | |
| table_definition_cache | LEAST({DBInstanceClassMemory/393040}, 20000) | -1, 400-524288 | TRUE | engine-default | dynamic | integer |
| table_open_cache | LEAST({DBInstanceClassMemory/1179121}, 6000) | 1-524288 | TRUE | engine-default | dynamic | integer |
| table_open_cache_instances | 1-64 | TRUE | engine-default | static | integer | |
| thread_cache_size | {DBInstanceClassMemory/1005785088} | 0-16384 | TRUE | system | dynamic | integer |
| thread_stack | 262144 | 131072-18446744073709547520 | TRUE | engine-default | static | integer |
| tmp_table_size | 1024-18446744073709551615 | TRUE | engine-default | dynamic | integer | |
| transaction_alloc_block_size | 1024-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| transaction_prealloc_size | 1024-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| validate_password_length | 0-2147483647 | FALSE | engine-default | dynamic | integer | |
| validate_password_mixed_case_count | 0-2147483647 | FALSE | engine-default | dynamic | integer | |
| validate_password_number_count | 0-2147483647 | FALSE | engine-default | dynamic | integer | |
| validate_password_special_char_count | 0-2147483647 | FALSE | engine-default | dynamic | integer | |
| wait_timeout | 1-31536000 | TRUE | engine-default | dynamic | integer | |
| optimizer_switch | default, batched_key_access=on, batched_key_access=off, block_nested_loop=on, block_nested_loop=off, condition_fanout_filter=on, condition_fanout_filter=off, derived_merge=on, derived_merge=off, duplicateweedout=on, duplicateweedout=off, engine_condition_pushdown=on, engine_condition_pushdown=off, firstmatch=on, firstmatch=off, index_condition_pushdown=on, index_condition_pushdown=off, index_merge=on, index_merge=off, index_merge_intersection=on, index_merge_intersection=off, index_merge_sort_union=on, index_merge_sort_union=off, index_merge_union=on, index_merge_union=off, loosescan=on, loosescan=off, materialization=on, materialization=off, mrr=on, mrr=off, mrr_cost_based=on, mrr_cost_based=off, semijoin=on, semijoin=off, subquery_materialization_cost_based=on, subquery_materialization_cost_based=off, use_index_extensions=on, use_index_extensions=off | TRUE | engine-default | dynamic | list | |
| sql_mode | 0 | 0, ANSI, ALLOW_INVALID_DATES, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_CREATE_USER, NO_AUTO_VALUE_ON_ZERO, NO_BACKSLASH_ESCAPES, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_FIELD_OPTIONS, NO_KEY_OPTIONS, NO_TABLE_OPTIONS, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PAD_CHAR_TO_FULL_LENGTH, PIPES_AS_CONCAT, REAL_AS_FLOAT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES, TRADITIONAL | TRUE | system | dynamic | list |
| aurora_oom_response | TRUE | engine-default | dynamic | string | ||
| aurora_parallel_query | OFF | ON, OFF | TRUE | system | dynamic | string |
| basedir | /rdsdbbin/oscar | FALSE | system | static | string | |
| datadir | /rdsdbdata/db/ | FALSE | system | static | string | |
| default_time_zone | FALSE | engine-default | static | string | ||
| default_tmp_storage_engine | InnoDB | InnoDB, MyISAM | TRUE | system | static | string |
| delay_key_write | OFF, ON, ALL | TRUE | engine-default | dynamic | string | |
| event_scheduler | ON, OFF | TRUE | engine-default | dynamic | string | |
| ft_boolean_syntax | FALSE | engine-default | dynamic | string | ||
| ft_stopword_file | /dev/null | TRUE | engine-default | static | string | |
| general_log_file | /rdsdbdata/log/general/mysql-general.log | FALSE | system | dynamic | string | |
| init_connect | TRUE | engine-default | dynamic | string | ||
| innodb_buffer_pool_filename | FALSE | engine-default | dynamic | string | ||
| innodb_file_format | Antelope, Barracuda | TRUE | engine-default | dynamic | string | |
| innodb_flush_method | O_DIRECT | O_DIRECT | TRUE | system | static | string |
| innodb_ft_aux_table | TRUE | engine-default | dynamic | string | ||
| innodb_ft_server_stopword_table | TRUE | engine-default | dynamic | string | ||
| innodb_ft_user_stopword_table | TRUE | engine-default | dynamic | string | ||
| innodb_monitor_disable | TRUE | engine-default | dynamic | string | ||
| innodb_monitor_enable | TRUE | engine-default | dynamic | string | ||
| innodb_monitor_reset | TRUE | engine-default | dynamic | string | ||
| innodb_monitor_reset_all | TRUE | engine-default | dynamic | string | ||
| innodb_stats_method | nulls_equal, nulls_unequal, nulls_ignored | TRUE | engine-default | dynamic | string | |
| internal_tmp_disk_storage_engine | MYISAM, INNODB | TRUE | engine-default | dynamic | string | |
| log-bin | /rdsdbdata/log/binlog/mysql-bin-changelog | FALSE | system | static | string | |
| log_error | /rdsdbdata/log/error/mysql-error.log | FALSE | system | static | string | |
| log_output | FILE | TABLE, FILE, NONE | TRUE | system | dynamic | string |
| myisam_stats_method | nulls_equal, nulls_unequal, nulls_ignored | TRUE | engine-default | dynamic | string | |
| optimizer_trace | enabled=on, enabled=off, one_line=on, one_line=off | TRUE | engine-default | dynamic | string | |
| optimizer_trace_features | greedy_search=on, greedy_search=off, range_optimizer=on, range_optimizer=off, dynamic_range=on, dynamic_range=off, repeated_subselect=on, repeated_subselect=off | TRUE | engine-default | dynamic | string | |
| performance-schema-consumer-events-waits-current | ON, OFF | TRUE | engine-default | static | string | |
| performance-schema-instrument | TRUE | engine-default | static | string | ||
| pid_file | /rdsdbdata/log/mysql-{EndPointPort}.pid | FALSE | system | static | string | |
| plugin_dir | FALSE | system | static | string | ||
| relay-log | /rdsdbdata/log/relaylog/relaylog | FALSE | system | static | string | |
| relay_log_info_repository | TABLE | FILE, TABLE | TRUE | system | static | string |
| secure_file_priv | /tmp | FALSE | system | static | string | |
| slow_query_log_file | /rdsdbdata/log/slowquery/mysql-slowquery.log | FALSE | system | dynamic | string | |
| socket | /tmp/mysql.sock | FALSE | system | static | string | |
| thread_handling | multiple-connections-per-thread | multiple-connections-per-thread, no-threads, one-thread-per-connection, dynamically-loaded | FALSE | system | static | string |
| tmpdir | /rdsdbdata/tmp/ | FALSE | system | static | string | |
| tx_isolation | READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE | TRUE | engine-default | dynamic | string | |
| validate-password | ON, OFF, FORCE, FORCE_PLUS_PERMANENT | FALSE | engine-default | static | string | |
| validate_password_dictionary_file | FALSE | engine-default | static | string | ||
| validate_password_policy | LOW, MEDIUM, STRONG | FALSE | engine-default | dynamic | string |