The following list details the changes to specific options/variables within MySQL 5.6.
-
audit-log
Introduced in version 5.6.10
-
audit_log_buffer_size
Introduced in version 5.6.10
-
audit_log_connection_policy
Introduced in version 5.6.20
-
audit_log_current_session
Introduced in version 5.6.20
-
Audit_log_current_size
Introduced in version 5.6.20
-
Audit_log_event_max_drop_size
Introduced in version 5.6.20
-
Audit_log_events
Introduced in version 5.6.20
-
Audit_log_events_filtered
Introduced in version 5.6.20
-
Audit_log_events_lost
Introduced in version 5.6.20
-
Audit_log_events_written
Introduced in version 5.6.20
-
audit_log_exclude_accounts
Introduced in version 5.6.20
-
audit_log_file
Introduced in version 5.6.10
-
audit_log_flush
Introduced in version 5.6.10
-
audit_log_format
Introduced in version 5.6.14
-
audit_log_include_accounts
Introduced in version 5.6.20
-
audit_log_policy
Introduced in version 5.6.10
-
audit_log_rotate_on_size
Introduced in version 5.6.10
-
audit_log_statement_policy
Introduced in version 5.6.20
-
audit_log_strategy
Introduced in version 5.6.10
-
Audit_log_total_size
Introduced in version 5.6.20
-
Audit_log_write_waits
Introduced in version 5.6.20
-
authentication_windows_log_level
Introduced in version 5.6.10
-
authentication_windows_use_principal_name
Introduced in version 5.6.10
-
avoid_temporal_upgrade
Introduced in version 5.6.24
Deprecated in version 5.6.24
-
back_log
Value parameter changes in version 5.6.6:
Default is -1 (signifies autosizing; do not assign this literal value), minimum is 1, maximum is 65535
-
bind-address
Removed in version 5.6.1
-
bind_address
Introduced in version 5.6.1
Value parameter changes in version 5.6.6:
Default is *
-
binlog-checksum
Introduced in version 5.6.2
Value parameter changes in version 5.6.6:
Default is CRC32
-
binlog_checksum
Introduced in version 5.6.2
Value parameter changes in version 5.6.6:
Default is CRC32
-
binlog_error_action
Introduced in version 5.6.22
-
binlog_format
Value parameter changes in version 5.6.10-ndb-7.3.1:
Default is MIXED
-
binlog_gtid_simple_recovery
Introduced in version 5.6.23
-
binlog_max_flush_queue_time
Introduced in version 5.6.6
-
binlog_order_commits
Introduced in version 5.6.6
-
binlog-row-event-max-size
Value parameter changes in version 5.6.6 (bitsize=64):
Default is 8192, minimum is 256, maximum is 18446744073709551615
Value parameter changes in version 5.6.6 (bitsize=32):
Default is 8192, minimum is 256, maximum is 4294967295
-
binlog_row_image
Introduced in version 5.6.2
-
binlog_rows_query_log_events
Introduced in version 5.6.2
-
Binlog_stmt_cache_disk_use
Introduced in version 5.6.1
-
binlog_stmt_cache_size
Introduced in version 5.6.1
-
Binlog_stmt_cache_use
Introduced in version 5.6.1
-
binlogging_impossible_mode
Introduced in version 5.6.20
Deprecated in version 5.6.22
-
block_encryption_mode
Introduced in version 5.6.17
-
Com_alter_user
Introduced in version 5.6.6
-
Com_get_diagnostics
Introduced in version 5.6.4
-
Com_show_new_master
Removed in version 5.6.2
-
Connection_control_delay_generated
Introduced in version 5.6.35
-
connection_control_failed_connections_threshold
Introduced in version 5.6.35
-
connection_control_max_connection_delay
Introduced in version 5.6.35
-
connection_control_min_connection_delay
Introduced in version 5.6.35
-
Connection_errors_accept
Introduced in version 5.6.5
-
Connection_errors_internal
Introduced in version 5.6.5
-
Connection_errors_max_connections
Introduced in version 5.6.5
-
Connection_errors_peer_address
Introduced in version 5.6.5
-
Connection_errors_select
Introduced in version 5.6.5
-
Connection_errors_tcpwrap
Introduced in version 5.6.5
-
core_file
Introduced in version 5.6.2
-
create_old_temporals
Introduced in version 5.6.25-ndb-7.4.7
Deprecated in version 5.6.25-ndb-7.4.7
-
daemon_memcached_enable_binlog
Introduced in version 5.6.6
-
daemon_memcached_engine_lib_name
Introduced in version 5.6.6
-
daemon_memcached_engine_lib_path
Introduced in version 5.6.6
-
daemon_memcached_option
Introduced in version 5.6.6
-
daemon_memcached_r_batch_size
Introduced in version 5.6.6
-
daemon_memcached_w_batch_size
Introduced in version 5.6.6
-
default-authentication-plugin
Introduced in version 5.6.6
-
default_tmp_storage_engine
Introduced in version 5.6.3
-
Delayed_errors
Deprecated in version 5.6.7
-
delayed_insert_limit
Deprecated in version 5.6.7
-
Delayed_insert_threads
Deprecated in version 5.6.7
-
delayed_insert_timeout
Deprecated in version 5.6.7
-
delayed_queue_size
Deprecated in version 5.6.7
-
Delayed_writes
Deprecated in version 5.6.7
-
disable-gtid-unsafe-statements
Introduced in version 5.6.5
Removed in version 5.6.9
-
disable_gtid_unsafe_statements
Introduced in version 5.6.5
Removed in version 5.6.9
-
disconnect_on_expired_password
Introduced in version 5.6.10
-
end_markers_in_json
Introduced in version 5.6.5
-
enforce_gtid_consistency
Introduced in version 5.6.9
-
engine_condition_pushdown
Removed in version 5.6.1
-
eq_range_index_dive_limit
Introduced in version 5.6.5
-
explicit_defaults_for_timestamp
Introduced in version 5.6.6
Deprecated in version 5.6.6
-
Firewall_access_denied
Introduced in version 5.6.24
-
Firewall_access_granted
Introduced in version 5.6.24
-
Firewall_cached_entries
Introduced in version 5.6.24
-
flush_time
Value parameter changes in version 5.6.6:
Default is 0, minimum is 0, maximum is 31536000
-
gtid_done
Introduced in version 5.6.5
Removed in version 5.6.9
-
gtid_executed
Introduced in version 5.6.9
-
gtid_lost
Introduced in version 5.6.5
Removed in version 5.6.9
-
gtid_mode
Introduced in version 5.6.5
-
gtid_next
Introduced in version 5.6.5
-
gtid_owned
Introduced in version 5.6.5
-
gtid_purged
Introduced in version 5.6.9
-
Handler_external_lock
Introduced in version 5.6.2
-
Handler_mrr_init
Introduced in version 5.6.1
-
Handler_read_last
Introduced in version 5.6.1
-
have_csv
Removed in version 5.6.1
-
have_innodb
Removed in version 5.6.1
-
have_ndbcluster
Removed in version 5.6.1
-
have_partitioning
Removed in version 5.6.1
-
have_profiling
Deprecated in version 5.6.8
-
have_ssl
Value parameter changes in version 5.6.6:
Default is not specified
-
host_cache_size
Introduced in version 5.6.5
Value parameter changes in version 5.6.8:
Default is -1 (signifies autosizing; do not assign this literal value), minimum is 0, maximum is 65536
-
ignore-db-dir
Introduced in version 5.6.3
-
ignore_db_dirs
Introduced in version 5.6.3
-
innodb
Deprecated in version 5.6.21
-
innodb_adaptive_flushing_lwm
Introduced in version 5.6.6
-
innodb_adaptive_max_sleep_delay
Introduced in version 5.6.3
-
innodb_additional_mem_pool_size
Deprecated in version 5.6.3
-
innodb_api_bk_commit_interval
Introduced in version 5.6.7
-
innodb_api_disable_rowlock
Introduced in version 5.6.6
-
innodb_api_enable_binlog
Introduced in version 5.6.6
-
innodb_api_enable_mdl
Introduced in version 5.6.6
-
innodb_api_trx_level
Introduced in version 5.6.6
-
innodb_autoextend_increment
Value parameter changes in version 5.6.6:
Default is 64, minimum is 1, maximum is 1000
-
Innodb_available_undo_logs
Introduced in version 5.6.5
-
Innodb_buffer_pool_bytes_data
Introduced in version 5.6.10
-
Innodb_buffer_pool_bytes_dirty
Introduced in version 5.6.10
-
innodb_buffer_pool_dump_at_shutdown
Introduced in version 5.6.3
-
innodb_buffer_pool_dump_now
Introduced in version 5.6.3
-
Innodb_buffer_pool_dump_status
Introduced in version 5.6.3
-
innodb_buffer_pool_filename
Introduced in version 5.6.3
-
innodb_buffer_pool_instances
Value parameter changes in version 5.6.6 (platform=Windows, bitsize=32):
Default is (autosized), minimum is 1, maximum is 64
Value parameter changes in version 5.6.6 (platform=Other):
Default is 8 (or 1 if innodb_buffer_pool_size < 1GB), minimum is 1, maximum is 64
-
innodb_buffer_pool_load_abort
Introduced in version 5.6.3
-
innodb_buffer_pool_load_at_startup
Introduced in version 5.6.3
-
innodb_buffer_pool_load_now
Introduced in version 5.6.3
-
Innodb_buffer_pool_load_status
Introduced in version 5.6.3
-
innodb_change_buffer_max_size
Introduced in version 5.6.2
-
innodb_checksum_algorithm
Introduced in version 5.6.3
Value parameter changes in version 5.6.6:
Default is crc32
Value parameter changes in version 5.6.7:
Default is innodb
-
innodb_checksums
Deprecated in version 5.6.3
-
innodb_cmp_per_index_enabled
Introduced in version 5.6.7
-
innodb_compression_failure_threshold_pct
Introduced in version 5.6.7
-
innodb_compression_level
Introduced in version 5.6.7
-
innodb_compression_pad_pct_max
Introduced in version 5.6.7
-
innodb_concurrency_tickets
Value parameter changes in version 5.6.6:
Default is 5000, minimum is 1, maximum is 4294967295
-
innodb_data_file_path
Value parameter changes in version 5.6.7:
Default is ibdata1:12M:autoextend
-
innodb_disable_sort_file_cache
Introduced in version 5.6.4
-
innodb_fil_make_page_dirty_debug
Introduced in version 5.6.17
-
innodb_file_per_table
Value parameter changes in version 5.6.6:
Default is ON
-
innodb_flush_log_at_timeout
Introduced in version 5.6.6
-
innodb_flush_method
Value parameter changes in version 5.6.7 (platform=Unix):
Default is NULL
-
innodb_flush_neighbors
Introduced in version 5.6.3
-
innodb_flushing_avg_loops
Introduced in version 5.6.6
-
innodb_force_load_corrupted
Introduced in version 5.6.3
-
innodb_ft_aux_table
Introduced in version 5.6.4
-
innodb_ft_cache_size
Introduced in version 5.6.4
Value parameter changes in version 5.6.10:
Default is 8000000, minimum is 1600000, maximum is 80000000
-
innodb_ft_enable_diag_print
Introduced in version 5.6.4
Value parameter changes in version 5.6.7:
Default is OFF
-
innodb_ft_enable_stopword
Introduced in version 5.6.4
-
innodb_ft_max_token_size
Introduced in version 5.6.4
Value parameter changes in version 5.6.14:
Default is 84, minimum is 10, maximum is 84
-
innodb_ft_min_token_size
Introduced in version 5.6.4
-
innodb_ft_num_word_optimize
Introduced in version 5.6.4
-
innodb_ft_result_cache_limit
Introduced in version 5.6.13
Value parameter changes in version 5.6.17:
Default is 2000000000, minimum is 1000000, maximum is 2**32-1
-
innodb_ft_server_stopword_table
Introduced in version 5.6.4
-
innodb_ft_sort_pll_degree
Introduced in version 5.6.4
-
innodb_ft_total_cache_size
Introduced in version 5.6.13
-
innodb_ft_user_stopword_table
Introduced in version 5.6.4
-
innodb_io_capacity_max
Introduced in version 5.6.6
-
innodb_large_prefix
Introduced in version 5.6.3
-
innodb_locks_unsafe_for_binlog
Deprecated in version 5.6.3
-
innodb_log_checkpoint_now
Introduced in version 5.6.12
-
innodb_log_compressed_pages
Introduced in version 5.6.11
-
innodb_log_file_size
Value parameter changes in version 5.6.3:
Default is 5242880, minimum is 1048576, maximum is 512GB / innodb_log_files_in_group
Value parameter changes in version 5.6.8:
Default is 50331648, minimum is 1048576, maximum is 512GB / innodb_log_files_in_group
-
innodb_lru_scan_depth
Introduced in version 5.6.3
-
innodb_max_dirty_pages_pct_lwm
Introduced in version 5.6.6
-
innodb_max_purge_lag_delay
Introduced in version 5.6.5
-
innodb_monitor_disable
Introduced in version 5.6.2
-
innodb_monitor_enable
Introduced in version 5.6.2
-
innodb_monitor_reset
Introduced in version 5.6.2
-
innodb_monitor_reset_all
Introduced in version 5.6.2
-
Innodb_num_open_files
Introduced in version 5.6.2
-
innodb_numa_interleave
Introduced in version 5.6.27
-
innodb_old_blocks_time
Value parameter changes in version 5.6.6:
Default is 1000, minimum is 0, maximum is 2**32-1
-
innodb_online_alter_log_max_size
Introduced in version 5.6.6
-
innodb_open_files
Value parameter changes in version 5.6.6:
Default is -1 (signifies autosizing; do not assign this literal value), minimum is 10, maximum is 2147483647
-
innodb_optimize_fulltext_only
Introduced in version 5.6.4
-
innodb_page_size
Introduced in version 5.6.4
-
innodb_print_all_deadlocks
Introduced in version 5.6.2
-
innodb_purge_batch_size
Value parameter changes in version 5.6.3:
Default is 300, minimum is 1, maximum is 5000
-
innodb_purge_threads
Value parameter changes in version 5.6.2:
Default is 0, minimum is 0, maximum is 32
Value parameter changes in version 5.6.5:
Default is 1, minimum is 1, maximum is 32
-
innodb_random_read_ahead
Introduced in version 5.6.3
-
innodb_read_only
Introduced in version 5.6.7
-
innodb_rollback_segments
Introduced in version 5.6.2
-
innodb_saved_page_number_debug
Introduced in version 5.6.17
-
innodb_sort_buffer_size
Introduced in version 5.6.4
Value parameter changes in version 5.6.5:
Default is 1048576, minimum is 65536, maximum is 67108864
-
innodb_stats_auto_recalc
Introduced in version 5.6.6
-
innodb_stats_include_delete_marked
Introduced in version 5.6.35
-
innodb_stats_method
Introduced in version 5.6.2
-
innodb_stats_on_metadata
Value parameter changes in version 5.6.6:
Default is OFF
-
innodb_stats_persistent
Introduced in version 5.6.6
-
innodb_stats_persistent_sample_pages
Introduced in version 5.6.2
-
innodb_stats_sample_pages
Deprecated in version 5.6.3
-
innodb_stats_transient_sample_pages
Introduced in version 5.6.2
-
innodb_status_output
Introduced in version 5.6.16
-
innodb_status_output_locks
Introduced in version 5.6.16
-
innodb_sync_array_size
Introduced in version 5.6.3
-
innodb_thread_sleep_delay
Value parameter changes in version 5.6.17:
Default is 10000, minimum is 0, maximum is 1000000
-
innodb_tmpdir
Introduced in version 5.6.29
-
innodb_undo_directory
Introduced in version 5.6.3
-
innodb_undo_logs
Introduced in version 5.6.3
-
innodb_undo_tablespaces
Introduced in version 5.6.3
-
innodb_use_sys_malloc
Deprecated in version 5.6.3
-
join_buffer_size
Value parameter changes in version 5.6.6 (platform=Windows):
Default is 262144, minimum is 128, maximum is 4294967168
Value parameter changes in version 5.6.6 (platform=Other, bitsize=64):
Default is 262144, minimum is 128, maximum is 18446744073709551488
Value parameter changes in version 5.6.6 (platform=Other, bitsize=32):
Default is 262144, minimum is 128, maximum is 4294967168
-
language
Deprecated in version 5.6.1 and replaced with
lc-messages-dir
-
Last_query_partial_plans
Introduced in version 5.6.5
-
log
Removed in version 5.6.1
-
log_bin_basename
Introduced in version 5.6.2
-
log_bin_use_v1_row_events
Introduced in version 5.6.6
-
log-raw
Introduced in version 5.6.3
-
log-slow-admin-statements
Removed in version 5.6.11
-
log_slow_admin_statements
Introduced in version 5.6.11
-
log_slow_queries
Removed in version 5.6.1
-
log-slow-slave-statements
Removed in version 5.6.11
-
log_slow_slave_statements
Introduced in version 5.6.11
-
log_throttle_queries_not_using_indexes
Introduced in version 5.6.5
-
master_info_repository
Introduced in version 5.6.2
-
master-retry-count
Deprecated in version 5.6.1
-
master_verify_checksum
Introduced in version 5.6.2
-
max_allowed_packet
Value parameter changes in version 5.6.6:
Default is 4194304, minimum is 1024, maximum is 1073741824
-
max_binlog_stmt_cache_size
Introduced in version 5.6.1
-
max_connect_errors
Value parameter changes in version 5.6.6 (bitsize=64):
Default is 100, minimum is 1, maximum is 18446744073709551615
Value parameter changes in version 5.6.6 (bitsize=32):
Default is 100, minimum is 1, maximum is 4294967295
-
max_delayed_threads
Deprecated in version 5.6.7
-
max_digest_length
Introduced in version 5.6.24
-
max_insert_delayed_threads
Deprecated in version 5.6.7
-
max_tmp_tables
Deprecated in version 5.6.7
-
metadata_locks_cache_size
Introduced in version 5.6.4
-
metadata_locks_hash_instances
Introduced in version 5.6.8
-
multi_range_count
Deprecated in version 5.6.7
-
myisam_sort_buffer_size
Value parameter changes in version 5.6.5 (bitsize=64):
Default is 8388608, minimum is 4096, maximum is 18446744073709551615
-
mysql_firewall_max_query_size
Introduced in version 5.6.24
Removed in version 5.6.26
-
mysql_firewall_mode
Introduced in version 5.6.24
-
mysql_firewall_trace
Introduced in version 5.6.24
-
named_pipe_full_access_group
Introduced in version 5.6.43
-
ndb_clear_apply_status
Introduced in version 5.6.28-ndb-7.4.9
-
Ndb_conflict_fn_epoch2
Introduced in version 5.6.21-ndb-7.4.2
-
Ndb_conflict_fn_epoch2_trans
Introduced in version 5.6.21-ndb-7.4.2
-
Ndb_conflict_fn_max_del_win
Introduced in version 5.6.21-ndb-7.4.1
-
Ndb_conflict_last_conflict_epoch
Introduced in version 5.6.21-ndb-7.4.2
-
Ndb_conflict_last_stable_epoch
Introduced in version 5.6.21-ndb-7.4.2
-
Ndb_conflict_reflected_op_discard_count
Introduced in version 5.6.21-ndb-7.4.2
-
Ndb_conflict_reflected_op_prepare_count
Introduced in version 5.6.21-ndb-7.4.2
-
Ndb_conflict_refresh_op_count
Introduced in version 5.6.21-ndb-7.4.2
-
Ndb_conflict_trans_row_conflict_count
Introduced in version 5.6.21-ndb-7.4.2
-
Ndb_epoch_delete_delete_count
Introduced in version 5.6.22-ndb-7.4.2
-
ndb_eventbuffer_free_percent
Introduced in version 5.6.22-ndb-7.4.3
-
ndb_eventbuffer_max_alloc
Introduced in version 5.6.14-ndb-7.3.3
-
ndb_index_stat_cache_entries
Removed in version 5.6.16-ndb-7.3.5
-
ndb_index_stat_update_freq
Removed in version 5.6.16-ndb-7.3.5
-
Ndb_last_commit_epoch_server
Introduced in version 5.6.20-ndb-7.4.1
-
Ndb_last_commit_epoch_session
Introduced in version 5.6.20-ndb-7.4.1
-
ndb-log-exclusive-reads
Introduced in version 5.6.20-ndb-7.4.1
-
ndb_log_exclusive_reads
Introduced in version 5.6.20-ndb-7.4.1
-
ndb-log-fail-terminate
Introduced in version 5.6.47-ndb-7.4.28
-
ndb-log-update-minimal
Introduced in version 5.6.36-ndb-7.4.16
-
ndb_recv_thread_activation_threshold
Introduced in version 5.6.10-ndb-7.3.1
-
ndb_recv_thread_cpu_mask
Introduced in version 5.6.10-ndb-7.3.1
-
ndb_show_foreign_key_mock_tables
Introduced in version 5.6.11-ndb-7.3.2
-
ndb_slave_conflict_role
Introduced in version 5.6.20-ndb-7.4.1
-
Ndb_slave_max_replicated_epoch
Introduced in version 5.6.20-ndb-7.4.1
-
Not_flushed_delayed_rows
Deprecated in version 5.6.7
-
old_passwords
Value parameter changes in version 5.6.6:
Default is 0
-
one-thread
Removed in version 5.6.1
-
open_files_limit
Value parameter changes in version 5.6.8:
Default is 5000, with possible adjustment, minimum is 0, maximum is platform dependent
-
optimizer_join_cache_level
Introduced in version 5.6.1
Removed in version 5.6.3
-
optimizer_switch
Value parameter changes in version 5.6.1:
Default is not specified
Value parameter changes in version 5.6.3:
Default is not specified
Value parameter changes in version 5.6.5:
Default is not specified
Value parameter changes in version 5.6.7:
Default is not specified
Value parameter changes in version 5.6.9:
Default is not specified
-
optimizer_trace
Introduced in version 5.6.3
-
optimizer_trace_features
Introduced in version 5.6.3
-
optimizer_trace_limit
Introduced in version 5.6.3
-
optimizer_trace_max_mem_size
Introduced in version 5.6.3
-
optimizer_trace_offset
Introduced in version 5.6.3
-
performance_schema
Value parameter changes in version 5.6.6:
Default is ON
-
Performance_schema_accounts_lost
Introduced in version 5.6.3
-
performance_schema_accounts_size
Introduced in version 5.6.3
Value parameter changes in version 5.6.6:
Default is -1 (signifies autosizing; do not assign this literal value), minimum is -1 (signifies autosizing; do not assign this literal value), maximum is 1048576
-
performance-schema-consumer-events-stages-current
Introduced in version 5.6.4
-
performance-schema-consumer-events-stages-history
Introduced in version 5.6.4
-
performance-schema-consumer-events-stages-history-long
Introduced in version 5.6.4
-
performance-schema-consumer-events-statements-current
Introduced in version 5.6.4
-
performance-schema-consumer-events-statements-history
Introduced in version 5.6.4
-
performance-schema-consumer-events-statements-history-long
Introduced in version 5.6.4
-
performance-schema-consumer-events-waits-current
Introduced in version 5.6.4
-
performance-schema-consumer-events-waits-history
Introduced in version 5.6.4
-
performance-schema-consumer-events-waits-history-long
Introduced in version 5.6.4
-
performance-schema-consumer-global-instrumentation
Introduced in version 5.6.4
-
performance-schema-consumer-statements-digest
Introduced in version 5.6.5
-
performance-schema-consumer-thread-instrumentation
Introduced in version 5.6.4
-
Performance_schema_digest_lost
Introduced in version 5.6.5
-
performance_schema_digests_size
Introduced in version 5.6.5
-
performance_schema_events_stages_history_long_size
Introduced in version 5.6.3
Value parameter changes in version 5.6.6:
Default is -1 (signifies autosizing; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 1048576
-
performance_schema_events_stages_history_size
Introduced in version 5.6.3
Value parameter changes in version 5.6.6:
Default is -1 (signifies autosizing; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 1024
-
performance_schema_events_statements_history_long_size
Introduced in version 5.6.3
Value parameter changes in version 5.6.6:
Default is -1 (signifies autosizing; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 1048576
-
performance_schema_events_statements_history_size
Introduced in version 5.6.3
Value parameter changes in version 5.6.6:
Default is -1 (signifies autosizing; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 1024
-
performance_schema_events_waits_history_long_size
Value parameter changes in version 5.6.6:
Default is -1 (signifies autosizing; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 1048576
-
performance_schema_events_waits_history_size
Value parameter changes in version 5.6.6:
Default is -1 (signifies autosizing; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 1024
-
Performance_schema_hosts_lost
Introduced in version 5.6.3
-
performance_schema_hosts_size
Introduced in version 5.6.3
Value parameter changes in version 5.6.6:
Default is -1 (signifies autosizing; do not assign this literal value), minimum is -1 (signifies autosizing; do not assign this literal value), maximum is 1048576
-
performance-schema-instrument
Introduced in version 5.6.4
-
performance_schema_max_cond_instances
Value parameter changes in version 5.6.6:
Default is -1 (signifies autosizing; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 1024
-
performance_schema_max_digest_length
Introduced in version 5.6.26
-
performance_schema_max_file_instances
Value parameter changes in version 5.6.6:
Default is -1 (signifies autosizing; do not assign this literal value), minimum is not specified, maximum is not specified
-
performance_schema_max_mutex_instances
Value parameter changes in version 5.6.6:
Default is -1 (signifies autoscaling; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 104857600
-
performance_schema_max_rwlock_classes
Value parameter changes in version 5.6.1:
Default is 30, minimum is 0, maximum is 256
Value parameter changes in version 5.6.15:
Default is 40, minimum is 0, maximum is 256
-
performance_schema_max_rwlock_instances
Value parameter changes in version 5.6.6:
Default is -1 (signifies autosizing; do not assign this literal value), minimum is -1 (signifies autosizing; do not assign this literal value), maximum is 104857600
-
performance_schema_max_socket_classes
Introduced in version 5.6.3
-
performance_schema_max_socket_instances
Introduced in version 5.6.3
Value parameter changes in version 5.6.6:
Default is -1 (signifies autosizing; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 1048576
-
performance_schema_max_stage_classes
Introduced in version 5.6.3
-
performance_schema_max_statement_classes
Introduced in version 5.6.3
-
performance_schema_max_table_handles
Value parameter changes in version 5.6.6:
Default is -1 (signifies autosizing; do not assign this literal value), minimum is not specified, maximum is not specified
-
performance_schema_max_table_instances
Value parameter changes in version 5.6.6:
Default is -1 (signifies autoscaling; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 1048576
-
performance_schema_max_thread_instances
Value parameter changes in version 5.6.6:
Default is -1 (signifies autosizing; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 1048576
-
Performance_schema_session_connect_attrs_lost
Introduced in version 5.6.6
-
performance_schema_session_connect_attrs_size
Introduced in version 5.6.6
-
performance_schema_setup_actors_size
Introduced in version 5.6.1
-
performance_schema_setup_objects_size
Introduced in version 5.6.1
-
Performance_schema_socket_classes_lost
Introduced in version 5.6.3
-
Performance_schema_socket_instances_lost
Introduced in version 5.6.3
-
Performance_schema_stage_classes_lost
Introduced in version 5.6.3
-
Performance_schema_statement_classes_lost
Introduced in version 5.6.3
-
Performance_schema_users_lost
Introduced in version 5.6.3
-
performance_schema_users_size
Introduced in version 5.6.3
Value parameter changes in version 5.6.6:
Default is -1 (signifies autosizing; do not assign this literal value), minimum is -1 (signifies autosizing; do not assign this literal value), maximum is 1048576
-
plugin-load-add
Introduced in version 5.6.3
-
profiling
Deprecated in version 5.6.8
-
profiling_history_size
Deprecated in version 5.6.8
-
pseudo_slave_mode
Introduced in version 5.6.10
-
query_cache_size
Value parameter changes in version 5.6.8 (bitsize=64):
Default is 1048576, minimum is 0, maximum is 18446744073709551615
Value parameter changes in version 5.6.8 (bitsize=32):
Default is 1048576, minimum is 0, maximum is 4294967295
-
query_cache_type
Value parameter changes in version 5.6.8:
Default is 0
-
relay_log_basename
Introduced in version 5.6.2
-
relay_log_info_repository
Introduced in version 5.6.2
-
report_port
Value parameter changes in version 5.6.5:
Default is [slave_port], minimum is 0, maximum is 65535
-
rpl_stop_slave_timeout
Introduced in version 5.6.13
-
Rsa_public_key
Introduced in version 5.6.6
-
safe-mode
Removed in version 5.6.6
-
secure_auth
Value parameter changes in version 5.6.5:
Default is ON
-
secure_file_priv
Value parameter changes in version 5.6.34:
Default is platform specific
-
sha256_password_private_key_path
Introduced in version 5.6.6
-
sha256_password_public_key_path
Introduced in version 5.6.6
-
show_old_temporals
Introduced in version 5.6.24
Deprecated in version 5.6.24
-
simplified_binlog_gtid_recovery
Introduced in version 5.6.21
Deprecated in version 5.6.23
-
skip-thread-priority
Removed in version 5.6.1
-
slave_checkpoint_group
Introduced in version 5.6.3
-
slave_checkpoint_period
Introduced in version 5.6.3
-
Slave_last_heartbeat
Introduced in version 5.6.1
-
slave_max_allowed_packet
Introduced in version 5.6.6
-
slave_parallel_workers
Introduced in version 5.6.3
-
slave_pending_jobs_size_max
Introduced in version 5.6.3
-
Slave_rows_last_search_algorithm_used
Introduced in version 5.6.6
-
slave_rows_search_algorithms
Introduced in version 5.6.6
-
slave-sql-verify-checksum
Introduced in version 5.6.2
-
slave_sql_verify_checksum
Introduced in version 5.6.2
-
slave_type_conversions
Value parameter changes in version 5.6.13:
Default is
-
slow-start-timeout
Introduced in version 5.6.5
-
sort_buffer_size
Value parameter changes in version 5.6.4 (platform=Windows):
Default is 262144, minimum is 32768, maximum is 4294967295
Value parameter changes in version 5.6.4 (platform=Other, bitsize=64):
Default is 262144, minimum is 32768, maximum is 18446744073709551615
Value parameter changes in version 5.6.4 (platform=Other, bitsize=32):
Default is 262144, minimum is 32768, maximum is 4294967295
-
sql_big_tables
Removed in version 5.6.1
-
sql_low_priority_updates
Removed in version 5.6.1
-
sql_max_join_size
Removed in version 5.6.1
-
sql-mode
Value parameter changes in version 5.6.6:
Default is NO_ENGINE_SUBSTITUTION
-
ssl_crl
Introduced in version 5.6.3
-
ssl_crlpath
Introduced in version 5.6.3
-
Ssl_server_not_after
Introduced in version 5.6.3
-
Ssl_server_not_before
Introduced in version 5.6.3
-
stored_program_cache
Introduced in version 5.6.5
-
sync_master_info
Value parameter changes in version 5.6.6 (bitsize=64):
Default is 10000, minimum is 0, maximum is 4294967295
Value parameter changes in version 5.6.6 (bitsize=32):
Default is 10000, minimum is 0, maximum is 4294967295
-
sync_relay_log
Value parameter changes in version 5.6.6 (bitsize=64):
Default is 10000, minimum is 0, maximum is 4294967295
Value parameter changes in version 5.6.6 (bitsize=32):
Default is 10000, minimum is 0, maximum is 4294967295
-
sync_relay_log_info
Value parameter changes in version 5.6.6 (bitsize=64):
Default is 10000, minimum is 0, maximum is 4294967295
Value parameter changes in version 5.6.6 (bitsize=32):
Default is 10000, minimum is 0, maximum is 4294967295
-
table_definition_cache
Value parameter changes in version 5.6.8:
Default is -1 (signifies autosizing; do not assign this literal value), minimum is 400, maximum is 524288
-
table_open_cache
Value parameter changes in version 5.6.8:
Default is 2000, minimum is 1, maximum is 524288
-
Table_open_cache_hits
Introduced in version 5.6.6
-
table_open_cache_instances
Introduced in version 5.6.6
-
Table_open_cache_misses
Introduced in version 5.6.6
-
Table_open_cache_overflows
Introduced in version 5.6.6
-
thread_cache_size
Value parameter changes in version 5.6.8:
Default is -1 (signifies autosizing; do not assign this literal value), minimum is 0, maximum is 16384
-
thread_concurrency
Deprecated in version 5.6.1
-
thread_pool_algorithm
Introduced in version 5.6.10
-
thread_pool_high_priority_connection
Introduced in version 5.6.10
-
thread_pool_max_unused_threads
Introduced in version 5.6.10
-
thread_pool_prio_kickup_timer
Introduced in version 5.6.10
-
thread_pool_size
Introduced in version 5.6.10
-
thread_pool_stall_limit
Introduced in version 5.6.10
-
timed_mutexes
Deprecated in version 5.6.20
-
transaction_alloc_block_size
Value parameter changes in version 5.6.24:
Default is 8192, minimum is 1024, maximum is 131072
-
transaction_prealloc_size
Value parameter changes in version 5.6.24:
Default is 4096, minimum is 1024, maximum is 131072
-
transaction-read-only
Introduced in version 5.6.5
-
tx_read_only
Introduced in version 5.6.5
-
validate-password
Introduced in version 5.6.6
-
validate_password_dictionary_file
Introduced in version 5.6.6
-
validate_password_dictionary_file_last_parsed
Introduced in version 5.6.26
-
validate_password_dictionary_file_words_count
Introduced in version 5.6.26
-
validate_password_length
Introduced in version 5.6.6
-
validate_password_mixed_case_count
Introduced in version 5.6.6
-
validate_password_number_count
Introduced in version 5.6.6
-
validate_password_policy
Introduced in version 5.6.6
-
validate_password_special_char_count
Introduced in version 5.6.6
-
validate-user-plugins
Introduced in version 5.6.11