MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
This section lists server variables, status variables, and options that were added for the first time, have been deprecated, or have been removed in MySQL 8.0.
The following system variables, status variables, and server options have been added in MySQL 8.0.
Acl_cache_items_count: Number of cached privilege objects. Added in MySQL 8.0.0.Audit_log_current_size: Audit log file current size. Added in MySQL 8.0.11.Audit_log_event_max_drop_size: Size of largest dropped audited event. Added in MySQL 8.0.11.Audit_log_events: Number of handled audited events. Added in MySQL 8.0.11.Audit_log_events_filtered: Number of filtered audited events. Added in MySQL 8.0.11.Audit_log_events_lost: Number of dropped audited events. Added in MySQL 8.0.11.Audit_log_events_written: Number of written audited events. Added in MySQL 8.0.11.Audit_log_total_size: Combined size of written audited events. Added in MySQL 8.0.11.Audit_log_write_waits: Number of write-delayed audited events. Added in MySQL 8.0.11.Authentication_ldap_sasl_supported_methods: Supported authentication methods for SASL LDAP authentication. Added in MySQL 8.0.21.Caching_sha2_password_rsa_public_key: caching_sha2_password authentication plugin RSA public key value. Added in MySQL 8.0.4.Com_alter_resource_group: Count of ALTER RESOURCE GROUP statements. Added in MySQL 8.0.3.Com_alter_user_default_role: Count of ALTER USER ... DEFAULT ROLE statements. Added in MySQL 8.0.0.Com_change_replication_source: Count of CHANGE REPLICATION SOURCE TO and CHANGE MASTER TO statements. Added in MySQL 8.0.23.Com_clone: Count of CLONE statements. Added in MySQL 8.0.2.Com_create_resource_group: Count of CREATE RESOURCE GROUP statements. Added in MySQL 8.0.3.Com_create_role: Count of CREATE ROLE statements. Added in MySQL 8.0.0.Com_drop_resource_group: Count of DROP RESOURCE GROUP statements. Added in MySQL 8.0.3.Com_drop_role: Count of DROP ROLE statements. Added in MySQL 8.0.0.Com_grant_roles: Count of GRANT ROLE statements. Added in MySQL 8.0.0.Com_install_component: Count of INSTALL COMPONENT statements. Added in MySQL 8.0.0.Com_replica_start: Count of START REPLICA and START SLAVE statements. Added in MySQL 8.0.22.Com_replica_stop: Count of STOP REPLICA and STOP SLAVE statements. Added in MySQL 8.0.22.Com_restart: Count of RESTART statements. Added in MySQL 8.0.4.Com_revoke_roles: Count of REVOKE ROLES statements. Added in MySQL 8.0.0.Com_set_resource_group: Count of SET RESOURCE GROUP statements. Added in MySQL 8.0.3.Com_set_role: Count of SET ROLE statements. Added in MySQL 8.0.0.Com_show_replica_status: Count of SHOW REPLICA STATUS and SHOW SLAVE STATUS statements. Added in MySQL 8.0.22.Com_show_replicas: Count of SHOW REPLICAS and SHOW SLAVE HOSTS statements. Added in MySQL 8.0.22.Com_uninstall_component: Count of UINSTALL COMPONENT statements. Added in MySQL 8.0.0.Compression_algorithm: Compression algorithm for current connection. Added in MySQL 8.0.18.Compression_level: Compression level for current connection. Added in MySQL 8.0.18.Connection_control_delay_generated: How many times server delayed connection request. Added in MySQL 8.0.1.Current_tls_ca: Current value of ssl_ca system variable. Added in MySQL 8.0.16.Current_tls_capath: Current value of ssl_capath system variable. Added in MySQL 8.0.16.Current_tls_cert: Current value of ssl_cert system variable. Added in MySQL 8.0.16.Current_tls_cipher: Current value of ssl_cipher system variable. Added in MySQL 8.0.16.Current_tls_ciphersuites: Current value of tsl_ciphersuites system variable. Added in MySQL 8.0.16.Current_tls_crl: Current value of ssl_crl system variable. Added in MySQL 8.0.16.Current_tls_crlpath: Current value of ssl_crlpath system variable. Added in MySQL 8.0.16.Current_tls_key: Current value of ssl_key system variable. Added in MySQL 8.0.16.Current_tls_version: Current value of tls_version system variable. Added in MySQL 8.0.16.Error_log_buffered_bytes: Number of bytes used in error_log table. Added in MySQL 8.0.22.Error_log_buffered_events: Number of events in error_log table. Added in MySQL 8.0.22.Error_log_expired_events: Number of events discarded from error_log table. Added in MySQL 8.0.22.Error_log_latest_write: Time of last write to error_log table. Added in MySQL 8.0.22.Firewall_access_denied: Number of statements rejected by MySQL Enterprise Firewall. Added in MySQL 8.0.11.Firewall_access_granted: Number of statements accepted by MySQL Enterprise Firewall. Added in MySQL 8.0.11.Firewall_cached_entries: Number of statements recorded by MySQL Enterprise Firewall. Added in MySQL 8.0.11.Global_connection_memory: Amount of memory currently used by all user threads. Added in MySQL 8.0.28.Innodb_buffer_pool_resize_status_code: InnoDB buffer pool resize status code. Added in MySQL 8.0.31.Innodb_buffer_pool_resize_status_progress: InnoDB buffer pool resize status progress. Added in MySQL 8.0.31.Innodb_redo_log_capacity_resized: Redo log capacity after the last completed capacity resize operation. Added in MySQL 8.0.30.Innodb_redo_log_checkpoint_lsn: The redo log checkpoint LSN. Added in MySQL 8.0.30.Innodb_redo_log_current_lsn: The redo log current LSN. Added in MySQL 8.0.30.Innodb_redo_log_enabled: InnoDB redo log status. Added in MySQL 8.0.21.Innodb_redo_log_flushed_to_disk_lsn: The red log flushed-to-disk LSN. Added in MySQL 8.0.30.Innodb_redo_log_logical_size: The redo log logical size. Added in MySQL 8.0.30.Innodb_redo_log_physical_size: The redo log physical size. Added in MySQL 8.0.30.Innodb_redo_log_read_only: Whether the redo log is read-only. Added in MySQL 8.0.30.Innodb_redo_log_resize_status: The redo log resize status. Added in MySQL 8.0.30.Innodb_redo_log_uuid: The redo log UUID. Added in MySQL 8.0.30.Innodb_system_rows_deleted: Number of rows deleted from system schema tables. Added in MySQL 8.0.19.Innodb_system_rows_inserted: Number of rows inserted into system schema tables. Added in MySQL 8.0.19.Innodb_system_rows_read: Number of rows read from system schema tables. Added in MySQL 8.0.19.Innodb_system_rows_updated: Number of rows updated in system schema tables. Added in MySQL 8.0.19.Innodb_undo_tablespaces_active: Number of active undo tablespaces. Added in MySQL 8.0.14.Innodb_undo_tablespaces_explicit: Number of user-created undo tablespaces. Added in MySQL 8.0.14.Innodb_undo_tablespaces_implicit: Number of undo tablespaces created by InnoDB. Added in MySQL 8.0.14.Innodb_undo_tablespaces_total: Total number of undo tablespaces. Added in MySQL 8.0.14.Mysqlx_bytes_received_compressed_payload: Number of bytes received as compressed message payloads, measured before decompression. Added in MySQL 8.0.19.Mysqlx_bytes_received_uncompressed_frame: Number of bytes received as compressed message payloads, measured after decompression. Added in MySQL 8.0.19.Mysqlx_bytes_sent_compressed_payload: Number of bytes sent as compressed message payloads, measured after compression. Added in MySQL 8.0.19.Mysqlx_bytes_sent_uncompressed_frame: Number of bytes sent as compressed message payloads, measured before compression. Added in MySQL 8.0.19.Mysqlx_compression_algorithm: Compression algorithm in use for X Protocol connection for this session. Added in MySQL 8.0.20.Mysqlx_compression_level: Compression level in use for X Protocol connection for this session. Added in MySQL 8.0.20.Replica_open_temp_tables: Number of temporary tables that replication SQL thread currently has open. Added in MySQL 8.0.26.Replica_rows_last_search_algorithm_used: Search algorithm most recently used by this replica to locate rows for row-based replication (index, table, or hash scan). Added in MySQL 8.0.26.Resource_group_supported: Whether server supports the resource group feature. Added in MySQL 8.0.31.Rpl_semi_sync_replica_status: Whether semisynchronous replication is operational on replica. Added in MySQL 8.0.26.Rpl_semi_sync_source_clients: Number of semisynchronous replicas. Added in MySQL 8.0.26.Rpl_semi_sync_source_net_avg_wait_time: Average time source has waited for replies from replica. Added in MySQL 8.0.26.Rpl_semi_sync_source_net_wait_time: Total time source has waited for replies from replica. Added in MySQL 8.0.26.Rpl_semi_sync_source_net_waits: Total number of times source waited for replies from replica. Added in MySQL 8.0.26.Rpl_semi_sync_source_no_times: Number of times source turned off semisynchronous replication. Added in MySQL 8.0.26.Rpl_semi_sync_source_no_tx: Number of commits not acknowledged successfully. Added in MySQL 8.0.26.Rpl_semi_sync_source_status: Whether semisynchronous replication is operational on source. Added in MySQL 8.0.26.Rpl_semi_sync_source_timefunc_failures: Number of times source failed when calling time functions. Added in MySQL 8.0.26.Rpl_semi_sync_source_tx_avg_wait_time: Average time source waited for each transaction. Added in MySQL 8.0.26.Rpl_semi_sync_source_tx_wait_time: Total time source waited for transactions. Added in MySQL 8.0.26.Rpl_semi_sync_source_tx_waits: Total number of times source waited for transactions. Added in MySQL 8.0.26.Rpl_semi_sync_source_wait_pos_backtraverse: Total number of times source has waited for event with binary coordinates lower than events waited for previously. Added in MySQL 8.0.26.Rpl_semi_sync_source_wait_sessions: Number of sessions currently waiting for replica replies. Added in MySQL 8.0.26.Rpl_semi_sync_source_yes_tx: Number of commits acknowledged successfully. Added in MySQL 8.0.26.Secondary_engine_execution_count: Number of queries offloaded to a secondary engine. Added in MySQL 8.0.13.Ssl_session_cache_timeout: Current SSL session timeout value in cache. Added in MySQL 8.0.29.Telemetry_traces_supported: Whether server telemetry traces is supported. Added in MySQL 8.0.33.Tls_library_version: Runtime version of OpenSSL library in use. Added in MySQL 8.0.30.activate_all_roles_on_login: Whether to activate all user roles at connect time. Added in MySQL 8.0.2.admin-ssl: Enable connection encryption. Added in MySQL 8.0.21.admin_address: IP address to bind to for connections on administrative interface. Added in MySQL 8.0.14.admin_port: TCP/IP number to use for connections on administrative interface. Added in MySQL 8.0.14.admin_ssl_ca: File that contains list of trusted SSL Certificate Authorities. Added in MySQL 8.0.21.admin_ssl_capath: Directory that contains trusted SSL Certificate Authority certificate files. Added in MySQL 8.0.21.admin_ssl_cert: File that contains X.509 certificate. Added in MySQL 8.0.21.admin_ssl_cipher: Permissible ciphers for connection encryption. Added in MySQL 8.0.21.admin_ssl_crl: File that contains certificate revocation lists. Added in MySQL 8.0.21.admin_ssl_crlpath: Directory that contains certificate revocation list files. Added in MySQL 8.0.21.admin_ssl_key: File that contains X.509 key. Added in MySQL 8.0.21.admin_tls_ciphersuites: Permissible TLSv1.3 ciphersuites for encrypted connections. Added in MySQL 8.0.21.admin_tls_version: Permissible TLS protocols for encrypted connections. Added in MySQL 8.0.21.audit-log: Whether to activate audit log plugin. Added in MySQL 8.0.11.audit_log_buffer_size: Size of audit log buffer. Added in MySQL 8.0.11.audit_log_compression: Audit log file compression method. Added in MySQL 8.0.11.audit_log_connection_policy: Audit logging policy for connection-related events. Added in MySQL 8.0.11.audit_log_current_session: Whether to audit current session. Added in MySQL 8.0.11.audit_log_database: Schema where audit tables are stored. Added in MySQL 8.0.33.audit_log_disable: Whether to disable the audit log. Added in MySQL 8.0.28.audit_log_encryption: Audit log file encryption method. Added in MySQL 8.0.11.audit_log_exclude_accounts: Accounts not to audit. Added in MySQL 8.0.11.audit_log_file: Name of audit log file. Added in MySQL 8.0.11.audit_log_filter_id: ID of current audit log filter. Added in MySQL 8.0.11.audit_log_flush: Close and reopen audit log file. Added in MySQL 8.0.11.audit_log_flush_interval_seconds: Whether to perform a recurring flush of the memory cache. Added in MySQL 8.0.34.audit_log_format: Audit log file format. Added in MySQL 8.0.11.audit_log_format_unix_timestamp: Whether to include Unix timestamp in JSON-format audit log. Added in MySQL 8.0.26.audit_log_include_accounts: Accounts to audit. Added in MySQL 8.0.11.audit_log_max_size: Limit on combined size of JSON audit log files. Added in MySQL 8.0.26.audit_log_password_history_keep_days: Number of days to retain archived audit log encryption passwords. Added in MySQL 8.0.17.audit_log_policy: Audit logging policy. Added in MySQL 8.0.11.audit_log_prune_seconds: The number of seconds after which audit log files become subject to pruning. Added in MySQL 8.0.24.audit_log_read_buffer_size: Audit log file read buffer size. Added in MySQL 8.0.11.audit_log_rotate_on_size: Close and reopen audit log file at this size. Added in MySQL 8.0.11.audit_log_statement_policy: Audit logging policy for statement-related events. Added in MySQL 8.0.11.audit_log_strategy: Audit logging strategy. Added in MySQL 8.0.11.authentication_fido_rp_id: Relying party ID for FIDO multifactor authentication. Added in MySQL 8.0.27.authentication_kerberos_service_key_tab: File containing Kerberos service keys to authenticate TGS ticket. Added in MySQL 8.0.26.authentication_kerberos_service_principal: Kerberos service principal name. Added in MySQL 8.0.26.authentication_ldap_sasl_auth_method_name: Authentication method name. Added in MySQL 8.0.11.authentication_ldap_sasl_bind_base_dn: LDAP server base distinguished name. Added in MySQL 8.0.11.authentication_ldap_sasl_bind_root_dn: LDAP server root distinguished name. Added in MySQL 8.0.11.authentication_ldap_sasl_bind_root_pwd: LDAP server root bind password. Added in MySQL 8.0.11.authentication_ldap_sasl_ca_path: LDAP server certificate authority file name. Added in MySQL 8.0.11.authentication_ldap_sasl_group_search_attr: LDAP server group search attribute. Added in MySQL 8.0.11.authentication_ldap_sasl_group_search_filter: LDAP custom group search filter. Added in MySQL 8.0.11.authentication_ldap_sasl_init_pool_size: LDAP server initial connection pool size. Added in MySQL 8.0.11.authentication_ldap_sasl_log_status: LDAP server log level. Added in MySQL 8.0.11.authentication_ldap_sasl_max_pool_size: LDAP server maximum connection pool size. Added in MySQL 8.0.11.authentication_ldap_sasl_referral: Whether to enable LDAP search referral. Added in MySQL 8.0.20.authentication_ldap_sasl_server_host: LDAP server host name or IP address. Added in MySQL 8.0.11.authentication_ldap_sasl_server_port: LDAP server port number. Added in MySQL 8.0.11.authentication_ldap_sasl_tls: Whether to use encrypted connections to LDAP server. Added in MySQL 8.0.11.authentication_ldap_sasl_user_search_attr: LDAP server user search attribute. Added in MySQL 8.0.11.authentication_ldap_simple_auth_method_name: Authentication method name. Added in MySQL 8.0.11.authentication_ldap_simple_bind_base_dn: LDAP server base distinguished name. Added in MySQL 8.0.11.authentication_ldap_simple_bind_root_dn: LDAP server root distinguished name. Added in MySQL 8.0.11.authentication_ldap_simple_bind_root_pwd: LDAP server root bind password. Added in MySQL 8.0.11.authentication_ldap_simple_ca_path: LDAP server certificate authority file name. Added in MySQL 8.0.11.authentication_ldap_simple_group_search_attr: LDAP server group search attribute. Added in MySQL 8.0.11.authentication_ldap_simple_group_search_filter: LDAP custom group search filter. Added in MySQL 8.0.11.authentication_ldap_simple_init_pool_size: LDAP server initial connection pool size. Added in MySQL 8.0.11.authentication_ldap_simple_log_status: LDAP server log level. Added in MySQL 8.0.11.authentication_ldap_simple_max_pool_size: LDAP server maximum connection pool size. Added in MySQL 8.0.11.authentication_ldap_simple_referral: Whether to enable LDAP search referral. Added in MySQL 8.0.20.authentication_ldap_simple_server_host: LDAP server host name or IP address. Added in MySQL 8.0.11.authentication_ldap_simple_server_port: LDAP server port number. Added in MySQL 8.0.11.authentication_ldap_simple_tls: Whether to use encrypted connections to LDAP server. Added in MySQL 8.0.11.authentication_ldap_simple_user_search_attr: LDAP server user search attribute. Added in MySQL 8.0.11.authentication_policy: Plugins for multifactor authentication; see documentation for syntax. Added in MySQL 8.0.27.authentication_windows_log_level: Windows authentication plugin logging level. Added in MySQL 8.0.11.authentication_windows_use_principal_name: Whether to use Windows authentication plugin principal name. Added in MySQL 8.0.11.binlog_encryption: Enable encryption for binary log files and relay log files on this server. Added in MySQL 8.0.14.binlog_expire_logs_auto_purge: Controls automatic purging of binary log files; can be overridden when enabled, by setting both binlog_expire_logs_seconds and expire_logs_days to 0. Added in MySQL 8.0.29.binlog_expire_logs_seconds: Purge binary logs after this many seconds. Added in MySQL 8.0.1.binlog_rotate_encryption_master_key_at_startup: Rotate binary log master key at server startup. Added in MySQL 8.0.14.binlog_row_metadata: Whether to record all or only minimal table related metadata to binary log when using row-based logging. Added in MySQL 8.0.1.binlog_row_value_options: Enables binary logging of partial JSON updates for row-based replication. Added in MySQL 8.0.3.binlog_transaction_compression: Enable compression for transaction payloads in binary log files. Added in MySQL 8.0.20.binlog_transaction_compression_level_zstd: Compression level for transaction payloads in binary log files. Added in MySQL 8.0.20.binlog_transaction_dependency_history_size: Number of row hashes kept for looking up transaction that last updated some row. Added in MySQL 8.0.1.binlog_transaction_dependency_tracking: Source of dependency information (commit timestamps or transaction write sets) from which to assess which transactions can be executed in parallel by replica's multithreaded applier. Added in MySQL 8.0.1.build_id: A unique build ID generated at compile time (Linux only). Added in MySQL 8.0.31.caching_sha2_password_auto_generate_rsa_keys: Whether to autogenerate RSA key-pair files. Added in MySQL 8.0.4.caching_sha2_password_digest_rounds: Number of hash rounds for caching_sha2_password authentication plugin. Added in MySQL 8.0.24.caching_sha2_password_private_key_path: SHA2 authentication plugin private key path name. Added in MySQL 8.0.3.caching_sha2_password_public_key_path: SHA2 authentication plugin public key path name. Added in MySQL 8.0.3.clone_autotune_concurrency: Enables dynamic spawning of threads for remote cloning operations. Added in MySQL 8.0.17.clone_block_ddl: Enables an exclusive backup lock during clone operations. Added in MySQL 8.0.27.clone_buffer_size: Defines size of intermediate buffer on donor MySQL server instance. Added in MySQL 8.0.17.clone_ddl_timeout: Number of seconds cloning operation waits for backup lock. Added in MySQL 8.0.17.clone_delay_after_data_drop: The time delay in seconds before the clone process starts. Added in MySQL 8.0.29.clone_donor_timeout_after_network_failure: The time allowed to restart a cloning operation after a network failure. Added in MySQL 8.0.24.clone_enable_compression: Enables compression of data at network layer during cloning. Added in MySQL 8.0.17.clone_max_concurrency: Maximum number of concurrent threads used to perform cloning operation. Added in MySQL 8.0.17.clone_max_data_bandwidth: Maximum data transfer rate in MiB per second for remote cloning operation. Added in MySQL 8.0.17.clone_max_network_bandwidth: Maximum network transfer rate in MiB per second for remote cloning operation. Added in MySQL 8.0.17.clone_ssl_ca: Specifies path to certificate authority (CA) file. Added in MySQL 8.0.14.clone_ssl_cert: Specifies path to public key certificate file. Added in MySQL 8.0.14.clone_ssl_key: Specifies path to private key file. Added in MySQL 8.0.14.clone_valid_donor_list: Defines donor host addresses for remote cloning operations. Added in MySQL 8.0.17.component_scheduler.enabled: Whether the scheduler is actively executing tasks. Added in MySQL 8.0.34.connection_control_failed_connections_threshold: Consecutive failed connection attempts before delays occur. Added in MySQL 8.0.1.connection_control_max_connection_delay: Maximum delay (milliseconds) for server response to failed connection attempts. Added in MySQL 8.0.1.connection_control_min_connection_delay: Minimum delay (milliseconds) for server response to failed connection attempts. Added in MySQL 8.0.1.connection_memory_chunk_size: Update Global_connection_memory only when user memory usage changes by this amount or more; 0 disables updating. Added in MySQL 8.0.28.connection_memory_limit: Maximum amount of memory that can be consumed by any one user connection before all queries by this user are rejected. Does not apply to system users such as MySQL root. Added in MySQL 8.0.28.create_admin_listener_thread: Whether to use dedicated listening thread for connections on administrative interface. Added in MySQL 8.0.14.cte_max_recursion_depth: Common table expression maximum recursion depth. Added in MySQL 8.0.3.ddl-rewriter: Whether to activate ddl_rewriter plugin. Added in MySQL 8.0.16.default_collation_for_utf8mb4: Default collation for utf8mb4 character set; for internal use by MySQL Replication only. Added in MySQL 8.0.11.default_table_encryption: Default schema and tablespace encryption setting. Added in MySQL 8.0.16.dragnet.Status: Result of most recent assignment to dragnet.log_error_filter_rules. Added in MySQL 8.0.12.dragnet.log_error_filter_rules: Filter rules for error logging. Added in MySQL 8.0.4.early-plugin-load: Specify plugins to load before loading mandatory built-in plugins and before storage engine initialization. Added in MySQL 8.0.0.enterprise_encryption.maximum_rsa_key_size: Maximum size of RSA keys generated by MySQL Enterprise Encryption. Added in MySQL 8.0.30.enterprise_encryption.rsa_support_legacy_padding: Decrypt and verify legacy MySQL Enterprise Encryption content. Added in MySQL 8.0.30.explain_format: Determines default output format used by EXPLAIN statements. Added in MySQL 8.0.32.generated_random_password_length: Maximum length of generated passwords. Added in MySQL 8.0.18.global_connection_memory_limit: Maximum total amount of memory that can be consumed by all user connections. When exceeded by Global_connection_memory, all queries from regular users are rejected. Does not apply to system users such as MySQL root. Added in MySQL 8.0.28.global_connection_memory_tracking: Whether or not to calculate global connection memory usage (as shown by Global_connection_memory); default is disabled. Added in MySQL 8.0.28.group_replication_advertise_recovery_endpoints: Connections offered for distributed recovery. Added in MySQL 8.0.21.group_replication_autorejoin_tries: Number of tries that member makes to rejoin group automatically. Added in MySQL 8.0.16.group_replication_clone_threshold: Transaction number gap between donor and recipient above which remote cloning operation is used for state transfer. Added in MySQL 8.0.17.group_replication_communication_debug_options: Level of debugging messages for Group Replication components. Added in MySQL 8.0.3.group_replication_communication_max_message_size: Maximum message size for Group Replication communications, larger messages are fragmented. Added in MySQL 8.0.16.group_replication_communication_stack: Specifies which communication stack (XCom or MySQL) should be used to establish group communication connections between members. Added in MySQL 8.0.27.group_replication_consistency: Type of transaction consistency guarantee which group provides. Added in MySQL 8.0.14.group_replication_exit_state_action: How instance behaves when it leaves group involuntarily. Added in MySQL 8.0.12.group_replication_flow_control_hold_percent: Percentage of group quota to remain unused. Added in MySQL 8.0.2.group_replication_flow_control_max_quota: Maximum flow control quota for group. Added in MySQL 8.0.2.group_replication_flow_control_member_quota_percent: Percentage of quota which member should assume is available for itself when calculating quotas. Added in MySQL 8.0.2.group_replication_flow_control_min_quota: Lowest flow control quota which can be assigned per member. Added in MySQL 8.0.2.group_replication_flow_control_min_recovery_quota: Lowest quota which can be assigned per member because another group member is recovering. Added in MySQL 8.0.2.group_replication_flow_control_period: Defines how many seconds to wait between flow control iterations. Added in MySQL 8.0.2.group_replication_flow_control_release_percent: How group quota should be released when flow control no longer needs to throttle writer members. Added in MySQL 8.0.2.group_replication_ip_allowlist: List of hosts permitted to connect to group (MySQL 8.0.22 and later). Added in MySQL 8.0.22.group_replication_member_expel_timeout: Time between suspected failure of group member and expelling it from group, causing group membership reconfiguration. Added in MySQL 8.0.13.group_replication_member_weight: Chance of this member being elected as primary. Added in MySQL 8.0.2.group_replication_message_cache_size: Maximum memory for group communication engine message cache (XCom). Added in MySQL 8.0.16.group_replication_paxos_single_leader: Use a single consensus leader in single-primary mode. Added in MySQL 8.0.27.group_replication_recovery_compression_algorithms: Permitted compression algorithms for outgoing recovery connections. Added in MySQL 8.0.18.group_replication_recovery_get_public_key: Whether to accept preference about fetching public key from donor. Added in MySQL 8.0.4.group_replication_recovery_public_key_path: To accept public key information. Added in MySQL 8.0.4.group_replication_recovery_tls_ciphersuites: Permitted cipher suites when TLSv1.3 is used for connection encryption with this instance as client (joining member). Added in MySQL 8.0.19.group_replication_recovery_tls_version: Permitted TLS protocols for connection encryption as client (joining member). Added in MySQL 8.0.19.group_replication_recovery_zstd_compression_level: Compression level for recovery connections that use zstd compression. Added in MySQL 8.0.18.group_replication_tls_source: Source of TLS material for Group Replication. Added in MySQL 8.0.21.group_replication_unreachable_majority_timeout: How long to wait for network partitions that result in minority to leave group. Added in MySQL 8.0.2.group_replication_view_change_uuid: UUID for view change event GTIDs. Added in MySQL 8.0.26.histogram_generation_max_mem_size: Maximum memory for creating histogram statistics. Added in MySQL 8.0.2.immediate_server_version: MySQL Server release number of server which is immediate replication source. Added in MySQL 8.0.14.information_schema_stats_expiry: Expiration setting for cached table statistics. Added in MySQL 8.0.3.init_replica: Statements that are executed when replica connects to source. Added in MySQL 8.0.26.innodb-dedicated-server: Enables automatic configuration of buffer pool size, log file size, and flush method. Added in MySQL 8.0.3.innodb_buffer_pool_debug: Permits multiple buffer pool instances when buffer pool is less than 1GB in size. Added in MySQL 8.0.0.innodb_buffer_pool_in_core_file: Controls writing of buffer pool pages to core files, defaults to OFF (as of 8.4) on systems that support MADV_DONTDUMP. Added in MySQL 8.0.14.innodb_checkpoint_disabled: Disables checkpoints so that deliberate server exit always initiates recovery. Added in MySQL 8.0.2.innodb_ddl_buffer_size: The maximum buffer size for DDL operations. Added in MySQL 8.0.27.innodb_ddl_log_crash_reset_debug: Debug option that resets DDL log crash injection counters. Added in MySQL 8.0.3.innodb_ddl_threads: The maximum number of parallel threads for index creation. Added in MySQL 8.0.27.innodb_deadlock_detect: Enables or disables deadlock detection. Added in MySQL 8.0.0.innodb_directories: Defines directories to scan at startup for tablespace data files. Added in MySQL 8.0.4.innodb_doublewrite_batch_size: This functionality was replaced by innodb_doublewrite_pages. Added in MySQL 8.0.20.innodb_doublewrite_dir: Doublewrite buffer file directory. Added in MySQL 8.0.20.innodb_doublewrite_files: Number of doublewrite files. Added in MySQL 8.0.20.innodb_doublewrite_pages: Number of doublewrite pages per thread. Added in MySQL 8.0.20.innodb_extend_and_initialize: Controls how new tablespace pages are allocated on Linux. Added in MySQL 8.0.22.innodb_fsync_threshold: Controls how often InnoDB calls fsync when creating new file. Added in MySQL 8.0.13.innodb_idle_flush_pct: Limits I/0 operations when InnoDB is idle. Added in MySQL 8.0.18.innodb_log_checkpoint_fuzzy_now: Debug option that forces InnoDB to write fuzzy checkpoint. Added in MySQL 8.0.13.innodb_log_spin_cpu_abs_lwm: Minimum amount of CPU usage below which user threads no longer spin while waiting for flushed redo. Added in MySQL 8.0.11.innodb_log_spin_cpu_pct_hwm: Maximum amount of CPU usage above which user threads no longer spin while waiting for flushed redo. Added in MySQL 8.0.11.innodb_log_wait_for_flush_spin_hwm: Maximum average log flush time beyond which user threads no longer spin while waiting for flushed redo. Added in MySQL 8.0.11.innodb_log_writer_threads: Enables dedicated log writer threads for writing and flushing redo logs. Added in MySQL 8.0.22.innodb_parallel_read_threads: Number of threads for parallel index reads. Added in MySQL 8.0.14.innodb_print_ddl_logs: Whether or not to print DDL logs to error log. Added in MySQL 8.0.3.innodb_redo_log_archive_dirs: Labeled redo log archive directories. Added in MySQL 8.0.17.innodb_redo_log_capacity: The size limit for redo log files. Added in MySQL 8.0.30.innodb_redo_log_encrypt: Controls encryption of redo log data for encrypted tablespaces. Added in MySQL 8.0.1.innodb_scan_directories: Defines directories to scan for tablespace files during InnoDB recovery. Added in MySQL 8.0.2.innodb_segment_reserve_factor: The percentage of tablespace file segment pages reserved as empty pages. Added in MySQL 8.0.26.innodb_spin_wait_pause_multiplier: Multiplier value used to determine number of PAUSE instructions in spin-wait loops. Added in MySQL 8.0.16.innodb_stats_include_delete_marked: Include delete-marked records when calculating persistent InnoDB statistics. Added in MySQL 8.0.1.innodb_temp_tablespaces_dir: Session temporary tablespaces path. Added in MySQL 8.0.13.innodb_tmpdir: Directory location for temporary table files created during online ALTER TABLE operations. Added in MySQL 8.0.0.innodb_undo_log_encrypt: Controls encryption of undo log data for encrypted tablespaces. Added in MySQL 8.0.1.innodb_use_fdatasync: Whether InnoDB uses fdatasync() instead of fsync() when flushing data to the operating system. Added in MySQL 8.0.26.innodb_validate_tablespace_paths: Enables tablespace path validation at startup. Added in MySQL 8.0.21.internal_tmp_mem_storage_engine: Storage engine to use for internal in-memory temporary tables. Added in MySQL 8.0.2.keyring-migration-destination: Key migration destination keyring plugin. Added in MySQL 8.0.4.keyring-migration-host: Host name for connecting to running server for key migration. Added in MySQL 8.0.4.keyring-migration-password: Password for connecting to running server for key migration. Added in MySQL 8.0.4.keyring-migration-port: TCP/IP port number for connecting to running server for key migration. Added in MySQL 8.0.4.keyring-migration-socket: Unix socket file or Windows named pipe for connecting to running server for key migration. Added in MySQL 8.0.4.keyring-migration-source: Key migration source keyring plugin. Added in MySQL 8.0.4.keyring-migration-to-component: Keyring migration is from plugin to component. Added in MySQL 8.0.24.keyring-migration-user: User name for connecting to running server for key migration. Added in MySQL 8.0.4.keyring_aws_cmk_id: AWS keyring plugin customer master key ID value. Added in MySQL 8.0.11.keyring_aws_conf_file: AWS keyring plugin configuration file location. Added in MySQL 8.0.11.keyring_aws_data_file: AWS keyring plugin storage file location. Added in MySQL 8.0.11.keyring_aws_region: AWS keyring plugin region. Added in MySQL 8.0.11.keyring_encrypted_file_data: keyring_encrypted_file plugin data file. Added in MySQL 8.0.11.keyring_encrypted_file_password: keyring_encrypted_file plugin password. Added in MySQL 8.0.11.keyring_hashicorp_auth_path: HashiCorp Vault AppRole authentication path. Added in MySQL 8.0.18.keyring_hashicorp_ca_path: Path to keyring_hashicorp CA file. Added in MySQL 8.0.18.keyring_hashicorp_caching: Whether to enable keyring_hashicorp caching. Added in MySQL 8.0.18.keyring_hashicorp_commit_auth_path: keyring_hashicorp_auth_path value in use. Added in MySQL 8.0.18.keyring_hashicorp_commit_ca_path: keyring_hashicorp_ca_path value in use. Added in MySQL 8.0.18.keyring_hashicorp_commit_caching: keyring_hashicorp_caching value in use. Added in MySQL 8.0.18.keyring_hashicorp_commit_role_id: keyring_hashicorp_role_id value in use. Added in MySQL 8.0.18.keyring_hashicorp_commit_server_url: keyring_hashicorp_server_url value in use. Added in MySQL 8.0.18.keyring_hashicorp_commit_store_path: keyring_hashicorp_store_path value in use. Added in MySQL 8.0.18.keyring_hashicorp_role_id: HashiCorp Vault AppRole authentication role ID. Added in MySQL 8.0.18.keyring_hashicorp_secret_id: HashiCorp Vault AppRole authentication secret ID. Added in MySQL 8.0.18.keyring_hashicorp_server_url: HashiCorp Vault server URL. Added in MySQL 8.0.18.keyring_hashicorp_store_path: HashiCorp Vault store path. Added in MySQL 8.0.18.keyring_oci_ca_certificate: CA certificate file for peer authentication. Added in MySQL 8.0.22.keyring_oci_compartment: OCI compartment OCID. Added in MySQL 8.0.22.keyring_oci_encryption_endpoint: OCI encryption server endpoint. Added in MySQL 8.0.22.keyring_oci_key_file: OCI RSA private key file. Added in MySQL 8.0.22.keyring_oci_key_fingerprint: OCI RSA private key file fingerprint. Added in MySQL 8.0.22.keyring_oci_management_endpoint: OCI management server endpoint. Added in MySQL 8.0.22.keyring_oci_master_key: OCI master key OCID. Added in MySQL 8.0.22.keyring_oci_secrets_endpoint: OCI secrets server endpoint. Added in MySQL 8.0.22.keyring_oci_tenancy: OCI tenancy OCID. Added in MySQL 8.0.22.keyring_oci_user: OCI user OCID. Added in MySQL 8.0.22.keyring_oci_vaults_endpoint: OCI vaults server endpoint. Added in MySQL 8.0.22.keyring_oci_virtual_vault: OCI vault OCID. Added in MySQL 8.0.22.keyring_okv_conf_dir: Oracle Key Vault keyring plugin configuration directory. Added in MySQL 8.0.11.keyring_operations: Whether keyring operations are enabled. Added in MySQL 8.0.4.lock_order: Whether to enable LOCK_ORDER tool at runtime. Added in MySQL 8.0.17.lock_order_debug_loop: Whether to cause debug assert when LOCK_ORDER tool encounters dependency flagged as loop. Added in MySQL 8.0.17.lock_order_debug_missing_arc: Whether to cause debug assert when LOCK_ORDER tool encounters undeclared dependency. Added in MySQL 8.0.17.lock_order_debug_missing_key: Whether to cause debug assert when LOCK_ORDER tool encounters object not properly instrumented with Performance Schema. Added in MySQL 8.0.17.lock_order_debug_missing_unlock: Whether to cause debug assert when LOCK_ORDER tool encounters lock that is destroyed while still held. Added in MySQL 8.0.17.lock_order_dependencies: Path to lock_order_dependencies.txt file. Added in MySQL 8.0.17.lock_order_extra_dependencies: Path to second dependency file. Added in MySQL 8.0.17.lock_order_output_directory: Directory where LOCK_ORDER tool writes logs. Added in MySQL 8.0.17.lock_order_print_txt: Whether to perform lock-order graph analysis and print textual report. Added in MySQL 8.0.17.lock_order_trace_loop: Whether to print log file trace when LOCK_ORDER tool encounters dependency flagged as loop. Added in MySQL 8.0.17.lock_order_trace_missing_arc: Whether to print log file trace when LOCK_ORDER tool encounters undeclared dependency. Added in MySQL 8.0.17.lock_order_trace_missing_key: Whether to print log file trace when LOCK_ORDER tool encounters object not properly instrumented with Performance Schema. Added in MySQL 8.0.17.lock_order_trace_missing_unlock: Whether to print log file trace when LOCK_ORDER tool encounters lock that is destroyed while still held. Added in MySQL 8.0.17.log_error_filter_rules: Filter rules for error logging. Added in MySQL 8.0.2.log_error_services: Components to use for error logging. Added in MySQL 8.0.2.log_error_suppression_list: Warning/information error log messages to suppress. Added in MySQL 8.0.13.log_replica_updates: Whether replica should log updates performed by its replication SQL thread to its own binary log. Added in MySQL 8.0.26.log_slow_extra: Whether to write extra information to slow query log file. Added in MySQL 8.0.14.log_slow_replica_statements: Cause slow statements as executed by replica to be written to slow query log. Added in MySQL 8.0.26.mandatory_roles: Automatically granted roles for all users. Added in MySQL 8.0.2.mysql_firewall_mode: Whether MySQL Enterprise Firewall is operational. Added in MySQL 8.0.11.mysql_firewall_trace: Whether to enable firewall trace. Added in MySQL 8.0.11.mysqlx: Whether X Plugin is initialized. Added in MySQL 8.0.11.mysqlx_compression_algorithms: Compression algorithms permitted for X Protocol connections. Added in MySQL 8.0.19.mysqlx_deflate_default_compression_level: Default compression level for Deflate algorithm on X Protocol connections. Added in MySQL 8.0.20.mysqlx_deflate_max_client_compression_level: Maximum permitted compression level for Deflate algorithm on X Protocol connections. Added in MySQL 8.0.20.mysqlx_interactive_timeout: Number of seconds to wait for interactive clients to time out. Added in MySQL 8.0.4.mysqlx_lz4_default_compression_level: Default compression level for LZ4 algorithm on X Protocol connections. Added in MySQL 8.0.20.mysqlx_lz4_max_client_compression_level: Maximum permitted compression level for LZ4 algorithm on X Protocol connections. Added in MySQL 8.0.20.mysqlx_read_timeout: Number of seconds to wait for blocking read operations to complete. Added in MySQL 8.0.4.mysqlx_wait_timeout: Number of seconds to wait for activity from connection. Added in MySQL 8.0.4.mysqlx_write_timeout: Number of seconds to wait for blocking write operations to complete. Added in MySQL 8.0.4.mysqlx_zstd_default_compression_level: Default compression level for zstd algorithm on X Protocol connections. Added in MySQL 8.0.20.mysqlx_zstd_max_client_compression_level: Maximum permitted compression level for zstd algorithm on X Protocol connections. Added in MySQL 8.0.20.named_pipe_full_access_group: Name of Windows group granted full access to named pipe. Added in MySQL 8.0.14.no-dd-upgrade: Prevent automatic upgrade of data dictionary tables at startup. Added in MySQL 8.0.4.no-monitor: Do not fork monitor process required for RESTART. Added in MySQL 8.0.12.original_commit_timestamp: Time when transaction was committed on original source. Added in MySQL 8.0.1.original_server_version: MySQL Server release number of server on which transaction was originally committed. Added in MySQL 8.0.14.partial_revokes: Whether partial revocation is enabled. Added in MySQL 8.0.16.password_history: Number of password changes required before password reuse. Added in MySQL 8.0.3.password_require_current: Whether password changes require current password verification. Added in MySQL 8.0.13.password_reuse_interval: Number of days elapsed required before password reuse. Added in MySQL 8.0.3.performance-schema-consumer-events-statements-cpu: Configure statement CPU-usage consumer. Added in MySQL 8.0.28.performance_schema_max_digest_sample_age: Query resample age in seconds. Added in MySQL 8.0.3.performance_schema_show_processlist: Select SHOW PROCESSLIST implementation. Added in MySQL 8.0.22.persist_only_admin_x509_subject: SSL certificate X.509 Subject that enables persisting persist-restricted system variables. Added in MySQL 8.0.14.persist_sensitive_variables_in_plaintext: Whether the server is permitted to store the values of sensitive system variables in an unencrypted format. Added in MySQL 8.0.29.persisted_globals_load: Whether to load persisted configuration settings. Added in MySQL 8.0.0.print_identified_with_as_hex: For SHOW CREATE USER, print hash values containing unprintable characters in hex. Added in MySQL 8.0.17.protocol_compression_algorithms: Permitted compression algorithms for incoming connections. Added in MySQL 8.0.18.pseudo_replica_mode: For internal server use. Added in MySQL 8.0.26.regexp_stack_limit: Regular expression match stack size limit. Added in MySQL 8.0.4.regexp_time_limit: Regular expression match timeout. Added in MySQL 8.0.4.replica_checkpoint_group: Maximum number of transactions processed by multithreaded replica before checkpoint operation is called to update progress status. Not supported by NDB Cluster. Added in MySQL 8.0.26.replica_checkpoint_period: Update progress status of multithreaded replica and flush relay log info to disk after this number of milliseconds. Not supported by NDB Cluster. Added in MySQL 8.0.26.replica_compressed_protocol: Use compression of source/replica protocol. Added in MySQL 8.0.26.replica_exec_mode: Allows for switching replication thread between IDEMPOTENT mode (key and some other errors suppressed) and STRICT mode; STRICT mode is default, except for NDB Cluster, where IDEMPOTENT is always used. Added in MySQL 8.0.26.replica_load_tmpdir: Location where replica should put its temporary files when replicating LOAD DATA statements. Added in MySQL 8.0.26.replica_max_allowed_packet: Maximum size, in bytes, of packet that can be sent from replication source server to replica; overrides max_allowed_packet. Added in MySQL 8.0.26.replica_net_timeout: Number of seconds to wait for more data from source/replica connection before aborting read. Added in MySQL 8.0.26.replica_parallel_type: Tells replica to use timestamp information (LOGICAL_CLOCK) or database partitioning (DATABASE) to parallelize transactions. Added in MySQL 8.0.26.replica_parallel_workers: Number of applier threads for executing replication transactions; when this is 0 or 1, there is only one applier thread. NDB Cluster: see documentation. Added in MySQL 8.0.26.replica_pending_jobs_size_max: Maximum size of replica worker queues holding events not yet applied. Added in MySQL 8.0.26.replica_preserve_commit_order: Ensures that all commits by replica workers happen in same order as on source to maintain consistency when using parallel applier threads. Added in MySQL 8.0.26.replica_skip_errors: Tells replication thread to continue replication when query returns error from provided list. Added in MySQL 8.0.26.replica_sql_verify_checksum: Cause replica to examine checksums when reading from relay log. Added in MySQL 8.0.26.replica_transaction_retries: Number of times replication SQL thread retries transaction in case it failed with deadlock or elapsed lock wait timeout, before giving up and stopping. Added in MySQL 8.0.26.replica_type_conversions: Controls type conversion mode on replica. Value is list of zero or more elements from this list: ALL_LOSSY, ALL_NON_LOSSY. Set to empty string to disallow type conversions between source and replica. Added in MySQL 8.0.26.replication_optimize_for_static_plugin_config: Shared locks for semisynchronous replication. Added in MySQL 8.0.23.replication_sender_observe_commit_only: Limited callbacks for semisynchronous replication. Added in MySQL 8.0.23.require_row_format: For internal server use. Added in MySQL 8.0.19.resultset_metadata: Whether server returns result set metadata. Added in MySQL 8.0.3.rewriter_enabled_for_threads_without_privilege_checks: If this is set to OFF, rewrites are skipped for replication threads which execute with privilege checks disabled (PRIVILEGE_CHECKS_USER is NULL). Added in MySQL 8.0.31.rpl_read_size: Set minimum amount of data in bytes which is read from binary log files and relay log files. Added in MySQL 8.0.11.rpl_semi_sync_replica_enabled: Whether semisynchronous replication is enabled on replica. Added in MySQL 8.0.26.rpl_semi_sync_replica_trace_level: Semisynchronous replication debug trace level on replica. Added in MySQL 8.0.26.rpl_semi_sync_source_enabled: Whether semisynchronous replication is enabled on source. Added in MySQL 8.0.26.rpl_semi_sync_source_timeout: Number of milliseconds to wait for replica acknowledgment. Added in MySQL 8.0.26.rpl_semi_sync_source_trace_level: Semisynchronous replication debug trace level on source. Added in MySQL 8.0.26.rpl_semi_sync_source_wait_for_replica_count: Number of replica acknowledgments source must receive per transaction before proceeding. Added in MySQL 8.0.26.rpl_semi_sync_source_wait_no_replica: Whether source waits for timeout even with no replicas. Added in MySQL 8.0.26.rpl_semi_sync_source_wait_point: Wait point for replica transaction receipt acknowledgment. Added in MySQL 8.0.26.rpl_stop_replica_timeout: Number of seconds that STOP REPLICA waits before timing out. Added in MySQL 8.0.26.schema_definition_cache: Number of schema definition objects that can be kept in dictionary object cache. Added in MySQL 8.0.0.secondary_engine_cost_threshold: Optimizer cost threshold for query offload to a secondary engine. Added in MySQL 8.0.16.select_into_buffer_size: Size of buffer used for OUTFILE or DUMPFILE export file; overrides read_buffer_size. Added in MySQL 8.0.22.select_into_disk_sync: Synchronize data with storage device after flushing buffer for OUTFILE or DUMPFILE export file; OFF disables synchronization and is default value. Added in MySQL 8.0.22.select_into_disk_sync_delay: When select_into_sync_disk = ON, sets delay in milliseconds after each synchronization of OUTFILE or DUMPFILE export file buffer, no effect otherwise. Added in MySQL 8.0.22.show-replica-auth-info: Show user name and password in SHOW REPLICAS on this source. Added in MySQL 8.0.26.show_create_table_skip_secondary_engine: Whether to exclude the SECONDARY ENGINE clause from SHOW CREATE TABLE output. Added in MySQL 8.0.18.show_create_table_verbosity: Whether to display ROW_FORMAT in SHOW CREATE TABLE even if it has default value. Added in MySQL 8.0.11.show_gipk_in_create_table_and_information_schema: Whether generated invisible primary keys are displayed in SHOW statements and INFORMATION_SCHEMA tables. Added in MySQL 8.0.30.skip-replica-start: If set, replication is not autostarted when replica server starts. Added in MySQL 8.0.26.source_verify_checksum: Cause source to examine checksums when reading from binary log. Added in MySQL 8.0.26.sql_generate_invisible_primary_key: Whether to generate invisible primary keys for any InnoDB tables which were created on this server and which have no explicit PKs. Added in MySQL 8.0.30.sql_replica_skip_counter: Number of events from source that replica should skip. Not compatible with GTID replication. Added in MySQL 8.0.26.sql_require_primary_key: Whether tables must have primary key. Added in MySQL 8.0.13.ssl_fips_mode: Whether to enable FIPS mode on server side. Added in MySQL 8.0.11.ssl_session_cache_mode: Whether to enable session ticket generation by server. Added in MySQL 8.0.29.ssl_session_cache_timeout: SSL Session timeout value in seconds. Added in MySQL 8.0.29.sync_source_info: Synchronize source information after every #th event. Added in MySQL 8.0.26.syseventlog.facility: Facility for syslog messages. Added in MySQL 8.0.13.syseventlog.include_pid: Whether to include server PID in syslog messages. Added in MySQL 8.0.13.syseventlog.tag: Tag for server identifier in syslog messages. Added in MySQL 8.0.13.table_encryption_privilege_check: Enables TABLE_ENCRYPTION_ADMIN privilege check. Added in MySQL 8.0.16.tablespace_definition_cache: Number of tablespace definition objects that can be kept in dictionary object cache. Added in MySQL 8.0.0.temptable_max_mmap: The maximum amount of memory the TempTable storage engine can allocate from memory-mapped temporary files. Added in MySQL 8.0.23.temptable_max_ram: Defines maximum amount of memory that can occupied by TempTable storage engine before data is stored on disk. Added in MySQL 8.0.2.temptable_use_mmap: Defines whether TempTable storage engine allocates memory-mapped files when the temptable_max_ram threshold is reached. Added in MySQL 8.0.16.terminology_use_previous: Use terminology from before specified version where changes are incompatible. Added in MySQL 8.0.26.thread_pool_algorithm: Thread pool algorithm. Added in MySQL 8.0.11.thread_pool_dedicated_listeners: Dedicates a listener thread in each thread group to listen for network events. Added in MySQL 8.0.23.thread_pool_high_priority_connection: Whether current session is high priority. Added in MySQL 8.0.11.thread_pool_max_active_query_threads: Maximum permissible number of active query threads per group. Added in MySQL 8.0.19.thread_pool_max_transactions_limit: Maximum number of transactions permitted during thread pool operation. Added in MySQL 8.0.23.thread_pool_max_unused_threads: Maximum permissible number of unused threads. Added in MySQL 8.0.11.thread_pool_prio_kickup_timer: How long before statement is moved to high-priority execution. Added in MySQL 8.0.11.thread_pool_query_threads_per_group: Maximum number of query threads for a thread group. Added in MySQL 8.0.31.thread_pool_size: Number of thread groups in thread pool. Added in MySQL 8.0.11.thread_pool_stall_limit: How long before statement is defined as stalled. Added in MySQL 8.0.11.thread_pool_transaction_delay: Delay period before thread pool executes a new transaction. Added in MySQL 8.0.31.tls_ciphersuites: Permissible TLSv1.3 ciphersuites for encrypted connections. Added in MySQL 8.0.16.upgrade: Control automatic upgrade at startup. Added in MySQL 8.0.16.use_secondary_engine: Whether to execute queries using a secondary engine. Added in MySQL 8.0.13.validate-config: Validate server configuration. Added in MySQL 8.0.16.validate_password.changed_characters_percentage: Minimum percentage of changed characters required for new passwords. Added in MySQL 8.0.34.validate_password.check_user_name: Whether to check passwords against user name. Added in MySQL 8.0.4.validate_password.dictionary_file: validate_password dictionary file. Added in MySQL 8.0.4.validate_password.dictionary_file_last_parsed: When dictionary file was last parsed. Added in MySQL 8.0.4.validate_password.dictionary_file_words_count: Number of words in dictionary file. Added in MySQL 8.0.4.validate_password.length: validate_password required password length. Added in MySQL 8.0.4.validate_password.mixed_case_count: validate_password required number of uppercase/lowercase characters. Added in MySQL 8.0.4.validate_password.number_count: validate_password required number of digit characters. Added in MySQL 8.0.4.validate_password.policy: validate_password password policy. Added in MySQL 8.0.4.validate_password.special_char_count: validate_password required number of special characters. Added in MySQL 8.0.4.version_compile_zlib: Version of compiled-in zlib library. Added in MySQL 8.0.11.windowing_use_high_precision: Whether to compute window functions to high precision. Added in MySQL 8.0.2.
The following system variables, status variables, and options have been deprecated in MySQL 8.0.
Compression: Whether client connection uses compression in client/server protocol. Deprecated in MySQL 8.0.18.Rsa_public_key: sha256_password authentication plugin RSA public key value. Deprecated in MySQL 8.0.16.Slave_open_temp_tables: Number of temporary tables that replication SQL thread currently has open. Deprecated in MySQL 8.0.26.Slave_rows_last_search_algorithm_used: Search algorithm most recently used by this replica to locate rows for row-based replication (index, table, or hash scan). Deprecated in MySQL 8.0.26.abort-slave-event-count: Option used by mysql-test for debugging and testing of replication. Deprecated in MySQL 8.0.29.admin-ssl: Enable connection encryption. Deprecated in MySQL 8.0.26.audit_log_connection_policy: Audit logging policy for connection-related events. Deprecated in MySQL 8.0.34.audit_log_exclude_accounts: Accounts not to audit. Deprecated in MySQL 8.0.34.audit_log_include_accounts: Accounts to audit. Deprecated in MySQL 8.0.34.audit_log_policy: Audit logging policy. Deprecated in MySQL 8.0.34.audit_log_statement_policy: Audit logging policy for statement-related events. Deprecated in MySQL 8.0.34.authentication_fido_rp_id: Relying party ID for FIDO multifactor authentication. Deprecated in MySQL 8.0.35.binlog_format: Specifies format of binary log. Deprecated in MySQL 8.0.34.binlog_transaction_dependency_tracking: Source of dependency information (commit timestamps or transaction write sets) from which to assess which transactions can be executed in parallel by replica's multithreaded applier. Deprecated in MySQL 8.0.35.character-set-client-handshake: Do not ignore client side character set value sent during handshake. Deprecated in MySQL 8.0.35.daemon_memcached_enable_binlog: . Deprecated in MySQL 8.0.22.daemon_memcached_engine_lib_name: Shared library implementing InnoDB memcached plugin. Deprecated in MySQL 8.0.22.daemon_memcached_engine_lib_path: Directory which contains shared library implementing InnoDB memcached plugin. Deprecated in MySQL 8.0.22.daemon_memcached_option: Space-separated options which are passed to underlying memcached daemon on startup. Deprecated in MySQL 8.0.22.daemon_memcached_r_batch_size: Specifies how many memcached read operations to perform before doing COMMIT to start new transaction. Deprecated in MySQL 8.0.22.daemon_memcached_w_batch_size: Specifies how many memcached write operations to perform before doing COMMIT to start new transaction. Deprecated in MySQL 8.0.22.default_authentication_plugin: Default authentication plugin. Deprecated in MySQL 8.0.27.disconnect-slave-event-count: Option used by mysql-test for debugging and testing of replication. Deprecated in MySQL 8.0.29.expire_logs_days: Purge binary logs after this many days. Deprecated in MySQL 8.0.3.group_replication_ip_whitelist: List of hosts permitted to connect to group. Deprecated in MySQL 8.0.22.group_replication_primary_member: Primary member UUID when group operates in single-primary mode. Empty string if group is operating in multi-primary mode. Deprecated in MySQL 8.0.4.group_replication_recovery_complete_at: Recovery policies when handling cached transactions after state transfer. Deprecated in MySQL 8.0.34.have_openssl: Whether mysqld supports SSL connections. Deprecated in MySQL 8.0.26.have_ssl: Whether mysqld supports SSL connections. Deprecated in MySQL 8.0.26.init_slave: Statements that are executed when replica connects to source. Deprecated in MySQL 8.0.26.innodb_api_bk_commit_interval: How often to auto-commit idle connections which use InnoDB memcached interface, in seconds. Deprecated in MySQL 8.0.22.innodb_api_disable_rowlock: . Deprecated in MySQL 8.0.22.innodb_api_enable_binlog: Allows use of InnoDB memcached plugin with MySQL binary log. Deprecated in MySQL 8.0.22.innodb_api_enable_mdl: Locks table used by InnoDB memcached plugin, so that it cannot be dropped or altered by DDL through SQL interface. Deprecated in MySQL 8.0.22.innodb_api_trx_level: Allows control of transaction isolation level on queries processed by memcached interface. Deprecated in MySQL 8.0.22.innodb_log_file_size: Size of each log file in log group. Deprecated in MySQL 8.0.30.innodb_log_files_in_group: Number of InnoDB log files in log group. Deprecated in MySQL 8.0.30.innodb_undo_tablespaces: Number of tablespace files that rollback segments are divided between. Deprecated in MySQL 8.0.4.keyring_encrypted_file_data: keyring_encrypted_file plugin data file. Deprecated in MySQL 8.0.34.keyring_encrypted_file_password: keyring_encrypted_file plugin password. Deprecated in MySQL 8.0.34.keyring_file_data: keyring_file plugin data file. Deprecated in MySQL 8.0.34.keyring_oci_ca_certificate: CA certificate file for peer authentication. Deprecated in MySQL 8.0.31.keyring_oci_compartment: OCI compartment OCID. Deprecated in MySQL 8.0.31.keyring_oci_encryption_endpoint: OCI encryption server endpoint. Deprecated in MySQL 8.0.31.keyring_oci_key_file: OCI RSA private key file. Deprecated in MySQL 8.0.31.keyring_oci_key_fingerprint: OCI RSA private key file fingerprint. Deprecated in MySQL 8.0.31.keyring_oci_management_endpoint: OCI management server endpoint. Deprecated in MySQL 8.0.31.keyring_oci_master_key: OCI master key OCID. Deprecated in MySQL 8.0.31.keyring_oci_secrets_endpoint: OCI secrets server endpoint. Deprecated in MySQL 8.0.31.keyring_oci_tenancy: OCI tenancy OCID. Deprecated in MySQL 8.0.31.keyring_oci_user: OCI user OCID. Deprecated in MySQL 8.0.31.keyring_oci_vaults_endpoint: OCI vaults server endpoint. Deprecated in MySQL 8.0.31.keyring_oci_virtual_vault: OCI vault OCID. Deprecated in MySQL 8.0.31.log_bin_trust_function_creators: If equal to 0 (default), then when --log-bin is used, stored function creation is allowed only to users having SUPER privilege and only if function created does not break binary logging. Deprecated in MySQL 8.0.34.log_bin_use_v1_row_events: Whether server is using version 1 binary log row events. Deprecated in MySQL 8.0.18.log_slave_updates: Whether replica should log updates performed by its replication SQL thread to its own binary log. Deprecated in MySQL 8.0.26.log_slow_slave_statements: Cause slow statements as executed by replica to be written to slow query log. Deprecated in MySQL 8.0.26.log_statements_unsafe_for_binlog: Disables error 1592 warnings being written to error log. Deprecated in MySQL 8.0.34.log_syslog: Whether to write error log to syslog. Deprecated in MySQL 8.0.2.master-info-file: Location and name of file that remembers source and where I/O replication thread is in source's binary log. Deprecated in MySQL 8.0.18.master_info_repository: Whether to write connection metadata repository, containing source information and replication I/O thread location in source's binary log, to file or table. Deprecated in MySQL 8.0.23.master_verify_checksum: Cause source to examine checksums when reading from binary log. Deprecated in MySQL 8.0.26.max_length_for_sort_data: Max number of bytes in sorted records. Deprecated in MySQL 8.0.20.myisam_repair_threads: Number of threads to use when repairing MyISAM tables. 1 disables parallel repair. Deprecated in MySQL 8.0.29.mysql_native_password_proxy_users: Whether mysql_native_password authentication plugin does proxying. Deprecated in MySQL 8.0.16.new: Use very new, possibly 'unsafe' functions. Deprecated in MySQL 8.0.35.no-dd-upgrade: Prevent automatic upgrade of data dictionary tables at startup. Deprecated in MySQL 8.0.16.old: Cause server to revert to certain behaviors present in older versions. Deprecated in MySQL 8.0.35.old-style-user-limits: Enable old-style user limits (before 5.0.3, user resources were counted per each user+host vs. per account). Deprecated in MySQL 8.0.30.performance_schema_show_processlist: Select SHOW PROCESSLIST implementation. Deprecated in MySQL 8.0.35.pseudo_slave_mode: For internal server use. Deprecated in MySQL 8.0.26.query_prealloc_size: Persistent buffer for query parsing and execution. Deprecated in MySQL 8.0.29.relay_log_info_file: File name for applier metadata repository in which replica records information about relay logs. Deprecated in MySQL 8.0.18.relay_log_info_repository: Whether to write location of replication SQL thread in relay logs to file or table. Deprecated in MySQL 8.0.23.replica_parallel_type: Tells replica to use timestamp information (LOGICAL_CLOCK) or database partitioning (DATABASE) to parallelize transactions. Deprecated in MySQL 8.0.29.rpl_stop_slave_timeout: Number of seconds that STOP REPLICA or STOP SLAVE waits before timing out. Deprecated in MySQL 8.0.26.safe-user-create: Do not allow new user creation by user who has no write privileges to mysql.user table; this option is deprecated and ignored. Deprecated in MySQL 8.0.11.sha256_password_auto_generate_rsa_keys: Whether to generate RSA key-pair files automatically. Deprecated in MySQL 8.0.16.sha256_password_private_key_path: SHA256 authentication plugin private key path name. Deprecated in MySQL 8.0.16.sha256_password_proxy_users: Whether sha256_password authentication plugin does proxying. Deprecated in MySQL 8.0.16.sha256_password_public_key_path: SHA256 authentication plugin public key path name. Deprecated in MySQL 8.0.16.show-slave-auth-info: Show user name and password in SHOW REPLICAS and SHOW SLAVE HOSTS on this source. Deprecated in MySQL 8.0.26.skip-character-set-client-handshake: Ignore client side character set value sent during handshake. Deprecated in MySQL 8.0.35.skip-host-cache: Do not cache host names. Deprecated in MySQL 8.0.30.skip-new: Do not use new, possibly wrong routines. Deprecated in MySQL 8.0.35.skip-slave-start: If set, replication is not autostarted when replica server starts. Deprecated in MySQL 8.0.26.skip-ssl: Disable connection encryption. Deprecated in MySQL 8.0.26.slave-skip-errors: Tells replication thread to continue replication when query returns error from provided list. Deprecated in MySQL 8.0.26.slave_checkpoint_group: Maximum number of transactions processed by multithreaded replica before checkpoint operation is called to update progress status. Not supported by NDB Cluster. Deprecated in MySQL 8.0.26.slave_checkpoint_period: Update progress status of multithreaded replica and flush relay log info to disk after this number of milliseconds. Not supported by NDB Cluster. Deprecated in MySQL 8.0.26.slave_compressed_protocol: Use compression of source/replica protocol. Deprecated in MySQL 8.0.18.slave_load_tmpdir: Location where replica should put its temporary files when replicating LOAD DATA statements. Deprecated in MySQL 8.0.26.slave_max_allowed_packet: Maximum size, in bytes, of packet that can be sent from replication source server to replica; overrides max_allowed_packet. Deprecated in MySQL 8.0.26.slave_net_timeout: Number of seconds to wait for more data from source/replica connection before aborting read. Deprecated in MySQL 8.0.26.slave_parallel_type: Tells replica to use timestamp information (LOGICAL_CLOCK) or database partioning (DATABASE) to parallelize transactions. Deprecated in MySQL 8.0.26.slave_parallel_workers: Number of applier threads for executing replication transactions in parallel; 0 or 1 disables replica multithreading. NDB Cluster: see documentation. Deprecated in MySQL 8.0.26.slave_pending_jobs_size_max: Maximum size of replica worker queues holding events not yet applied. Deprecated in MySQL 8.0.26.slave_preserve_commit_order: Ensures that all commits by replica workers happen in same order as on source to maintain consistency when using parallel applier threads. Deprecated in MySQL 8.0.26.slave_rows_search_algorithms: Determines search algorithms used for replica update batching. Any 2 or 3 from this list: INDEX_SEARCH, TABLE_SCAN, HASH_SCAN. Deprecated in MySQL 8.0.18.slave_sql_verify_checksum: Cause replica to examine checksums when reading from relay log. Deprecated in MySQL 8.0.26.slave_transaction_retries: Number of times replication SQL thread retries transaction in case it failed with deadlock or elapsed lock wait timeout, before giving up and stopping. Deprecated in MySQL 8.0.26.slave_type_conversions: Controls type conversion mode on replica. Value is list of zero or more elements from this list: ALL_LOSSY, ALL_NON_LOSSY. Set to empty string to disallow type conversions between source and replica. Deprecated in MySQL 8.0.26.sql_slave_skip_counter: Number of events from source that replica should skip. Not compatible with GTID replication. Deprecated in MySQL 8.0.26.ssl: Enable connection encryption. Deprecated in MySQL 8.0.26.ssl_fips_mode: Whether to enable FIPS mode on server side. Deprecated in MySQL 8.0.34.symbolic-links: Permit symbolic links for MyISAM tables. Deprecated in MySQL 8.0.2.sync_master_info: Synchronize source information after every #th event. Deprecated in MySQL 8.0.26.sync_relay_log_info: Synchronize relay.info file to disk after every #th event. Deprecated in MySQL 8.0.34.temptable_use_mmap: Defines whether TempTable storage engine allocates memory-mapped files when the temptable_max_ram threshold is reached. Deprecated in MySQL 8.0.26.transaction_prealloc_size: Persistent buffer for transactions to be stored in binary log. Deprecated in MySQL 8.0.29.transaction_write_set_extraction: Defines algorithm used to hash writes extracted during transaction. Deprecated in MySQL 8.0.26.
The following system variables, status variables, and options have been removed in MySQL 8.0.
Com_alter_db_upgrade: Count of ALTER DATABASE ... UPGRADE DATA DIRECTORY NAME statements. Removed in MySQL 8.0.0.Innodb_available_undo_logs: Total number of InnoDB rollback segments; different from innodb_rollback_segments, which displays number of active rollback segments. Removed in MySQL 8.0.2.Qcache_free_blocks: Number of free memory blocks in query cache. Removed in MySQL 8.0.3.Qcache_free_memory: Amount of free memory for query cache. Removed in MySQL 8.0.3.Qcache_hits: Number of query cache hits. Removed in MySQL 8.0.3.Qcache_inserts: Number of query cache inserts. Removed in MySQL 8.0.3.Qcache_lowmem_prunes: Number of queries which were deleted from query cache due to lack of free memory in cache. Removed in MySQL 8.0.3.Qcache_not_cached: Number of noncached queries (not cacheable, or not cached due to query_cache_type setting). Removed in MySQL 8.0.3.Qcache_queries_in_cache: Number of queries registered in query cache. Removed in MySQL 8.0.3.Qcache_total_blocks: Total number of blocks in query cache. Removed in MySQL 8.0.3.Slave_heartbeat_period: Replica's replication heartbeat interval, in seconds. Removed in MySQL 8.0.1.Slave_last_heartbeat: Shows when latest heartbeat signal was received, in TIMESTAMP format. Removed in MySQL 8.0.1.Slave_received_heartbeats: Number of heartbeats received by replica since previous reset. Removed in MySQL 8.0.1.Slave_retried_transactions: Total number of times since startup that replication SQL thread has retried transactions. Removed in MySQL 8.0.1.Slave_running: State of this server as replica (replication I/O thread status). Removed in MySQL 8.0.1.bootstrap: Used by mysql installation scripts. Removed in MySQL 8.0.0.date_format: DATE format (unused). Removed in MySQL 8.0.3.datetime_format: DATETIME/TIMESTAMP format (unused). Removed in MySQL 8.0.3.des-key-file: Load keys for des_encrypt() and des_encrypt from given file. Removed in MySQL 8.0.3.group_replication_allow_local_disjoint_gtids_join: Allow current server to join group even if it has transactions not present in group. Removed in MySQL 8.0.4.have_crypt: Availability of crypt() system call. Removed in MySQL 8.0.3.ignore-db-dir: Treat directory as nondatabase directory. Removed in MySQL 8.0.0.ignore_builtin_innodb: Ignore built-in InnoDB. Removed in MySQL 8.0.3.ignore_db_dirs: Directories treated as nondatabase directories. Removed in MySQL 8.0.0.innodb_checksums: Enable InnoDB checksums validation. Removed in MySQL 8.0.0.innodb_disable_resize_buffer_pool_debug: Disables resizing of InnoDB buffer pool. Removed in MySQL 8.0.0.innodb_file_format: Format for new InnoDB tables. Removed in MySQL 8.0.0.innodb_file_format_check: Whether InnoDB performs file format compatibility checking. Removed in MySQL 8.0.0.innodb_file_format_max: File format tag in shared tablespace. Removed in MySQL 8.0.0.innodb_large_prefix: Enables longer keys for column prefix indexes. Removed in MySQL 8.0.0.innodb_locks_unsafe_for_binlog: Force InnoDB not to use next-key locking. Instead use only row-level locking. Removed in MySQL 8.0.0.innodb_scan_directories: Defines directories to scan for tablespace files during InnoDB recovery. Removed in MySQL 8.0.4.innodb_stats_sample_pages: Number of index pages to sample for index distribution statistics. Removed in MySQL 8.0.0.innodb_support_xa: Enable InnoDB support for XA two-phase commit. Removed in MySQL 8.0.0.innodb_undo_logs: Number of undo logs (rollback segments) used by InnoDB; alias for innodb_rollback_segments. Removed in MySQL 8.0.2.internal_tmp_disk_storage_engine: Storage engine for internal temporary tables. Removed in MySQL 8.0.16.log-warnings: Write some noncritical warnings to log file. Removed in MySQL 8.0.3.log_builtin_as_identified_by_password: Whether to log CREATE/ALTER USER, GRANT in backward-compatible fashion. Removed in MySQL 8.0.11.log_error_filter_rules: Filter rules for error logging. Removed in MySQL 8.0.4.log_syslog: Whether to write error log to syslog. Removed in MySQL 8.0.13.log_syslog_facility: Facility for syslog messages. Removed in MySQL 8.0.13.log_syslog_include_pid: Whether to include server PID in syslog messages. Removed in MySQL 8.0.13.log_syslog_tag: Tag for server identifier in syslog messages. Removed in MySQL 8.0.13.max_tmp_tables: Unused. Removed in MySQL 8.0.3.metadata_locks_cache_size: Size of metadata locks cache. Removed in MySQL 8.0.13.metadata_locks_hash_instances: Number of metadata lock hashes. Removed in MySQL 8.0.13.multi_range_count: Maximum number of ranges to send to table handler at once during range selects. Removed in MySQL 8.0.3.myisam_repair_threads: Number of threads to use when repairing MyISAM tables. 1 disables parallel repair. Removed in MySQL 8.0.30.old_passwords: Selects password hashing method for PASSWORD(). Removed in MySQL 8.0.11.partition: Enable (or disable) partitioning support. Removed in MySQL 8.0.0.query_cache_limit: Do not cache results that are bigger than this. Removed in MySQL 8.0.3.query_cache_min_res_unit: Minimal size of unit in which space for results is allocated (last unit is trimmed after writing all result data). Removed in MySQL 8.0.3.query_cache_size: Memory allocated to store results from old queries. Removed in MySQL 8.0.3.query_cache_type: Query cache type. Removed in MySQL 8.0.3.query_cache_wlock_invalidate: Invalidate queries in query cache on LOCK for write. Removed in MySQL 8.0.3.secure_auth: Disallow authentication for accounts that have old (pre-4.1) passwords. Removed in MySQL 8.0.3.show_compatibility_56: Compatibility for SHOW STATUS/VARIABLES. Removed in MySQL 8.0.1.skip-partition: Do not enable user-defined partitioning. Removed in MySQL 8.0.0.sync_frm: Sync .frm to disk on create. Enabled by default. Removed in MySQL 8.0.0.temp-pool: Using this option causes most temporary files created to use small set of names, rather than unique name for each new file. Removed in MySQL 8.0.1.time_format: TIME format (unused). Removed in MySQL 8.0.3.tx_isolation: Default transaction isolation level. Removed in MySQL 8.0.3.tx_read_only: Default transaction access mode. Removed in MySQL 8.0.3.