Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 36.3Mb
PDF (A4) - 36.3Mb
PDF (RPM) - 36.2Mb
HTML Download (TGZ) - 10.4Mb
HTML Download (Zip) - 10.4Mb
HTML Download (RPM) - 9.2Mb
Man Pages (TGZ) - 224.6Kb
Man Pages (Zip) - 332.7Kb
Info (Gzip) - 3.3Mb
Info (Zip) - 3.3Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  General Information  /  Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 5.7

1.4 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.

Options and Variables Introduced 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.

Options and Variables Deprecated in MySQL 5.7

The following system variables, status variables, and options have been deprecated in MySQL 5.7.

  • Innodb_available_undo_logs: Total number of InnoDB rollback segments; different from innodb_rollback_segments, which displays number of active rollback segments. Deprecated as of MySQL 5.7.19.

  • Qcache_free_blocks: Number of free memory blocks in query cache. Deprecated as of MySQL 5.7.20.

  • Qcache_free_memory: Amount of free memory for 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 which were deleted from query cache due to lack of free memory in cache. Deprecated as of MySQL 5.7.20.

  • Qcache_not_cached: Number of noncached queries (not cacheable, or not cached due to query_cache_type setting). Deprecated as of MySQL 5.7.20.

  • Qcache_queries_in_cache: Number of queries registered in query cache. Deprecated as of MySQL 5.7.20.

  • Qcache_total_blocks: Total number of blocks in query cache. Deprecated as of MySQL 5.7.20.

  • Slave_heartbeat_period: Replica's replication heartbeat interval, in seconds. Deprecated as of MySQL 5.7.6.

  • Slave_last_heartbeat: Shows when latest heartbeat signal was received, in TIMESTAMP format. Deprecated as of MySQL 5.7.6.

  • Slave_received_heartbeats: Number of heartbeats received by replica since previous reset. Deprecated as of MySQL 5.7.6.

  • Slave_retried_transactions: Total number of times since startup that replication SQL thread has retried transactions. Deprecated as of MySQL 5.7.6.

  • Slave_running: State of this server as replica (replication 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 startup check for tables without native partitioning. Deprecated as of MySQL 5.7.17.

  • group_replication_allow_local_disjoint_gtids_join: Allow current server to join group even if it has transactions not present in group. Deprecated as of MySQL 5.7.21.

  • have_crypt: Availability of 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: 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: File format tag in 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 XA two-phase commit. Deprecated as of MySQL 5.7.10.

  • innodb_undo_logs: Number of undo logs (rollback segments) used by InnoDB; 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: Write some noncritical warnings to log file. Deprecated as of MySQL 5.7.2.

  • metadata_locks_cache_size: Size of 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 is trimmed after writing all result data). Deprecated as of MySQL 5.7.20.

  • query_cache_size: 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 causes most temporary files created to use small set of names, rather than unique name for each new file. Deprecated as of MySQL 5.7.18.

  • tx_isolation: 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.

Options and Variables Removed in MySQL 5.7

The following system variables, status variables, and options have been removed in MySQL 5.7.

  • Com_show_slave_status_nonblocking: Count of SHOW REPLICA | SLAVE STATUS NONBLOCKING statements. Removed in MySQL 5.7.6.

  • Max_statement_time_exceeded: Number of statements that exceeded 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: 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 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 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 variable-length data. Removed in MySQL 5.7.6.

  • innodb_use_sys_malloc: Whether InnoDB uses OS or own memory allocator. Removed in MySQL 5.7.4.

  • log-slow-admin-statements: Log slow OPTIMIZE, ANALYZE, ALTER and other administrative statements to slow query log if it is open. Removed in MySQL 5.7.1.

  • log-slow-slave-statements: Cause slow statements as executed by replica to be written to 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: Default storage engine. Removed in MySQL 5.7.5.

  • thread_concurrency: Permits application to provide hint to threads system for desired number of threads which should be run at one 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.