1.1 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 (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:

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

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

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

  • 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

• 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 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 (signifies autosizing; do not assign this literal value), 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 (signifies autosizing; do not assign this literal value), 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 (signifies autosizing; do not assign this literal value), 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 (signifies autosizing; do not assign this literal value), 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 (signifies autosizing; do not assign this literal value), 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 (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 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 (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 autosizing; do not assign this literal value), 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 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 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 (signifies autosizing; do not assign this literal value), 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 (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 autosizing; do not assign this literal value), minimum is not specified, maximum is not specified

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

  • Default is 1048576, minimum is 0, maximum is 4294967295

  Value parameter changes in version 5.6.8:

  • Default is 1048576, minimum is 0, maximum is 18446744073709551615

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

  • 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 0, maximum is 4294967295

  Value parameter changes in version 5.6.6:

  • Default is 10000, minimum is 0, maximum is 18446744073709551615

• sync_relay_log

  Value parameter changes in version 5.6.6:

  • Default is 10000, minimum is 0, maximum is 4294967295

  Value parameter changes in version 5.6.6:

  • Default is 10000, minimum is 0, maximum is 18446744073709551615

• sync_relay_log_info

  Value parameter changes in version 5.6.6:

  • Default is 10000, minimum is 0, maximum is 4294967295

  Value parameter changes in version 5.6.6:

  • Default is 10000, minimum is 0, maximum is 18446744073709551615

• 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