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

1.2 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_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 (autosized), minimum is 1, maximum is 65535

  • bind-address

    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:

    • 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 18446744073709551615

  • 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

  • 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

  • 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

  • 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

  • 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 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.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

    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:

    • Default is (autosized), minimum is 1, maximum is 64

    Value parameter changes in version 5.6.6:

    • 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:

    • 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_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 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.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_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.34

  • 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 not specified, 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:

    • 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 4294967295

    Value parameter changes in version 5.6.6:

    • Default is 262144, minimum is 128, maximum is 18446744073709547520

  • 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_index

    Introduced in version 5.6.4

  • log-bin-use-v1-row-events

    Introduced in version 5.6.6

  • 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_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.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:

    • 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 18446744073709551615

  • 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:

    • 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

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

    Introduced in version 5.6.10-ndb-7.3.1

  • 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_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 not specified

  • 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 not specified, 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 (autosized), minimum is -1 (autosized), 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 (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.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.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.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.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.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.6:

    • Default is -1 (autosized), minimum is -1 (autosized), 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 (autosized), minimum is not specified, maximum is not specified

  • 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 (autosized), minimum is not specified, maximum is not specified

  • performance_schema_max_mutex_instances

    Value parameter changes in version 5.6.6:

    • Default is -1 (autosized), minimum is not specified, maximum is not specified

  • performance_schema_max_rwlock_classes

    Value parameter changes in version 5.6.1:

    • Default is 30, minimum is not specified, maximum is not specified

    Value parameter changes in version 5.6.15:

    • Default is 40, minimum is not specified, maximum is not specified

  • performance_schema_max_rwlock_instances

    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.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.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.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.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.6:

    • Default is -1 (autosized), minimum is -1 (autosized), 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:

    • 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 18446744073709551615

  • query_cache_type

    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

  • 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

  • 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_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

  • slave_type_conversions

    Value parameter changes in version 5.6.13:

    • Default is not specified

  • slow-start-timeout

    Introduced in version 5.6.5

  • sort_buffer_size

    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 4294967295

    Value parameter changes in version 5.6.4:

    • Default is 262144, minimum is 32768, maximum is 18446744073709551615

  • 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:

    • 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 18446744073709551615

  • sync_relay_log

    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 18446744073709551615

  • sync_relay_log_info

    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 18446744073709551615

  • table_definition_cache

    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.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 (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

  • 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