Amazon Aurora MySQL 8.0 オプショングループ DB Parameter Groupのデフォルトパラメータを確認する場合は以下URLを参照ください。
https://inab818.site/amazon-web-services/aurora-mysql8-0-optiongroup-dbparametergroup-default-parameterlist/
| 名前 | 値 | 許可された値 | 変更可能 | 送信元 | 適用タイプ | データ型 |
| activate_all_roles_on_login | 0 | 0, 1 | TRUE | engine-default | dynamic | boolean |
| allow-suspicious-udfs | 0, 1 | FALSE | engine-default | static | boolean | |
| aurora_binlog_replication_max_yield_seconds | 0-36000 | TRUE | engine-default | dynamic | integer | |
| aurora_enable_staggered_replica_restart | 0, 1 | TRUE | system | dynamic | boolean | |
| aurora_fwd_writer_idle_timeout | 60 | 1-86400 | TRUE | system | dynamic | integer |
| aurora_fwd_writer_max_connections_pct | 10 | 0-90 | TRUE | system | dynamic | integer |
| aurora_parallel_query | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| aurora_read_replica_read_committed | OFF | ON, OFF | TRUE | engine-default | dynamic | string |
| autocommit | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| auto_increment_increment | 1-65535 | TRUE | engine-default | dynamic | integer | |
| auto_increment_offset | 1-65535 | TRUE | engine-default | dynamic | integer | |
| automatic_sp_privileges | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| aws_default_comprehend_role | TRUE | engine-default | dynamic | string | ||
| aws_default_lambda_role | TRUE | engine-default | dynamic | string | ||
| aws_default_logs_role | TRUE | engine-default | dynamic | string | ||
| aws_default_s3_role | TRUE | engine-default | dynamic | string | ||
| aws_default_sagemaker_role | TRUE | engine-default | dynamic | string | ||
| back_log | 1-65535 | TRUE | engine-default | static | integer | |
| basedir | /rdsdbbin/oscar | FALSE | system | static | string | |
| binlog_cache_size | 32768 | 4096-18446744073709547520 | TRUE | system | dynamic | integer |
| binlog_checksum | NONE, CRC32 | TRUE | engine-default | dynamic | string | |
| binlog-do-db | TRUE | engine-default | static | list | ||
| binlog_error_action | IGNORE_ERROR, ABORT_SERVER | TRUE | engine-default | dynamic | string | |
| binlog_format | OFF | ROW, STATEMENT, MIXED, OFF | TRUE | system | static | string |
| binlog_group_commit_sync_delay | 0-1000000 | TRUE | engine-default | dynamic | integer | |
| binlog_group_commit_sync_no_delay_count | 0-100000 | TRUE | engine-default | dynamic | integer | |
| binlog-ignore-db | TRUE | engine-default | static | list | ||
| binlog_max_flush_queue_time | 0-100000 | TRUE | engine-default | dynamic | integer | |
| binlog_order_commits | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| binlog_row_image | full, minimal, noblob | TRUE | engine-default | dynamic | string | |
| binlog_row_metadata | full, minimal | TRUE | engine-default | dynamic | string | |
| binlog_rows_query_log_events | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| binlog_row_value_options | PARTIAL_JSON, | TRUE | engine-default | dynamic | string | |
| binlog_stmt_cache_size | 4096-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| binlog_transaction_compression | ON, OFF | TRUE | engine-default | dynamic | string | |
| binlog_transaction_compression_level_zstd | 1月22日 | TRUE | engine-default | dynamic | integer | |
| binlog_transaction_dependency_history_size | 1-1000000 | TRUE | engine-default | dynamic | integer | |
| binlog_transaction_dependency_tracking | COMMIT_ORDER, WRITESET, WRITESET_SESSION | TRUE | engine-default | dynamic | string | |
| bulk_insert_buffer_size | 0-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| character_set_client | big5, dec8, cp850, hp8, koi8r, latin1, latin2, swe7, ascii, ujis, sjis, hebrew, tis620, euckr, koi8u, gb2312, greek, cp1250, gbk, latin5, armscii8, utf8, cp866, keybcs2, macce, macroman, cp852, latin7, utf8mb4, cp1251, cp1256, cp1257, binary, geostd8, cp932, eucjpms | TRUE | engine-default | dynamic | string | |
| character-set-client-handshake | 0, 1 | TRUE | engine-default | static | boolean | |
| character_set_connection | big5, dec8, cp850, hp8, koi8r, latin1, latin2, swe7, ascii, ujis, sjis, hebrew, tis620, euckr, koi8u, gb2312, greek, cp1250, gbk, latin5, armscii8, utf8, ucs2, cp866, keybcs2, macce, macroman, cp852, latin7, utf8mb4, cp1251, utf16, cp1256, cp1257, utf32, binary, geostd8, cp932, eucjpms | TRUE | engine-default | dynamic | string | |
| character_set_database | big5, dec8, cp850, hp8, koi8r, latin1, latin2, swe7, ascii, ujis, sjis, hebrew, tis620, euckr, koi8u, gb2312, greek, cp1250, gbk, latin5, armscii8, utf8, ucs2, cp866, keybcs2, macce, macroman, cp852, latin7, utf8mb4, cp1251, utf16, cp1256, cp1257, utf32, binary, geostd8, cp932, eucjpms | TRUE | engine-default | dynamic | string | |
| character_set_filesystem | big5, dec8, cp850, hp8, koi8r, latin1, latin2, swe7, ascii, ujis, sjis, hebrew, tis620, euckr, koi8u, gb2312, greek, cp1250, gbk, latin5, armscii8, utf8, ucs2, cp866, keybcs2, macce, macroman, cp852, latin7, utf8mb4, cp1251, utf16, cp1256, cp1257, utf32, binary, geostd8, cp932, eucjpms | TRUE | engine-default | dynamic | string | |
| character_set_results | big5, dec8, cp850, hp8, koi8r, latin1, latin2, swe7, ascii, ujis, sjis, hebrew, tis620, euckr, koi8u, gb2312, greek, cp1250, gbk, latin5, armscii8, utf8, ucs2, cp866, keybcs2, macce, macroman, cp852, latin7, utf8mb4, cp1251, utf16, cp1256, cp1257, utf32, binary, geostd8, cp932, eucjpms | TRUE | engine-default | dynamic | string | |
| character_set_server | big5, dec8, cp850, hp8, koi8r, latin1, latin2, swe7, ascii, ujis, sjis, hebrew, tis620, euckr, koi8u, gb2312, greek, cp1250, gbk, latin5, armscii8, utf8, ucs2, cp866, keybcs2, macce, macroman, cp852, latin7, utf8mb4, cp1251, utf16, cp1256, cp1257, utf32, binary, geostd8, cp932, eucjpms | TRUE | engine-default | dynamic | string | |
| check_proxy_users | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| collation_connection | big5_chinese_ci, big5_bin, dec8_swedish_ci, dec8_bin, cp850_general_ci, cp850_bin, hp8_english_ci, hp8_bin, koi8r_general_ci, koi8r_bin, latin1_german1_ci, latin1_swedish_ci, latin1_danish_ci, latin1_german2_ci, latin1_bin, latin1_general_ci, latin1_general_cs, latin1_spanish_ci, latin2_czech_cs, latin2_general_ci, latin2_hungarian_ci, latin2_croatian_ci, latin2_bin, swe7_swedish_ci, swe7_bin, ascii_general_ci, ascii_bin, ujis_japanese_ci, ujis_bin, sjis_japanese_ci, sjis_bin, hebrew_general_ci, hebrew_bin, tis620_thai_ci, tis620_bin, euckr_korean_ci, euckr_bin, koi8u_general_ci, koi8u_bin, gb2312_chinese_ci, gb2312_bin, greek_general_ci, greek_bin, cp1250_general_ci, cp1250_czech_cs, cp1250_croatian_ci, cp1250_bin, cp1250_polish_ci, gbk_chinese_ci, gbk_bin, latin5_turkish_ci, latin5_bin, armscii8_general_ci, armscii8_bin, utf8_general_ci, utf8_bin, utf8_unicode_ci, utf8_icelandic_ci, utf8_latvian_ci, utf8_romanian_ci, utf8_slovenian_ci, utf8_polish_ci, utf8_estonian_ci, utf8_spanish_ci, utf8_swedish_ci, utf8_turkish_ci, utf8_czech_ci, utf8_danish_ci, utf8_lithuanian_ci, utf8_slovak_ci, utf8_spanish2_ci, utf8_roman_ci, utf8_persian_ci, utf8_esperanto_ci, utf8_hungarian_ci, utf8_sinhala_ci, ucs2_general_ci, ucs2_bin, ucs2_unicode_ci, ucs2_icelandic_ci, ucs2_latvian_ci, ucs2_romanian_ci, ucs2_slovenian_ci, ucs2_polish_ci, ucs2_estonian_ci, ucs2_spanish_ci, ucs2_swedish_ci, ucs2_turkish_ci, ucs2_czech_ci, ucs2_danish_ci, ucs2_lithuanian_ci, ucs2_slovak_ci, ucs2_spanish2_ci, ucs2_roman_ci, ucs2_persian_ci, ucs2_esperanto_ci, ucs2_hungarian_ci, ucs2_sinhala_ci, cp866_general_ci, cp866_bin, keybcs2_general_ci, keybcs2_bin, macce_general_ci, macce_bin, macroman_general_ci, macroman_bin, cp852_general_ci, cp852_bin, latin7_estonian_cs, latin7_general_ci, latin7_general_cs, latin7_bin, utf8mb4_general_ci, utf8mb4_bin, utf8mb4_unicode_ci, utf8mb4_icelandic_ci, utf8mb4_latvian_ci, utf8mb4_romanian_ci, utf8mb4_slovenian_ci, utf8mb4_polish_ci, utf8mb4_estonian_ci, utf8mb4_spanish_ci, utf8mb4_swedish_ci, utf8mb4_turkish_ci, utf8mb4_czech_ci, utf8mb4_danish_ci, utf8mb4_lithuanian_ci, utf8mb4_slovak_ci, utf8mb4_spanish2_ci, utf8mb4_roman_ci, utf8mb4_persian_ci, utf8mb4_esperanto_ci, utf8mb4_hungarian_ci, utf8mb4_sinhala_ci, cp1251_bulgarian_ci, cp1251_ukrainian_ci, cp1251_bin, cp1251_general_ci, cp1251_general_cs, utf16_general_ci, utf16_bin, utf16_unicode_ci, utf16_icelandic_ci, utf16_latvian_ci, utf16_romanian_ci, utf16_slovenian_ci, utf16_polish_ci, utf16_estonian_ci, utf16_spanish_ci, utf16_swedish_ci, utf16_turkish_ci, utf16_czech_ci, utf16_danish_ci, utf16_lithuanian_ci, utf16_slovak_ci, utf16_spanish2_ci, utf16_roman_ci, utf16_persian_ci, utf16_esperanto_ci, utf16_hungarian_ci, utf16_sinhala_ci, cp1256_general_ci, cp1256_bin, cp1257_lithuanian_ci, cp1257_bin, cp1257_general_ci, utf32_general_ci, utf32_bin, utf32_unicode_ci, utf32_icelandic_ci, utf32_latvian_ci, utf32_romanian_ci, utf32_slovenian_ci, utf32_polish_ci, utf32_estonian_ci, utf32_spanish_ci, utf32_swedish_ci, utf32_turkish_ci, utf32_czech_ci, utf32_danish_ci, utf32_lithuanian_ci, utf32_slovak_ci, utf32_spanish2_ci, utf32_roman_ci, utf32_persian_ci, utf32_esperanto_ci, utf32_hungarian_ci, utf32_sinhala_ci, binary, geostd8_general_ci, geostd8_bin, cp932_japanese_ci, cp932_bin, eucjpms_japanese_ci, eucjpms_bin, utf8mb4_0900_ai_ci, utf8mb4_0900_as_ci, utf8mb4_0900_as_cs, utf8mb4_0900_bin | TRUE | engine-default | dynamic | string | |
| collation_server | big5_chinese_ci, big5_bin, dec8_swedish_ci, dec8_bin, cp850_general_ci, cp850_bin, hp8_english_ci, hp8_bin, koi8r_general_ci, koi8r_bin, latin1_german1_ci, latin1_swedish_ci, latin1_danish_ci, latin1_german2_ci, latin1_bin, latin1_general_ci, latin1_general_cs, latin1_spanish_ci, latin2_czech_cs, latin2_general_ci, latin2_hungarian_ci, latin2_croatian_ci, latin2_bin, swe7_swedish_ci, swe7_bin, ascii_general_ci, ascii_bin, ujis_japanese_ci, ujis_bin, sjis_japanese_ci, sjis_bin, hebrew_general_ci, hebrew_bin, tis620_thai_ci, tis620_bin, euckr_korean_ci, euckr_bin, koi8u_general_ci, koi8u_bin, gb2312_chinese_ci, gb2312_bin, greek_general_ci, greek_bin, cp1250_general_ci, cp1250_czech_cs, cp1250_croatian_ci, cp1250_bin, cp1250_polish_ci, gbk_chinese_ci, gbk_bin, latin5_turkish_ci, latin5_bin, armscii8_general_ci, armscii8_bin, utf8_general_ci, utf8_bin, utf8_unicode_ci, utf8_icelandic_ci, utf8_latvian_ci, utf8_romanian_ci, utf8_slovenian_ci, utf8_polish_ci, utf8_estonian_ci, utf8_spanish_ci, utf8_swedish_ci, utf8_turkish_ci, utf8_czech_ci, utf8_danish_ci, utf8_lithuanian_ci, utf8_slovak_ci, utf8_spanish2_ci, utf8_roman_ci, utf8_persian_ci, utf8_esperanto_ci, utf8_hungarian_ci, utf8_sinhala_ci, ucs2_general_ci, ucs2_bin, ucs2_unicode_ci, ucs2_icelandic_ci, ucs2_latvian_ci, ucs2_romanian_ci, ucs2_slovenian_ci, ucs2_polish_ci, ucs2_estonian_ci, ucs2_spanish_ci, ucs2_swedish_ci, ucs2_turkish_ci, ucs2_czech_ci, ucs2_danish_ci, ucs2_lithuanian_ci, ucs2_slovak_ci, ucs2_spanish2_ci, ucs2_roman_ci, ucs2_persian_ci, ucs2_esperanto_ci, ucs2_hungarian_ci, ucs2_sinhala_ci, cp866_general_ci, cp866_bin, keybcs2_general_ci, keybcs2_bin, macce_general_ci, macce_bin, macroman_general_ci, macroman_bin, cp852_general_ci, cp852_bin, latin7_estonian_cs, latin7_general_ci, latin7_general_cs, latin7_bin, utf8mb4_general_ci, utf8mb4_bin, utf8mb4_unicode_ci, utf8mb4_icelandic_ci, utf8mb4_latvian_ci, utf8mb4_romanian_ci, utf8mb4_slovenian_ci, utf8mb4_polish_ci, utf8mb4_estonian_ci, utf8mb4_spanish_ci, utf8mb4_swedish_ci, utf8mb4_turkish_ci, utf8mb4_czech_ci, utf8mb4_danish_ci, utf8mb4_lithuanian_ci, utf8mb4_slovak_ci, utf8mb4_spanish2_ci, utf8mb4_roman_ci, utf8mb4_persian_ci, utf8mb4_esperanto_ci, utf8mb4_hungarian_ci, utf8mb4_sinhala_ci, cp1251_bulgarian_ci, cp1251_ukrainian_ci, cp1251_bin, cp1251_general_ci, cp1251_general_cs, utf16_general_ci, utf16_bin, utf16_unicode_ci, utf16_icelandic_ci, utf16_latvian_ci, utf16_romanian_ci, utf16_slovenian_ci, utf16_polish_ci, utf16_estonian_ci, utf16_spanish_ci, utf16_swedish_ci, utf16_turkish_ci, utf16_czech_ci, utf16_danish_ci, utf16_lithuanian_ci, utf16_slovak_ci, utf16_spanish2_ci, utf16_roman_ci, utf16_persian_ci, utf16_esperanto_ci, utf16_hungarian_ci, utf16_sinhala_ci, cp1256_general_ci, cp1256_bin, cp1257_lithuanian_ci, cp1257_bin, cp1257_general_ci, utf32_general_ci, utf32_bin, utf32_unicode_ci, utf32_icelandic_ci, utf32_latvian_ci, utf32_romanian_ci, utf32_slovenian_ci, utf32_polish_ci, utf32_estonian_ci, utf32_spanish_ci, utf32_swedish_ci, utf32_turkish_ci, utf32_czech_ci, utf32_danish_ci, utf32_lithuanian_ci, utf32_slovak_ci, utf32_spanish2_ci, utf32_roman_ci, utf32_persian_ci, utf32_esperanto_ci, utf32_hungarian_ci, utf32_sinhala_ci, binary, geostd8_general_ci, geostd8_bin, cp932_japanese_ci, cp932_bin, eucjpms_japanese_ci, eucjpms_bin, utf8mb4_0900_ai_ci, utf8mb4_0900_as_ci, utf8mb4_0900_as_cs, utf8mb4_0900_bin | TRUE | engine-default | dynamic | string | |
| completion_type | 0-2 | TRUE | engine-default | dynamic | integer | |
| concurrent_insert | 0-2 | TRUE | engine-default | dynamic | integer | |
| connect_timeout | 2-31536000 | TRUE | engine-default | dynamic | integer | |
| core-file | 0, 1 | FALSE | engine-default | static | boolean | |
| cte_max_recursion_depth | 0-4294967295 | TRUE | engine-default | dynamic | integer | |
| datadir | /rdsdbdata/db/ | FALSE | system | static | string | |
| default_authentication_plugin | mysql_native_password | mysql_native_password, sha256_password, caching_sha2_password | FALSE | engine-default | static | string |
| default_password_lifetime | 0 | 0-65535 | TRUE | system | dynamic | integer |
| default_storage_engine | InnoDB | InnoDB, MRG_MYISAM, BLACKHOLE, CSV, MEMORY, FEDERATED, ARCHIVE, MyISAM | FALSE | system | dynamic | string |
| default_time_zone | FALSE | engine-default | static | string | ||
| default_tmp_storage_engine | InnoDB | InnoDB, MyISAM | TRUE | system | static | string |
| 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 | |
| delay_key_write | OFF, ON, ALL | TRUE | engine-default | dynamic | string | |
| div_precision_increment | 0-30 | TRUE | engine-default | dynamic | integer | |
| end_markers_in_json | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| enforce_gtid_consistency | OFF, WARN, ON | TRUE | engine-default | static | string | |
| eq_range_index_dive_limit | 0-4294967295 | TRUE | engine-default | dynamic | integer | |
| event_scheduler | ON, OFF | TRUE | engine-default | dynamic | string | |
| explicit_defaults_for_timestamp | 1 | 0, 1 | TRUE | system | static | boolean |
| flush | 0, 1 | FALSE | engine-default | dynamic | boolean | |
| flush_time | 0-31536000 | TRUE | engine-default | dynamic | integer | |
| ft_boolean_syntax | FALSE | engine-default | dynamic | string | ||
| 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 | |
| ft_stopword_file | /dev/null | TRUE | engine-default | static | string | |
| general_log | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| general_log_file | /rdsdbdata/log/general/mysql-general.log | FALSE | system | dynamic | string | |
| generated_random_password_length | 20 | 5-255 | TRUE | engine-default | dynamic | integer |
| group_concat_max_len | 4-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| gtid_executed_compression_period | 0-4294967295 | TRUE | engine-default | dynamic | integer | |
| gtid-mode | OFF_PERMISSIVE | OFF, OFF_PERMISSIVE, ON_PERMISSIVE, ON | TRUE | system | static | string |
| gtid_purged | FALSE | engine-default | dynamic | string | ||
| histogram_generation_max_mem_size | 1000000-18446744073709551615 | TRUE | engine-default | dynamic | integer | |
| host_cache_size | 0-65536 | TRUE | engine-default | dynamic | integer | |
| information_schema_stats_expiry | 0-31536000 | TRUE | engine-default | dynamic | integer | |
| init_connect | TRUE | engine-default | dynamic | string | ||
| innodb_adaptive_flushing | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| innodb_adaptive_hash_index | 0 | 0, 1 | TRUE | system | dynamic | boolean |
| 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_autoinc_lock_mode | 0-2 | TRUE | engine-default | static | integer | |
| 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_filename | FALSE | engine-default | dynamic | string | ||
| 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_buffer_pool_size | {DBInstanceClassMemory*3/4} | 335544320-9223372036854775807 | TRUE | system | static | integer |
| innodb_change_buffer_max_size | 0-50 | FALSE | engine-default | dynamic | integer | |
| innodb_checksum_algorithm | none | crc32, innodb, none, strict_crc32, strict_innodb, strict_none | FALSE | system | dynamic | string |
| innodb_commit_concurrency | 0-1000 | TRUE | engine-default | static | integer | |
| innodb_concurrency_tickets | 1-4294967295 | TRUE | engine-default | dynamic | integer | |
| innodb_data_home_dir | FALSE | system | static | string | ||
| innodb_deadlock_detect | ON | ON, OFF | TRUE | engine-default | dynamic | string |
| innodb_default_row_format | DYNAMIC, COMPACT, REDUNDANT | TRUE | engine-default | dynamic | string | |
| innodb_doublewrite | 0 | 0 | FALSE | system | static | boolean |
| innodb_file_per_table | 0, 1 | TRUE | engine-default | static | boolean | |
| innodb_fill_factor | 10-100 | 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_log_at_trx_commit | 0-2 | FALSE | engine-default | dynamic | integer | |
| innodb_flush_method | O_DIRECT | O_DIRECT | FALSE | system | static | string |
| innodb_flush_neighbors | 0-2 | FALSE | engine-default | dynamic | integer | |
| innodb_force_load_corrupted | 0, 1 | FALSE | engine-default | static | boolean | |
| innodb_ft_aux_table | TRUE | engine-default | dynamic | string | ||
| innodb_ft_cache_size | 0-4294967295 | TRUE | engine-default | static | integer | |
| innodb_ft_enable_stopword | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| innodb_ft_max_token_size | 10-252 | TRUE | engine-default | static | integer | |
| innodb_ft_min_token_size | 0-16 | TRUE | engine-default | static | integer | |
| innodb_ft_num_word_optimize | 1-4294967295 | TRUE | engine-default | dynamic | integer | |
| innodb_ft_server_stopword_table | TRUE | engine-default | dynamic | string | ||
| innodb_ft_sort_pll_degree | 1-32 | TRUE | engine-default | static | integer | |
| innodb_ft_user_stopword_table | TRUE | engine-default | dynamic | string | ||
| 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_log_compressed_pages | 0, 1 | FALSE | engine-default | dynamic | boolean | |
| 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_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_old_blocks_pct | 5-95 | TRUE | engine-default | dynamic | integer | |
| innodb_old_blocks_time | 0-4294967295 | TRUE | engine-default | dynamic | integer | |
| innodb_online_alter_log_max_size | 65536-18446744073709551615 | TRUE | engine-default | dynamic | integer | |
| innodb_open_files | -1, 10-4294967295 | TRUE | engine-default | static | integer | |
| innodb_optimize_fulltext_only | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| innodb_page_cleaners | 1-64 | TRUE | engine-default | static | integer | |
| innodb_page_size | FALSE | engine-default | static | string | ||
| innodb_print_all_deadlocks | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| innodb_purge_batch_size | 1-5000 | TRUE | engine-default | dynamic | integer | |
| innodb_purge_threads | 1-32 | TRUE | engine-default | static | integer | |
| innodb_read_io_threads | 1-64 | FALSE | engine-default | static | integer | |
| innodb_read_only | 0, 1 | FALSE | engine-default | static | boolean | |
| innodb_replication_delay | 0-4294967295 | TRUE | engine-default | dynamic | integer | |
| innodb_rollback_on_timeout | 0, 1 | TRUE | engine-default | static | boolean | |
| innodb_rollback_segments | 1-128 | TRUE | engine-default | dynamic | integer | |
| innodb_sort_buffer_size | 65536-67108864 | TRUE | engine-default | static | integer | |
| innodb_spin_wait_delay | 0-4294967295 | TRUE | engine-default | dynamic | integer | |
| innodb_spin_wait_pause_multiplier | 1-100 | TRUE | engine-default | dynamic | integer | |
| innodb_stats_auto_recalc | 0, 1 | TRUE | system | dynamic | boolean | |
| innodb_stats_include_delete_marked | 0, 1 | TRUE | engine-default | static | boolean | |
| innodb_stats_method | nulls_equal, nulls_unequal, nulls_ignored | TRUE | engine-default | dynamic | string | |
| innodb_stats_on_metadata | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| innodb_stats_persistent | OFF, ON, 0, 1 | TRUE | system | dynamic | boolean | |
| 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_status_output | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| innodb_status_output_locks | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| innodb_strict_mode | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| innodb_sync_array_size | 1-1024 | TRUE | engine-default | static | integer | |
| innodb_sync_spin_loops | 30 | 0-9223372036854775807 | TRUE | engine-default | dynamic | integer |
| innodb_table_locks | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| innodb_thread_concurrency | 0-1000 | FALSE | engine-default | dynamic | integer | |
| innodb_thread_sleep_delay | 0-9223372036854775807 | TRUE | engine-default | dynamic | integer | |
| innodb_undo_directory | FALSE | system | static | string | ||
| innodb_use_native_aio | 0, 1 | FALSE | engine-default | static | boolean | |
| innodb_write_io_threads | 1-64 | FALSE | engine-default | static | integer | |
| interactive_timeout | 1-31536000 | TRUE | engine-default | dynamic | integer | |
| internal_tmp_mem_storage_engine | TempTable | TempTable, MEMORY | TRUE | system | dynamic | string |
| join_buffer_size | 128-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| keep_files_on_create | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| 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 | |
| lc_time_names | ar_AE, ar_BH, ar_DZ, ar_EG, ar_IN, ar_IQ, ar_JO, ar_KW, ar_LB, ar_LY, ar_MA, ar_OM, ar_QA, ar_SA, ar_SD, ar_SY, ar_TN, ar_YE, be_BY, bg_BG, ca_ES, cs_CZ, da_DK, de_AT, de_BE, de_CH, de_DE, de_LU, el_GR, en_AU, en_CA, en_GB, en_IN, en_NZ, en_PH, en_US, en_ZA, en_ZW, es_AR, es_BO, es_CL, es_CO, es_CR, es_DO, es_EC, es_ES, es_GT, es_HN, es_MX, es_NI, es_PA, es_PE, es_PR, es_PY, es_SV, es_US, es_UY, es_VE, et_EE, eu_ES, fi_FI, fo_FO, fr_BE, fr_CA, fr_CH, fr_FR, fr_LU, gl_ES, gu_IN, he_IL, hi_IN, hr_HR, hu_HU, id_ID, is_IS, it_CH, it_IT, ja_JP, ko_KR, lt_LT, lv_LV, mk_MK, mn_MN, ms_MY, nb_NO, nl_BE, nl_NL, no_NO, pl_PL, pt_BR, pt_PT, ro_RO, ru_RU, ru_UA, sk_SK, sl_SI, sq_AL, sr_RS, sv_FI, sv_SE, ta_IN, te_IN, th_TH, tr_TR, uk_UA, ur_PK, vi_VN, zh_CN, zh_HK, zh_TW | TRUE | engine-default | dynamic | string | |
| local_infile | 1 | 0, 1 | TRUE | system | dynamic | boolean |
| lock_wait_timeout | 1-31536000 | TRUE | engine-default | dynamic | integer | |
| log-bin | /rdsdbdata/log/binlog/mysql-bin-changelog | FALSE | system | static | string | |
| log_bin_trust_function_creators | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| log_error | /rdsdbdata/log/error/mysql-error.log | FALSE | system | static | string | |
| log_error_verbosity | 1月3日 | TRUE | engine-default | dynamic | integer | |
| log_output | FILE | TABLE, FILE, NONE | TRUE | system | dynamic | string |
| log_queries_not_using_indexes | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| log_replica_updates | 1 | 0, 1 | FALSE | system | static | boolean |
| log_slow_admin_statements | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| log_slow_extra | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| log_slow_replica_statements | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| log_throttle_queries_not_using_indexes | 0-4294967295 | TRUE | engine-default | dynamic | integer | |
| long_query_time | 0-31536000 | TRUE | engine-default | dynamic | float | |
| lower_case_table_names | 0-1 | TRUE | engine-default | static | integer | |
| low_priority_updates | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| mandatory_roles | TRUE | engine-default | dynamic | string | ||
| 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_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_user_connections | 0-4294967295 | TRUE | engine-default | dynamic | integer | |
| max_write_lock_count | 1-18446744073709547520 | TRUE | engine-default | dynamic | 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 | |
| myisam_stats_method | nulls_equal, nulls_unequal, nulls_ignored | TRUE | engine-default | dynamic | string | |
| myisam_use_mmap | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| mysql_native_password_proxy_users | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| 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 | |
| ngram_token_size | 1月10日 | TRUE | engine-default | static | integer | |
| old-style-user-limits | 0, 1 | TRUE | engine-default | static | boolean | |
| optimizer_prune_level | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| optimizer_search_depth | 0-62 | 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_condition_pushdown=on, derived_condition_pushdown=off, derived_merge=on, derived_merge=off, duplicateweedout=on, duplicateweedout=off, engine_condition_pushdown=on, engine_condition_pushdown=off, firstmatch=on, firstmatch=off, hash_join=on, hash_join=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, prefer_ordering_index=on, prefer_ordering_index=off, semijoin=on, semijoin=off, skip_scan=on, skip_scan=off, subquery_materialization_cost_based=on, subquery_materialization_cost_based=off, use_index_extensions=on, use_index_extensions=off, use_invisible_indexes=on, use_invisible_indexes=off | TRUE | engine-default | dynamic | list | |
| 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 | |
| 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 | |
| partial_revokes | 0 | 0, 1 | FALSE | engine-default | dynamic | boolean |
| performance_schema | 0 | 0, 1 | TRUE | system | static | boolean |
| performance_schema_accounts_size | -1048577 | TRUE | engine-default | static | integer | |
| 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-current | ON, OFF | TRUE | engine-default | static | string | |
| 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 | |
| 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-instrument | TRUE | engine-default | static | string | ||
| 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_digest_sample_age | 0-1048576 | TRUE | engine-default | dynamic | 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_show_processlist | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| performance_schema_users_size | -1048577 | TRUE | engine-default | static | integer | |
| pid_file | /rdsdbdata/log/mysql-{EndPointPort}.pid | FALSE | system | static | string | |
| plugin_dir | FALSE | system | static | string | ||
| 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_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_only | 0 | 0, 1 | TRUE | system | dynamic | boolean |
| read_rnd_buffer_size | 524288 | 8200-2147479552 | TRUE | system | dynamic | integer |
| regexp_stack_limit | 0-2147483647 | TRUE | engine-default | dynamic | integer | |
| regexp_time_limit | 0-2147483647 | TRUE | engine-default | dynamic | integer | |
| relay-log | /rdsdbdata/log/relaylog/relaylog | FALSE | system | static | string | |
| relay_log_recovery | 1 | 0, 1 | FALSE | system | dynamic | boolean |
| relay-log-space-limit | 0-4294967295 | TRUE | engine-default | static | integer | |
| replica_checkpoint_group | 32-524280 | TRUE | engine-default | dynamic | integer | |
| replica_checkpoint_period | 1-4294967295 | TRUE | engine-default | dynamic | integer | |
| replica_parallel_type | DATABASE, LOGICAL_CLOCK | TRUE | engine-default | dynamic | string | |
| replica_parallel_workers | 0-1024 | TRUE | engine-default | dynamic | integer | |
| replica_pending_jobs_size_max | 1024-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| replica_preserve_commit_order | ON, OFF | TRUE | engine-default | dynamic | string | |
| replica-skip-errors | OFF, all, ddl_exist_errors, <integer> | TRUE | engine-default | static | list | |
| replica_sql_verify_checksum | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| replicate-do-db | TRUE | engine-default | dynamic | list | ||
| replicate-do-table | TRUE | engine-default | dynamic | list | ||
| replicate-ignore-db | TRUE | engine-default | dynamic | list | ||
| replicate-ignore-table | TRUE | engine-default | dynamic | list | ||
| replicate-wild-do-table | TRUE | engine-default | dynamic | list | ||
| replicate-wild-ignore-table | TRUE | engine-default | dynamic | list | ||
| replica_transaction_retries | 0-4294967295 | TRUE | engine-default | dynamic | integer | |
| replica_type_conversions | ALL_LOSSY, ALL_NON_LOSSY, ALL_SIGNED, ALL_UNSIGNED | TRUE | engine-default | static | list | |
| require_secure_transport | ON, OFF | TRUE | engine-default | dynamic | string | |
| rpl_read_size | 8192-4294959104 | TRUE | engine-default | dynamic | integer | |
| safe-user-create | 0, 1 | TRUE | engine-default | static | boolean | |
| schema_definition_cache | 256-524288 | TRUE | engine-default | dynamic | integer | |
| secure_file_priv | /tmp | FALSE | system | static | string | |
| server_audit_events | CONNECT, QUERY, QUERY_DCL, QUERY_DDL, QUERY_DML, TABLE | TRUE | engine-default | dynamic | list | |
| server_audit_excl_users | TRUE | engine-default | dynamic | string | ||
| server_audit_incl_users | TRUE | engine-default | dynamic | string | ||
| server_audit_logging | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| server_audit_logs_upload | 0 | 0, 1 | TRUE | engine-default | dynamic | boolean |
| server_id | {ServerId} | FALSE | system | dynamic | integer | |
| skip-character-set-client-handshake | 0, 1 | TRUE | engine-default | static | boolean | |
| skip_external_locking | 0, 1 | FALSE | engine-default | static | boolean | |
| skip_name_resolve | 1 | 0, 1 | FALSE | system | static | boolean |
| skip-replica-start | 1 | 0, 1 | FALSE | system | static | boolean |
| skip_show_database | 0, 1 | TRUE | engine-default | static | boolean | |
| slow_launch_time | 0-31536000 | TRUE | engine-default | dynamic | integer | |
| slow_query_log | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| slow_query_log_file | /rdsdbdata/log/slowquery/mysql-slowquery.log | FALSE | system | dynamic | string | |
| socket | /tmp/mysql.sock | FALSE | system | static | string | |
| sort_buffer_size | 32768-18446744073709551615 | TRUE | engine-default | dynamic | integer | |
| source_verify_checksum | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| sql_mode | 0 | 0, ANSI, ALLOW_INVALID_DATES, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_VALUE_ON_ZERO, NO_BACKSLASH_ESCAPES, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, 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, TIME_TRUNCATE_FRACTIONAL | TRUE | system | dynamic | list |
| sql_select_limit | 0-18446744073709551615 | TRUE | engine-default | dynamic | integer | |
| ssl_cipher | AES256-SHA,AES128-SHA,DES-CBC3-SHA,ADH-DES-CBC3-SHA,EDH-RSA-DES-CBC3-SHA,EDH-DSS-DES-CBC3-SHA,ADH-AES256-SHA,DHE-RSA-AES256-SHA,DHE-DSS-AES256-SHA,ADH-AES128-SHA,DHE-RSA-AES128-SHA,DHE-DSS-AES128-SHA,HIGH | DHE-RSA-AES128-SHA, DHE-RSA-AES128-SHA256, DHE-RSA-AES128-GCM-SHA256, DHE-RSA-AES256-SHA, DHE-RSA-AES256-SHA256, DHE-RSA-AES256-GCM-SHA384, ECDHE-RSA-AES128-SHA, ECDHE-RSA-AES128-SHA256, ECDHE-RSA-AES128-GCM-SHA256, ECDHE-RSA-AES256-SHA, ECDHE-RSA-AES256-SHA384, ECDHE-RSA-AES256-GCM-SHA384 | TRUE | system | static | list |
| stored_program_cache | 256-524288 | TRUE | engine-default | dynamic | integer | |
| stored_program_definition_cache | 256-524288 | TRUE | engine-default | dynamic | integer | |
| sync_binlog | 1 | 0-18446744073709547520 | FALSE | system | dynamic | integer |
| sync_relay_log_info | 0-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| sync_source_info | 0-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| sysdate-is-now | 0, 1 | TRUE | engine-default | static | boolean | |
| 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 | |
| tablespace_definition_cache | 256-524288 | TRUE | engine-default | dynamic | integer | |
| temptable_max_mmap | 1.07E+09 | 0-18446744073709551615 | TRUE | engine-default | dynamic | integer |
| temptable_max_ram | 1.07E+09 | 2097152-18446744073709551615 | TRUE | engine-default | dynamic | integer |
| temptable_use_mmap | 1 | 0, 1 | TRUE | engine-default | dynamic | boolean |
| thread_cache_size | {DBInstanceClassMemory/1005785088} | 0-16384 | TRUE | system | dynamic | integer |
| thread_handling | thread-pools | thread-pools, no-threads, one-thread-per-connection, dynamically-loaded | FALSE | system | static | string |
| thread_stack | 262144 | 131072-18446744073709547520 | TRUE | engine-default | static | integer |
| time_zone | Africa/Harare, Africa/Monrovia, Africa/Nairobi, Africa/Windhoek, America/Bogota, America/Caracas, America/Chihuahua, America/Cuiaba, America/Denver, America/Fortaleza, America/Guatemala, America/Halifax, America/Manaus, America/Matamoros, America/Monterrey, America/Montevideo, America/Phoenix, America/Tijuana, Asia/Ashgabat, Asia/Baghdad, Asia/Baku, Asia/Bangkok, Asia/Beirut, Asia/Calcutta, Asia/Kabul, Asia/Karachi, Asia/Kathmandu, Asia/Muscat, Asia/Riyadh, Asia/Seoul, Asia/Shanghai, Asia/Singapore, Asia/Taipei, Asia/Tehran, Asia/Tokyo, Asia/Ulaanbaatar, Atlantic/Azores, Australia/Adelaide, Australia/Brisbane, Australia/Darwin, Australia/Hobart, Australia/Perth, Australia/Sydney, Canada/Saskatchewan, Brazil/East, Europe/Amsterdam, Europe/Athens, Europe/Dublin, Europe/Helsinki, Europe/Paris, Europe/Prague, Europe/Sarajevo, Pacific/Auckland, Pacific/Guam, Pacific/Honolulu, Pacific/Samoa, US/Alaska, US/Central, US/Eastern, US/East-Indiana, US/Pacific, UTC | TRUE | engine-default | dynamic | string | |
| tls_version | TLSv1, TLSv1.1, TLSv1.2 | TRUE | engine-default | static | list | |
| tmpdir | /rdsdbdata/tmp/ | FALSE | system | static | string | |
| tmp_table_size | 1024-18446744073709551615 | TRUE | engine-default | dynamic | integer | |
| transaction_alloc_block_size | 1024-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| transaction_isolation | READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE | TRUE | engine-default | dynamic | string | |
| transaction_prealloc_size | 1024-18446744073709547520 | TRUE | engine-default | dynamic | integer | |
| updatable_views_with_limit | 0, 1 | TRUE | engine-default | dynamic | boolean | |
| validate-password | ON, OFF, FORCE, FORCE_PLUS_PERMANENT | FALSE | engine-default | static | string | |
| validate_password_dictionary_file | FALSE | engine-default | static | string | ||
| 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_policy | LOW, MEDIUM, STRONG | FALSE | engine-default | dynamic | string | |
| validate_password_special_char_count | 0-2147483647 | FALSE | engine-default | dynamic | integer | |
| wait_timeout | 1-31536000 | TRUE | engine-default | dynamic | integer | |
| windowing_use_high_precision | 0, 1 | TRUE | engine-default | dynamic | boolean |