可修改参数列表（MySQL 5.7）--云数据库 veDB MySQL 版-火山引擎

文档中心

导航

可修改参数列表（MySQL 5.7）

最近更新时间：2025.03.25 11:45:14首次发布时间：2025.03.25 10:11:37

本文介绍兼容版本为 MySQL 5.7 实例提供的可修改参数，以及参数的默认值、修改后是否需要重启和取值范围。

参数列表

参数	默认值	取值范围	是否重启生效
auto_increment_increment	1	[1-65535]	否
auto_increment_offset	1	[1-65535]	否
automatic_sp_privileges	ON	[ON\|OFF]	否
back_log	3000	[0-65535]	是
character_set_filesystem	binary	[utf8\|latin1\|gbk\|binary]	否
character_set_server	utf8mb4	[utf8mb4]	是
collation_server	utf8mb4_general_ci	[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\|utf8_german2_ci\|utf8_croatian_ci\|utf8_unicode_520_ci\|utf8_vietnamese_ci\|utf8_general_mysql500_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\|ucs2_german2_ci\|ucs2_croatian_ci\|ucs2_unicode_520_ci\|ucs2_vietnamese_ci\|ucs2_general_mysql500_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\|utf8mb4_german2_ci\|utf8mb4_croatian_ci\|utf8mb4_unicode_520_ci\|utf8mb4_vietnamese_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\|utf16_german2_ci\|utf16_croatian_ci\|utf16_unicode_520_ci\|utf16_vietnamese_ci\|utf16le_general_ci\|utf16le_bin\|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\|utf32_german2_ci\|utf32_croatian_ci\|utf32_unicode_520_ci\|utf32_vietnamese_ci\|binary\|geostd8_general_ci\|geostd8_bin\|cp932_japanese_ci\|cp932_bin\|eucjpms_japanese_ci\|eucjpms_bin\|gb18030_chinese_ci\|gb18030_bin\|gb18030_unicode_520_ci]	否
connect_timeout	10	[2-31536000]	否
default_week_format	0	[0-7]	否
delay_key_write	ON	[OFF\|ON\|ALL]	否
disconnect_on_expired_password	ON	[ON\|OFF]	是
div_precision_increment	4	[0-30]	否
end_markers_in_json	OFF	[ON\|OFF]	否
eq_range_index_dive_limit	200	[0-4294967295]	否
explicit_defaults_for_timestamp	ON	[ON\|OFF]	否
flush_time	0	[0-31536000]	否
ft_max_word_len	84	[10-84]	是
ft_min_word_len	4	[1-84]	是
ft_query_expansion_limit	20	[0-1000]	是
group_concat_max_len	1024	[4-18446744073709551615]	否
innodb_adaptive_flushing	ON	[ON\|OFF]	否
innodb_adaptive_flushing_lwm	10	[0-70]	否
innodb_adaptive_hash_index	OFF	[ON\|OFF]	否
innodb_adaptive_max_sleep_delay	150000	[0-1000000]	否
innodb_autoextend_increment	64	[1-1000]	否
innodb_autoinc_lock_mode	2	[0-2]	是
innodb_buffer_pool_dump_at_shutdown	ON	[ON\|OFF]	否
innodb_buffer_pool_load_at_startup	ON	[ON\|OFF]	是
innodb_buffer_pool_size	{DBNodeClassMemory*3/4}	[{DBNodeClassMemory1/16}-{DBNodeClassMemory4/5}]	否
innodb_change_buffer_max_size	25	[0-50]	否
innodb_cmp_per_index_enabled	OFF	[ON\|OFF]	否
innodb_concurrency_tickets	5000	[1-18446744073709551615]	否
innodb_deadlock_detect	ON	[ON\|OFF]	否
innodb_disable_sort_file_cache	OFF	[ON\|OFF]	否
innodb_fill_factor	100	[10-100]	否
innodb_flush_neighbors	0	[0-2]	否
innodb_flush_sync	ON	[ON\|OFF]	否
innodb_ft_cache_size	8000000	[1600000-80000000]	是
innodb_ft_enable_diag_print	OFF	[ON\|OFF]	否
innodb_ft_enable_stopword	ON	[ON\|OFF]	否
innodb_ft_max_token_size	84	[10-84]	是
innodb_ft_min_token_size	3	[0-16]	是
innodb_ft_num_word_optimize	2000	[1000-10000]	否
innodb_ft_result_cache_limit	2000000000	[1000000-4294967295]	否
innodb_ft_sort_pll_degree	2	[1-16]	是
innodb_ft_total_cache_size	640000000	[32000000-1600000000]	是
innodb_io_capacity	25000	[100-18446744073709551615]	否
innodb_io_capacity_max	50000	[100-18446744073709551615]	否
innodb_large_prefix	ON	[ON\|OFF]	否
innodb_lock_wait_timeout	50	[1-1073741824]	否
innodb_log_checksums	ON	[ON\|OFF]	否
innodb_log_compressed_pages	ON	[ON\|OFF]	否
innodb_max_dirty_pages_pct	90	[0-99.999]	否
innodb_max_dirty_pages_pct_lwm	0	[0-99.999]	否
innodb_max_purge_lag	0	[0-18446744073709551615]	否
innodb_max_purge_lag_delay	0	[0-10000000]	否
innodb_max_undo_log_size	1073741824	[10485760-18446744073709551615]	否
innodb_old_blocks_pct	37	[5-95]	否
innodb_old_blocks_time	1000	[0-4294967295]	否
innodb_online_alter_log_max_size	4398046511104	[65536-18446744073709551615]	否
innodb_optimize_fulltext_only	OFF	[ON\|OFF]	否
innodb_print_all_deadlocks	OFF	[ON\|OFF]	否
innodb_purge_batch_size	5000	[1-5000]	否
innodb_purge_rseg_truncate_frequency	16	[1-128]	否
innodb_purge_threads	{MIN(MAX(DBNodeClassCPU,4),32)}	[1-32]	是
innodb_random_read_ahead	OFF	[ON\|OFF]	否
innodb_read_ahead_threshold	56	[0-64]	否
innodb_rollback_on_timeout	OFF	[ON\|OFF]	是
innodb_sort_buffer_size	67108864	[65536-67108864]	是
innodb_spin_wait_delay	6	[0-18446744073709551615]	否
innodb_stats_auto_recalc	ON	[ON\|OFF]	否
innodb_stats_method	nulls_equal	[nulls_equal\|nulls_unequal\|nulls_ignored]	否
innodb_stats_on_metadata	OFF	[ON\|OFF]	否
innodb_stats_persistent	ON	[ON\|OFF]	否
innodb_stats_persistent_sample_pages	20	[1-18446744073709551615]	否
innodb_stats_transient_sample_pages	8	[1-18446744073709551615]	否
innodb_strict_mode	ON	[ON\|OFF]	否
innodb_sync_array_size	1	[1-1024]	是
innodb_sync_spin_loops	30	[0-18446744073709551615]	否
innodb_table_locks	ON	[ON\|OFF]	否
innodb_thread_concurrency	0	[0-1000]	否
innodb_undo_log_truncate	ON	[ON\|OFF]	否
interactive_timeout	28800	[1-31536000]	否
join_buffer_size	{MIN(DBNodeClassMemory/1048576*128,262144)}	[128-67108864]	否
key_cache_age_threshold	300	[100-18446744073709551600]	否
key_cache_block_size	1024	[512-16384]	否
key_cache_division_limit	100	[1-100]	否
kill_idle_transaction	0	[0-31536000]	否
lc_time_names	en_US	[ja_JP\|pt_BR\|en_US]	否
local_infile	OFF	[ON\|OFF]	否
lock_wait_timeout	31536000	[1-31536000]	否
log_queries_not_using_indexes	OFF	[ON\|OFF]	否
log_throttle_queries_not_using_indexes	0	[0-18446744073709551615]	否
long_query_time	1	[0-4719230590769954816]	否
master_verify_checksum	OFF	[ON\|OFF]	否
max_allowed_packet	67108864	[1024-1073741824]	否
max_connect_errors	18446744073709551615	[1-18446744073709551615]	否
max_digest_length	1024	[0-1048576]	是
max_error_count	1024	[0-65535]	否
max_execution_time	0	[0-18446744073709551615]	否
max_heap_table_size	16777216	[16384-18446744073709551615]	否
max_join_size	18446744073709551615	[1-18446744073709551615]	否
max_length_for_sort_data	4096	[4-8388608]	否
max_points_in_geometry	65536	[3-1048576]	否
max_prepared_stmt_count	16382	[0-1048576]	否
max_seeks_for_key	18446744073709551615	[1-18446744073709551615]	否
max_sort_length	1024	[4-8388608]	否
max_sp_recursion_depth	0	[0-255]	否
max_write_lock_count	18446744073709551615	[1-18446744073709551615]	否
min_examined_row_limit	0	[0-18446744073709551615]	否
mysql_native_password_proxy_users	OFF	[ON\|OFF]	否
net_read_timeout	30	[1-31536000]	否
net_retry_count	10	[1-18446744073709551615]	否
net_write_timeout	60	[1-31536000]	否
ngram_token_size	2	[1-10]	是
optimizer_prune_level	1	[0-1]	否
optimizer_search_depth	62	[0-62]	否
optimizer_switch	index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on,prefer_ordering_index=on,favor_range_scan=off	*[index_merge=on\|index_merge=off\|index_merge_union=on\|index_merge_union=off\|index_merge_sort_union=on\|index_merge_sort_union=off\|index_merge_intersection=on\|index_merge_intersection=off\|engine_condition_pushdown=on\|engine_condition_pushdown=off\|index_condition_pushdown=on\|index_condition_pushdown=off\|mrr=on\|mrr=off\|mrr_cost_based=on\|mrr_cost_based=off\|block_nested_loop=on\|block_nested_loop=off\|batched_key_access=on\|batched_key_access=off\|materialization=on\|materialization=off\|semijoin=on\|semijoin=off\|loosescan=on\|loosescan=off\|firstmatch=on\|firstmatch=off\|duplicateweedout=on\|duplicateweedout=off\|subquery_materialization_cost_based=on\|subquery_materialization_cost_based=off\|use_index_extensions=on\|use_index_extensions=off\|condition_fanout_filter=on\|condition_fanout_filter=off\|derived_merge=on\|derived_merge=off\|use_invisible_indexes=on\|use_invisible_indexes=off\|skip_scan=on\|skip_scan=off\|hash_join=on\|hash_join=off\|subquery_to_derived=on\|subquery_to_derived=off\|prefer_ordering_index=on\|prefer_ordering_index=off\|hypergraph_optimizer=on\|hypergraph_optimizer=off\|derived_condition_pushdown=on\|derived_condition_pushdown=off\|favor_range_scan=on\|favor_range_scan=off\|default=on\|default=off]	否
optimizer_trace	enabled=off,one_line=off	*[enabled=on\|enabled=off\|one_line=on\|one_line=off\|default=on\|default=off]	否
optimizer_trace_features	greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on	*[greedy_search=on\|greedy_search=off\|range_optimizer=on\|range_optimizer=off\|dynamic_range=on\|dynamic_range=off\|repeated_subselect=on\|repeated_subselect=off\|default=on\|default=off]	否
optimizer_trace_limit	1	[0-9223372036854775807]	否
optimizer_trace_max_mem_size	1048576	[0-18446744073709551615]	否
optimizer_trace_offset	-1	[-9223372036854775808-9223372036854775807]	否
performance_schema	OFF	[ON\|OFF]	是
preload_buffer_size	32768	[1024-1073741824]	否
query_alloc_block_size	8192	[1024-4294967295]	否
query_prealloc_size	8192	[8192-18446744073709551615]	否
range_alloc_block_size	4096	[4096-4294967295]	否
range_optimizer_max_mem_size	8388608	[0-18446744073709551615]	否
session_track_gtids	OFF	[OFF\|OWN_GTID\|ALL_GTIDS]	否
session_track_schema	ON	[ON\|OFF]	否
sha256_password_proxy_users	OFF	[ON\|OFF]	否
show_old_temporals	OFF	[ON\|OFF]	否
skip_name_resolve	OFF	[ON\|OFF]	是
slow_launch_time	2	[0-31536000]	否
slow_query_log	ON	[ON\|OFF]	否
sort_buffer_size	2097152	[32768-18446744073709551615]	否
sql_mode	ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION	*[REAL_AS_FLOAT\|PIPES_AS_CONCAT\|ANSI_QUOTES\|IGNORE_SPACE\|ONLY_FULL_GROUP_BY\|NO_UNSIGNED_SUBTRACTION\|NO_DIR_IN_CREATE\|NO_AUTO_VALUE_ON_ZERO\|NO_BACKSLASH_ESCAPES\|STRICT_TRANS_TABLES\|STRICT_ALL_TABLES\|NO_ZERO_IN_DATE\|NO_ZERO_DATE\|ALLOW_INVALID_DATES\|ERROR_FOR_DIVISION_BY_ZERO\|HIGH_NOT_PRECEDENCE\|NO_ENGINE_SUBSTITUTION\|PAD_CHAR_TO_FULL_LENGTH\|NO_AUTO_CREATE_USER\|NO_FIELD_OPTIONS\|NO_KEY_OPTIONS\|NO_TABLE_OPTIONS\|]	否
stored_program_cache	256	[16-524288]	否
table_definition_cache	16384	[400-524288]	否
table_open_cache	{MAX(DBNodeClassMemory/1073741824*256,2048)}	[1-524288]	否
table_open_cache_instances	{MAX(DBNodeClassCPU,32)}	[1-64]	是
thread_pool_high_prio_mode	transactions	[transactions\|statements\|none]	否
thread_pool_high_prio_tickets	4294967295	[0-4294967295]	否
thread_pool_idle_timeout	60	[1-4294967295]	否
thread_pool_oversubscribe	8	[1-1000]	否
thread_pool_size	{DBNodeClassCPU*4}	[{DBNodeClassCPU1}-{DBNodeClassCPU10}]	否
thread_pool_stall_limit	10	[10-4294967295]	否
thread_stack	262144	[131072-1073741824]	是
time_zone	+8:00	[SYSTEM\|-12:00\|-11:00\|-10:00\|-9:00\|-8:00\|-7:00\|-6:00\|-5:00\|-4:00\|-3:00\|-2:00\|-1:00\|+0:00\|+1:00\|+2:00\|+3:00\|+4:00\|+5:00\|+5:30\|+6:00\|+6:30\|+7:00\|+8:0\|+9:00\|+10:00\|+11:00\|+12:00\|+13:00]	否
tmp_table_size	16777216	[1024-18446744073709551615]	否
transaction_alloc_block_size	8192	[1024-131072]	否
transaction_isolation	READ-COMMITTED	[READ-UNCOMMITTED\|READ-COMMITTED\|REPEATABLE-READ\|SERIALIZABLE]	否
transaction_prealloc_size	4096	[1024-131072]	否
updatable_views_with_limit	YES	[NO\|YES]	否
wait_timeout	28800	[1-31536000]	否

如何查询 veDB MySQL 实例不支持修改的参数的设定值？

登录云数据库 veDB MySQL 版控制台，在实例参数配置页面中搜索参数。若搜索不到，可登录数据库工作台，使用 SQL 语句 SHOW variables like '参数名' 查看。