Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 32.6Mb
PDF (A4) - 32.6Mb
PDF (RPM) - 30.7Mb
HTML Download (TGZ) - 7.8Mb
HTML Download (Zip) - 7.9Mb
HTML Download (RPM) - 6.7Mb
Man Pages (TGZ) - 143.2Kb
Man Pages (Zip) - 202.4Kb
Info (Gzip) - 3.0Mb
Info (Zip) - 3.0Mb


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-06-27

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.

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

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

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

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


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