automatic_sp_privileges 否 [ON|OFF] ON ON
auto_increment_increment 否 [1-65535] 1 1
auto_increment_offset 否 [1-65535] 1 1
avoid_temporal_upgrade 否 [ON|OFF] OFF OFF
back_log 是 [0-65535] 3000 3000
binlog_cache_size 否 [4096-16777216] 2097152 2097152
binlog_checksum 是 [CRC32|NONE] CRC32 CRC32
binlog_order_commits 否 [ON|OFF] ON ON
binlog_rows_query_log_events 否 [ON|OFF] OFF OFF
binlog_row_image 否 [full|minimal] full full
binlog_stmt_cache_size 否 [4096-16777216] 32768 32768
block_encryption_mode 否 ["aes-128-ecb"|"aes-... "aes-128-ecb" "aes-128-ecb"
bulk_insert_buffer_size 否 [0-4294967295] 4194304 4194304
character_set_filesystem 否 [utf8|latin1|gbk|bin... binary binary
character_set_server 是 [utf8|latin1|gbk|gb1... utf8 utf8
concurrent_insert 否 [0|1|2] 1 1
connect_timeout 否 [1-3600] 10 10
default_storage_engine 是 [InnoDB|innodb] InnoDB InnoDB
default_time_zone 是 [SYSTEM|-12:00|-11:0... SYSTEM SYSTEM
default_week_format 否 [0-7] 0 0
delayed_insert_limit 否 [1-4294967295] 100 100
delayed_insert_timeout 否 [1-3600] 300 300
delayed_queue_size 否 [1-4294967295] 1000 1000
delay_key_write 否 [ON|OFF|ALL] ON ON
disconnect_on_expired_password 是 [ON|OFF] ON ON
div_precision_increment 否 [0-30] 4 4
end_markers_in_json 否 [ON|OFF] OFF OFF
eq_range_index_dive_limit 否 [0-4294967295] 10 10
event_scheduler 否 [ON|OFF] OFF OFF
explicit_defaults_for_timestamp 否 [ON|OFF] OFF OFF
flush_time 否 [0-31536000] 0 0
ft_max_word_len 是 [10-4294967295] 84 84
ft_min_word_len 是 [1-3600] 4 4
ft_query_expansion_limit 是 [0-1000] 20 20
group_concat_max_len 否 [4-18446744073709547... 1024 1024
host_cache_size 否 [0-65535] 644 644
innodb_adaptive_flushing 否 [ON|OFF] ON ON
innodb_adaptive_flushing_lwm 否 [0-70] 10 10
innodb_adaptive_hash_index 否 [ON|OFF] ON ON
innodb_adaptive_max_sleep_delay 否 [1-1000000] 150000 150000
innodb_autoextend_increment 否 [1-1000] 64 64
innodb_autoinc_lock_mode 是 [0|1|2] 2 2
innodb_buffer_pool_dump_at_shutdown 否 [ON|OFF] ON ON
innodb_buffer_pool_dump_pct 否 [1-100] 25 25
innodb_buffer_pool_instances 是 [1-64] {LEAST(DBInstanceClassMemory/1073741824, 8)} 1
innodb_buffer_pool_load_at_startup 是 [ON|OFF] ON ON
innodb_change_buffering 否 [none|inserts|delete... all all
innodb_change_buffer_max_size 否 [0-50] 25 25
innodb_checksum_algorithm 否 [innodb|crc32|none|s... crc32 crc32
innodb_cmp_per_index_enabled 否 [ON|OFF] OFF OFF
innodb_commit_concurrency 是 [0-1000] 0 0
innodb_compression_failure_threshold_pct 否 [0-100] 5 5
innodb_compression_level 否 [0-9] 6 6
innodb_compression_pad_pct_max 否 [0-70] 50 50
innodb_concurrency_tickets 否 [1-4294967295] 5000 5000
innodb_deadlock_detect 否 [ON|OFF] ON ON
innodb_disable_sort_file_cache 否 [ON|OFF] ON ON
innodb_flush_method 是 [fsync|O_DSYNC|littl... O_DIRECT O_DIRECT
innodb_flush_neighbors 否 [0|1|2] 0 1
innodb_flush_sync 否 [ON|OFF] ON ON
innodb_ft_cache_size 是 [1600000-80000000] 8000000 8000000
innodb_ft_enable_diag_print 否 [ON|OFF] OFF OFF
innodb_ft_enable_stopword 否 [ON|OFF] ON ON
innodb_ft_max_token_size 是 [10-84] 84 84
innodb_ft_min_token_size 是 [0-16] 3 3
innodb_ft_num_word_optimize 否 [0-10000] 2000 2000
innodb_ft_result_cache_limit 否 [1000000-4294967295] 2000000000 2000000000
innodb_ft_sort_pll_degree 是 [1-16] 2 2
innodb_ft_total_cache_size 是 [32000000-1600000000... 640000000 640000000
innodb_io_capacity 否 [100-4294967295] 20000 20000
innodb_io_capacity_max 否 [100-4294967295] 40000 40000
innodb_large_prefix 否 [ON|OFF] OFF OFF
innodb_lock_wait_timeout 否 [1-1073741824] 50 50
innodb_log_checksums 否 [ON|OFF] ON ON
innodb_log_compressed_pages 否 [ON|OFF] OFF OFF
innodb_lru_scan_depth 否 [100-4294967295] 1024 1024
innodb_max_dirty_pages_pct 否 [50-90] 75 75
innodb_max_dirty_pages_pct_lwm 否 [0-75] 0 0
innodb_max_purge_lag 否 [0-4294967295] 0 0
innodb_max_purge_lag_delay 否 [0-10000000] 0 0
innodb_max_undo_log_size 否 [10485760-1844674407... 1073741824 1073741824
innodb_monitor_disable 否 all
innodb_monitor_enable 否 all
innodb_old_blocks_pct 否 [5-95] 37 37
innodb_old_blocks_time 否 [0-1024] 1000 1000
innodb_online_alter_log_max_size 否 [134217728-214748364... 134217728 134217728
innodb_open_files 是 [1-8192] 3000 3000
innodb_optimize_fulltext_only 否 [ON|OFF] OFF OFF
innodb_page_cleaners 是 [1-64] 1 1
innodb_print_all_deadlocks 否 [OFF|ON] OFF OFF
innodb_purge_batch_size 是 [1-5000] 300 300
innodb_purge_rseg_truncate_frequency 否 [1-128] 128 128
innodb_purge_threads 是 [1-32] 1 1
innodb_random_read_ahead 否 [ON|OFF] OFF OFF
innodb_read_ahead_threshold 否 [0-64] 56 56
innodb_read_io_threads 是 [1-64] 4 4
innodb_rollback_on_timeout 是 [OFF|ON] OFF OFF
innodb_rollback_segments 否 [1-128] 128 128
innodb_sort_buffer_size 是 [65536-67108864] 1048576 1048576
innodb_spin_wait_delay 否 [0-4294967295] 6 6
innodb_stats_auto_recalc 否 [ON|OFF] ON ON
innodb_stats_method 否 [nulls_equal|nulls_u... nulls_equal nulls_equal
innodb_stats_on_metadata 否 [ON|OFF] OFF OFF
innodb_stats_persistent 否 [ON|OFF] ON ON
innodb_stats_persistent_sample_pages 否 [0-4294967295] 20 20
innodb_stats_sample_pages 否 [1-4294967296] 8 8
innodb_stats_transient_sample_pages 否 [1-4294967295] 8 8
innodb_status_output 否 [ON|OFF] OFF OFF
innodb_status_output_locks 否 [ON|OFF] OFF OFF
innodb_strict_mode 否 [ON|OFF] OFF OFF
innodb_sync_array_size 是 [1-1024] 1 1
innodb_sync_spin_loops 否 [0-4294967295] 30 30
innodb_table_locks 否 [ON|OFF] ON ON
innodb_thread_concurrency 否 [0-256] 0 0
innodb_thread_sleep_delay 否 [1-3600000] 10000 10000
innodb_write_io_threads 是 [1-64] 4 4
interactive_timeout 否 [10-86400] 7200 7200
join_buffer_size 否 [128-4294967295] {LEAST(DBInstanceClassMemory/1048576*128, 262144)} 262144
key_cache_age_threshold 否 [100-4294967295] 300 300
key_cache_block_size 否 [512-16384] 1024 1024
key_cache_division_limit 否 [1-100] 100 100
lc_time_names 否 [ja_JP|pt_BR|en_US] en_US en_US
lock_wait_timeout 否 [1-1073741824] 31536000 31536000
log_queries_not_using_indexes 否 [ON|OFF] OFF OFF
log_slow_admin_statements 否 [ON|OFF] OFF OFF
log_throttle_queries_not_using_indexes 否 [0-4294967295] 0 0
long_query_time 否 [0.1-31536000] 1 1
loose_innodb_data_file_purge 否 [ON|OFF] ON ON
loose_innodb_data_file_purge_interval 否 [0-10000] 100 100
loose_innodb_data_file_purge_max_size 否 [16-1073741824] 512 512
loose_innodb_log_optimize_ddl 否 [ON|OFF] OFF OFF
loose_innodb_numa_interleave 是 [ON|OFF] ON ON
loose_max_execution_time 否 [0-4294967295] 0 0
loose_optimizer_trace 否 .* enabled=off,one_line=off enabled=off,one_line=off
loose_optimizer_trace_features 否 .* greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
loose_opt_rds_enable_show_slave_lag 否 bool ON ON
loose_opt_rds_last_error_gtid 否 bool ON ON
loose_performance_point_iostat_interval 否 [0-60] 2 2
loose_performance_point_iostat_volume_size 是 [0-100000] 10000 10000
loose_performance_point_lock_rwlock_enabled 否 [ON|OFF] ON ON
loose_rds_check_core_file_enabled 否 bool ON ON
loose_rds_kill_connections 否 [0, 1844674407370955... 20 20
loose_rds_set_connection_id_enabled 否 [ON|OFF] ON ON
loose_thread_pool_enabled 否 [ON|OFF] ON OFF
loose_thread_pool_oversubscribe 否 [10-64] 32 16
loose_thread_pool_size 否 [1-32] 4 4
loose_validate_password_length 否 [1-12] 8 8
low_priority_updates 否 [0|1] 0 0
master_verify_checksum 否 [ON|OFF] OFF OFF
max_allowed_packet 否 [16384-1073741824] 1073741824 1073741824
max_binlog_stmt_cache_size 否 [4096-18446744073709... 18446744073709547520 18446744073709547520
max_connect_errors 否 [1-4294967295] 100 100
max_error_count 否 [0-65535] 64 64
max_heap_table_size 否 [16384-1844674407370... 67108864 67108864
max_join_size 否 [1-18446744073709551... 18446744073709551615 18446744073709551615
max_length_for_sort_data 否 [0-838860] 1024 1024
max_points_in_geometry 否 [3-1048576] 65536 65536
max_prepared_stmt_count 否 [0-1048576] 16382 16382
max_seeks_for_key 否 [1-18446744073709551... 18446744073709500000 18446744073709500000
max_sort_length 否 [4-8388608] 1024 1024
max_sp_recursion_depth 否 [0-255] 0 0
max_write_lock_count 否 [1-102400] 102400 102400
metadata_locks_cache_size 是 [1-1048576] 1024 1024
min_examined_row_limit 否 [0-4294967295] 0 0
myisam_sort_buffer_size 否 [262144-16777216] 262144 262144
mysql_native_password_proxy_users 否 [ON|OFF] OFF OFF
net_buffer_length 否 [1024-1048576] 16384 16384
net_read_timeout 否 [1-31536000] 30 30
net_retry_count 否 [1-4294967295] 10 10
net_write_timeout 否 [1-31536000] 60 60
ngram_token_size 是 [0-20] 2 2
old_passwords 否 [0|2] 0 0
open_files_limit 是 [4000-655350] 65535 65535
optimizer_prune_level 否 [0|1] 1 1
optimizer_search_depth 否 [0-62] 62 62
optimizer_trace_limit 否 [0-4294967295] 1 1
optimizer_trace_max_mem_size 否 [0-4294967295] 16384 16384
optimizer_trace_offset 否 [0-4294967295] -1 -1
performance_schema 是 [ON|OFF] OFF OFF
preload_buffer_size 否 [1024-1073741824] 32768 32768
query_alloc_block_size 否 [1024-16384] 8192 8192
query_cache_limit 否 [1-1048576] 1048576 1048576
query_cache_min_res_unit 否 [512-184467440737095... 1024 1024
query_cache_size 否 [0-10485760000] 0 3145728
query_cache_type 是 [0|1|2] 0 0
query_cache_wlock_invalidate 否 [ON|OFF] OFF OFF
query_prealloc_size 否 [8192-1048576] 8192 8192
range_alloc_block_size 否 [4096-18446744073709... 4096 4096
range_optimizer_max_mem_size 是 [0-18446744073709551... 8388608 8388608
rds_reserved_connections 否 [0-512] 512 512
session_track_gtids 否 [OFF|OWN_GTID|ALL_GT... OFF OFF
session_track_schema ON
session_track_state_change OFF
sha256_password_proxy_users 否 [ON|OFF] OFF OFF
show_compatibility_56 否 [ON|OFF] OFF OFF
show_old_temporals 否 [ON|OFF] OFF OFF
slave_net_timeout 否 [15-300] 60 60
slave_parallel_type 否 [DATABASE|LOGICAL_CL... LOGICAL_CLOCK LOGICAL_CLOCK
slow_launch_time 否 [1-1024] 2 2
slow_query_log 否 [ON|OFF] ON ON
sort_buffer_size 否 [32768-4294967295] 262144 262144
sql_mode 否 (\s*|REAL_AS_FLOAT|P...
stored_program_cache 否 [16-524288] 256 256
table_definition_cache 否 [400-80480] {LEAST(DBInstanceClassMemory/1073741824*512, 2048)} 512
table_open_cache 否 [1-524288] {LEAST(DBInstanceClassMemory/1073741824*256, 2048)} 2000
table_open_cache_instances 是 [1-64] {LEAST(DBInstanceClassMemory/1073741824, 16)} 16
thread_cache_size 否 [0-16384] 256 256
thread_stack 是 [131072-1073741824] 262144 262144
tls_version 是 [TLSv1,TLSv1.1,TLSv1... TLSv1,TLSv1.1,TLSv1.2 TLSv1,TLSv1.1,TLSv1.2
tmp_table_size 否 [262144-134217728] 2097152 2097152
transaction_alloc_block_size 否 [1024-131072] 8192 8192
transaction_isolation 否 [READ-UNCOMMITTED|RE... READ-COMMITTED READ-COMMITTED
transaction_prealloc_size 否 [1024-131072] 4096 4096
updatable_views_with_limit 否 [YES|NO] YES YES
wait_timeout 否 [1-31536000] 86400 86400
| 模板ID:rpg-sys-01030401010100 |
模板名称:mysql_innodb_5.7_basic_normal_safe |
| 数据库引擎:MySQL |
数据库版本:5.7 |
| 描述:sync_binlog=1, innodb_flush_log_at_trx_commit=1, semi-sync |
| 模板ID:rpg-sys-01020402010200 |
模板名称:mysql_innodb_5.6_standard_normal_high |
| 数据库引擎:MySQL |
数据库版本:5.6 |
| 描述:sync_binlog=1000, innodb_flush_log_at_trx_commit=2, async |
基本信息
模板ID:rpg-sys-01020402010100 模板名称:mysql_innodb_5.6_standard_normal_safe
数据库引擎:MySQL 数据库版本:5.6
描述:sync_binlog=1, innodb_flush_log_at_trx_commit=1, semi-sync
参数
参数名 描述 是否重启 可修改参数值 默认值 配置值
automatic_sp_privileges 否 [ON|OFF] ON ON
auto_increment_increment 否 [1-65535] 1 1
auto_increment_offset 否 [1-65535] 1 1
back_log 是 [0-65535] 3000 3000
binlog_cache_size 否 [4096-16777216] 2097152 2097152
binlog_checksum 是 [CRC32|NONE] CRC32 CRC32
binlog_order_commits 否 [ON|OFF] ON ON
binlog_rows_query_log_events 否 [ON|OFF] OFF OFF
binlog_row_image 否 [full|minimal] full full
binlog_stmt_cache_size 否 [4096-16777216] 32768 32768
block_encryption_mode 否 ["aes-128-ecb"|"aes-... "aes-128-ecb" "aes-128-ecb"
bulk_insert_buffer_size 否 [0-4294967295] 4194304 4194304
character_set_client 否 [utf8|latin1|gbk|utf... utf8 utf8
character_set_filesystem 否 [utf8|latin1|gbk|bin... binary binary
character_set_server 是 [utf8|latin1|gbk|utf... utf8 utf8
concurrent_insert 否 [0|1|2] 1 1
connect_timeout 否 [1-3600] 10 10
default_storage_engine 是 [InnoDB|TokuDB|innod... InnoDB InnoDB
default_time_zone 是 [SYSTEM|-12:00|-11:0... SYSTEM SYSTEM
default_week_format 否 [0-7] 0 0
delayed_insert_limit 否 [1-4294967295] 100 100
delayed_insert_timeout 否 [1-3600] 300 300
delayed_queue_size 否 [1-4294967295] 1000 1000
delay_key_write 否 [ON|OFF|ALL] ON ON
disconnect_on_expired_password 是 [ON|OFF] ON ON
div_precision_increment 否 [0-30] 4 4
end_markers_in_json 否 [ON|OFF] OFF OFF
eq_range_index_dive_limit 否 [0-4294967295] 10 10
explicit_defaults_for_timestamp 是 true|false false false
flush_time 否 [0-31536000] 0 0
ft_max_word_len 是 [10-4294967295] 84 84
ft_min_word_len 是 [1-3600] 4 4
ft_query_expansion_limit 是 [0-1000] 20 20
group_concat_max_len 否 [4-18446744073709547... 1024 1024
host_cache_size 否 [0-65535] 643 643
innodb_adaptive_flushing 否 [ON|OFF] ON ON
innodb_adaptive_flushing_lwm 否 [0-70] 10 10
innodb_adaptive_hash_index 否 [ON|OFF] ON ON
innodb_adaptive_max_sleep_delay 否 [1-1000000] 150000 150000
innodb_additional_mem_pool_size 是 [2097152-104857600] 2097152 2097152
innodb_autoextend_increment 否 [1-1000] 64 64
innodb_autoinc_lock_mode 是 [0|1|2] 2 2
innodb_buffer_pool_dump_at_shutdown 否 [ON|OFF] OFF OFF
innodb_buffer_pool_instances 是 [1-64] 8 8
innodb_buffer_pool_load_at_startup 是 [ON|OFF] OFF OFF
innodb_change_buffering 否 [none|inserts|delete... all all
innodb_change_buffer_max_size 否 [0-50] 25 25
innodb_checksum_algorithm 否 [innodb|crc32|none|s... innodb innodb
innodb_cmp_per_index_enabled 否 [ON|OFF] OFF OFF
innodb_commit_concurrency 是 [0-1000] 0 0
innodb_compression_failure_threshold_pct 否 [0-100] 5 5
innodb_compression_level 否 [0-9] 6 6
innodb_compression_pad_pct_max 否 [0-70] 50 50
innodb_concurrency_tickets 否 [1-4294967295] 5000 5000
innodb_disable_sort_file_cache 否 [ON|OFF] ON ON
innodb_flush_method 是 [fsync|O_DSYNC|littl... O_DIRECT O_DIRECT
innodb_flush_neighbors 否 [0|1|2] 0 1
innodb_ft_cache_size 是 [1600000-80000000] 8000000 8000000
innodb_ft_enable_diag_print 否 [ON|OFF] OFF OFF
innodb_ft_enable_stopword 否 [ON|OFF] ON ON
innodb_ft_max_token_size 是 [10-84] 84 84
innodb_ft_min_token_size 是 [0-16] 3 3
innodb_ft_num_word_optimize 否 [0-10000] 2000 2000
innodb_ft_result_cache_limit 否 [1000000-4294967295] 2000000000 2000000000
innodb_ft_sort_pll_degree 是 [1-16] 2 2
innodb_ft_total_cache_size 是 [32000000-1600000000... 640000000 640000000
innodb_io_capacity 否 [100-4294967295] 20000 20000
innodb_io_capacity_max 否 [100-4294967295] 40000 40000
innodb_large_prefix 否 [ON|OFF] OFF OFF
innodb_lock_wait_timeout 否 [1-1073741824] 50 50
innodb_log_compressed_pages 否 [ON|OFF] OFF OFF
innodb_lru_scan_depth 否 [100-4294967295] 1024 1024
innodb_max_dirty_pages_pct 否 [50-90] 75 75
innodb_max_dirty_pages_pct_lwm 否 [0-75] 0 0
innodb_max_purge_lag 否 [0-4294967295] 0 0
innodb_max_purge_lag_delay 否 [0-10000000] 0 0
innodb_monitor_disable 否 all
innodb_monitor_enable 否 all
innodb_old_blocks_pct 否 [5-95] 37 37
innodb_old_blocks_time 否 [0-1024] 1000 1000
innodb_online_alter_log_max_size 否 [134217728-214748364... 134217728 134217728
innodb_open_files 是 [1-8192] 3000 3000
innodb_optimize_fulltext_only 否 [ON|OFF] OFF OFF
innodb_print_all_deadlocks 否 [OFF|ON] OFF OFF
innodb_purge_batch_size 是 [1-5000] 300 300
innodb_purge_threads 是 [1-32] 1 1
innodb_random_read_ahead 否 [ON|OFF] OFF OFF
innodb_read_ahead_threshold 否 [0-64] 56 56
innodb_read_io_threads 是 [1-64] 4 4
innodb_rollback_on_timeout 是 [OFF|ON] OFF OFF
innodb_rollback_segments 否 [1-128] 128 128
innodb_sort_buffer_size 是 [65536-67108864] 1048576 1048576
innodb_spin_wait_delay 否 [0-4294967295] 6 6
innodb_stats_auto_recalc 否 [ON|OFF] ON ON
innodb_stats_method 否 [nulls_equal|nulls_u... nulls_equal nulls_equal
innodb_stats_on_metadata 否 [ON|OFF] OFF OFF
innodb_stats_persistent 否 [ON|OFF] ON ON
innodb_stats_persistent_sample_pages 否 [0-4294967295] 20 20
innodb_stats_sample_pages 否 [1-4294967296] 8 8
innodb_stats_transient_sample_pages 否 [1-4294967295] 8 8
innodb_status_output 否 [ON|OFF] OFF OFF
innodb_status_output_locks 否 [ON|OFF] OFF OFF
innodb_strict_mode 否 [ON|OFF] OFF OFF
innodb_support_xa 否 [ON|OFF] ON ON
innodb_sync_array_size 是 [1-1024] 1 1
innodb_sync_spin_loops 否 [0-4294967295] 30 30
innodb_table_locks 否 [ON|OFF] ON ON
innodb_thread_concurrency 否 [0-256] 0 0
innodb_thread_sleep_delay 否 [1-3600000] 10000 10000
innodb_write_io_threads 是 [1-64] 4 4
interactive_timeout 否 [10-86400] 7200 7200
join_buffer_size 否 [128-4294967295] {LEAST(DBInstanceClassMemory/1048576*128, 262144)} 262144
key_cache_age_threshold 否 [100-4294967295] 300 300
key_cache_block_size 否 [512-16384] 1024 1024
key_cache_division_limit 否 [1-100] 100 100
lc_time_names 否 [ja_JP|pt_BR|en_US] en_US en_US
lock_wait_timeout 否 [1-1073741824] 31536000 31536000
log_queries_not_using_indexes 否 [ON|OFF] OFF OFF
log_slow_admin_statements 否 [ON|OFF] OFF OFF
log_throttle_queries_not_using_indexes 否 [0-4294967295] 0 0
long_query_time 否 [0.1-31536000] 1 1
loose_gap_lock_raise_error 否 [ON|OFF] OFF OFF
loose_gap_lock_write_log 否 [ON|OFF] OFF OFF
loose_innodb_data_file_purge 否 [ON|OFF] ON ON
loose_innodb_data_file_purge_interval 否 [0-10000] 100 100
loose_innodb_data_file_purge_max_size 否 [16-1073741824] 512 512
loose_max_statement_time 否 [0-4294967295] 0 0
loose_optimizer_trace 否 .* enabled=off,one_line=off enabled=off,one_line=off
loose_optimizer_trace_features 否 .* greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
loose_rds_indexstat 否 [ON|OFF] OFF OFF
loose_rds_max_tmp_disk_space 否 [10737418240-1073741... 10737418240 10737418240
loose_rds_set_connection_id_enabled 否 [ON|OFF] ON ON
loose_rds_tablestat 否 [ON|OFF] OFF OFF
loose_rds_threads_running_high_watermark 否 [0-50000] 50000 50000
loose_thread_pool_oversubscribe 否 [10-64] 32 16
loose_thread_pool_size 否 [1-32] 4 4
loose_tokudb_auto_analyze 否 [0-4294967295] 30 30
loose_tokudb_buffer_pool_ratio 是 [0-100] 0 0
loose_validate_password_length 否 [1-15] 8 8
low_priority_updates 否 [0|1] 0 0
master_verify_checksum 否 [ON|OFF] OFF OFF
max_allowed_packet 否 [16384-1073741824] 1073741824 1073741824
max_binlog_stmt_cache_size 否 [4096-18446744073709... 18446744073709547520 18446744073709547520
max_connect_errors 否 [1-4294967295] 100 100
max_error_count 否 [0-65535] 64 64
max_heap_table_size 否 [16384-1844674407370... 16777216 16777216
max_join_size 否 [1-18446744073709551... 18446744073709551615 18446744073709551615
max_length_for_sort_data 否 [0-838860] 1024 1024
max_prepared_stmt_count 否 [0-1048576] 16382 16382
max_seeks_for_key 否 [1-18446744073709551... 18446744073709500000 18446744073709500000
max_sort_length 否 [4-8388608] 1024 1024
max_sp_recursion_depth 否 [0-255] 0 0
max_write_lock_count 否 [1-102400] 102400 102400
metadata_locks_cache_size 是 [1-1048576] 1024 1024
min_examined_row_limit 否 [0-4294967295] 0 0
myisam_sort_buffer_size 否 [262144-16777216] 262144 262144
net_buffer_length 否 [1024-1048576] 16384 16384
net_read_timeout 否 [1-31536000] 30 30
net_retry_count 否 [1-4294967295] 10 10
net_write_timeout 否 [1-31536000] 60 60
old_passwords 否 [0|1|2] 0 0
open_files_limit 是 [4000-655350] 65535 65535
optimizer_prune_level 否 [0|1] 1 1
optimizer_search_depth 否 [0-62] 62 62
optimizer_trace_limit 否 [0-4294967295] 1 1
optimizer_trace_max_mem_size 否 [0-4294967295] 16384 16384
optimizer_trace_offset 否 [0-4294967295] -1 -1
performance_schema 是 [ON|OFF] OFF OFF
preload_buffer_size 否 [1024-1073741824] 32768 32768
query_alloc_block_size 否 [1024-16384] 8192 8192
query_cache_limit 否 [1-1048576] 1048576 1048576
query_cache_min_res_unit 否 [512-184467440737095... 4096 4096
query_cache_size 否 [0-104857600] 3145728 3145728
query_cache_type 是 [0|1|2] 0 0
query_cache_wlock_invalidate 否 [ON|OFF] OFF OFF
query_prealloc_size 否 [8192-1048576] 8192 8192
range_alloc_block_size 否 [4096-18446744073709... 4096 4096
rds_reset_all_filter 否 [0|1] 0 0
slave_net_timeout 否 [15-300] 60 60
slow_launch_time 否 [1-1024] 2 2
slow_query_log 否 [ON|OFF] ON ON
sort_buffer_size 否 [32768-4294967295] 262144 262144
sql_mode 否 (\s*|REAL_AS_FLOAT|P... NO_ENGINE_SUBSTITUTION
stored_program_cache 否 [16-524288] 256 256
table_definition_cache 否 [400-80480] {LEAST(DBInstanceClassMemory/1073741824*512, 2048)} 512
table_open_cache 否 [1-524288] {LEAST(DBInstanceClassMemory/1073741824*256, 2048)} 2000
table_open_cache_instances 是 [1-64] {LEAST(DBInstanceClassMemory/1073741824, 16)} 16
thread_cache_size 否 [0-16384] 256 256
thread_stack 是 [131072-1073741824] 262144 262144
tls_version 是 [TLSv1,TLSv1.1,TLSv1... TLSv1,TLSv1.1,TLSv1.2 TLSv1,TLSv1.1,TLSv1.2
tmp_table_size 否 [262144-134217728] 2097152 2097152
transaction_alloc_block_size 否 [1024-131072] 8192 8192
transaction_isolation 是 [READ-COMMITTED|REPE... READ-COMMITTED READ-COMMITTED
transaction_prealloc_size 否 [1024-131072] 4096 4096
updatable_views_with_limit 否 [YES|NO] YES YES
wait_timeout 否 [1-31536000] 86400 86400