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 options are new in MySQL 8.0, and have not been included in any previous release series.
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.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_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_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_uninstall_component: Count of UINSTALL COMPONENT statements. Added in MySQL 8.0.0.Connection_control_delay_generated: How many times the server delayed a 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.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.Secondary_engine_execution_count: For future use. Added in MySQL 8.0.13.activate_all_roles_on_login: Whether to activate all user roles at connect time. Added in MySQL 8.0.2.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.audit-log: Whether to activate the audit log plugin. Added in MySQL 8.0.11.audit_log_buffer_size: The size of the 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_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: The name of the 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 the audit log file. Added in MySQL 8.0.11.audit_log_format: The audit log file format. Added in MySQL 8.0.11.audit_log_include_accounts: Accounts to audit. Added in MySQL 8.0.11.audit_log_policy: Audit logging policy. Added in MySQL 8.0.11.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 the audit log file at a certain 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: The audit logging strategy. Added in MySQL 8.0.11.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_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_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_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_seconds: Purge binary logs after this many seconds. Added in MySQL 8.0.1.binlog_rotate_encryption_master_key_at_startup: Rotate the binary log master key at server startup. Added in MySQL 8.0.14.binlog_row_metadata: Configures the amount of table related metadata binary logged 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_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 slave's multithreaded applier.. Added in MySQL 8.0.1.caching_sha2_password_auto_generate_rsa_keys: Whether to autogenerate RSA key-pair files. Added in MySQL 8.0.4.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.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.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 the ddl_rewriter plugin. Added in MySQL 8.0.16.default_collation_for_utf8mb4: Default collation for utf8mb4 character set. Added in MySQL 8.0.11.default_table_encryption: The 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.group_replication_autorejoin_tries: Number of tries that a member makes to automatically rejoin the group. Added in MySQL 8.0.16.group_replication_communication_debug_options: The 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_consistency: The type of transaction consistency guarantee which the group provides. Added in MySQL 8.0.14.group_replication_exit_state_action: How the instance behaves when it leaves the group involuntarily. Added in MySQL 8.0.12.group_replication_flow_control_hold_percent: Defines what percentage of the group quota remains unused. Added in MySQL 8.0.2.group_replication_flow_control_max_commit_quota: Defines the maximum flow control quota of the group. Added in MySQL 8.0.2.group_replication_flow_control_member_quota_percent: Defines the percentage of the quota that a member should assume is available for itself when calculating the quotas. Added in MySQL 8.0.2.group_replication_flow_control_min_quota: Controls the lowest flow control quota that can be assigned to a member. Added in MySQL 8.0.2.group_replication_flow_control_min_recovery_quota: Controls the lowest quota that can be assigned to a member because of another recovering member in the group. 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: Defines how the group quota should be released when flow control no longer needs to throttle the writer members. Added in MySQL 8.0.2.group_replication_member_expel_timeout: The time between a suspected failure of a group member and it being expelled from the group, causing a 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 the message cache in the group communication engine (XCom). Added in MySQL 8.0.16.group_replication_recovery_get_public_key: Whether to accept preference about fetching public key from master. 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_unreachable_majority_timeout: How long to wait for network partitions that result in a minority to leave the group. Added in MySQL 8.0.2.histogram_generation_max_mem_size: Maximum memory for creating histogram statistics. Added in MySQL 8.0.2.immediate_server_version: The MySQL Server release number of the server that is the immediate master in a replication topology. Added in MySQL 8.0.14.information_schema_stats_expiry: Expiration setting for cached table statistics. Added in MySQL 8.0.3.innodb_buffer_pool_debug: Permits multiple buffer pool instances when the 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. Added in MySQL 8.0.14.innodb_checkpoint_disabled: Disables checkpoints so that a deliberate server exit always initiates recovery. Added in MySQL 8.0.2.innodb_ddl_log_crash_reset_debug: A debug option that resets DDL log crash injection counters. Added in MySQL 8.0.3.innodb_deadlock_detect: Enables or disables deadlock detection. Added in MySQL 8.0.0.innodb_dedicated_server: Enables automatic configuration of buffer pool size, log file size, and flush method. Added in MySQL 8.0.3.innodb_directories: Defines directories to scan at startup for tablespace data files. Added in MySQL 8.0.4.innodb_fsync_threshold: Controls how often InnoDB calls fsync when creating a new file. Added in MySQL 8.0.13.innodb_log_checkpoint_fuzzy_now: A debug option that forces InnoDB to write a 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: The maximum average log flush time beyond which user threads no longer spin while waiting for flushed redo. Added in MySQL 8.0.11.innodb_parallel_read_threads: Defines the 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 the error log. Added in MySQL 8.0.3.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_spin_wait_pause_multiplier: Defines a multiplier value used to determine the 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: The directory location for the 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.internal_tmp_mem_storage_engine: Defines the storage 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-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_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 a 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 the 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 the lock_order_dependencies.txt file. Added in MySQL 8.0.17.lock_order_extra_dependencies: Path to a 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 a 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 the 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_slow_extra: Whether to write extra information to the slow query log file. Added in MySQL 8.0.14.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_interactive_timeout: Number of seconds to wait for interactive clients to timeout. Added in MySQL 8.0.4.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 on a 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.named_pipe_full_access_group: Name of Windows group granted full access to the 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: The time when a transaction was committed on the original master. Added in MySQL 8.0.1.original_server_version: The MySQL Server release number of the server where a 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_max_digest_sample_age: The query resample age in seconds. Added in MySQL 8.0.3.persist_only_admin_x509_subject: SSL certificate X.509 Subject that enables persisting persist-restricted system variables. Added in MySQL 8.0.14.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.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.resultset_metadata: Whether the server returns result set metadata. Added in MySQL 8.0.3.rpl_read_size: Set the minimum amount of data in bytes that is read from the binary log files and relay log files. Added in MySQL 8.0.11.secondary_engine_cost_threshold: For future use. Added in MySQL 8.0.16.show_create_table_verbosity: Whether to display ROW_FORMAT in SHOW CREATE TABLE even if it has the default value. Added in MySQL 8.0.11.sql_require_primary_key: Whether tables must have a 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.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 the TABLE_ENCRYPTION_ADMIN privilege check. Added in MySQL 8.0.16.temptable_max_ram: Defines the maximum amount of memory that can occupied by the TempTable storage engine before data is stored on disk. Added in MySQL 8.0.2.temptable_use_mmap: Defines whether the TempTable storage engine allocates memory-mapped files when the temptable_max_ram threshold is reached.. Added in MySQL 8.0.16.thread_pool_algorithm: The thread pool algorithm. Added in MySQL 8.0.11.thread_pool_high_priority_connection: Whether the current session is high priority. Added in MySQL 8.0.11.thread_pool_max_unused_threads: The maximum permitted number of unused threads. Added in MySQL 8.0.11.thread_pool_prio_kickup_timer: How long before a statement is moved to high-priority execution. Added in MySQL 8.0.11.thread_pool_size: Number of thread groups in the thread pool. Added in MySQL 8.0.11.thread_pool_stall_limit: How long before a statement is defined as stalled. Added in MySQL 8.0.11.tls_ciphersuites: TLSv1.3 ciphersuites permitted for encrypted connections. Added in MySQL 8.0.16.upgrade: Control automatic upgrade at startup. Added in MySQL 8.0.16.use_secondary_engine: For future use. Added in MySQL 8.0.13.validate-config: Validate server configuration. Added in MySQL 8.0.16.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 the 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.
expire_logs_days: Purge binary logs after this many days. Deprecated as of MySQL 8.0.3.innodb_undo_tablespaces: Number of tablespace files that rollback segments are divided between. Deprecated as of MySQL 8.0.4.log_syslog: Whether to write error log to syslog. Deprecated as of MySQL 8.0.2.no-dd-upgrade: Prevent automatic upgrade of data dictionary tables at startup. Deprecated as of MySQL 8.0.16.symbolic-links: Permit symbolic links for MyISAM tables. Deprecated as of MySQL 8.0.2.
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: Display the total number of InnoDB rollback segments; different from innodb_rollback_segments, which displays the number of active rollback segments. Removed in MySQL 8.0.2.Qcache_free_blocks: Number of free memory blocks in the query cache. Removed in MySQL 8.0.3.Qcache_free_memory: The amount of free memory for the 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 that were deleted from the query cache due to lack of free memory in the cache. Removed in MySQL 8.0.3.Qcache_not_cached: Number of noncached queries (not cacheable, or not cached due to the query_cache_type setting). Removed in MySQL 8.0.3.Qcache_queries_in_cache: Number of queries registered in the query cache. Removed in MySQL 8.0.3.Qcache_total_blocks: The total number of blocks in the query cache. Removed in MySQL 8.0.3.Slave_heartbeat_period: The slave's replication heartbeat interval, in seconds. Removed in MySQL 8.0.1.Slave_last_heartbeat: Shows when the latest heartbeat signal was received, in TIMESTAMP format. Removed in MySQL 8.0.1.Slave_received_heartbeats: Number of heartbeats received by a replication slave since previous reset. Removed in MySQL 8.0.1.Slave_retried_transactions: The total number of times since startup that the replication slave SQL thread has retried transactions. Removed in MySQL 8.0.1.Slave_running: The state of this server as a replication slave (slave I/O thread status). Removed in MySQL 8.0.1.bootstrap: Used by mysql installation scripts. Removed in MySQL 8.0.0.date_format: The DATE format (unused). Removed in MySQL 8.0.3.datetime_format: The 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 the current server to join the group even if it has transactions not present in the group. Removed in MySQL 8.0.4.have_crypt: Availability of the crypt() system call. Removed in MySQL 8.0.3.ignore-builtin-innodb: Ignore the built-in InnoDB. Removed in MySQL 8.0.3.ignore-db-dir: Treat directory as nondatabase directory. Removed in MySQL 8.0.0.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 the InnoDB buffer pool. Removed in MySQL 8.0.0.innodb_file_format: The 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: The file format tag in the 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 the XA two-phase commit. Removed in MySQL 8.0.0.innodb_undo_logs: Defines the number of undo logs (rollback segments) used by InnoDB; an 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: Log some noncritical warnings to the 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 the 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: The maximum number of ranges to send to a table handler at once during range selects. Removed in MySQL 8.0.3.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 will be trimmed after writing all result data). Removed in MySQL 8.0.3.query_cache_size: The 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 will cause most temporary files created to use a small set of names, rather than a unique name for each new file. Removed in MySQL 8.0.1.time_format: The TIME format (unused). Removed in MySQL 8.0.3.tx_isolation: The default transaction isolation level. Removed in MySQL 8.0.3.tx_read_only: Default transaction access mode. Removed in MySQL 8.0.3.