MySQL 5.7 新增参数

 

这些数据是通过 ” show global variables ;” 获得，可能不是所有的新增参数。我的 MySQL 版本是5.7.24 。

 

参数	默认值
binlog_group_commit_sync_delay	0
binlog_group_commit_sync_no_delay_count	0
binlog_transaction_dependency_history_size	25000
binlog_transaction_dependency_tracking	COMMIT_ORDER
check_proxy_users	OFF
default_authentication_plugin	mysql_native_password
default_password_lifetime	0
disabled_storage_engines
gtid_executed_compression_period	1000
have_statement_timeout	YES
innodb_adaptive_hash_index_parts	8
innodb_buffer_pool_chunk_size	134217728
innodb_buffer_pool_dump_pct	25
innodb_deadlock_detect	ON
innodb_default_row_format	dynamic
innodb_fill_factor	100
innodb_flush_sync	ON
innodb_log_checksums	ON
innodb_log_write_ahead_size	8192
innodb_page_cleaners	4
innodb_purge_rseg_truncate_frequency	128
innodb_temp_data_file_path	ibtmp1:12M:autoextend
innodb_undo_log_truncate	OFF
internal_tmp_disk_storage_engine	InnoDB
keyring_operations	ON
log_builtin_as_identified_by_password	OFF
log_error_verbosity	3
log_statements_unsafe_for_binlog	ON
log_syslog	OFF
log_syslog_facility	daemon
log_syslog_include_pid	ON
log_syslog_tag
log_timestamps	UTC
max_execution_time	0
max_points_in_geometry	65536
mysql_native_password_proxy_users	OFF
ngram_token_size	2
offline_mode	OFF
parser_max_mem_size	18446744073709551615
performance_schema_events_transactions_history_long_size	10000
performance_schema_events_transactions_history_size	10
performance_schema_max_index_stat	-1
performance_schema_max_memory_classes	320
performance_schema_max_metadata_locks	-1
performance_schema_max_prepared_statements_instances	-1
performance_schema_max_program_instances	-1
performance_schema_max_sql_text_length	1024
performance_schema_max_statement_stack	10
performance_schema_max_table_lock_stat	-1
range_optimizer_max_mem_size	8388608
rbr_exec_mode	STRICT
require_secure_transport	OFF
session_track_gtids	OFF
session_track_schema	ON
session_track_state_change	OFF
session_track_system_variables	time_zone,autocommit,character_set_client,character_set_results,character_set_connection
session_track_transaction_info	OFF
sha256_password_proxy_users	OFF
show_compatibility_56	OFF
show_create_table_verbosity	OFF
slave_parallel_type	DATABASE
slave_preserve_commit_order	OFF
super_read_only	OFF
tls_version	TLSv1,TLSv1.1
transaction_isolation	REPEATABLE-READ
transaction_read_only	OFF
transaction_write_set_extraction	OFF

 

• innodb_buffer_pool_chunk_size

在 buffer pool resing 操作时 chunk 的大小 。

• innodb_default_row_format

默认的innodb表行格式。

• innodb_fill_factor

指定 B-tree 页用于存放数据占空间比例。

• innodb_log_checksums

启用或禁用重做日志页的校验和，取代了参数 innodb_log_checksum_algorithm。

• innodb_page_cleaners

Buffer pool 中用于刷新脏页的页清理线程的数量。

• innodb_temp_data_file_path

指定临时表空间数据文件路径。

• innodb_undo_log_truncate

在线收缩undo表空间。

• slave_parallel_type

并行复制的类型。

• transaction_isolation

用于替换参数 tx_isolation 。

• transaction_read_only

用于替换参数 tx_read_only 。