MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide

1.4 Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 5.6

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

Options and Variables Introduced in MySQL 5.6

The following system variables, status variables, and server options have been added in MySQL 5.6.

Options and Variables Deprecated in MySQL 5.6

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

  • Delayed_errors: Number of rows written with INSERT DELAYED for which some error occurred. Deprecated as of MySQL 5.6.7.

  • Delayed_insert_threads: Number of INSERT DELAYED thread handlers in use. Deprecated as of MySQL 5.6.7.

  • Delayed_writes: Number of INSERT DELAYED rows written. Deprecated as of MySQL 5.6.7.

  • Not_flushed_delayed_rows: Number of rows waiting to be written in INSERT DELAY queues. Deprecated as of MySQL 5.6.7.

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

  • binlogging_impossible_mode: Deprecated and later removed. Use binlog_error_action instead. Deprecated as of MySQL 5.6.22.

  • delayed_insert_limit: After inserting delayed_insert_limit rows, INSERT DELAYED handler checks whether there are any SELECT statements pending. If so, it allows these to execute before continuing. Deprecated as of MySQL 5.6.7.

  • delayed_insert_timeout: How many seconds INSERT DELAYED thread should wait for INSERT statements before terminating. Deprecated as of MySQL 5.6.7.

  • delayed_queue_size: What size queue (in rows) should be allocated for handling INSERT DELAYED. Deprecated as of MySQL 5.6.7.

  • explicit_defaults_for_timestamp: Whether TIMESTAMP columns are nullable and have DEFAULT NULL. Deprecated as of MySQL 5.6.6.

  • have_profiling: Whether statement profiling capability is available. Deprecated as of MySQL 5.6.8.

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

  • innodb_additional_mem_pool_size: Size of memory pool InnoDB uses to store data dictionary information and other internal data structures. Deprecated as of MySQL 5.6.3.

  • innodb_checksums: Enable InnoDB checksums validation. Deprecated as of MySQL 5.6.3.

  • innodb_locks_unsafe_for_binlog: Force InnoDB not to use next-key locking. Instead use only row-level locking. Deprecated as of MySQL 5.6.3.

  • innodb_stats_sample_pages: Number of index pages to sample for index distribution statistics. Deprecated as of MySQL 5.6.3.

  • innodb_use_sys_malloc: Whether InnoDB uses OS or own memory allocator. Deprecated as of MySQL 5.6.3.

  • language: Client error messages in given language. May be given as full path. Deprecated as of MySQL 5.6.1.

  • master-retry-count: Number of tries replica makes to connect to source before giving up. Deprecated as of MySQL 5.6.1.

  • max_delayed_threads: Do not start more than this number of threads to handle INSERT DELAYED statements. If set to zero, which means INSERT DELAYED is not used. Deprecated as of MySQL 5.6.7.

  • max_insert_delayed_threads: Synonym for max_delayed_threads. Deprecated as of MySQL 5.6.7.

  • max_tmp_tables: Unused. Deprecated as of MySQL 5.6.7.

  • multi_range_count: Maximum number of ranges to send to table handler at once during range selects. Deprecated as of MySQL 5.6.7.

  • profiling: Enable or disable statement profiling. Deprecated as of MySQL 5.6.8.

  • profiling_history_size: How many statements to maintain profiling information for. Deprecated as of MySQL 5.6.8.

  • show_old_temporals: Whether SHOW CREATE TABLE should indicate pre-5.6.4 temporal columns. Deprecated as of MySQL 5.6.24.

  • simplified_binlog_gtid_recovery: Renamed to binlog_gtid_simple_recovery. Deprecated as of MySQL 5.6.23.

  • thread_concurrency: Permits application to provide hint to threads system for desired number of threads which should be run at one time. Deprecated as of MySQL 5.6.1.

  • timed_mutexes: Specify whether to time mutexes (only InnoDB mutexes are currently supported). Deprecated as of MySQL 5.6.20.

Options and Variables Removed in MySQL 5.6

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

  • Com_show_new_master: Count of SHOW NEW MASTER statements. Removed in MySQL 5.6.2.

  • bind-address: IP address or host name to bind to. Removed in MySQL 5.6.1.

  • disable-gtid-unsafe-statements: Obsolete: Replaced by enforce_gtid_consistency in MySQL 5.6.9. Removed in MySQL 5.6.9.

  • disable_gtid_unsafe_statements: Obsolete: Replaced by enforce_gtid_consistency in MySQL 5.6.9. Removed in MySQL 5.6.9.

  • engine_condition_pushdown: Push supported query conditions to storage engine. Removed in MySQL 5.6.1.

  • gtid_done: Obsolete: Replaced by gtid_executed in MySQL 5.6.9. Removed in MySQL 5.6.9.

  • gtid_lost: Obsolete: Replaced by gtid_purged in MySQL 5.6.9. Removed in MySQL 5.6.9.

  • have_csv: Whether mysqld supports csv tables. Removed in MySQL 5.6.1.

  • have_innodb: Whether mysqld supports InnoDB tables. Removed in MySQL 5.6.1.

  • have_partitioning: Whether mysqld supports partitioning. Removed in MySQL 5.6.1.

  • log: Log connections and queries to file. Removed in MySQL 5.6.1.

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

  • log-slow-slave-statements: Cause slow statements as executed by replica to be written to slow query log. Removed in MySQL 5.6.11.

  • log_slow_queries: Whether to log slow queries. Logging defaults to hostname-slow.log file. Must be enabled to activate other slow query log options. Removed in MySQL 5.6.1.

  • mysql_firewall_max_query_size: Maximum size of recorded statements. Removed in MySQL 5.6.26.

  • one-thread: Only use one thread (for debugging under Linux). Removed in MySQL 5.6.1.

  • optimizer_join_cache_level: How join buffers are used. Removed in MySQL 5.6.3.

  • safe-mode: Skip some optimization stages (for testing). Removed in MySQL 5.6.6.

  • skip-thread-priority: Do not give threads different priorities. Removed in MySQL 5.6.1.

  • sql_big_tables: This variable is deprecated, and is mapped to big_tables. Removed in MySQL 5.6.1.

  • sql_low_priority_updates: This variable is deprecated, and is mapped to low_priority_updates. Removed in MySQL 5.6.1.

  • sql_max_join_size: This variable is deprecated, and is mapped to max_join_size. Removed in MySQL 5.6.1.