文档中心

可修改参数列表（MySQL 5.7）

最近更新时间：2024.02.06 21:22:13

首次发布时间：2023.03.15 17:15:36

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

序号	参数名	参数默认值	是否需要重启	取值范围
1	auto_increment_increment	1	否	[1-65535]
2	auto_increment_offset	1	否	[1-65535]
3	automatic_sp_privileges	ON	否	[ON\|OFF]
4	avoid_temporal_upgrade	OFF	否	[ON\|OFF]
5	back_log	3000	是	[1-65535]
6	binlog_cache_size	2097152	否	[4096-16777216]
7	binlog_checksum	CRC32	否	[CRC32\|NONE]
8	binlog_order_commits	ON	否	[ON\|OFF]
9	binlog_row_image	full	否	[full\|minimal]
10	binlog_rows_query_log_events	OFF	否	[ON\|OFF]
11	binlog_stmt_cache_size	32768	否	[4096-16777216]
12	block_encryption_mode	aes-128-ecb	否	[aes-128-ecb\|aes-192-ecb\|aes-256-ecb\|aes-128-cbc\|aes-192-cbc\|aes-256-cbc]
13	bulk_insert_buffer_size	4194304	否	[0-4294967295]
14	character_set_filesystem	binary	否	[utf8\|latin1\|gbk\|binary]
15	character_set_server	utf8	是	[utf8\|latin1\|gbk\|gb18030\|utf8mb4]
16	collation_server	utf8_general_ci	是	[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\|latin1_bin\|latin1_danish_ci\|latin1_general_ci\|latin1_general_cs\|latin1_german1_ci\|latin1_german2_ci\|latin1_spanish_ci\|latin1_swedish_ci\|gbk_bin\|gbk_chinese_ci\|gb18030_bin\|gb18030_chinese_ci\|gb18030_unicode_520_ci\|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]
17	concurrent_insert	AUTO	否	[NEVER\|AUTO\|ALWAYS]
18	connect_timeout	10	否	[2-3600]
19	default_storage_engine	InnoDB	是	[InnoDB\|innodb]
20	default_time_zone	+08: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:00\|+9:00\|+10:00\|+11:00\|+12:00\|+13:00]
21	default_week_format	0	否	[0-7]
22	delay_key_write	ON	否	[ON\|OFF\|ALL]
23	delayed_insert_timeout	300	否	[1-3600]
24	disconnect_on_expired_password	ON	是	[ON\|OFF]
25	div_precision_increment	4	否	[0-30]
26	end_markers_in_json	OFF	否	[ON\|OFF]
27	eq_range_index_dive_limit	100	否	[0-4294967295]
28	event_scheduler	OFF	否	[ON\|OFF]
29	explicit_defaults_for_timestamp	OFF	否	[ON\|OFF]
30	flush_time	0	否	[0-31536000]
31	ft_max_word_len	84	是	[10-84]
32	ft_min_word_len	4	是	[1-84]
33	ft_query_expansion_limit	20	是	[0-1000]
34	general_log	OFF	否	[OFF]
35	group_concat_max_len	1024	否	[4-1844674407370954752]
36	host_cache_size	644	否	[0-65535]
37	init_connect	-	否	[空\|set names utf8mb4\|set names utf8\|set names utf8mb4 collate utf8mb4_general_ci]
38	innodb_adaptive_flushing	ON	否	[ON\|OFF]
39	innodb_adaptive_flushing_lwm	10	否	[0-70]
40	innodb_adaptive_hash_index	OFF	否	[ON\|OFF]
41	innodb_adaptive_max_sleep_delay	150000	否	[1-1000000]
42	innodb_autoextend_increment	64	否	[1-1000]
43	innodb_autoinc_lock_mode	2	是	[0\|1\|2]
44	innodb_buffer_pool_dump_at_shutdown	ON	否	[ON\|OFF]
45	innodb_buffer_pool_dump_pct	25	否	[1-100]
46	innodb_buffer_pool_instances	2	是	[1-64]
47	innodb_buffer_pool_load_at_startup	ON	是	[ON\|OFF]
48	innodb_buffer_pool_size	1073741824	否	[134217728-1099511627776]
49	innodb_change_buffer_max_size	25	否	[0-50]
50	innodb_change_buffering	all	否	[none\|inserts\|deletes\|changes\|purges\|all]
51	innodb_checksum_algorithm	crc32	否	[innodb\|crc32\|none\|strict_innodb\|strict_crc32\|strict_none]
52	innodb_cmp_per_index_enabled	OFF	否	[ON\|OFF]
53	innodb_commit_concurrency	0	是	[0-1000]
54	innodb_compression_failure_threshold_pct	5	否	[0-100]
55	innodb_compression_level	6	否	[0-9]
56	innodb_compression_pad_pct_max	50	否	[0-70]
57	innodb_concurrency_tickets	5000	否	[1-4294967295]
58	innodb_deadlock_detect	ON	否	[ON\|OFF]
59	innodb_disable_sort_file_cache	OFF	否	[ON\|OFF]
60	innodb_flush_log_at_trx_commit	1	否	[0\|1\|2]
61	innodb_flush_method	O_DIRECT	是	[fsync\|O_DSYNC\|O_DIRECT\|O_DIRECT_NO_FSYNC]
62	innodb_flush_neighbors	0	否	[0\|1\|2]
63	innodb_flush_sync	ON	否	[ON\|OFF]
64	innodb_ft_cache_size	8000000	是	[1600000-80000000]
65	innodb_ft_enable_diag_print	OFF	否	[ON\|OFF]
66	innodb_ft_enable_stopword	ON	否	[ON\|OFF]
67	innodb_ft_max_token_size	84	是	[10-84]
68	innodb_ft_min_token_size	3	是	[0-16]
69	innodb_ft_num_word_optimize	2000	否	[0-10000]
70	innodb_ft_result_cache_limit	2000000000	否	[1000000-4294967295]
71	innodb_ft_sort_pll_degree	2	是	[1-16]
72	innodb_ft_total_cache_size	640000000	是	[32000000-1600000000]
73	innodb_io_capacity	1000	否	[100-4294967295]
74	innodb_io_capacity_max	2000	否	[100-4294967295]
75	innodb_large_prefix	ON	否	[ON\|OFF]
76	innodb_lock_wait_timeout	50	否	[1-1073741824]
77	innodb_log_checksums	ON	否	[ON\|OFF]
78	innodb_log_compressed_pages	OFF	否	[ON\|OFF]
79	innodb_lru_scan_depth	1024	否	[100-4294967295]
80	innodb_max_dirty_pages_pct	75	否	[0-99]
81	innodb_max_dirty_pages_pct_lwm	0	否	[0-99]
82	innodb_max_purge_lag	0	否	[0-4294967295]
83	innodb_max_purge_lag_delay	0	否	[0-10000000]
84	innodb_max_undo_log_size	1073741824	否	[10485760-18446744073709551615]
85	innodb_monitor_enable	all	否	[all]
86	innodb_old_blocks_pct	37	否	[5-95]
87	innodb_old_blocks_time	1000	否	[0-1024]
88	innodb_online_alter_log_max_size	134217728	否	[134217728-2147483647]
89	innodb_open_files	3000	是	[10-8192]
90	innodb_optimize_fulltext_only	OFF	否	[ON\|OFF]
91	innodb_page_cleaners	2	是	[1-64]
92	innodb_print_all_deadlocks	ON	否	[OFF\|ON]
93	innodb_purge_batch_size	300	是	[1-5000]
94	innodb_purge_rseg_truncate_frequency	128	否	[1-128]
95	innodb_purge_threads	1	是	[1-32]
96	innodb_random_read_ahead	OFF	否	[ON\|OFF]
97	innodb_read_ahead_threshold	56	否	[0-1024]
98	innodb_read_io_threads	1	是	[1-64]
99	innodb_rollback_on_timeout	OFF	是	[OFF\|ON]
100	innodb_rollback_segments	128	否	[1-128]
101	innodb_spin_wait_delay	6	否	[0-4294967295]
102	innodb_stats_auto_recalc	ON	否	[ON\|OFF]
103	innodb_stats_method	nulls_equal	否	[nulls_equal\|nulls_unequal\|nulls_ignored]
104	innodb_stats_on_metadata	OFF	否	[ON\|OFF]
105	innodb_stats_persistent	ON	否	[ON\|OFF]
106	innodb_stats_persistent_sample_pages	20	否	[0-4294967295]
107	innodb_stats_sample_pages	8	否	[1-4294967296]
108	innodb_stats_transient_sample_pages	8	否	[1-4294967295]
109	innodb_status_output	OFF	否	[ON\|OFF]
110	innodb_status_output_locks	OFF	否	[ON\|OFF]
111	innodb_strict_mode	OFF	否	[ON\|OFF]
112	innodb_sync_array_size	512	是	[1-1024]
113	innodb_sync_spin_loops	30	否	[0-4294967295]
114	innodb_table_locks	ON	否	[ON\|OFF]
115	innodb_temp_data_file_path	ibtmp1:50M:autoextend:max:30G	是	-
116	innodb_thread_concurrency	0	否	[0-1000]
117	innodb_thread_sleep_delay	10000	否	[0-1000000]
118	innodb_undo_log_truncate	OFF	否	[ON\|OFF]
119	innodb_write_io_threads	1	是	[1-64]
120	interactive_timeout	7200	否	[10-86400]
121	join_buffer_size	262144	否	[128-4294967295]
122	key_cache_age_threshold	300	否	[100-4294967295]
123	key_cache_block_size	1024	否	[512-16384]
124	key_cache_division_limit	100	否	[1-100]
125	lc_time_names	en_US	否	[ja_JP\|pt_BR\|en_US]
126	local_infile	ON	否	[ON\|OFF]
127	lock_wait_timeout	31536000	否	[1-31536000]
128	log_bin_use_v1_row_events	OFF	否	[ON\|OFF]
129	log_error_verbosity	2	否	[1-3]
130	log_queries_not_using_indexes	OFF	否	[ON\|OFF]
131	log_slow_admin_statements	OFF	否	[ON\|OFF]
132	log_throttle_queries_not_using_indexes	0	否	[0-4294967295]
133	long_query_time	1	否	[0.1-31536000]
134	loose_thread_pool_enabled	ON	是	[ON\|OFF]
135	loose_thread_pool_oversubscribe	16	否	[2-128]
136	loose_thread_pool_size	2	否	[1-64]
137	low_priority_updates	OFF	否	[ON\|OFF]
138	lower_case_table_names	1	是	[0\|1]
139	master_verify_checksum	OFF	否	[ON\|OFF]
140	max_allowed_packet	1073741824	否	[16384-1073741824]
141	max_binlog_cache_size	18446744073709547520	否	[4096-18446744073709547520]
142	max_binlog_stmt_cache_size	18400000000000000000	否	[4096-18446744073709547520]
143	max_connect_errors	100	否	[0-4294967295]
144	max_connections	600	否	[100-100000]
145	max_error_count	64	否	[0-65535]
146	max_execution_time	0	否	[0-4294967295]
147	max_heap_table_size	67108864	否	[16384-1844674407370954752]
148	max_join_size	18446744073709551615	否	[1-18446744073709551615]
149	max_length_for_sort_data	1024	否	[0-838860]
150	max_points_in_geometry	65536	否	[3-1048576]
151	max_prepared_stmt_count	16382	否	[0-1048576]
152	max_seeks_for_key	18400000000000000000	否	[1-18446744073709551615]
153	max_sort_length	1024	否	[4-8388608]
154	max_sp_recursion_depth	0	否	[0-255]
155	max_user_connections	0	否	[0\|100-100000]
156	max_write_lock_count	102400	否	[1-102400]
157	metadata_locks_cache_size	1024	是	[1-1048576]
158	min_examined_row_limit	0	否	[0-4294967295]
159	myisam_sort_buffer_size	262144	否	[262144-16777216]
160	mysql_native_password_proxy_users	OFF	否	[ON\|OFF]
161	net_buffer_length	16384	否	[1024-1048576]
162	net_read_timeout	30	否	[1-31536000]
163	net_retry_count	10	否	[1-4294967295]
164	net_write_timeout	60	否	[1-31536000]
165	ngram_token_size	2	是	[1-10]
166	open_files_limit	1048576	是	[4000-1073741824]
167	optimizer_prune_level	1	否	[0\|1]
168	optimizer_search_depth	62	否	[0-62]
169	optimizer_trace_limit	1	否	[0-4294967295]
170	optimizer_trace_max_mem_size	16384	否	[0-4294967295]
171	optimizer_trace_offset	-1	否	[-1-4294967295]
172	performance_schema	OFF	是	[ON\|OFF]
173	preload_buffer_size	32768	否	[1024-1073741824]
174	query_alloc_block_size	8192	否	[1024-16384]
175	query_cache_limit	1048576	否	[1-1048576]
176	query_cache_min_res_unit	1024	否	[512-18446744073709551608]
177	query_cache_size	0	否	[0-10485760000]
178	query_cache_type	OFF	是	[OFF\|ON\|DEMAND]
179	query_cache_wlock_invalidate	OFF	否	[ON\|OFF]
180	query_prealloc_size	8192	否	[8192-1048576]
181	range_alloc_block_size	4096	否	[4096-18446744073709551615]
182	range_optimizer_max_mem_size	8388608	是	[0-18446744073709551615]
183	read_buffer_size	262144	否	[8200-2147479552]
184	relay_log_recovery	ON	是	[ON\|OFF]
185	session_track_gtids	OFF	否	[OFF\|OWN_GTID\|ALL_GTIDS]
186	sha256_password_proxy_users	OFF	否	[ON\|OFF]
187	show_old_temporals	OFF	否	[ON\|OFF]
188	slave_net_timeout	60	否	[1-31536000]
189	slave_parallel_type	LOGICAL_CLOCK	否	[DATABASE\|LOGICAL_CLOCK]
190	slave_type_conversions	-	是	[空\|ALL_LOSSY\|ALL_NON_LOSSY\|ALL_LOSSY,ALL_NON_LOSSY\|ALL_SIGNED\|ALL_UNSIGNED\|ALL_SIGNED,ALL_UNSIGNED]
191	slow_launch_time	2	否	[1-1024]
192	slow_query_log	ON	否	[ON\|OFF]
193	sort_buffer_size	262144	否	[32768-4294967295]
194	sql_mode	ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION	否	[*ALLOW_INVALID_DATES\|ANSI_QUOTES\|ERROR_FOR_DIVISION_BY_ZERO\|HIGH_NOT_PRECEDENCE\|IGNORE_SPACE\|NO_AUTO_CREATE_USER\|NO_AUTO_VALUE_ON_ZERO\|NO_BACKSLASH_ESCAPES\|NO_DIR_IN_CREATE\|NO_ENGINE_SUBSTITUTION\|NO_FIELD_OPTIONS\|NO_KEY_OPTIONS\|NO_TABLE_OPTIONS\|NO_UNSIGNED_SUBTRACTION\|NO_ZERO_DATE\|NO_ZERO_IN_DATE\|ONLY_FULL_GROUP_BY\|PAD_CHAR_TO_FULL_LENGTH\|PIPES_AS_CONCAT\|REAL_AS_FLOAT\|STRICT_ALL_TABLES\|STRICT_TRANS_TABLES]
195	sql_safe_updates	OFF	否	[ON\|OFF]
196	stored_program_cache	256	否	[16-524288]
197	sync_binlog	1	否	[0-4294967295]
198	sync_master_info	10000	否	[0-4294967295]
199	sync_relay_log_info	10000	否	[0-4294967295]
200	table_definition_cache	1024	否	[400-80480]
201	table_open_cache	512	否	[1-524288]
202	table_open_cache_instances	2	是	[1-64]
203	thread_cache_size	1024	否	[0-16384]
204	thread_stack	1048576	是	[131072-2147483647]
205	tls_version	TLSv1,TLSv1.1,TLSv1.2	是	[TLSv1,TLSv1.1,TLSv1.2\|TLSv1,TLSv1.1\|TLSv1.2]
206	tmp_table_size	2097152	否	[262144-134217728]
207	transaction_alloc_block_size	8192	否	[1024-131072]
208	transaction_isolation	READ-COMMITTED	否	[READ-UNCOMMITTED\|READ-COMMITTED\|REPEATABLE-READ\|SERIALIZABLE]
209	transaction_prealloc_size	4096	否	[1024-131072]
210	updatable_views_with_limit	YES	否	[YES\|NO]
211	wait_timeout	86400	否	[1-31536000]

常见问题

如何查询云数据库 MySQL 版不支持修改的参数的设定值？

可登录数据库工作台，使用 SQL 语句 SHOW variables like '参数名'查看。

常见问题

如何查询云数据库 MySQL 版不支持修改的参数的设定值？