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等等未进行统计。
参考资料:
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html