Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.9Mb
PDF (A4) - 37.9Mb
PDF (RPM) - 37.2Mb
HTML Download (TGZ) - 10.2Mb
HTML Download (Zip) - 10.3Mb
HTML Download (RPM) - 8.9Mb
Man Pages (TGZ) - 214.6Kb
Man Pages (Zip) - 327.5Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
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. These are grouped into the following categories of options and variables:

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

Variables and Options Added or Removed in MySQL 5.7: Server/General

This section lists server variables and options of a general nature that were added or removed in MySQL 5.7.

Variables and Options Added in MySQL 5.7: Server/General

Variables and Options Deprecated in MySQL 5.7: Server/General

Variables and Options Removed in MySQL 5.7: Server/General

Variables and Options Added in MySQL 5.7: Server/General

Variables and Options Deprecated in MySQL 5.7: Server/General

  • avoid_temporal_upgrade: Whether ALTER TABLE should upgrade pre-5.6.4 temporal columns. Deprecated in MySQL 5.7.6.

  • bootstrap: Used by mysql installation scripts. Deprecated in MySQL 5.7.6.

  • log-warnings: Log some noncritical warnings to the log file. Deprecated in MySQL 5.7.2.

  • metadata_locks_cache_size: Size of the metadata locks cache. Deprecated in MySQL 5.7.4.

  • metadata_locks_hash_instances: Number of metadata lock hashes. Deprecated in MySQL 5.7.4.

  • show_compatibility_56: Compatibility for SHOW STATUS/VARIABLES. Deprecated in MySQL 5.7.6.

  • show_old_temporals: Whether SHOW CREATE TABLE should indicate pre-5.6.4 temporal columns. Deprecated in MySQL 5.7.6.

  • sync_frm: Sync .frm to disk on create. Enabled by default. Deprecated in MySQL 5.7.6.

Variables and Options Removed in MySQL 5.7: Server/General

Variables and Options Added or Removed in MySQL 5.7: InnoDB

This section lists server variables and options relating to the InnoDB storage engine that were added, deprecated, or removed in MySQL 5.7.

Variables and Options Added in MySQL 5.7: InnoDB

Variables and Options Deprecated in MySQL 5.7: InnoDB

Variables and Options Removed in MySQL 5.7: InnoDB

Variables and Options Added in MySQL 5.7: InnoDB

  • 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 dynamically. 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_buffer_pool_resize_status: The status of the dynamic buffer pool resizing operation. Added in MySQL 5.7.5.

  • innodb_compress_debug: Compresses all tables using a specified compression algorithm. Added in MySQL 5.7.8.

  • innodb_create_intrinsic: Enable this option to create performance-optimized temporary tables using CREATE TEMPORY TABLE syntax. Added in MySQL 5.7.5.

  • 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_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_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_sync_debug: Enables InnoDB sync debug checking. Added in MySQL 5.7.8.

  • innodb_temp_data_file_path: Defines the path to temporary tablespace data files and their sizes. Added in MySQL 5.7.1.

  • innodb_undo_log_truncate: Enable this option to mark the InnoDB undo tablespace for truncation. Added in MySQL 5.7.5.

  • mecab_rc_file: Defines the path to the mecabrc configuration file for the MeCab parser for InnoDB Full-Text Search. Added in MySQL 5.7.6.

  • ngram_token_size: Defines the n-gram token size for the InnoDB Full-Text Search n-gram parser. Added in MySQL 5.7.6.

Variables and Options Deprecated in MySQL 5.7: InnoDB

  • innodb: Enable InnoDB (if this version of MySQL supports it). Deprecated in MySQL 5.7.5.

  • innodb_file_format: The format for new InnoDB tables. Deprecated in MySQL 5.7.7.

  • innodb_file_format_check: Whether InnoDB performs file format compatibility checking. Deprecated in MySQL 5.7.7.

  • innodb_file_format_max: The file format tag in the shared tablespace. Deprecated in MySQL 5.7.7.

  • innodb_large_prefix: Enables longer keys for column prefix indexes. Deprecated in MySQL 5.7.7.

  • innodb_support_xa: Enable InnoDB support for the XA two-phase commit. Deprecated in MySQL 5.7.10.

Variables and Options Removed in MySQL 5.7: InnoDB

  • 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_create_intrinsic: Enable this option to create performance-optimized temporary tables using CREATE TEMPORY TABLE syntax. Removed in MySQL 5.7.6.

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

  • timed_mutexes: Specify whether to time mutexes (only InnoDB mutexes are currently supported). Removed in MySQL 5.7.5.

Variables and Options Added or Removed in MySQL 5.7: Replication/Binary Log

This section lists server variables and options relating to MySQL Replication and binary logging that were added or deprecated in MySQL 5.7. No variables or options relating to replication or binary logging have been removed in MySQL 5.7.

Variables and Options Added in MySQL 5.7: Replication and Binary Log

Variables and Options Deprecated in MySQL 5.7: Replication and Binary Log

Variables and Options Added in MySQL 5.7: Replication and Binary Log

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

  • Com_show_slave_status_nonblocking: Count of SHOW SLAVE STATUS NONBLOCKING statements. Added in MySQL 5.7.2.

  • executed-gtids-compression-period: Deprecated and will be removed in a future version. Use the renamed gtid-executed-compression-period instead. Added in MySQL 5.7.5.

  • executed_gtids_compression_period: Deprecated and will be removed in a future version. Use the renamed gtid_executed_compression_period instead. Added in MySQL 5.7.5.

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

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

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

  • slave-parallel-type: Tells the slave to use database partioning (DATABASE) or timestamp information (LOGICAL_CLOCK) from the master to parallelize transactions. The default is DATABASE. Added in MySQL 5.7.2.

  • slave_parallel_type: Tells the slave to use database partioning (DATABASE) or information (LOGICAL_CLOCK) from master to parallelize transactions. The default is DATABASE. 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 worker threads. Added in MySQL 5.7.5.

Variables and Options Deprecated in MySQL 5.7: Replication and Binary Log

  • avoid_temporal_upgrade: Whether ALTER TABLE should upgrade pre-5.6.4 temporal columns. Deprecated as of MySQL 5.7.6.

  • bootstrap: Used by mysql installation scripts. Deprecated as of MySQL 5.7.6.

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

  • partition: Enable (or disable) partitioning support. Deprecated as of MySQL 5.7.16.

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

Variables and Options Added or Removed in MySQL 5.7: Performance Schema

This section lists server variables and options relating to PERFORMANCE_SCHEMA that were added in MySQL 5.7. No variables or options relating to Performance Schema have been deprecated or removed in MySQL 5.7.


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