Related Documentation Download this Manual
PDF (US Ltr) - 29.0Mb
PDF (A4) - 29.0Mb
PDF (RPM) - 28.0Mb
HTML Download (TGZ) - 7.1Mb
HTML Download (Zip) - 7.1Mb
HTML Download (RPM) - 6.1Mb
Man Pages (TGZ) - 182.1Kb
Man Pages (Zip) - 291.7Kb
Info (Gzip) - 2.8Mb
Info (Zip) - 2.8Mb
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.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 in MySQL 5.6.7.

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

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

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

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

  • binlogging_impossible_mode: Deprecated and later removed. Use binlog_error_action instead. Deprecated in 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 in MySQL 5.6.7.

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

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

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

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

  • innodb: Enable InnoDB (if this version of MySQL supports it). Deprecated in 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 in MySQL 5.6.3.

  • innodb_checksums: Enable InnoDB checksums validation. Deprecated in MySQL 5.6.3.

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

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

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

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

  • master-retry-count: Number of tries replica makes to connect to source before giving up. Deprecated in 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 in MySQL 5.6.7.

  • max_insert_delayed_threads: Synonym for max_delayed_threads. Deprecated in MySQL 5.6.7.

  • max_tmp_tables: Unused. Deprecated in MySQL 5.6.7.

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

  • profiling: Enable or disable statement profiling. Deprecated in MySQL 5.6.8.

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

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

  • simplified_binlog_gtid_recovery: Renamed to binlog_gtid_simple_recovery. Deprecated in 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 in MySQL 5.6.1.

  • timed_mutexes: Specify whether to time mutexes (only InnoDB mutexes are currently supported). Deprecated in 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.