MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide
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 server options have been added in MySQL 5.6.
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.