MySQL 8.0 增加了许多新的特性和功能,与此同时也引入了许多新的配置参数,本文汇总了MySQL 8.0 新增加的参数,并按功能进行了分类。截止8.0.20版本。
1. Binlog
配置参数:
binlog_encryption
binlog_expire_logs_seconds
binlog_rotate_encryption_master_key_at_startup
binlog_row_metadata
binlog_row_value_options
binlog_transaction_compression
binlog_transaction_compression_level_zstd
binlog_transaction_dependency_history_size
binlog_transaction_dependency_tracking
2. InnoDB
配置参数:
innodb_dedicated_server
innodb_directories
innodb_fsync_threshold
innodb_idle_flush_pct
innodb_log_checkpoint_fuzzy_now(WITH_DEBUG编译选项下可用)
innodb_log_spin_cpu_abs_lwm
innodb_log_spin_cpu_pct_hwm
innodb_log_wait_for_flush_spin_hwm
innodb_log_writer_threads(8.0.22版本)
innodb_parallel_read_threads
innodb_print_ddl_logs
innodb_redo_log_archive_dirs
innodb_redo_log_encrypt
innodb_spin_wait_pause_multiplier
innodb_stats_include_delete_marked
innodb_temp_tablespaces_dir
innodb_tmpdir
innodb_undo_log_encrypt
innodb_buffer_pool_in_core_file
innodb_doublewrite_batch_size
innodb_doublewrite_dir
innodb_doublewrite_files
innodb_doublewrite_pages
innodb_buffer_pool_debug(WITH_DEBUG编译选项下可用)
innodb_checkpoint_disabled(WITH_DEBUG编译选项下可用)
innodb_ddl_log_crash_reset_debug(WITH_DEBUG编译选项下可用)
状态变量:
Innodb_system_rows_deleted
Innodb_system_rows_inserted
Innodb_system_rows_read
Innodb_undo_tablespaces_active
Innodb_undo_tablespaces_explicit
Innodb_undo_tablespaces_implicit
Innodb_undo_tablespaces_total
3. 克隆功能
配置参数:
clone_autotune_concurrency
clone_buffer_size
clone_ddl_timeout
clone_enable_compression
clone_max_concurrency
clone_max_data_bandwidth
clone_max_network_bandwidth
clone_ssl_ca
clone_ssl_cert
clone_ssl_key
clone_valid_donor_list
状态变量:
Com_clone
4. 组复制
配置参数:
group_replication_autorejoin_tries
group_replication_clone_threshold
group_replication_communication_debug_options
group_replication_communication_max_message_size
group_replication_consistency
group_replication_exit_state_action
group_replication_flow_control_hold_percent
group_replication_flow_control_max_quota
group_replication_flow_control_member_quota_percent
group_replication_flow_control_min_quota
group_replication_flow_control_min_recovery_quota
group_replication_flow_control_period
group_replication_flow_control_release_percent
group_replication_member_expel_timeout
group_replication_member_weight
group_replication_message_cache_size
group_replication_recovery_compression_algorithms
group_replication_recovery_get_public_key
group_replication_recovery_public_key_path
group_replication_recovery_tls_ciphersuites
group_replication_recovery_tls_version
group_replication_recovery_zstd_compression_level
group_replication_unreachable_majority_timeout
5. 角色功能
配置参数:
activate_all_roles_on_login
mandatory_roles
状态变量:
Com_alter_user_default_role
Com_create_role
Com_drop_role
Com_grant_roles
Com_revoke_roles
Com_set_role
6. 资源组
状态变量:
Com_alter_resource_group
Com_create_resource_group
Com_drop_resource_group
Com_set_resource_group
7. CTE
配置参数:
cte_max_recursion_depth
8. 直方图
配置参数:
histogram_generation_max_mem_size
9. 正则表达式
配置参数:
regexp_stack_limit
regexp_time_limit
10. 窗口函数
配置参数:
windowing_use_high_precision
11. 压缩功能:
配置参数:
protocol_compression_algorithms
状态变量:
Compression_algorithm(session级)
Compression_level(session级)
12. 管理端口:
配置参数:
admin_address
admin_port
create_admin_listener_thread
13. caching_sha2_password
配置参数:
caching_sha2_password_auto_generate_rsa_keys
caching_sha2_password_private_key_path
caching_sha2_password_public_key_path
状态变量:
Caching_sha2_password_rsa_public_key
14. Mysqlx
配置参数:
mysqlx
mysqlx_compression_algorithms
mysqlx_deflate_default_compression_level
mysqlx_deflate_max_client_compression_level
mysqlx_interactive_timeout
mysqlx_lz4_default_compression_level
mysqlx_lz4_max_client_compression_level
mysqlx_read_timeout
mysqlx_wait_timeout
mysqlx_write_timeout
mysqlx_zstd_default_compression_level
mysqlx_zstd_max_client_compression_level
状态变量:
Mysqlx_bytes_received_compressed_payload
Mysqlx_bytes_received_uncompressed_frame
Mysqlx_bytes_sent_compressed_payload
Mysqlx_bytes_sent_uncompressed_frame
Mysqlx_compression_algorithm
Mysqlx_compression_level
15. tls
配置参数:
tls_ciphersuites
状态变量:
Current_tls_ca
Current_tls_capath
Current_tls_cert
Current_tls_cipher
Current_tls_ciphersuites
Current_tls_crl
Current_tls_crlpath
Current_tls_key
Current_tls_version
16. Secondary_engine
参数配置:
secondary_engine_cost_threshold(未来使用)
use_secondary_engine(未来使用)
状态变量:
Secondary_engine_execution_count(未来使用
17. 其他
命令行参数:
early-plugin-load
upgrade
validate-config
配置参数:
default_collation_for_utf8mb4
internal_tmp_mem_storage_engine
default_table_encryption
generated_random_password_length
immediate_server_version(session级参数)
information_schema_stats_expiry
log_error_services
log_error_suppression_list
log_slow_extra
original_commit_timestamp(session级参数)
original_server_version(session级参数)
partial_revokes
password_history
password_require_current
password_reuse_interval
performance_schema_max_digest_sample_age
persist_only_admin_x509_subject
persisted_globals_load
print_identified_with_as_hex
require_row_format(session级参数)
resultset_metadata
rpl_read_size
show_create_table_skip_secondary_engine
show_create_table_verbosity
sql_require_primary_key
ssl_fips_mode
table_encryption_privilege_check
temptable_max_ram
temptable_use_mmap
version_compile_zlib
状态变量:
Acl_cache_items_count
Com_install_component
Com_uninstall_component
Com_restart
备注:
企业版审计功能、防火墙、线程池以及一些不常用的插件,比如connection_control、keyring、validate_password等等未进行统计。
参考资料: