Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 34.6Mb
PDF (A4) - 34.6Mb
PDF (RPM) - 32.3Mb
HTML Download (TGZ) - 8.2Mb
HTML Download (Zip) - 8.2Mb
HTML Download (RPM) - 7.0Mb
Man Pages (TGZ) - 147.5Kb
Man Pages (Zip) - 208.8Kb
Info (Gzip) - 3.1Mb
Info (Zip) - 3.2Mb

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

Pre-General Availability Draft: 2017-12-16

1.5 Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.0

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.

Where applicable, separate lists have been provided—for variables and options which have been added, removed, or deprecated —within each section.

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

Options and Variables Deprecated in MySQL 8.0

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

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

  • symbolic-links: Permit symbolic links for MyISAM tables. Deprecated as of MySQL 8.0.2.

Options and Variables Removed in MySQL 8.0

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

  • bootstrap: Used by mysql installation scripts. Removed in MySQL 8.0.0.

  • Com_alter_db_upgrade: Count of ALTER DATABASE ... UPGRADE DATA DIRECTORY NAME statements. 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.

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

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

  • log-warnings: Log some noncritical warnings to the log file. Removed in MySQL 8.0.3.

  • log_error_filter_rules: Filter rules for error logging. Removed in MySQL 8.0.4.

  • max_tmp_tables: Unused. Removed in MySQL 8.0.3.

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

  • partition: Enable (or disable) partitioning support. Removed in MySQL 8.0.0.

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

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

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

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

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