MySQL 8.0 新增的配置参数

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等等未进行统计。

发表评论