MySQL :: MySQL Server Version Reference :: 1.4 Option/Variable Changes for mysqld 5.6

MySQL Server Version Reference :: 1 mysqld Option/Variable Reference :: 1.4 Option/Variable Changes for mysqld 5.6

« 1.3 Option/Variable Changes for mysqld 5.5

1.5 Option/Variable Changes for mysqld 5.7 »

Section Navigation [Toggle]

1 mysqld Option/Variable Reference
1.1 Option/Variable Changes for mysqld 5.0
1.2 Option/Variable Changes for mysqld 5.1
1.3 Option/Variable Changes for mysqld 5.5
1.4 Option/Variable Changes for mysqld 5.6
1.5 Option/Variable Changes for mysqld 5.7

1.4. Option/Variable Changes for mysqld 5.6

The list below details the changes in 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_file

Introduced in version 5.6.10
audit_log_flush

Introduced in version 5.6.10
audit_log_policy

Introduced in version 5.6.10
audit_log_rotate_on_size

Introduced in version 5.6.10
audit_log_strategy

Introduced in version 5.6.10
authentication_windows_log_level

Introduced in version 5.6.10
authentication_windows_use_principal_name

Introduced in version 5.6.10
back_log

Value parameter changes in version 5.6.5:
- Default is 50, minimum is 1, maximum is 65535
Value parameter changes in version 5.6.6:
- Default is -1 (autosized), minimum is 1, maximum is 65535
big-tables

Removed in version 5.6.1
bind-address

Value parameter changes in version 5.6.5:
- Default is 0.0.0.0
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.5:
- Default is NONE
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.5:
- Default is NONE
Value parameter changes in version 5.6.6:
- Default is CRC32
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.5:
- Default is 1024, minimum is 256, maximum is 4294967295
Value parameter changes in version 5.6.5:
- Default is 1024, minimum is 256, maximum is 18446744073709547520
Value parameter changes in version 5.6.6:
- Default is 8192, minimum is 256, maximum is 4294967295
Value parameter changes in version 5.6.6:
- Default is 8192, minimum is 256, maximum is 18446744073709547520
binlog_row_image

Introduced in version 5.6.2
binlog_rows_query_log_events

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
Com_alter_user

Introduced in version 5.6.6
Com_get_diagnostics

Introduced in version 5.6.4
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_addr

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
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_passwords

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
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
flush_time

Value parameter changes in version 5.6.5:
- Default is 1800, minimum is not specified, maximum is not specified
Value parameter changes in version 5.6.6:
- Default is not specified, minimum is not specified, maximum is not specified
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-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
host_cache_size

Introduced in version 5.6.5

Value parameter changes in version 5.6.7:
- Default is 128, minimum is not specified, maximum is 65536
Value parameter changes in version 5.6.8:
- Default is -1 (autosized), minimum is not specified, maximum is 65536
ignore-db-dir

Introduced in version 5.6.3
ignore_db_dirs

Introduced in version 5.6.3
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.5:
- Default is 8, minimum is 1, maximum is 1000
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.5:
- Default is 1, minimum is 1, maximum is 64
Value parameter changes in version 5.6.6:
- Default is -1 (autosized), 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.5:
- Default is innodb
Value parameter changes in version 5.6.6:
- Default is crc32
Value parameter changes in version 5.6.7:
- Default is innodb
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.5:
- Default is 500, minimum is 1, maximum is 4294967295
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.6:
- Default is ibdata1:10M:autoextend
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_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.6:
- Default is fdatasync
Value parameter changes in version 5.6.6:
- Default is fdatasync
Value parameter changes in version 5.6.6:
- Default is fdatasync
Value parameter changes in version 5.6.7:
- Default is fdatasync
Value parameter changes in version 5.6.7:
- Default is fdatasync
Value parameter changes in version 5.6.7:
- Default is fdatasync
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.4:
- Default is 32000000, minimum is not specified, maximum is not specified
Value parameter changes in version 5.6.10:
- Default is 8000000, minimum is not specified, maximum is not specified
innodb_ft_enable_diag_print

Introduced in version 5.6.4

Value parameter changes in version 5.6.6:
- Default is OFF
Value parameter changes in version 5.6.7:
- Default is ON
innodb_ft_enable_stopword

Introduced in version 5.6.4
innodb_ft_max_token_size

Introduced in version 5.6.4
innodb_ft_min_token_size

Introduced in version 5.6.4
innodb_ft_num_word_optimize

Introduced in version 5.6.4
innodb_ft_server_stopword_table

Introduced in version 5.6.4
innodb_ft_sort_pll_degree

Introduced in version 5.6.4
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_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_old_blocks_time

Value parameter changes in version 5.6.5:
- Default is not specified, minimum is not specified, maximum is 2**32-1
Value parameter changes in version 5.6.6:
- Default is 1000, minimum is not specified, 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.5:
- Default is 300, minimum is 10, maximum is 4294967295
Value parameter changes in version 5.6.6:
- Default is -1 (autosized), minimum is 10, maximum is 4294967295
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 not specified, minimum is not specified, 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_sort_buffer_size

Introduced in version 5.6.4

Value parameter changes in version 5.6.4:
- Default is 1048576, minimum is 524288, maximum is 67108864
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_method

Introduced in version 5.6.2
innodb_stats_on_metadata

Value parameter changes in version 5.6.5:
- Default is ON
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_sync_array_size

Introduced in version 5.6.3
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:
- Default is 262144, minimum is 128, maximum is 4294967295
Value parameter changes in version 5.6.6:
- Default is 262144, minimum is 128, maximum is 18446744073709547520
language

Deprecatedand replaced with lc-messages-dir in version 5.6.1
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

Value parameter changes in version 5.6.6:
- Default is not specified
log-bin-use-v1-row-events

Introduced in version 5.6.6

Value parameter changes in version 5.6.6:
- Default is not specified
log-raw

Introduced in version 5.6.3
log_slow_admin_statements

Introduced in version 5.6.11
log-slow-admin-statements

Removed in version 5.6.11
log-slow-queries

Removed in version 5.6.1
log_slow_slave_statements

Introduced in version 5.6.11
log-slow-slave-statements

Removed 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-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
master-verify-checksum

Introduced in version 5.6.2
max_allowed_packet

Value parameter changes in version 5.6.5:
- Default is 1048576, minimum is 1024, maximum is 1073741824
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.5:
- Default is 10, minimum is 1, maximum is 4294967295
Value parameter changes in version 5.6.5:
- Default is 10, minimum is 1, maximum is 18446744073709547520
Value parameter changes in version 5.6.6:
- Default is 100, minimum is 1, maximum is 4294967295
Value parameter changes in version 5.6.6:
- Default is 100, minimum is 1, maximum is 18446744073709547520
max_delayed_threads

Deprecated in version 5.6.7
max_insert_delayed_threads

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
ndb-recv-thread-activation-threshold

Introduced in version 5.6.10-ndb-7.3.1

Value parameter changes in version 5.6.10-ndb-7.3.1:
- Default is 8, minimum is not specified, maximum is 16
ndb_recv_thread_activation_threshold

Introduced in version 5.6.10-ndb-7.3.1

Value parameter changes in version 5.6.10-ndb-7.3.1:
- Default is 8, minimum is not specified, maximum is 16
ndb-recv-thread-cpu-mask

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
Not_flushed_delayed_rows

Deprecated in version 5.6.7
old_passwords

Value parameter changes in version 5.6.5:
- Default is not specified
Value parameter changes in version 5.6.6:
- Default is not specified
one-thread

Removed in version 5.6.1
open-files-limit

Value parameter changes in version 5.6.7:
- Default is not specified, minimum is not specified, maximum is 65535
Value parameter changes in version 5.6.8:
- Default is -1 (autosized), minimum is not specified, maximum is 65535
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.5:
- Default is OFF
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.5:
- Default is 10, minimum is not specified, maximum is 1048576
Value parameter changes in version 5.6.6:
- Default is -1 (autosized), minimum is -1, maximum is 1048576
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.5:
- Default is 10000, minimum is not specified, maximum is not specified
Value parameter changes in version 5.6.6:
- Default is -1 (autosized), minimum is not specified, maximum is not specified
performance_schema_events_stages_history_size

Introduced in version 5.6.3

Value parameter changes in version 5.6.5:
- Default is 10, minimum is not specified, maximum is not specified
Value parameter changes in version 5.6.6:
- Default is -1 (autosized), minimum is not specified, maximum is not specified
performance_schema_events_statements_history_long_size

Introduced in version 5.6.3

Value parameter changes in version 5.6.5:
- Default is 10000, minimum is not specified, maximum is not specified
Value parameter changes in version 5.6.6:
- Default is -1 (autosized), minimum is not specified, maximum is not specified
performance_schema_events_statements_history_size

Introduced in version 5.6.3

Value parameter changes in version 5.6.5:
- Default is 10, minimum is not specified, maximum is not specified
Value parameter changes in version 5.6.6:
- Default is -1 (autosized), minimum is not specified, maximum is not specified
performance_schema_events_waits_history_long_size

Value parameter changes in version 5.6.5:
- Default is 10000, minimum is not specified, maximum is not specified
Value parameter changes in version 5.6.6:
- Default is -1 (autosized), minimum is not specified, maximum is not specified
performance_schema_events_waits_history_size

Value parameter changes in version 5.6.5:
- Default is 10, minimum is not specified, maximum is not specified
Value parameter changes in version 5.6.6:
- Default is -1 (autosized), minimum is not specified, maximum is not specified
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.5:
- Default is 10, minimum is not specified, maximum is 1048576
Value parameter changes in version 5.6.6:
- Default is -1 (autosized), minimum is -1, maximum is 1048576
performance-schema-instrument

Introduced in version 5.6.4
performance_schema_max_cond_instances

Value parameter changes in version 5.6.5:
- Default is 1000, minimum is not specified, maximum is not specified
Value parameter changes in version 5.6.6:
- Default is -1 (autosized), minimum is not specified, maximum is not specified
performance_schema_max_file_instances

Value parameter changes in version 5.6.5:
- Default is 10000, minimum is not specified, maximum is not specified
Value parameter changes in version 5.6.6:
- Default is -1 (autosized), minimum is not specified, maximum is not specified
performance_schema_max_mutex_instances

Value parameter changes in version 5.6.5:
- Default is 1000, minimum is not specified, maximum is not specified
Value parameter changes in version 5.6.6:
- Default is -1 (autosized), minimum is not specified, maximum is not specified
performance_schema_max_rwlock_instances

Value parameter changes in version 5.6.5:
- Default is 1000, minimum is not specified, maximum is not specified
Value parameter changes in version 5.6.6:
- Default is -1 (autosized), minimum is not specified, maximum is not specified
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.5:
- Default is 1000, minimum is not specified, maximum is not specified
Value parameter changes in version 5.6.6:
- Default is -1 (autosized), minimum is not specified, maximum is not specified
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.5:
- Default is 100000, minimum is not specified, maximum is not specified
Value parameter changes in version 5.6.6:
- Default is -1 (autosized), minimum is not specified, maximum is not specified
performance_schema_max_table_instances

Value parameter changes in version 5.6.5:
- Default is 50000, minimum is not specified, maximum is not specified
Value parameter changes in version 5.6.6:
- Default is -1 (autosized), minimum is not specified, maximum is not specified
performance_schema_max_thread_instances

Value parameter changes in version 5.6.5:
- Default is 1000, minimum is not specified, maximum is not specified
Value parameter changes in version 5.6.6:
- Default is -1 (autosized), minimum is not specified, maximum is not specified
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.5:
- Default is 10, minimum is not specified, maximum is 1048576
Value parameter changes in version 5.6.6:
- Default is -1 (autosized), minimum is -1, 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.7:
- Default is not specified, minimum is not specified, maximum is 4294967295
Value parameter changes in version 5.6.7:
- Default is not specified, minimum is not specified, maximum is 18446744073709547520
Value parameter changes in version 5.6.8:
- Default is 1048576, minimum is not specified, maximum is 4294967295
Value parameter changes in version 5.6.8:
- Default is 1048576, minimum is not specified, maximum is 18446744073709547520
query_cache_type

Value parameter changes in version 5.6.7:
- Default is 1
Value parameter changes in version 5.6.8:
- Default is not specified
relay_log_basename

Introduced in version 5.6.2
relay-log-info-repository

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 not specified, maximum is 65535
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.4:
- Default is OFF
Value parameter changes in version 5.6.5:
- Default is ON
server_uuid

Introduced in version 5.6.0
sha256_password_private_key_path

Introduced in version 5.6.6
sha256_password_public_key_path

Introduced in version 5.6.6
skip-thread-priority

Removed in version 5.6.1
slave_checkpoint_group

Introduced in version 5.6.3
slave-checkpoint-group

Introduced in version 5.6.3
slave_checkpoint_period

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-max-allowed-packet

Introduced in version 5.6.6
slave_parallel_workers

Introduced in version 5.6.3
slave-parallel-workers

Introduced in version 5.6.3
slave_pending_jobs_size_max

Introduced in version 5.6.3
slave-pending-jobs-size-max

Introduced in version 5.6.3
slave-rows-search-algorithms

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
slow-start-timeout

Introduced in version 5.6.5
sort_buffer_size

Value parameter changes in version 5.6.3:
- Default is 2097144, minimum is 32768, maximum is 4294967295
Value parameter changes in version 5.6.3:
- Default is 2097144, minimum is 32768, maximum is 18446744073709547520
Value parameter changes in version 5.6.4:
- Default is 262144, minimum is 32768, maximum is 4294967295
Value parameter changes in version 5.6.4:
- Default is 262144, minimum is 32768, maximum is 18446744073709547520
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.5:
- Default is ''
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.5:
- Default is not specified, minimum is not specified, maximum is 4294967295
Value parameter changes in version 5.6.5:
- Default is not specified, minimum is not specified, maximum is 18446744073709547520
Value parameter changes in version 5.6.6:
- Default is 10000, minimum is not specified, maximum is 4294967295
Value parameter changes in version 5.6.6:
- Default is 10000, minimum is not specified, maximum is 18446744073709547520
sync_relay_log

Value parameter changes in version 5.6.5:
- Default is not specified, minimum is not specified, maximum is 4294967295
Value parameter changes in version 5.6.5:
- Default is not specified, minimum is not specified, maximum is 18446744073709547520
Value parameter changes in version 5.6.6:
- Default is 10000, minimum is not specified, maximum is 4294967295
Value parameter changes in version 5.6.6:
- Default is 10000, minimum is not specified, maximum is 18446744073709547520
sync_relay_log_info

Value parameter changes in version 5.6.5:
- Default is not specified, minimum is not specified, maximum is 4294967295
Value parameter changes in version 5.6.5:
- Default is not specified, minimum is not specified, maximum is 18446744073709547520
Value parameter changes in version 5.6.6:
- Default is 10000, minimum is not specified, maximum is 4294967295
Value parameter changes in version 5.6.6:
- Default is 10000, minimum is not specified, maximum is 18446744073709547520
table_definition_cache

Value parameter changes in version 5.6.7:
- Default is 400, minimum is 400, maximum is 524288
Value parameter changes in version 5.6.8:
- Default is -1 (autosized), minimum is 400, maximum is 524288
table_open_cache

Value parameter changes in version 5.6.7:
- Default is 400, minimum is 400, maximum is 524288
Value parameter changes in version 5.6.8:
- Default is 2000, minimum is 400, 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.7:
- Default is not specified, minimum is not specified, maximum is 16384
Value parameter changes in version 5.6.8:
- Default is -1 (autosized), minimum is not specified, 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
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_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

Top / Previous / Next / Up / Table of Contents