这些数据是通过 ” 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 。
