Documentation Home
MySQL 5.6 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 31.2Mb
PDF (A4) - 31.3Mb
PDF (RPM) - 29.5Mb
HTML Download (TGZ) - 7.3Mb
HTML Download (Zip) - 7.3Mb
HTML Download (RPM) - 6.2Mb
Man Pages (TGZ) - 180.3Kb
Man Pages (Zip) - 290.3Kb
Info (Gzip) - 3.0Mb
Info (Zip) - 3.0Mb
Excerpts from this Manual

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

1.5 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 options are new in MySQL 5.6, and have not been included in any previous release series.

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, the INSERT DELAYED handler will check if 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 an 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 a 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 the OS or its own memory allocator. Deprecated as of MySQL 5.6.3.

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

  • master-retry-count: Number of tries the slave makes to connect to the master 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: This variable is a 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: The maximum number of ranges to send to a 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 the application to give the threads system a hint for the desired number of threads that should be run at the same 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 the 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 the slow query log if it is open. Removed in MySQL 5.6.11.

  • log-slow-slave-statements: Cause slow statements as executed by the slave to be written to the 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.