Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.8Mb
PDF (A4) - 37.8Mb
PDF (RPM) - 36.4Mb
HTML Download (TGZ) - 9.9Mb
HTML Download (Zip) - 9.9Mb
HTML Download (RPM) - 8.6Mb
Man Pages (TGZ) - 209.5Kb
Man Pages (Zip) - 318.7Kb
Info (Gzip) - 3.5Mb
Info (Zip) - 3.5Mb
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.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.

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

  • executed-gtids-compression-period: Deprecated and will be removed in a future version; use the renamed gtid-executed-compression-period instead. Deprecated as of MySQL 5.7.6.

  • executed_gtids_compression_period: Deprecated and will be removed in a future version; use the renamed gtid_executed_compression_period instead. Deprecated as of MySQL 5.7.6.

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

  • simplified_binlog_gtid_recovery: Controls how binary logs are iterated during GTID recovery. 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.

Options and Variables Removed in MySQL 5.7

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

  • 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 will be removed in a future version. Use the renamed binlog_error_action instead.. Removed in MySQL 5.7.6.

  • default-authentication-plugin: The default authentication plugin. Removed in MySQL 5.7.2.

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

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


User Comments
Sign Up Login You must be logged in to post a comment.