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