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 a temporary file instead of the binary log statement cache. Added in MySQL 5.6.1.Binlog_stmt_cache_use: Number of statements that used the 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 the server delayed a connection request. Added in MySQL 5.6.35.Connection_errors_accept: Number of errors calling accept on the 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 the 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 the 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 a 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 the last index entry. Added in MySQL 5.6.1.Innodb_available_undo_logs: Display the total number of InnoDB rollback segments; different from innodb_rollback_segments, which displays the 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 the buffer pool. Added in MySQL 5.6.10.Innodb_buffer_pool_bytes_dirty: Number of bytes currently dirty in the 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 the 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 the 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 slave 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 the open tables cache. Added in MySQL 5.6.6.audit-log: Whether to activate the audit log plugin. Added in MySQL 5.6.10.audit_log_buffer_size: The size of the 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: The name of the audit log file. Added in MySQL 5.6.10.audit_log_flush: Close and reopen the audit log file. Added in MySQL 5.6.10.audit_log_format: The 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 the audit log file at a certain 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: The 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 the server cannot write to the 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 slaves/readers. Added in MySQL 5.6.2.binlog_stmt_cache_size: Size of the cache to hold nontransactional statements for the binary log during a 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: Specifies the shared library that implements the InnoDB memcached plugin. Added in MySQL 5.6.6.daemon_memcached_engine_lib_path: Directory that contains the shared library that implements the InnoDB memcached plugin. Added in MySQL 5.6.6.daemon_memcached_option: Space-separated options that are passed to the 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 a COMMIT to start a new transaction. Added in MySQL 5.6.6.daemon_memcached_w_batch_size: Specifies how many memcached write operations to perform before doing a COMMIT to start a new transaction. Added in MySQL 5.6.6.default-authentication-plugin: The default authentication plugin. Added in MySQL 5.6.6.default_tmp_storage_engine: The 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 a transactionally safe manner. Added in MySQL 5.6.9.eq_range_index_dive_limit: The 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 the 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 the logs can contain. Added in MySQL 5.6.5.gtid_next: Specifies the GTID for the next statement to execute; see documentation for details. Added in MySQL 5.6.5.gtid_owned: The set of GTIDs owned by this client (session), or by all clients, together with the thread ID of the owner (global). Read-only. Added in MySQL 5.6.5.gtid_purged: The set of all GTIDs that have been purged from the binary log. Added in MySQL 5.6.9.host_cache_size: Size of the 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 automatically adjust the value of innodb_thread_sleep_delay up or down according to the current workload. Added in MySQL 5.6.3.innodb_api_bk_commit_interval: How often to auto-commit idle connections that use the 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: Lets you use the InnoDB memcached plugin with the MySQL binary log. Added in MySQL 5.6.6.innodb_api_enable_mdl: Locks the table used by the InnoDB memcached plugin, so that it cannot be dropped or altered by DDL through the SQL interface. Added in MySQL 5.6.6.innodb_api_trx_level: Lets you control the transaction isolation level on queries processed by the memcached interface. Added in MySQL 5.6.6.innodb_buffer_pool_dump_at_shutdown: Specifies whether to record the pages cached in the InnoDB buffer pool when the MySQL server is shut down, to shorten the warmup process at the next restart. Added in MySQL 5.6.3.innodb_buffer_pool_dump_now: Immediately records the pages cached in the InnoDB buffer pool. Added in MySQL 5.6.3.innodb_buffer_pool_filename: Specifies the file that holds the 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, the InnoDB buffer pool is automatically "warmed up" by loading the same pages it held at an earlier time. Added in MySQL 5.6.3.innodb_buffer_pool_load_now: Immediately "warms up" the InnoDB buffer pool by loading a set of data pages, without waiting for a server restart. Added in MySQL 5.6.3.innodb_change_buffer_max_size: Maximum size for the InnoDB change buffer, as a percentage of the total size of buffer pool. Added in MySQL 5.6.2.innodb_checksum_algorithm: Specifies how to generate and verify the 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 the INFORMATION_SCHEMA.INNODB_CMP_PER_INDEX table. Added in MySQL 5.6.7.innodb_compression_failure_threshold_pct: Sets the 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: Specifies the level of zlib compression to use for InnoDB compressed tables and indexes. Added in MySQL 5.6.7.innodb_compression_pad_pct_max: Specifies the 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 the first page of the 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 a page from the InnoDB buffer pool also flushes other dirty pages in the same extent. Added in MySQL 5.6.3.innodb_flushing_avg_loops: Number of iterations for which InnoDB keeps the previously calculated snapshot of the 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: Specifies the qualified name of an InnoDB table containing a FULLTEXT index for diagnostic purposes. Added in MySQL 5.6.4.innodb_ft_cache_size: Size of the cache that holds a parsed document in memory while creating an 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: During creation of an InnoDB FULLTEXT index, omits stopwords from the search index. Added in MySQL 5.6.4.innodb_ft_max_token_size: Maximum length of words that are stored in an InnoDB FULLTEXT index. Added in MySQL 5.6.4.innodb_ft_min_token_size: Minimum length of words that are stored in an 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 an InnoDB FULLTEXT index. Added in MySQL 5.6.4.innodb_ft_result_cache_limit: The InnoDB FULLTEXT search query result cache limit. Added in MySQL 5.6.13.innodb_ft_server_stopword_table: Specifies a table holding a list of stopwords for InnoDB FULLTEXT indexes, which overrides the default stopword list and 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 an InnoDB FULLTEXT index in parallel, when building a search index for a large table. Added in MySQL 5.6.4.innodb_ft_total_cache_size: The total memory allocated for the InnoDB FULLTEXT search index cache. Added in MySQL 5.6.13.innodb_ft_user_stopword_table: Specifies a table holding a list of stopwords for InnoDB FULLTEXT indexes, which overrides the default stopword list and also innodb_ft_server_stopword_table. Added in MySQL 5.6.4.innodb_io_capacity_max: The limit up to which InnoDB is allowed to extend the 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: A debug option that forces InnoDB to write a 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 the algorithms and heuristics for the flush operation for the 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 the dirty page ratio. Added in MySQL 5.6.6.innodb_max_purge_lag_delay: Specifies the maximum delay in milliseconds for the formula calculated using the innodb_max_purge_lag configuration option. Added in MySQL 5.6.5.innodb_monitor_disable: Turns off one or more counters in the information_schema.innodb_metrics table. Added in MySQL 5.6.2.innodb_monitor_enable: Turns on one or more counters in the information_schema.innodb_metrics table. Added in MySQL 5.6.2.innodb_monitor_reset: Resets to zero the count value for one or more counters in the information_schema.innodb_metrics table. Added in MySQL 5.6.2.innodb_monitor_reset_all: Resets all values (minimum, maximum, and so on) for one or more counters in the information_schema.innodb_metrics table. Added in MySQL 5.6.2.innodb_numa_interleave: Enables the NUMA MPOL_INTERLEAVE memory policy for allocation of the InnoDB buffer pool. Added in MySQL 5.6.27.innodb_online_alter_log_max_size: Specifies an upper limit on size of the temporary log files used during online DDL operations for InnoDB tables. Added in MySQL 5.6.6.innodb_optimize_fulltext_only: Makes the OPTIMIZE TABLE statement for an InnoDB table process the newly added, deleted, and updated token data for a FULLTEXT index, rather than reorganizing the data in the clustered index of the table. Added in MySQL 5.6.4.innodb_page_size: Specifies the page size for all InnoDB tablespaces in an instance. Added in MySQL 5.6.4.innodb_print_all_deadlocks: During shutdown, prints information about all InnoDB deadlocks to the server error log. Added in MySQL 5.6.2.innodb_random_read_ahead: Enables the random read-ahead technique for optimizing InnoDB I/O. Added in MySQL 5.6.3.innodb_read_only: Starts the server in read-only mode. Added in MySQL 5.6.7.innodb_rollback_segments: Defines how many of the rollback segments in the system tablespace that InnoDB uses within a transaction. Added in MySQL 5.6.2.innodb_saved_page_number_debug: Saves a page number. Added in MySQL 5.6.17.innodb_sort_buffer_size: Specifies size of a buffer used for sorting data during creation of an InnoDB index. Added in MySQL 5.6.4.innodb_stats_auto_recalc: Causes InnoDB to automatically recalculate persistent statistics after the data in a table 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 the 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 the 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 the persistent statistics feature is turned off (the default setting). Added in MySQL 5.6.2.innodb_status_output: Used to enable or disable periodic output for the standard InnoDB Monitor. Also used in combination with innodb_status_output_locks to enable and disable periodic output for the InnoDB Lock Monitor. Added in MySQL 5.6.16.innodb_status_output_locks: Used to enable or disable periodic output for the standard InnoDB Lock Monitor. innodb_status_output must also be enabled to produce periodic output for the InnoDB Lock Monitor. Added in MySQL 5.6.16.innodb_sync_array_size: Splits an 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: The directory location for the temporary table files created during online ALTER TABLE operations. Added in MySQL 5.6.29.innodb_undo_directory: The relative or absolute directory path where InnoDB creates separate tablespaces for the undo logs; typically used to place those logs on a different storage device. Added in MySQL 5.6.3.innodb_undo_logs: Defines the number of undo logs (rollback segments) used by InnoDB; an 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 the slow query log if it is open. Added 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. 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 master status information and replication I/O thread location in the master's binary logs to a file or table. Added in MySQL 5.6.2.master_verify_checksum: Cause master to examine checksums when reading from the binary log. Added in MySQL 5.6.2.max_binlog_stmt_cache_size: Can be used to restrict the total size used to cache all nontransactional statements during a transaction. Added in MySQL 5.6.1.max_digest_length: The maximum digest size in bytes. Added in MySQL 5.6.24.metadata_locks_cache_size: Size of the 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 the 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 the accounts table. Added in MySQL 5.6.3.performance_schema_digests_size: Number of rows in the events_statements_summary_by_digest table. Added in MySQL 5.6.5.performance_schema_events_stages_history_long_size: Number of rows in the events_stages_history_long table. Added in MySQL 5.6.3.performance_schema_events_stages_history_size: Number of rows per thread in the events_stages_history table. Added in MySQL 5.6.3.performance_schema_events_statements_history_long_size: Number of rows in the events_statements_history_long table. Added in MySQL 5.6.3.performance_schema_events_statements_history_size: Number of rows per thread in the events_statements_history table. Added in MySQL 5.6.3.performance_schema_hosts_size: Number of rows in the hosts table. Added in MySQL 5.6.3.performance_schema_max_digest_length: The maximum Performance Schema digest size in bytes. Added in MySQL 5.6.26.performance_schema_max_socket_classes: The maximum number of socket instruments. Added in MySQL 5.6.3.performance_schema_max_socket_instances: The maximum number of instrumented socket objects. Added in MySQL 5.6.3.performance_schema_max_stage_classes: The maximum number of stage instruments. Added in MySQL 5.6.3.performance_schema_max_statement_classes: The maximum number of statement instruments. Added in MySQL 5.6.3.performance_schema_session_connect_attrs_size: Size of the connection attribute strings buffer per thread. Added in MySQL 5.6.6.performance_schema_setup_actors_size: Number of rows in the setup_actors table. Added in MySQL 5.6.1.performance_schema_setup_objects_size: Number of rows in the setup_objects table. Added in MySQL 5.6.1.performance_schema_users_size: Number of rows in the 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 the replication SQL thread's location in the relay logs to a file or a table. Added in MySQL 5.6.2.rpl_stop_slave_timeout: Set the number of seconds that 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 slave to examine checksums when reading from the relay log. Added in MySQL 5.6.2.slave_checkpoint_group: Maximum number of transactions processed by a multithreaded slave before a 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 slave 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 a packet that can be sent from a replication master to a slave; overrides max_allowed_packet. Added in MySQL 5.6.6.slave_parallel_workers: Number of applier threads for executing replication transactions in parallel. A value of 0 disables slave multithreading. Not supported by MySQL Cluster. Added in MySQL 5.6.3.slave_pending_jobs_size_max: Maximum size of slave worker queues holding events not yet applied. Added in MySQL 5.6.3.slave_rows_search_algorithms: Determines search algorithms used for slave update batching. Any 2 or 3 from the list INDEX_SEARCH, TABLE_SCAN, HASH_SCAN. Added in MySQL 5.6.6.slave_sql_verify_checksum: Cause slave 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 a "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: The thread pool algorithm. Added in MySQL 5.6.10.thread_pool_high_priority_connection: Whether the 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 a statement is moved to high-priority execution. Added in MySQL 5.6.10.thread_pool_size: Number of thread groups in the thread pool. Added in MySQL 5.6.10.thread_pool_stall_limit: How long before a 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 the 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 the 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, 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.
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.