1.5 Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 5.7
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 5.7.
The following system variables, status variables, and options are new in MySQL 5.7, and have not been included in any previous release series.
Audit_log_current_size: Audit log file current size. Added in MySQL 5.7.9.Audit_log_event_max_drop_size: Size of largest dropped audited event. Added in MySQL 5.7.9.Audit_log_events: Number of handled audited events. Added in MySQL 5.7.9.Audit_log_events_filtered: Number of filtered audited events. Added in MySQL 5.7.9.Audit_log_events_lost: Number of dropped audited events. Added in MySQL 5.7.9.Audit_log_events_written: Number of written audited events. Added in MySQL 5.7.9.Audit_log_total_size: Combined size of written audited events. Added in MySQL 5.7.9.Audit_log_write_waits: Number of write-delayed audited events. Added in MySQL 5.7.9.Com_change_repl_filter: Count of CHANGE REPLICATION FILTER statements. Added in MySQL 5.7.3.Com_explain_other: Count of EXPLAIN FOR CONNECTION statements. Added in MySQL 5.7.2.Com_group_replication_start: Count of START GROUP_REPLICATION statements. Added in MySQL 5.7.6.Com_group_replication_stop: Count of STOP GROUP_REPLICATION statements. Added in MySQL 5.7.6.Com_show_create_user: Count of SHOW CREATE USER statements. Added in MySQL 5.7.6.Com_show_slave_status_nonblocking: Count of SHOW SLAVE STATUS NONBLOCKING statements. Added in MySQL 5.7.0.Com_shutdown: Count of SHUTDOWN statements. Added in MySQL 5.7.9.Connection_control_delay_generated: How many times the server delayed a connection request. Added in MySQL 5.7.17.Firewall_access_denied: Number of statements rejected by MySQL Enterprise Firewall. Added in MySQL 5.7.9.Firewall_access_granted: Number of statements accepted by MySQL Enterprise Firewall. Added in MySQL 5.7.9.Firewall_cached_entries: Number of statements recorded by MySQL Enterprise Firewall. Added in MySQL 5.7.9.Innodb_buffer_pool_resize_status: The status of the dynamic buffer pool resizing operation. Added in MySQL 5.7.5.Locked_connects: Number of attempts to connect to locked accounts. Added in MySQL 5.7.6.Max_execution_time_exceeded: Number of statements that exceeded the execution timeout value. Added in MySQL 5.7.8.Max_execution_time_set: Number of statements for which execution timeout was set. Added in MySQL 5.7.8.Max_execution_time_set_failed: Number of statements for which execution timeout setting failed. Added in MySQL 5.7.8.Max_statement_time_exceeded: Number of statements that exceeded the execution timeout value. Added in MySQL 5.7.4.Max_statement_time_set: Number of statements for which execution timeout was set. Added in MySQL 5.7.4.Max_statement_time_set_failed: Number of statements for which execution timeout setting failed. Added in MySQL 5.7.4.Max_used_connections_time: The time at which Max_used_connections reached its current value. Added in MySQL 5.7.5.Performance_schema_index_stat_lost: Number of indexes for which statistics were lost. Added in MySQL 5.7.6.Performance_schema_memory_classes_lost: How many memory instruments could not be loaded. Added in MySQL 5.7.2.Performance_schema_metadata_lock_lost: Number of metadata locks that could not be recorded. Added in MySQL 5.7.3.Performance_schema_nested_statement_lost: Number of stored program statements for which statistics were lost. Added in MySQL 5.7.2.Performance_schema_prepared_statements_lost: Number of prepared statements that could not be instrumented. Added in MySQL 5.7.4.Performance_schema_program_lost: Number of stored programs for which statistics were lost. Added in MySQL 5.7.2.Performance_schema_table_lock_stat_lost: Number of tables for which lock statistics were lost. Added in MySQL 5.7.6.Rewriter_number_loaded_rules: Number of rewrite rules successfully loaded into memory. Added in MySQL 5.7.6.Rewriter_number_reloads: Number of reloads of rules table into memory. Added in MySQL 5.7.6.Rewriter_number_rewritten_queries: Number of queries rewritten since the plugin was loaded. Added in MySQL 5.7.6.Rewriter_reload_error: Whether an error occurred when last loading the rewriting rules into memory. Added in MySQL 5.7.6.audit-log: Whether to activate the audit log plugin. Added in MySQL 5.7.9.audit_log_buffer_size: The size of the audit log buffer. Added in MySQL 5.7.9.audit_log_compression: Audit log file compression method. Added in MySQL 5.7.21.audit_log_connection_policy: Audit logging policy for connection-related events. Added in MySQL 5.7.9.audit_log_current_session: Whether to audit current session. Added in MySQL 5.7.9.audit_log_encryption: Audit log file encryption method. Added in MySQL 5.7.21.audit_log_exclude_accounts: Accounts not to audit. Added in MySQL 5.7.9.audit_log_file: The name of the audit log file. Added in MySQL 5.7.9.audit_log_filter_id: ID of current audit log filter. Added in MySQL 5.7.13.audit_log_flush: Close and reopen the audit log file. Added in MySQL 5.7.9.audit_log_format: The audit log file format. Added in MySQL 5.7.9.audit_log_include_accounts: Accounts to audit. Added in MySQL 5.7.9.audit_log_policy: Audit logging policy. Added in MySQL 5.7.9.audit_log_read_buffer_size: Audit log file read buffer size. Added in MySQL 5.7.21.audit_log_rotate_on_size: Close and reopen the audit log file at a certain size. Added in MySQL 5.7.9.audit_log_statement_policy: Audit logging policy for statement-related events. Added in MySQL 5.7.9.audit_log_strategy: The audit logging strategy. Added in MySQL 5.7.9.authentication_ldap_sasl_auth_method_name: Authentication method name. Added in MySQL 5.7.19.authentication_ldap_sasl_bind_base_dn: LDAP server base distinguished name. Added in MySQL 5.7.19.authentication_ldap_sasl_bind_root_dn: LDAP server root distinguished name. Added in MySQL 5.7.19.authentication_ldap_sasl_bind_root_pwd: LDAP server root bind password. Added in MySQL 5.7.19.authentication_ldap_sasl_ca_path: LDAP server certificate authority file name. Added in MySQL 5.7.19.authentication_ldap_sasl_group_search_attr: LDAP server group search attribute. Added in MySQL 5.7.19.authentication_ldap_sasl_group_search_filter: LDAP custom group search filter. Added in MySQL 5.7.21.authentication_ldap_sasl_init_pool_size: LDAP server initial connection pool size. Added in MySQL 5.7.19.authentication_ldap_sasl_log_status: LDAP server log level. Added in MySQL 5.7.19.authentication_ldap_sasl_max_pool_size: LDAP server maximum connection pool size. Added in MySQL 5.7.19.authentication_ldap_sasl_server_host: LDAP server host name or IP address. Added in MySQL 5.7.19.authentication_ldap_sasl_server_port: LDAP server port number. Added in MySQL 5.7.19.authentication_ldap_sasl_tls: Whether to use encrypted connections to LDAP server. Added in MySQL 5.7.19.authentication_ldap_sasl_user_search_attr: LDAP server user search attribute. Added in MySQL 5.7.19.authentication_ldap_simple_auth_method_name: Authentication method name. Added in MySQL 5.7.19.authentication_ldap_simple_bind_base_dn: LDAP server base distinguished name. Added in MySQL 5.7.19.authentication_ldap_simple_bind_root_dn: LDAP server root distinguished name. Added in MySQL 5.7.19.authentication_ldap_simple_bind_root_pwd: LDAP server root bind password. Added in MySQL 5.7.19.authentication_ldap_simple_ca_path: LDAP server certificate authority file name. Added in MySQL 5.7.19.authentication_ldap_simple_group_search_attr: LDAP server group search attribute. Added in MySQL 5.7.19.authentication_ldap_simple_group_search_filter: LDAP custom group search filter. Added in MySQL 5.7.21.authentication_ldap_simple_init_pool_size: LDAP server initial connection pool size. Added in MySQL 5.7.19.authentication_ldap_simple_log_status: LDAP server log level. Added in MySQL 5.7.19.authentication_ldap_simple_max_pool_size: LDAP server maximum connection pool size. Added in MySQL 5.7.19.authentication_ldap_simple_server_host: LDAP server host name or IP address. Added in MySQL 5.7.19.authentication_ldap_simple_server_port: LDAP server port number. Added in MySQL 5.7.19.authentication_ldap_simple_tls: Whether to use encrypted connections to LDAP server. Added in MySQL 5.7.19.authentication_ldap_simple_user_search_attr: LDAP server user search attribute. Added in MySQL 5.7.19.authentication_windows_log_level: Windows authentication plugin logging level. Added in MySQL 5.7.9.authentication_windows_use_principal_name: Whether to use Windows authentication plugin principal name. Added in MySQL 5.7.9.auto_generate_certs: Whether to autogenerate SSL key and certificate files. Added in MySQL 5.7.5.avoid_temporal_upgrade: Whether ALTER TABLE should upgrade pre-5.6.4 temporal columns. Added in MySQL 5.7.6.binlog_error_action: Controls what happens when the server cannot write to the binary log. Added in MySQL 5.7.6.binlog_group_commit_sync_delay: Sets the number of microseconds to wait before synchronizing transactions to disk. Added in MySQL 5.7.5.binlog_group_commit_sync_no_delay_count: Sets the maximum number of transactions to wait for before aborting the current delay specified by binlog_group_commit_sync_delay. Added in MySQL 5.7.5.binlog_gtid_simple_recovery: Controls how binary logs are iterated during GTID recovery. Added in MySQL 5.7.6.binlog_transaction_dependency_history_size: Number of row hashes kept for looking up transaction that last updated some row. Added in MySQL 5.7.22.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 5.7.22.binlogging_impossible_mode: Deprecated and later removed. Use binlog_error_action instead. Added in MySQL 5.7.5.block_encryption_mode: Mode for block-based encryption algorithms. Added in MySQL 5.7.4.check_proxy_users: Whether built-in authentication plugins do proxying. Added in MySQL 5.7.7.connection_control_failed_connections_threshold: Consecutive failed connection attempts before delays occur. Added in MySQL 5.7.17.connection_control_max_connection_delay: Maximum delay (milliseconds) for server response to failed connection attempts. Added in MySQL 5.7.17.connection_control_min_connection_delay: Minimum delay (milliseconds) for server response to failed connection attempts. Added in MySQL 5.7.17.daemonize: Run as System V daemon. Added in MySQL 5.7.6.default_authentication_plugin: The default authentication plugin. Added in MySQL 5.7.2.default_password_lifetime: Age in days when passwords effectively expire. Added in MySQL 5.7.4.disable-partition-engine-check: Whether to disable the startup check for tables with nonnative partitioning. Added in MySQL 5.7.17.disabled_storage_engines: Storage engines that cannot be used to create tables. Added in MySQL 5.7.8.disconnect_on_expired_password: Whether server disconnects clients with expired passwords if clients cannot handle such accounts. Added in MySQL 5.7.1.early-plugin-load: Specify plugins to load before loading mandatory built-in plugins and before storage engine initialization. Added in MySQL 5.7.11.executed_gtids_compression_period: Renamed to gtid_executed_compression_period. Added in MySQL 5.7.5.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. Added in MySQL 5.7.17.group_replication_allow_local_lower_version_join: Allow the current server to join the group even if it has a lower plugin version than the group. Added in MySQL 5.7.17.group_replication_auto_increment_increment: Determines the interval between successive column values for transactions that execute on this server. Added in MySQL 5.7.17.group_replication_bootstrap_group: Configure this server to bootstrap the group. Added in MySQL 5.7.17.group_replication_components_stop_timeout: Timeout, in seconds, that the plugin waits for each of the components when shutting down. Added in MySQL 5.7.17.group_replication_compression_threshold: The value in bytes above which (LZ4) compression is enforced; when set to zero, deactivates compression. Added in MySQL 5.7.17.group_replication_enforce_update_everywhere_checks: Enable or disable strict consistency checks for multi-master update everywhere. Added in MySQL 5.7.17.group_replication_exit_state_action: How the instance behaves when it leaves the group involuntarily. Added in MySQL 5.7.24.group_replication_flow_control_applier_threshold: Number of waiting transactions in the applier queue that trigger flow control. Added in MySQL 5.7.17.group_replication_flow_control_certifier_threshold: Specifies the number of waiting transactions in the certifier queue that trigger flow control. Added in MySQL 5.7.17.group_replication_flow_control_mode: Specifies the mode used for flow control. Added in MySQL 5.7.17.group_replication_force_members: A comma separated list of peer addresses, such as host1:port1,host2:port2. Added in MySQL 5.7.17.group_replication_group_name: The name of the group. Added in MySQL 5.7.17.group_replication_group_seeds: A list of peer addresses, comma separated list such as host1:port1,host2:port2. Added in MySQL 5.7.17.group_replication_gtid_assignment_block_size: Number of consecutive GTIDs that are reserved for each member; each member consumes its blocks and reserves more when needed. Added in MySQL 5.7.17.group_replication_ip_whitelist: The list of hosts permitted to connect to the group. Added in MySQL 5.7.17.group_replication_local_address: The local address in host:port formatted string. Added in MySQL 5.7.17.group_replication_member_weight: Chance of this member being elected as primary. Added in MySQL 5.7.20.group_replication_poll_spin_loops: Number of times the group communication thread waits. Added in MySQL 5.7.17.group_replication_recovery_complete_at: Recovery policies when handling cached transactions after state transfer. Added in MySQL 5.7.17.group_replication_recovery_reconnect_interval: The sleep time, in seconds, between reconnection attempts when no donor was found in the group. Added in MySQL 5.7.17.group_replication_recovery_retry_count: Number of times that a joining member tries to connect to the available donors before giving up. Added in MySQL 5.7.17.group_replication_recovery_ssl_ca: File that contains list of trusted SSL Certificate Authorities. Added in MySQL 5.7.17.group_replication_recovery_ssl_capath: Directory that contains trusted SSL Certificate Authority certificate files. Added in MySQL 5.7.17.group_replication_recovery_ssl_cert: Name of SSL certificate file to use for establishing encrypted connection. Added in MySQL 5.7.17.group_replication_recovery_ssl_cipher: Permissible ciphers for SSL encryption. Added in MySQL 5.7.17.group_replication_recovery_ssl_crl: File that contains certificate revocation lists. Added in MySQL 5.7.17.group_replication_recovery_ssl_crlpath: Directory that contains certificate revocation-list files. Added in MySQL 5.7.17.group_replication_recovery_ssl_key: Name of SSL key file to use for establishing encrypted connection. Added in MySQL 5.7.17.group_replication_recovery_ssl_verify_server_cert: Make the recovery process check the server's Common Name value in the donor sent certificate. Added in MySQL 5.7.17.group_replication_recovery_use_ssl: Whether Group Replication recovery connection should use SSL. Added in MySQL 5.7.17.group_replication_single_primary_mode: Instructs the group to use a single server for the read/write workload. Added in MySQL 5.7.17.group_replication_ssl_mode: Desired security state of connection between Group Replication members. Added in MySQL 5.7.17.group_replication_start_on_boot: Whether the server should start Group Replication or not during server start. Added in MySQL 5.7.17.group_replication_transaction_size_limit: Sets the maximum size of transaction in bytes which the group accepts. Added in MySQL 5.7.19.group_replication_unreachable_majority_timeout: How long to wait for network partitions that result in a minority to leave the group. Added in MySQL 5.7.19.gtid_executed_compression_period: Compress gtid_executed table each time this many transactions have occurred. 0 means never compress this table. Applies only when binary logging is disabled. Added in MySQL 5.7.6.have_statement_timeout: Whether statement execution timeout is available. Added in MySQL 5.7.4.initialize: Whether to run in initialization mode (secure). Added in MySQL 5.7.6.initialize-insecure: Whether to run in initialization mode (insecure). Added in MySQL 5.7.6.innodb_adaptive_hash_index_parts: Partitions the adaptive hash index search system into n partitions, with each partition protected by a separate latch. Each index is bound to a specific partition based on space ID and index ID attributes. Added in MySQL 5.7.8.innodb_background_drop_list_empty: This debug option delays table creation until the background drop list is empty. Added in MySQL 5.7.10.innodb_buffer_pool_chunk_size: Defines the chunk size that is used when resizing the buffer pool. Added in MySQL 5.7.5.innodb_buffer_pool_dump_pct: Specifies the percentage of the most recently used pages for each buffer pool to read out and dump. Added in MySQL 5.7.2.innodb_compress_debug: Compresses all tables using a specified compression algorithm. Added in MySQL 5.7.8.innodb_deadlock_detect: Enables or disables deadlock detection. Added in MySQL 5.7.15.innodb_default_row_format: Defines the default row format (ROW_FORMAT) for InnoDB tables. Added in MySQL 5.7.9.innodb_disable_resize_buffer_pool_debug: Disables resizing of the InnoDB buffer pool. Added in MySQL 5.7.6.innodb_fill_factor: Defines the percentage B-tree leaf and non-leaf page space that is to be filled with data. The remaining space is reserved for future growth. Added in MySQL 5.7.5.innodb_flush_sync: Enable innodb_flush_sync to ignore the innodb_io_capacity setting for bursts of I/O activity that occur at checkpoints. Disable innodb_flush_sync to adhere to the limit on I/O activity defined by the innodb_io_capacity setting. Added in MySQL 5.7.8.innodb_ft_result_cache_limit: The InnoDB FULLTEXT search query result cache limit. Added in MySQL 5.7.2.innodb_ft_total_cache_size: The total memory allocated for the InnoDB FULLTEXT search index cache. Added in MySQL 5.7.2.innodb_log_checkpoint_now: A debug option that forces InnoDB to write a checkpoint. Added in MySQL 5.7.2.innodb_log_checksum_algorithm: Specifies how to generate and verify the checksum stored in each redo log disk block. Added in MySQL 5.7.8.innodb_log_checksums: Enables or disables checksums for redo log pages. Added in MySQL 5.7.9.innodb_log_write_ahead_size: The write-ahead block size for the redo log. Added in MySQL 5.7.4.innodb_max_undo_log_size: Sets the threshold for truncating the InnoDB undo log. Added in MySQL 5.7.5.innodb_merge_threshold_set_all_debug: Overrides the current MERGE_THRESHOLD setting with the specified value for all indexes that are currently in the dictionary cache. Added in MySQL 5.7.6.innodb_numa_interleave: Enables the NUMA MPOL_INTERLEAVE memory policy for allocation of the InnoDB buffer pool. Added in MySQL 5.7.9.innodb_optimize_point_storage: Enable this option to store POINT data as fixed-length data rather than a variable-length data. Added in MySQL 5.7.5.innodb_page_cleaners: Number of page cleaner threads. Added in MySQL 5.7.4.innodb_purge_rseg_truncate_frequency: The rate at which undo log purge should be invoked as part of the purge action. A value of n invokes undo log purge on every nth iteration of purge invocation. Added in MySQL 5.7.5.innodb_stats_include_delete_marked: Include delete-marked records when calculating persistent InnoDB statistics. Added in MySQL 5.7.17.innodb_status_output: Used to enable or disable periodic output for the standard InnoDB Monitor. Also used in combination with innodb_status_output_locks to enable and disable periodic output for the InnoDB Lock Monitor. Added in MySQL 5.7.4.innodb_status_output_locks: Used to enable or disable periodic output for the standard InnoDB Lock Monitor. innodb_status_output must also be enabled to produce periodic output for the InnoDB Lock Monitor. Added in MySQL 5.7.4.innodb_sync_debug: Enables InnoDB sync debug checking. Added in MySQL 5.7.8.innodb_temp_data_file_path: Path to temporary tablespace data files and their sizes. Added in MySQL 5.7.1.innodb_tmpdir: The directory location for the temporary table files created during online ALTER TABLE operations. Added in MySQL 5.7.11.innodb_undo_log_truncate: Enable this option to mark the InnoDB undo tablespace for truncation. Added in MySQL 5.7.5.internal_tmp_disk_storage_engine: Storage engine for internal temporary tables. Added in MySQL 5.7.5.keyring-migration-destination: Key migration destination keyring plugin. Added in MySQL 5.7.21.keyring-migration-host: Host name for connecting to running server for key migration. Added in MySQL 5.7.21.keyring-migration-password: Password for connecting to running server for key migration. Added in MySQL 5.7.21.keyring-migration-port: TCP/IP port number for connecting to running server for key migration. Added in MySQL 5.7.21.keyring-migration-socket: Unix socket file or Windows named pipe for connecting to running server for key migration. Added in MySQL 5.7.21.keyring-migration-source: Key migration source keyring plugin. Added in MySQL 5.7.21.keyring-migration-user: User name for connecting to running server for key migration. Added in MySQL 5.7.21.keyring_aws_cmk_id: AWS keyring plugin customer master key ID value. Added in MySQL 5.7.19.keyring_aws_conf_file: AWS keyring plugin configuration file location. Added in MySQL 5.7.19.keyring_aws_data_file: AWS keyring plugin storage file location. Added in MySQL 5.7.19.keyring_aws_region: AWS keyring plugin region. Added in MySQL 5.7.19.keyring_encrypted_file_data: keyring_encrypted_file plugin data file. Added in MySQL 5.7.21.keyring_encrypted_file_password: keyring_encrypted_file plugin password. Added in MySQL 5.7.21.keyring_file_data: keyring_file plugin data file. Added in MySQL 5.7.11.keyring_okv_conf_dir: Oracle Key Vault keyring plugin configuration directory. Added in MySQL 5.7.12.keyring_operations: Whether keyring operations are enabled. Added in MySQL 5.7.21.log_backward_compatible_user_definitions: Whether to log CREATE/ALTER USER, GRANT in backward-compatible fashion. Added in MySQL 5.7.6.log_builtin_as_identified_by_password: Whether to log CREATE/ALTER USER, GRANT in backward-compatible fashion. Added in MySQL 5.7.9.log_error_verbosity: Error logging verbosity level. Added in MySQL 5.7.2.log_slow_admin_statements: Log slow OPTIMIZE, ANALYZE, ALTER and other administrative statements to the slow query log if it is open. Added in MySQL 5.7.1.log_slow_slave_statements: Cause slow statements as executed by the slave to be written to the slow query log. Added in MySQL 5.7.1.log_statements_unsafe_for_binlog: Disables error 1592 warnings being written to the error log. Added in MySQL 5.7.11.log_syslog: Whether to write error log to syslog. Added in MySQL 5.7.5.log_syslog_facility: Facility for syslog messages. Added in MySQL 5.7.5.log_syslog_include_pid: Whether to include server PID in syslog messages. Added in MySQL 5.7.5.log_syslog_tag: Tag for server identifier in syslog messages. Added in MySQL 5.7.5.log_timestamps: Log timestamp format. Added in MySQL 5.7.2.max_digest_length: The maximum digest size in bytes. Added in MySQL 5.7.6.max_execution_time: Statement execution timeout value. Added in MySQL 5.7.8.max_points_in_geometry: Maximum number of points in geometry values for ST_Buffer_Strategy(). Added in MySQL 5.7.8.max_statement_time: Statement execution timeout value. Added in MySQL 5.7.4.mecab_charset: The character set currently used by the MeCab full-text parser plugin. Added in MySQL 5.7.6.mecab_rc_file: Path to the mecabrc configuration file for the MeCab parser for full-text search. Added in MySQL 5.7.6.mysql_firewall_mode: Whether MySQL Enterprise Firewall is operational. Added in MySQL 5.7.9.mysql_firewall_trace: Whether to enable firewall trace. Added in MySQL 5.7.9.mysql_native_password_proxy_users: Whether the mysql_native_password authentication plugin does proxying. Added in MySQL 5.7.7.mysqlx: Whether X Plugin is initialized. Added in MySQL 5.7.12.mysqlx_bind_address: The network address X Plugin uses for connections. Added in MySQL 5.7.17.mysqlx_connect_timeout: Maximum permitted waiting time in seconds for a connection to set up a session. Added in MySQL 5.7.12.mysqlx_idle_worker_thread_timeout: Time in seconds after which idle worker threads are terminated. Added in MySQL 5.7.12.mysqlx_max_allowed_packet: Maximum size of network packets that can be received by X Plugin. Added in MySQL 5.7.12.mysqlx_max_connections: Maximum number of concurrent client connections X Plugin can accept. Added in MySQL 5.7.12.mysqlx_min_worker_threads: Minimum number of worker threads used for handling client requests. Added in MySQL 5.7.12.mysqlx_port: Port number on which X Plugin accepts TCP/IP connections. Added in MySQL 5.7.12.mysqlx_port_open_timeout: Time which the X Plugin waits when accepting connections. Added in MySQL 5.7.17.mysqlx_socket: Path to the socket where X Plugin listens for connections. Added in MySQL 5.7.15.mysqlx_ssl_ca: File that contains list of trusted SSL Certificate Authorities. Added in MySQL 5.7.12.mysqlx_ssl_capath: Directory that contains trusted SSL Certificate Authority certificate files. Added in MySQL 5.7.12.mysqlx_ssl_cert: File that contains X.509 certificate. Added in MySQL 5.7.12.mysqlx_ssl_cipher: Permissible ciphers for connection encryption. Added in MySQL 5.7.12.mysqlx_ssl_crl: File that contains certificate revocation lists. Added in MySQL 5.7.12.mysqlx_ssl_crlpath: Directory that contains certificate revocation list files. Added in MySQL 5.7.12.mysqlx_ssl_key: File that contains X.509 key. Added in MySQL 5.7.12.named_pipe_full_access_group: Name of Windows group granted full access to the named pipe. Added in MySQL 5.7.25.ngram_token_size: Defines the n-gram token size for the full-text search ngram parser. Added in MySQL 5.7.6.offline_mode: Whether server is offline. Added in MySQL 5.7.5.parser_max_mem_size: Maximum amount of memory available to parser. Added in MySQL 5.7.12.performance-schema-consumer-events-transactions-current: Configure events-transactions-current consumer. Added in MySQL 5.7.3.performance-schema-consumer-events-transactions-history: Configure events-transactions-history consumer. Added in MySQL 5.7.3.performance-schema-consumer-events-transactions-history-long: Configure events-transactions-history-long consumer. Added in MySQL 5.7.3.performance_schema_events_transactions_history_long_size: Number of rows in the events_transactions_history_long table. Added in MySQL 5.7.3.performance_schema_events_transactions_history_size: Number of rows per thread in the events_transactions_history table. Added in MySQL 5.7.3.performance_schema_max_digest_length: The maximum Performance Schema digest size in bytes. Added in MySQL 5.7.8.performance_schema_max_index_stat: Maximum number of indexes to keep statistics for. Added in MySQL 5.7.6.performance_schema_max_memory_classes: The maximum number of memory instruments. Added in MySQL 5.7.2.performance_schema_max_metadata_locks: The maximum number of metadata locks to track. Added in MySQL 5.7.3.performance_schema_max_prepared_statements_instances: Number of rows in the prepared_statements_instances table. Added in MySQL 5.7.4.performance_schema_max_program_instances: The maximum number of stored programs for statistics. Added in MySQL 5.7.2.performance_schema_max_sql_text_length: The maximum number of bytes stored from SQL statements. Added in MySQL 5.7.6.performance_schema_max_statement_stack: The maximum stored program nesting for statistics. Added in MySQL 5.7.2.performance_schema_max_table_lock_stat: Maximum number of tables to keep lock statistics for. Added in MySQL 5.7.6.range_optimizer_max_mem_size: Limit on range optimizer memory consumption. Added in MySQL 5.7.9.rbr_exec_mode: Allows for switching the server between IDEMPOTENT mode (key and some other errors suppressed) and STRICT mode; STRICT mode is the default. Added in MySQL 5.7.1.require_secure_transport: Whether client connections must use secure transport. Added in MySQL 5.7.8.rewriter_enabled: Whether the example query rewrite plugin is enabled. Added in MySQL 5.7.6.rewriter_verbose: For internal use. Added in MySQL 5.7.6.rpl_semi_sync_master_wait_for_slave_count: How many slave acknowledgments the master must receive per transaction before proceeding. Added in MySQL 5.7.3.rpl_semi_sync_master_wait_point: The wait point for slave transaction receipt acknowledgment. Added in MySQL 5.7.2.rpl_stop_slave_timeout: Set the number of seconds that STOP SLAVE waits before timing out. Added in MySQL 5.7.2.session_track_gtids: Enables a tracker which can be configured to track different GTIDs. Added in MySQL 5.7.6.session_track_schema: Whether to track schema changes. Added in MySQL 5.7.4.session_track_state_change: Whether to track session state changes. Added in MySQL 5.7.4.session_track_system_variables: Session variables to track changes for. Added in MySQL 5.7.4.session_track_transaction_info: How to perform transaction tracking. Added in MySQL 5.7.8.sha256_password_auto_generate_rsa_keys: Whether to autogenerate RSA key-pair files. Added in MySQL 5.7.5.sha256_password_proxy_users: Whether the sha256_password authentication plugin does proxying. Added in MySQL 5.7.7.show_compatibility_56: Compatibility for SHOW STATUS/VARIABLES. Added in MySQL 5.7.6.show_create_table_verbosity: Whether to display ROW_FORMAT in SHOW CREATE TABLE even if it has the default value. Added in MySQL 5.7.22.show_old_temporals: Whether SHOW CREATE TABLE should indicate pre-5.6.4 temporal columns. Added in MySQL 5.7.6.simplified_binlog_gtid_recovery: Renamed to binlog_gtid_simple_recovery. Added in MySQL 5.7.5.slave_parallel_type: Tells the slave to use timestamp information (LOGICAL_CLOCK) or database partioning (DATABASE) to parallelize transactions. Added in MySQL 5.7.2.slave_preserve_commit_order: Ensures that all commits by slave workers happen in the same order as on the master to maintain consistency when using parallel applier threads. Added in MySQL 5.7.5.super_read_only: Whether to ignore SUPER exceptions to read-only mode. Added in MySQL 5.7.8.thread_pool_algorithm: The thread pool algorithm. Added in MySQL 5.7.9.thread_pool_high_priority_connection: Whether the current session is high priority. Added in MySQL 5.7.9.thread_pool_max_unused_threads: Maximum permissible number of unused threads. Added in MySQL 5.7.9.thread_pool_prio_kickup_timer: How long before a statement is moved to high-priority execution. Added in MySQL 5.7.9.thread_pool_size: Number of thread groups in the thread pool. Added in MySQL 5.7.9.thread_pool_stall_limit: How long before a statement is defined as stalled. Added in MySQL 5.7.9.tls_version: Permissible TLS protocols for encrypted connections. Added in MySQL 5.7.10.transaction_write_set_extraction: Defines the algorithm used to hash the writes extracted during a transaction. Added in MySQL 5.7.6.validate_password_check_user_name: Whether to check passwords against user name. Added in MySQL 5.7.15.validate_password_dictionary_file_last_parsed: When the dictionary file was last parsed. Added in MySQL 5.7.8.validate_password_dictionary_file_words_count: Number of words in dictionary file. Added in MySQL 5.7.8.version_tokens_session: Client token list for Version Tokens. Added in MySQL 5.7.8.version_tokens_session_number: For internal use. Added in MySQL 5.7.8.
The following system variables, status variables, and options have been deprecated in MySQL 5.7.
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. Deprecated as of MySQL 5.7.19.Qcache_free_blocks: Number of free memory blocks in the query cache. Deprecated as of MySQL 5.7.20.Qcache_free_memory: The amount of free memory for the query cache. Deprecated as of MySQL 5.7.20.Qcache_hits: Number of query cache hits. Deprecated as of MySQL 5.7.20.Qcache_inserts: Number of query cache inserts. Deprecated as of MySQL 5.7.20.Qcache_lowmem_prunes: Number of queries that were deleted from the query cache due to lack of free memory in the cache. Deprecated as of MySQL 5.7.20.Qcache_not_cached: Number of noncached queries (not cacheable, or not cached due to the query_cache_type setting). Deprecated as of MySQL 5.7.20.Qcache_queries_in_cache: Number of queries registered in the query cache. Deprecated as of MySQL 5.7.20.Qcache_total_blocks: The total number of blocks in the query cache. Deprecated as of MySQL 5.7.20.Slave_heartbeat_period: The slave's replication heartbeat interval, in seconds. Deprecated as of MySQL 5.7.6.Slave_last_heartbeat: Shows when the latest heartbeat signal was received, in TIMESTAMP format. Deprecated as of MySQL 5.7.6.Slave_received_heartbeats: Number of heartbeats received by a replication slave since previous reset. Deprecated as of MySQL 5.7.6.Slave_retried_transactions: The total number of times since startup that the replication slave SQL thread has retried transactions. Deprecated as of MySQL 5.7.6.Slave_running: The state of this server as a replication slave (slave I/O thread status). Deprecated as of MySQL 5.7.6.avoid_temporal_upgrade: Whether ALTER TABLE should upgrade pre-5.6.4 temporal columns. Deprecated as of MySQL 5.7.6.binlog_max_flush_queue_time: How long to read transactions before flushing to binary log. Deprecated as of MySQL 5.7.9.bootstrap: Used by mysql installation scripts. Deprecated as of MySQL 5.7.6.des-key-file: Load keys for des_encrypt() and des_encrypt from given file. Deprecated as of MySQL 5.7.6.disable-partition-engine-check: Whether to disable the startup check for tables with nonnative partitioning. Deprecated as of MySQL 5.7.17.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. Deprecated as of MySQL 5.7.21.have_crypt: Availability of the crypt() system call. Deprecated as of MySQL 5.7.6.have_query_cache: Whether mysqld supports query cache. Deprecated as of MySQL 5.7.20.ignore-db-dir: Treat directory as nondatabase directory. Deprecated as of MySQL 5.7.16.ignore_db_dirs: Directories treated as nondatabase directories. Deprecated as of MySQL 5.7.16.innodb: Enable InnoDB (if this version of MySQL supports it). Deprecated as of MySQL 5.7.5.innodb_file_format: The format for new InnoDB tables. Deprecated as of MySQL 5.7.7.innodb_file_format_check: Whether InnoDB performs file format compatibility checking. Deprecated as of MySQL 5.7.7.innodb_file_format_max: The file format tag in the shared tablespace. Deprecated as of MySQL 5.7.7.innodb_large_prefix: Enables longer keys for column prefix indexes. Deprecated as of MySQL 5.7.7.innodb_support_xa: Enable InnoDB support for the XA two-phase commit. Deprecated as of MySQL 5.7.10.innodb_undo_logs: Defines the number of undo logs (rollback segments) used by InnoDB; an alias for innodb_rollback_segments. Deprecated as of MySQL 5.7.19.innodb_undo_tablespaces: Number of tablespace files that rollback segments are divided between. Deprecated as of MySQL 5.7.21.log-warnings: Log some noncritical warnings to the log file. Deprecated as of MySQL 5.7.2.metadata_locks_cache_size: Size of the metadata locks cache. Deprecated as of MySQL 5.7.4.metadata_locks_hash_instances: Number of metadata lock hashes. Deprecated as of MySQL 5.7.4.old_passwords: Selects password hashing method for PASSWORD(). Deprecated as of MySQL 5.7.6.partition: Enable (or disable) partitioning support. Deprecated as of MySQL 5.7.16.query_cache_limit: Do not cache results that are bigger than this. Deprecated as of MySQL 5.7.20.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). Deprecated as of MySQL 5.7.20.query_cache_size: The memory allocated to store results from old queries. Deprecated as of MySQL 5.7.20.query_cache_type: Query cache type. Deprecated as of MySQL 5.7.20.query_cache_wlock_invalidate: Invalidate queries in query cache on LOCK for write. Deprecated as of MySQL 5.7.20.secure_auth: Disallow authentication for accounts that have old (pre-4.1) passwords. Deprecated as of MySQL 5.7.5.show_compatibility_56: Compatibility for SHOW STATUS/VARIABLES. Deprecated as of MySQL 5.7.6.show_old_temporals: Whether SHOW CREATE TABLE should indicate pre-5.6.4 temporal columns. Deprecated as of MySQL 5.7.6.skip-partition: Do not enable user-defined partitioning. Deprecated as of MySQL 5.7.16.sync_frm: Sync .frm to disk on create. Enabled by default. Deprecated as of MySQL 5.7.6.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. Deprecated as of MySQL 5.7.18.tx_isolation: The default transaction isolation level. Deprecated as of MySQL 5.7.20.tx_read_only: Default transaction access mode. Deprecated as of MySQL 5.7.20.
The following system variables, status variables, and options have been removed in MySQL 5.7.
Com_show_slave_status_nonblocking: Count of SHOW SLAVE STATUS NONBLOCKING statements. Removed in MySQL 5.7.6.Max_statement_time_exceeded: Number of statements that exceeded the execution timeout value. Removed in MySQL 5.7.8.Max_statement_time_set: Number of statements for which execution timeout was set. Removed in MySQL 5.7.8.Max_statement_time_set_failed: Number of statements for which execution timeout setting failed. Removed in MySQL 5.7.8.binlogging_impossible_mode: Deprecated and later removed. Use binlog_error_action instead. Removed in MySQL 5.7.6.default-authentication-plugin: The default authentication plugin. Removed in MySQL 5.7.2.executed_gtids_compression_period: Renamed to gtid_executed_compression_period. Removed in MySQL 5.7.6.innodb_additional_mem_pool_size: Size of a memory pool InnoDB uses to store data dictionary information and other internal data structures. Removed in MySQL 5.7.4.innodb_log_checksum_algorithm: Specifies how to generate and verify the checksum stored in each redo log disk block. Removed in MySQL 5.7.9.innodb_optimize_point_storage: Enable this option to store POINT data as fixed-length data rather than a variable-length data. Removed in MySQL 5.7.6.innodb_use_sys_malloc: Whether InnoDB uses the OS or its own memory allocator. Removed in MySQL 5.7.4.log-slow-admin-statements: Log slow OPTIMIZE, ANALYZE, ALTER and other administrative statements to the slow query log if it is open. Removed in MySQL 5.7.1.log-slow-slave-statements: Cause slow statements as executed by the slave to be written to the slow query log. Removed in MySQL 5.7.1.log_backward_compatible_user_definitions: Whether to log CREATE/ALTER USER, GRANT in backward-compatible fashion. Removed in MySQL 5.7.9.max_statement_time: Statement execution timeout value. Removed in MySQL 5.7.8.simplified_binlog_gtid_recovery: Renamed to binlog_gtid_simple_recovery. Removed in MySQL 5.7.6.storage_engine: The default storage engine. Removed in MySQL 5.7.5.thread_concurrency: Permits the application to give the threads system a hint for the desired number of threads that should be run at the same time. Removed in MySQL 5.7.2.timed_mutexes: Specify whether to time mutexes (only InnoDB mutexes are currently supported). Removed in MySQL 5.7.5.