MySQL 5.6 Release Notes
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.
The following system variables, status variables, and options are new in MySQL 5.6, and have not been included in any previous release series.
Audit_log_current_size: Audit log file current size. Added in MySQL 5.6.20.Audit_log_event_max_drop_size: Size of largest dropped audited event. Added in MySQL 5.6.20.Audit_log_events: Number of handled audited events. Added in MySQL 5.6.20.Audit_log_events_filtered: Number of filtered audited events. Added in MySQL 5.6.20.Audit_log_events_lost: Number of dropped audited events. Added in MySQL 5.6.20.Audit_log_events_written: Number of written audited events. Added in MySQL 5.6.20.Audit_log_total_size: Combined size of written audited events. Added in MySQL 5.6.20.Audit_log_write_waits: Number of write-delayed audited events. Added in MySQL 5.6.20.Binlog_stmt_cache_disk_use: Number of nontransactional statements that used temporary file instead of binary log statement cache. Added in MySQL 5.6.1.Binlog_stmt_cache_use: Number of statements that used temporary binary log statement cache. Added in MySQL 5.6.1.Com_alter_user: Count of ALTER USER statements. Added in MySQL 5.6.6.Com_get_diagnostics: Count of GET DIAGNOSTICS statements. Added in MySQL 5.6.4.Connection_control_delay_generated: How many times server delayed connection request. Added in MySQL 5.6.35.Connection_errors_accept: Number of errors calling accept on listening port. Added in MySQL 5.6.5.Connection_errors_internal: Number of connections refused due to internal errors. Added in MySQL 5.6.5.Connection_errors_max_connections: Number of connections refused due to max_connections limit. Added in MySQL 5.6.5.Connection_errors_peer_address: Number of errors searching for connection client IP addresses. Added in MySQL 5.6.5.Connection_errors_select: Number of errors calling select/poll on listening port. Added in MySQL 5.6.5.Connection_errors_tcpwrap: Number of connections refused by libwrap. Added in MySQL 5.6.5.Firewall_access_denied: Number of statements rejected by MySQL Enterprise Firewall. Added in MySQL 5.6.24.Firewall_access_granted: Number of statements accepted by MySQL Enterprise Firewall. Added in MySQL 5.6.24.Firewall_cached_entries: Number of statements recorded by MySQL Enterprise Firewall. Added in MySQL 5.6.24.Handler_external_lock: Number of locks started while statement executed. Added in MySQL 5.6.2.Handler_mrr_init: Number of times storage engine MRR implementation is used for table access. Added in MySQL 5.6.1.Handler_read_last: Number of requests to read last index entry. Added in MySQL 5.6.1.Innodb_available_undo_logs: Total number of InnoDB rollback segments; different from innodb_rollback_segments, which displays number of active rollback segments. Added in MySQL 5.6.5.Innodb_buffer_pool_bytes_data: Number of bytes containing data (dirty or clean) in buffer pool. Added in MySQL 5.6.10.Innodb_buffer_pool_bytes_dirty: Number of bytes currently dirty in buffer pool. Added in MySQL 5.6.10.Innodb_buffer_pool_dump_status: Display status of buffer pool recording operation triggered by innodb_buffer_pool_dump_at_shutdown or innodb_buffer_pool_dump_now. Added in MySQL 5.6.3.Innodb_buffer_pool_load_status: Display status of buffer pool warmup operation triggered by innodb_buffer_pool_load_at_startup or innodb_buffer_pool_load_now. Added in MySQL 5.6.3.Innodb_num_open_files: Number of physical files currently opened by InnoDB. Added in MySQL 5.6.2.Last_query_partial_plans: Number of iterations in execution plan construction for previous statement. Added in MySQL 5.6.5.Performance_schema_accounts_lost: How many accounts table rows could not be added. Added in MySQL 5.6.3.Performance_schema_digest_lost: How many digests could not be instrumented. Added in MySQL 5.6.5.Performance_schema_hosts_lost: How many hosts table rows could not be added. Added in MySQL 5.6.3.Performance_schema_session_connect_attrs_lost: Number of connections for which attribute strings could not be created. Added in MySQL 5.6.6.Performance_schema_socket_classes_lost: How many socket instruments could not be loaded. Added in MySQL 5.6.3.Performance_schema_socket_instances_lost: How many socket instrument instances could not be created. Added in MySQL 5.6.3.Performance_schema_stage_classes_lost: How many stage instruments could not be loaded. Added in MySQL 5.6.3.Performance_schema_statement_classes_lost: How many statement instruments could not be loaded. Added in MySQL 5.6.3.Performance_schema_users_lost: How many users table rows could not be added. Added in MySQL 5.6.3.Rsa_public_key: sha256_password authentication plugin RSA public key value. Added in MySQL 5.6.6.Slave_last_heartbeat: Shows when latest heartbeat signal was received, in TIMESTAMP format. Added in MySQL 5.6.1.Slave_rows_last_search_algorithm_used: Search algorithm most recently used by this replica to locate rows for row-based replication (index, table, or hash scan). Added in MySQL 5.6.6.Ssl_server_not_after: SSL certificate last valid date. Added in MySQL 5.6.3.Ssl_server_not_before: SSL certificate first valid date. Added in MySQL 5.6.3.Table_open_cache_hits: Number of hits for open tables cache lookups. Added in MySQL 5.6.6.Table_open_cache_misses: Number of misses for open tables cache lookups. Added in MySQL 5.6.6.Table_open_cache_overflows: Number of overflows for open tables cache. Added in MySQL 5.6.6.audit-log: Whether to activate audit log plugin. Added in MySQL 5.6.10.audit_log_buffer_size: Size of audit log buffer. Added in MySQL 5.6.10.audit_log_connection_policy: Audit logging policy for connection-related events. Added in MySQL 5.6.20.audit_log_current_session: Whether to audit current session. Added in MySQL 5.6.20.audit_log_exclude_accounts: Accounts not to audit. Added in MySQL 5.6.20.audit_log_file: Name of audit log file. Added in MySQL 5.6.10.audit_log_flush: Close and reopen audit log file. Added in MySQL 5.6.10.audit_log_format: Audit log file format. Added in MySQL 5.6.14.audit_log_include_accounts: Accounts to audit. Added in MySQL 5.6.20.audit_log_policy: Audit logging policy. Added in MySQL 5.6.10.audit_log_rotate_on_size: Close and reopen audit log file at this size. Added in MySQL 5.6.10.audit_log_statement_policy: Audit logging policy for statement-related events. Added in MySQL 5.6.20.audit_log_strategy: Audit logging strategy. Added in MySQL 5.6.10.authentication_windows_log_level: Windows authentication plugin logging level. Added in MySQL 5.6.10.authentication_windows_use_principal_name: Whether to use Windows authentication plugin principal name. Added in MySQL 5.6.10.avoid_temporal_upgrade: Whether ALTER TABLE should upgrade pre-5.6.4 temporal columns. Added in MySQL 5.6.24.bind_address: IP address or host name to bind to. Added in MySQL 5.6.1.binlog-checksum: Enable/disable binary log checksums. Added in MySQL 5.6.2.binlog_checksum: Enable/disable binary log checksums. Added in MySQL 5.6.2.binlog_error_action: Controls what happens when server cannot write to binary log. Added in MySQL 5.6.22.binlog_gtid_simple_recovery: Controls how binary logs are iterated during GTID recovery. Added in MySQL 5.6.23.binlog_max_flush_queue_time: How long to read transactions before flushing to binary log. Added in MySQL 5.6.6.binlog_order_commits: Whether to commit in same order as writes to binary log. Added in MySQL 5.6.6.binlog_row_image: Use full or minimal images when logging row changes. Added in MySQL 5.6.2.binlog_rows_query_log_events: When enabled, enables logging of rows query log events when using row-based logging. Disabled by default. Do not enable when producing logs for pre-5.6 replicas/readers. Added in MySQL 5.6.2.binlog_stmt_cache_size: Size of cache to hold nontransactional statements for binary log during transaction. Added in MySQL 5.6.1.binlogging_impossible_mode: Deprecated and later removed. Use binlog_error_action instead. Added in MySQL 5.6.20.block_encryption_mode: Mode for block-based encryption algorithms. Added in MySQL 5.6.17.connection_control_failed_connections_threshold: Consecutive failed connection attempts before delays occur. Added in MySQL 5.6.35.connection_control_max_connection_delay: Maximum delay (milliseconds) for server response to failed connection attempts. Added in MySQL 5.6.35.connection_control_min_connection_delay: Minimum delay (milliseconds) for server response to failed connection attempts. Added in MySQL 5.6.35.core_file: Write core file on server crashes. Added in MySQL 5.6.2.daemon_memcached_enable_binlog: . Added in MySQL 5.6.6.daemon_memcached_engine_lib_name: Shared library implementing InnoDB memcached plugin. Added in MySQL 5.6.6.daemon_memcached_engine_lib_path: Directory which contains shared library implementing InnoDB memcached plugin. Added in MySQL 5.6.6.daemon_memcached_option: Space-separated options which are passed to underlying memcached daemon on startup. Added in MySQL 5.6.6.daemon_memcached_r_batch_size: Specifies how many memcached read operations to perform before doing COMMIT to start new transaction. Added in MySQL 5.6.6.daemon_memcached_w_batch_size: Specifies how many memcached write operations to perform before doing COMMIT to start new transaction. Added in MySQL 5.6.6.default-authentication-plugin: Default authentication plugin. Added in MySQL 5.6.6.default_tmp_storage_engine: Default storage engine (table type) for TEMPORARY tables. Added in MySQL 5.6.3.disable-gtid-unsafe-statements: Obsolete: Replaced by enforce_gtid_consistency in MySQL 5.6.9. Added in MySQL 5.6.5.disable_gtid_unsafe_statements: Obsolete: Replaced by enforce_gtid_consistency in MySQL 5.6.9. Added in MySQL 5.6.5.disconnect_on_expired_password: Whether server disconnects clients with expired passwords if clients cannot handle such accounts. Added in MySQL 5.6.10.end_markers_in_json: Whether optimizer JSON output should add end markers. Added in MySQL 5.6.5.enforce_gtid_consistency: Prevents execution of statements that cannot be logged in transactionally safe manner. Added in MySQL 5.6.9.eq_range_index_dive_limit: Cutoff for switching from index dives to index statistics. Added in MySQL 5.6.5.explicit_defaults_for_timestamp: Whether TIMESTAMP columns are nullable and have DEFAULT NULL. Added in MySQL 5.6.6.gtid_done: Obsolete: Replaced by gtid_executed in MySQL 5.6.9. Added in MySQL 5.6.5.gtid_executed: Global: All GTIDs in binary log (global) or current transaction (session). Read-only. Added in MySQL 5.6.9.gtid_lost: Obsolete: Replaced by gtid_purged in MySQL 5.6.9. Added in MySQL 5.6.5.gtid_mode: Controls whether GTID based logging is enabled and what type of transactions logs can contain. Added in MySQL 5.6.5.gtid_next: Specifies GTID for next statement to execute; see documentation for details. Added in MySQL 5.6.5.gtid_owned: Set of GTIDs owned by this client (session), or by all clients, together with thread ID of owner (global). Read-only. Added in MySQL 5.6.5.gtid_purged: Set of all GTIDs that have been purged from binary log. Added in MySQL 5.6.9.host_cache_size: Size of host cache. Added in MySQL 5.6.5.ignore-db-dir: Treat directory as nondatabase directory. Added in MySQL 5.6.3.ignore_db_dirs: Directories treated as nondatabase directories. Added in MySQL 5.6.3.innodb_adaptive_flushing_lwm: Low water mark representing percentage of redo log capacity at which adaptive flushing is enabled. Added in MySQL 5.6.6.innodb_adaptive_max_sleep_delay: Allows InnoDB to adjust value of innodb_thread_sleep_delay up or down automatically, according to current workload. Added in MySQL 5.6.3.innodb_api_bk_commit_interval: How often to auto-commit idle connections which use InnoDB memcached interface, in seconds. Added in MySQL 5.6.7.innodb_api_disable_rowlock: . Added in MySQL 5.6.6.innodb_api_enable_binlog: Allows use of InnoDB memcached plugin with MySQL binary log. Added in MySQL 5.6.6.innodb_api_enable_mdl: Locks table used by InnoDB memcached plugin, so that it cannot be dropped or altered by DDL through SQL interface. Added in MySQL 5.6.6.innodb_api_trx_level: Allows control of transaction isolation level on queries processed by memcached interface. Added in MySQL 5.6.6.innodb_buffer_pool_dump_at_shutdown: Specifies whether to record pages cached in InnoDB buffer pool when MySQL server is shut down, to shorten warmup process at next restart. Added in MySQL 5.6.3.innodb_buffer_pool_dump_now: Immediately record pages cached in InnoDB buffer pool. Added in MySQL 5.6.3.innodb_buffer_pool_filename: Specifies file containing list of page numbers produced by innodb_buffer_pool_dump_at_shutdown or innodb_buffer_pool_dump_now. Added in MySQL 5.6.3.innodb_buffer_pool_load_abort: Interrupts process of restoring InnoDB buffer pool contents triggered by innodb_buffer_pool_load_at_startup or innodb_buffer_pool_load_now. Added in MySQL 5.6.3.innodb_buffer_pool_load_at_startup: Specifies that, on MySQL server startup, InnoDB buffer pool is automatically "warmed up" by loading same pages it held at earlier time. Added in MySQL 5.6.3.innodb_buffer_pool_load_now: Immediately "warms up" InnoDB buffer pool by loading set of data pages, without waiting for server restart. Added in MySQL 5.6.3.innodb_change_buffer_max_size: Maximum size for InnoDB change buffer, as percentage of total size of buffer pool. Added in MySQL 5.6.2.innodb_checksum_algorithm: Specifies how to generate and verify checksum stored in each disk block of each InnoDB tablespace. Added in MySQL 5.6.3.innodb_cmp_per_index_enabled: Enables per-index compression-related statistics in INFORMATION_SCHEMA.INNODB_CMP_PER_INDEX table. Added in MySQL 5.6.7.innodb_compression_failure_threshold_pct: Cutoff point at which MySQL begins adding padding within compressed pages to avoid expensive compression failures. Added in MySQL 5.6.7.innodb_compression_level: Level of zlib compression to use for InnoDB compressed tables and indexes. Added in MySQL 5.6.7.innodb_compression_pad_pct_max: Maximum percentage that can be reserved as free space within each compressed page, to avoid compression failures when tightly packed data is recompressed. Added in MySQL 5.6.7.innodb_disable_sort_file_cache: Disable OS file system cache for merge-sort temporary files. Added in MySQL 5.6.4.innodb_fil_make_page_dirty_debug: Dirties first page of specified tablespace. Added in MySQL 5.6.17.innodb_flush_log_at_timeout: Write and flush logs every N seconds. Added in MySQL 5.6.6.innodb_flush_neighbors: Specifies whether or not flushing page from InnoDB buffer pool also flushes other dirty pages in same extent. Added in MySQL 5.6.3.innodb_flushing_avg_loops: Number of iterations for which InnoDB keeps previously calculated snapshot of flushing state, controlling how quickly adaptive flushing responds to changing workloads. Added in MySQL 5.6.6.innodb_force_load_corrupted: Lets InnoDB load tables at startup that are marked as corrupted; use only during troubleshooting. Added in MySQL 5.6.3.innodb_ft_aux_table: Qualified name of InnoDB table containing FULLTEXT index for diagnostic purposes. Added in MySQL 5.6.4.innodb_ft_cache_size: Size of cache holding parsed document in memory while creating InnoDB FULLTEXT index. Added in MySQL 5.6.4.innodb_ft_enable_diag_print: Whether to enable additional full-text search diagnostic output. Added in MySQL 5.6.4.innodb_ft_enable_stopword: Omit stop words from search index during creation of InnoDB FULLTEXT index. Added in MySQL 5.6.4.innodb_ft_max_token_size: Maximum length of words that are stored in InnoDB FULLTEXT index. Added in MySQL 5.6.4.innodb_ft_min_token_size: Minimum length of words that are stored in InnoDB FULLTEXT index. Added in MySQL 5.6.4.innodb_ft_num_word_optimize: Number of words to process during each OPTIMIZE TABLE operation on InnoDB FULLTEXT index. Added in MySQL 5.6.4.innodb_ft_result_cache_limit: InnoDB FULLTEXT search query result cache limit. Added in MySQL 5.6.13.innodb_ft_server_stopword_table: Specifies table holding list of stopwords for InnoDB FULLTEXT indexes, overriding default stopword list; can be overridden by innodb_ft_user_stopword_table. Added in MySQL 5.6.4.innodb_ft_sort_pll_degree: Number of threads used to create InnoDB FULLTEXT index in parallel, when building search index for large table. Added in MySQL 5.6.4.innodb_ft_total_cache_size: Total memory allocated for InnoDB FULLTEXT search index cache. Added in MySQL 5.6.13.innodb_ft_user_stopword_table: Specifies table holding list of stopwords for InnoDB FULLTEXT indexes, overriding default stopword list as well as innodb_ft_server_stopword_table. Added in MySQL 5.6.4.innodb_io_capacity_max: Limit up to which InnoDB is allowed to extend innodb_io_capacity setting in case of emergency. Added in MySQL 5.6.6.innodb_large_prefix: Enables longer keys for column prefix indexes. Added in MySQL 5.6.3.innodb_log_checkpoint_now: Debug option that forces InnoDB to write checkpoint. Added in MySQL 5.6.12.innodb_log_compressed_pages: Specifies whether images of re-compressed pages are stored in InnoDB redo logs. Added in MySQL 5.6.11.innodb_lru_scan_depth: Influences algorithms and heuristics for flush operation for InnoDB buffer pool. Added in MySQL 5.6.3.innodb_max_dirty_pages_pct_lwm: Low water mark representing percentage of dirty pages where preflushing is enabled to control dirty page ratio. Added in MySQL 5.6.6.innodb_max_purge_lag_delay: Maximum delay in milliseconds for formula calculated using innodb_max_purge_lag configuration option. Added in MySQL 5.6.5.innodb_monitor_disable: Turns off one or more counters in information_schema.innodb_metrics table. Added in MySQL 5.6.2.innodb_monitor_enable: Turns on one or more counters in information_schema.innodb_metrics table. Added in MySQL 5.6.2.innodb_monitor_reset: Resets count value for one or more counters in information_schema.innodb_metrics table to zero. Added in MySQL 5.6.2.innodb_monitor_reset_all: Resets all values (minimum, maximum, and so on) for one or more counters in information_schema.innodb_metrics table. Added in MySQL 5.6.2.innodb_numa_interleave: Enables NUMA MPOL_INTERLEAVE memory policy for allocation of InnoDB buffer pool. Added in MySQL 5.6.27.innodb_online_alter_log_max_size: Upper limit on size of temporary log files used during online DDL operations for InnoDB tables. Added in MySQL 5.6.6.innodb_optimize_fulltext_only: Causes OPTIMIZE TABLE statement for InnoDB table to process newly added, deleted, and updated token data for FULLTEXT index, rather than to reorganize data in clustered index of table. Added in MySQL 5.6.4.innodb_page_size: Specifies page size for all InnoDB tablespaces in instance. Added in MySQL 5.6.4.innodb_print_all_deadlocks: During shutdown, prints information about all InnoDB deadlocks to server error log. Added in MySQL 5.6.2.innodb_random_read_ahead: Enables random read-ahead technique for optimizing InnoDB I/O. Added in MySQL 5.6.3.innodb_read_only: Starts server in read-only mode. Added in MySQL 5.6.7.innodb_rollback_segments: Defines number of rollback segments in system tablespace for InnoDB to use within transaction. Added in MySQL 5.6.2.innodb_saved_page_number_debug: Saves page number. Added in MySQL 5.6.17.innodb_sort_buffer_size: Specifies size of buffer used for sorting data during creation of InnoDB index. Added in MySQL 5.6.4.innodb_stats_auto_recalc: Causes InnoDB to recalculate persistent statistics automatically after table data is changed substantially. Added in MySQL 5.6.6.innodb_stats_include_delete_marked: Include delete-marked records when calculating persistent InnoDB statistics. Added in MySQL 5.6.35.innodb_stats_method: Specifies how InnoDB index statistics collection code should treat NULLs. Added in MySQL 5.6.2.innodb_stats_persistent: Turns on InnoDB persistent statistics feature. Added in MySQL 5.6.6.innodb_stats_persistent_sample_pages: Number of pages to sample in each InnoDB index, when persistent statistics feature is also enabled. Added in MySQL 5.6.2.innodb_stats_transient_sample_pages: Number of pages to sample in each InnoDB index, when persistent statistics feature is turned off (default). Added in MySQL 5.6.2.innodb_status_output: Used to enable or disable periodic output for standard InnoDB Monitor. Also used in combination with innodb_status_output_locks to enable and disable periodic output for InnoDB Lock Monitor. Added in MySQL 5.6.16.innodb_status_output_locks: Used to enable or disable periodic output for standard InnoDB Lock Monitor. innodb_status_output must also be enabled to produce periodic output for InnoDB Lock Monitor. Added in MySQL 5.6.16.innodb_sync_array_size: Splits internal data structure used to coordinate threads, for higher concurrency in workloads with large numbers of waiting threads. Added in MySQL 5.6.3.innodb_tmpdir: Directory location for temporary table files created during online ALTER TABLE operations. Added in MySQL 5.6.29.innodb_undo_directory: Relative or absolute directory path where InnoDB creates separate tablespaces for undo logs; typically used to place those logs on different storage device. Added in MySQL 5.6.3.innodb_undo_logs: Number of undo logs (rollback segments) used by InnoDB; alias for innodb_rollback_segments. Added in MySQL 5.6.3.innodb_undo_tablespaces: Number of tablespace files that rollback segments are divided between. Added in MySQL 5.6.3.log-raw: Whether to log queries without rewriting. Added in MySQL 5.6.3.log_bin_basename: Path and base name for binary log files. Added in MySQL 5.6.2.log_bin_use_v1_row_events: Whether server is using version 1 binary log row events. Added in MySQL 5.6.6.log_slow_admin_statements: Log slow OPTIMIZE, ANALYZE, ALTER and other administrative statements to slow query log if it is open. Added in MySQL 5.6.11.log_slow_slave_statements: Cause slow statements as executed by replica to be written to slow query log. Added in MySQL 5.6.11.log_throttle_queries_not_using_indexes: Throttle write rate to slow log for queries not using indexes slow query log if it is open. Added in MySQL 5.6.5.master_info_repository: Whether to write connection metadata repository, containing source information and replication I/O thread location in source's binary log, to file or table. Added in MySQL 5.6.2.master_verify_checksum: Cause source to examine checksums when reading from binary log. Added in MySQL 5.6.2.max_binlog_stmt_cache_size: Can be used to restrict total size used to cache all nontransactional statements during transaction. Added in MySQL 5.6.1.max_digest_length: Maximum digest size in bytes. Added in MySQL 5.6.24.metadata_locks_cache_size: Size of metadata locks cache. Added in MySQL 5.6.4.metadata_locks_hash_instances: Number of metadata lock hashes. Added in MySQL 5.6.8.mysql_firewall_max_query_size: Maximum size of recorded statements. Added in MySQL 5.6.24.mysql_firewall_mode: Whether MySQL Enterprise Firewall is operational. Added in MySQL 5.6.24.mysql_firewall_trace: Whether to enable firewall trace. Added in MySQL 5.6.24.named_pipe_full_access_group: Name of Windows group granted full access to named pipe. Added in MySQL 5.6.43.optimizer_join_cache_level: How join buffers are used. Added in MySQL 5.6.1.optimizer_trace: Control optimizer tracing. Added in MySQL 5.6.3.optimizer_trace_features: Control optimizer tracing. Added in MySQL 5.6.3.optimizer_trace_limit: Control optimizer tracing. Added in MySQL 5.6.3.optimizer_trace_max_mem_size: Control optimizer tracing. Added in MySQL 5.6.3.optimizer_trace_offset: Control optimizer tracing. Added in MySQL 5.6.3.performance-schema-consumer-events-stages-current: Configure events-stages-current consumer. Added in MySQL 5.6.4.performance-schema-consumer-events-stages-history: Configure events-stages-history consumer. Added in MySQL 5.6.4.performance-schema-consumer-events-stages-history-long: Configure events-stages-history-long consumer. Added in MySQL 5.6.4.performance-schema-consumer-events-statements-current: Configure events-statements-current consumer. Added in MySQL 5.6.4.performance-schema-consumer-events-statements-history: Configure events-statements-history consumer. Added in MySQL 5.6.4.performance-schema-consumer-events-statements-history-long: Configure events-statements-history-long consumer. Added in MySQL 5.6.4.performance-schema-consumer-events-waits-current: Configure events-waits-current consumer. Added in MySQL 5.6.4.performance-schema-consumer-events-waits-history: Configure events-waits-history consumer. Added in MySQL 5.6.4.performance-schema-consumer-events-waits-history-long: Configure events-waits-history-long consumer. Added in MySQL 5.6.4.performance-schema-consumer-global-instrumentation: Configure global-instrumentation consumer. Added in MySQL 5.6.4.performance-schema-consumer-statements-digest: Configure statements-digest consumer. Added in MySQL 5.6.5.performance-schema-consumer-thread-instrumentation: Configure thread-instrumentation consumer. Added in MySQL 5.6.4.performance-schema-instrument: Configure Performance Schema instrument. Added in MySQL 5.6.4.performance_schema_accounts_size: Number of rows in accounts table. Added in MySQL 5.6.3.performance_schema_digests_size: Number of rows in events_statements_summary_by_digest table. Added in MySQL 5.6.5.performance_schema_events_stages_history_long_size: Number of rows in events_stages_history_long table. Added in MySQL 5.6.3.performance_schema_events_stages_history_size: Number of rows per thread in events_stages_history table. Added in MySQL 5.6.3.performance_schema_events_statements_history_long_size: Number of rows in events_statements_history_long table. Added in MySQL 5.6.3.performance_schema_events_statements_history_size: Number of rows per thread in events_statements_history table. Added in MySQL 5.6.3.performance_schema_hosts_size: Number of rows in hosts table. Added in MySQL 5.6.3.performance_schema_max_digest_length: Maximum Performance Schema digest size in bytes. Added in MySQL 5.6.26.performance_schema_max_socket_classes: Maximum number of socket instruments. Added in MySQL 5.6.3.performance_schema_max_socket_instances: Maximum number of instrumented socket objects. Added in MySQL 5.6.3.performance_schema_max_stage_classes: Maximum number of stage instruments. Added in MySQL 5.6.3.performance_schema_max_statement_classes: Maximum number of statement instruments. Added in MySQL 5.6.3.performance_schema_session_connect_attrs_size: Size of connection attribute strings buffer per thread. Added in MySQL 5.6.6.performance_schema_setup_actors_size: Number of rows in setup_actors table. Added in MySQL 5.6.1.performance_schema_setup_objects_size: Number of rows in setup_objects table. Added in MySQL 5.6.1.performance_schema_users_size: Number of rows in users table. Added in MySQL 5.6.3.plugin-load-add: Add to list of plugins to load at startup. Added in MySQL 5.6.3.pseudo_slave_mode: For internal server use. Added in MySQL 5.6.10.relay_log_basename: Complete path to relay log, including file name. Added in MySQL 5.6.2.relay_log_info_repository: Whether to write location of replication SQL thread in relay logs to file or table. Added in MySQL 5.6.2.rpl_stop_slave_timeout: Number of seconds that STOP REPLICA or STOP SLAVE waits before timing out. Added in MySQL 5.6.13.sha256_password_private_key_path: SHA256 authentication plugin private key path name. Added in MySQL 5.6.6.sha256_password_public_key_path: SHA256 authentication plugin public key path name. Added in MySQL 5.6.6.show_old_temporals: Whether SHOW CREATE TABLE should indicate pre-5.6.4 temporal columns. Added in MySQL 5.6.24.simplified_binlog_gtid_recovery: Renamed to binlog_gtid_simple_recovery. Added in MySQL 5.6.21.slave-sql-verify-checksum: Cause replica to examine checksums when reading from relay log. Added in MySQL 5.6.2.slave_checkpoint_group: Maximum number of transactions processed by multithreaded replica before checkpoint operation is called to update progress status. Not supported by NDB Cluster. Added in MySQL 5.6.3.slave_checkpoint_period: Update progress status of multithreaded replica and flush relay log info to disk after this number of milliseconds. Not supported by NDB Cluster. Added in MySQL 5.6.3.slave_max_allowed_packet: Maximum size, in bytes, of packet that can be sent from replication source server to replica; overrides max_allowed_packet. Added in MySQL 5.6.6.slave_parallel_workers: Number of applier threads for executing replication transactions in parallel. 0 disables replica multithreading. Not supported by MySQL Cluster. Added in MySQL 5.6.3.slave_pending_jobs_size_max: Maximum size of replica worker queues holding events not yet applied. Added in MySQL 5.6.3.slave_rows_search_algorithms: Determines search algorithms used for replica update batching. Any 2 or 3 from this list: INDEX_SEARCH, TABLE_SCAN, HASH_SCAN. Added in MySQL 5.6.6.slave_sql_verify_checksum: Cause replica to examine checksums when reading from relay log. Added in MySQL 5.6.2.slow-start-timeout: Wait before trying to kill windows service at startup. Added in MySQL 5.6.5.ssl_crl: File that contains certificate revocation lists. Added in MySQL 5.6.3.ssl_crlpath: Directory that contains certificate revocation list files. Added in MySQL 5.6.3.stored_program_cache: Sets "soft" upper limit for number of cached stored routines per connection. Stored procedures and stored functions are cached separately; this variable sets size for both of these. Added in MySQL 5.6.5.table_open_cache_instances: Number of open tables cache instances. Added in MySQL 5.6.6.thread_pool_algorithm: Thread pool algorithm. Added in MySQL 5.6.10.thread_pool_high_priority_connection: Whether current session is high priority. Added in MySQL 5.6.10.thread_pool_max_unused_threads: Maximum permissible number of unused threads. Added in MySQL 5.6.10.thread_pool_prio_kickup_timer: How long before statement is moved to high-priority execution. Added in MySQL 5.6.10.thread_pool_size: Number of thread groups in thread pool. Added in MySQL 5.6.10.thread_pool_stall_limit: How long before statement is defined as stalled. Added in MySQL 5.6.10.transaction-read-only: Default transaction access mode. Added in MySQL 5.6.5.tx_read_only: Default transaction access mode. Added in MySQL 5.6.5.validate-password: Whether to activate password validation plugin. Added in MySQL 5.6.6.validate_password_dictionary_file: validate_password dictionary file. Added in MySQL 5.6.6.validate_password_dictionary_file_last_parsed: When dictionary file was last parsed. Added in MySQL 5.6.26.validate_password_dictionary_file_words_count: Number of words in dictionary file. Added in MySQL 5.6.26.validate_password_length: validate_password required password length. Added in MySQL 5.6.6.validate_password_mixed_case_count: validate_password required number of uppercase/lowercase characters. Added in MySQL 5.6.6.validate_password_number_count: validate_password required number of digit characters. Added in MySQL 5.6.6.validate_password_policy: validate_password password policy. Added in MySQL 5.6.6.validate_password_special_char_count: validate_password required number of special characters. Added in MySQL 5.6.6.validate_user_plugins: Whether to perform additional validation of user plugins. Added in MySQL 5.6.11.
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.
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.