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

1.4 Option/Variable Changes for mysqld 5.7

The list below details the changes in specific options/variables within MySQL 5.7

  • audit-log

    Introduced in version 5.7.9

  • audit_log_buffer_size

    Introduced in version 5.7.9

  • audit_log_connection_policy

    Introduced in version 5.7.9

  • audit_log_current_session

    Introduced in version 5.7.9

  • Audit_log_current_size

    Introduced in version 5.7.9

  • Audit_log_event_max_drop_size

    Introduced in version 5.7.9

  • Audit_log_events

    Introduced in version 5.7.9

  • Audit_log_events_filtered

    Introduced in version 5.7.9

  • Audit_log_events_lost

    Introduced in version 5.7.9

  • Audit_log_events_written

    Introduced in version 5.7.9

  • audit_log_exclude_accounts

    Introduced in version 5.7.9

  • audit_log_file

    Introduced in version 5.7.9

  • audit_log_flush

    Introduced in version 5.7.9

  • audit_log_format

    Introduced in version 5.7.9

  • audit_log_include_accounts

    Introduced in version 5.7.9

  • audit_log_policy

    Introduced in version 5.7.9

  • audit_log_rotate_on_size

    Introduced in version 5.7.9

  • audit_log_statement_policy

    Introduced in version 5.7.9

  • audit_log_strategy

    Introduced in version 5.7.9

  • Audit_log_total_size

    Introduced in version 5.7.9

  • Audit_log_write_waits

    Introduced in version 5.7.9

  • auto_generate_certs

    Introduced in version 5.7.5

  • avoid_temporal_upgrade

    Introduced in version 5.7.6

    Deprecated in version 5.7.6

  • binlog_error_action

    Introduced in version 5.7.6

    Value parameter changes in version 5.7.7:

    • Default is ABORT_SERVER

  • binlog-format

    Value parameter changes in version 5.7.7:

    • Default is ROW

  • binlog_group_commit_sync_delay

    Introduced in version 5.7.5

  • binlog_group_commit_sync_no_delay_count

    Introduced in version 5.7.5

  • binlog_gtid_simple_recovery

    Introduced in version 5.7.6

    Value parameter changes in version 5.7.7:

    • Default is TRUE

  • binlog_max_flush_queue_time

    Deprecated in version 5.7.9

  • binlogging_impossible_mode

    Introduced in version 5.7.5

    Deprecated in version 5.7.6

  • block_encryption_mode

    Introduced in version 5.7.4

  • bootstrap

    Deprecated in version 5.7.6

  • check_proxy_users

    Introduced in version 5.7.7

  • Com_change_repl_filter

    Introduced in version 5.7.3

  • Com_explain_other

    Introduced in version 5.7.2

  • Com_show_create_user

    Introduced in version 5.7.6

  • Com_show_slave_status_nonblocking

    Introduced in version 5.7.6

  • Com_shutdown

    Introduced in version 5.7.9

  • create_old_temporals

    Removed in version 5.7

  • daemonize

    Introduced in version 5.7.6

  • default-authentication-plugin

    Removed in version 5.7.2

  • default_authentication_plugin

    Introduced in version 5.7.2

  • default_password_lifetime

    Introduced in version 5.7.4

    Value parameter changes in version 5.7.11:

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

  • disabled_storage_engines

    Introduced in version 5.7.8

  • disconnect_on_expired_password

    Introduced in version 5.7.1

  • early-plugin-load

    Introduced in version 5.7.11

    Value parameter changes in version 5.7.12:

    • Default is empty string

  • enforce-gtid-consistency

    Value parameter changes in version 5.7.6:

    • Default is OFF

  • enforce_gtid_consistency

    Value parameter changes in version 5.7.6:

    • Default is OFF

  • eq_range_index_dive_limit

    Value parameter changes in version 5.7.4:

    • Default is 200, minimum is not specified, maximum is 4294967295

  • executed-gtids-compression-period

    Introduced in version 5.7.5

    Deprecated in version 5.7.6

  • executed_gtids_compression_period

    Introduced in version 5.7.5

    Deprecated in version 5.7.6

  • Firewall_access_denied

    Introduced in version 5.7.9

  • Firewall_access_granted

    Introduced in version 5.7.9

  • Firewall_cached_entries

    Introduced in version 5.7.9

  • gtid-executed-compression-period

    Introduced in version 5.7.6

  • gtid_executed_compression_period

    Introduced in version 5.7.6

  • gtid-mode

    Value parameter changes in version 5.7.6:

    • Default is OFF

  • gtid_mode

    Value parameter changes in version 5.7.6:

    • Default is OFF

  • have_statement_timeout

    Introduced in version 5.7.4

  • initialize

    Introduced in version 5.7.6

  • initialize-insecure

    Introduced in version 5.7.6

  • innodb

    Deprecated in version 5.7.5

  • innodb_adaptive_hash_index_parts

    Introduced in version 5.7.8

  • innodb_additional_mem_pool_size

    Removed in version 5.7.4

  • innodb_background_drop_list_empty

    Introduced in version 5.7.10

  • innodb_buffer_pool_chunk_size

    Introduced in version 5.7.5

  • innodb_buffer_pool_dump_at_shutdown

    Value parameter changes in version 5.7.7:

    • Default is ON

  • innodb_buffer_pool_dump_pct

    Introduced in version 5.7.2

    Value parameter changes in version 5.7.7:

    • Default is 25, minimum is 1, maximum is 100

  • innodb_buffer_pool_load_at_startup

    Value parameter changes in version 5.7.7:

    • Default is ON

  • Innodb_buffer_pool_resize_status

    Introduced in version 5.7.5

  • innodb_checksum_algorithm

    Value parameter changes in version 5.7.7:

    • Default is crc32

  • innodb_compress_debug

    Introduced in version 5.7.8

  • innodb_create_intrinsic

    Introduced in version 5.7.5

    Removed in version 5.7.6

  • innodb_default_row_format

    Introduced in version 5.7.9

  • innodb_disable_resize_buffer_pool_debug

    Introduced in version 5.7.6

  • innodb_file_format

    Deprecated in version 5.7.7

    Value parameter changes in version 5.7.7:

    • Default is Barracuda

  • innodb_file_format_check

    Deprecated in version 5.7.7

  • innodb_file_format_max

    Deprecated in version 5.7.7

  • innodb_fill_factor

    Introduced in version 5.7.5

  • innodb_flush_sync

    Introduced in version 5.7.8

  • innodb_ft_max_token_size

    Value parameter changes in version 5.7.3:

    • Default is 84, minimum is 10, maximum is 84

  • innodb_ft_result_cache_limit

    Introduced in version 5.7.2

    Value parameter changes in version 5.7.4:

    • Default is 2000000000, minimum is 1000000, maximum is 2**32-1

  • innodb_ft_total_cache_size

    Introduced in version 5.7.2

  • innodb_large_prefix

    Deprecated in version 5.7.7

    Value parameter changes in version 5.7.7:

    • Default is ON

  • innodb_log_buffer_size

    Value parameter changes in version 5.7.6:

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

  • innodb_log_checksum_algorithm

    Introduced in version 5.7.8

    Removed in version 5.7.9

  • innodb_log_checksums

    Introduced in version 5.7.9

  • innodb_log_file_size

    Value parameter changes in version 5.7.11:

    • Default is 50331648, minimum is 4194304, maximum is 512GB / innodb_log_files_in_group

  • innodb_log_write_ahead_size

    Introduced in version 5.7.4

  • innodb_max_dirty_pages_pct

    Value parameter changes in version 5.7.5:

    • Default is 75, minimum is not specified, maximum is 99.99

  • innodb_max_dirty_pages_pct_lwm

    Value parameter changes in version 5.7.5:

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

  • innodb_max_undo_log_size

    Introduced in version 5.7.5

  • innodb_merge_threshold_set_all_debug

    Introduced in version 5.7.6

  • innodb_numa_interleave

    Introduced in version 5.7.9

  • innodb_optimize_point_storage

    Introduced in version 5.7.5

    Removed in version 5.7.6

  • innodb_page_cleaners

    Introduced in version 5.7.4

    Value parameter changes in version 5.7.8:

    • Default is 4, minimum is 1, maximum is 64

  • innodb_page_size

    Value parameter changes in version 5.7.6:

    • Default is 16384

  • innodb_purge_rseg_truncate_frequency

    Introduced in version 5.7.5

  • innodb_purge_threads

    Value parameter changes in version 5.7.8:

    • Default is 4, minimum is 1, maximum is 32

  • innodb_status_output

    Introduced in version 5.7.4

  • innodb_status_output_locks

    Introduced in version 5.7.4

  • innodb_strict_mode

    Value parameter changes in version 5.7.7:

    • Default is ON

  • innodb_support_xa

    Deprecated in version 5.7.10

  • innodb_sync_debug

    Introduced in version 5.7.8

  • innodb_temp_data_file_path

    Introduced in version 5.7.1

  • innodb_thread_sleep_delay

    Value parameter changes in version 5.7.4:

    • Default is 10000, minimum is not specified, maximum is 1000000

  • innodb_tmpdir

    Introduced in version 5.7.11

  • innodb_undo_directory

    Value parameter changes in version 5.7.8:

    • Default is not specified

  • innodb_undo_log_truncate

    Introduced in version 5.7.5

  • innodb_undo_tablespaces

    Value parameter changes in version 5.7.8:

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

  • innodb_use_sys_malloc

    Removed in version 5.7.4

  • internal_tmp_disk_storage_engine

    Introduced in version 5.7.5

    Value parameter changes in version 5.7.6:

    • Default is INNODB

  • keyring_file_data

    Introduced in version 5.7.11

  • keyring_okv_conf_dir

    Introduced in version 5.7.12

  • Locked_connects

    Introduced in version 5.7.6

  • log_backward_compatible_user_definitions

    Introduced in version 5.7.6

    Removed in version 5.7.9

  • log_builtin_as_identified_by_password

    Introduced in version 5.7.9

  • log_error_verbosity

    Introduced in version 5.7.2

  • log-slow-admin-statements

    Removed in version 5.7.1

  • log_slow_admin_statements

    Introduced in version 5.7.1

  • log-slow-slave-statements

    Removed in version 5.7.1

  • log_slow_slave_statements

    Introduced in version 5.7.1

  • log_statements_unsafe_for_binlog

    Introduced in version 5.7.11

  • log_syslog

    Introduced in version 5.7.5

  • log_syslog_facility

    Introduced in version 5.7.5

  • log_syslog_include_pid

    Introduced in version 5.7.5

  • log_syslog_tag

    Introduced in version 5.7.5

  • log_timestamps

    Introduced in version 5.7.2

  • log-warnings

    Deprecated in version 5.7.2

    Value parameter changes in version 5.7.2:

    • Default is 2, minimum is not specified, maximum is 4294967295

    Value parameter changes in version 5.7.2:

    • Default is 2, minimum is not specified, maximum is 18446744073709551615

  • max_digest_length

    Introduced in version 5.7.6

  • max_execution_time

    Introduced in version 5.7.8

  • Max_execution_time_exceeded

    Introduced in version 5.7.8

  • Max_execution_time_set

    Introduced in version 5.7.8

  • Max_execution_time_set_failed

    Introduced in version 5.7.8

  • max_points_in_geometry

    Introduced in version 5.7.8

  • max_statement_time

    Introduced in version 5.7.4

    Removed in version 5.7.8

  • Max_statement_time_exceeded

    Introduced in version 5.7.4

    Removed in version 5.7.8

  • Max_statement_time_set

    Introduced in version 5.7.4

    Removed in version 5.7.8

  • Max_statement_time_set_failed

    Introduced in version 5.7.4

    Removed in version 5.7.8

  • Max_used_connections_time

    Introduced in version 5.7.5

  • mecab_charset

    Introduced in version 5.7.6

  • mecab_rc_file

    Introduced in version 5.7.6

  • metadata_locks_cache_size

    Deprecated in version 5.7.4

  • metadata_locks_hash_instances

    Deprecated in version 5.7.4

  • mysql_firewall_mode

    Introduced in version 5.7.9

  • mysql_firewall_trace

    Introduced in version 5.7.9

  • mysql_native_password_proxy_users

    Introduced in version 5.7.7

  • ndb-allow-copying-alter-table

    Introduced in version 5.7.10-ndb-7.5.0

  • ndb-cluster-connection-pool-nodeids

    Introduced in version 5.7.10-ndb-7.5.0

  • ndb_data_node_neighbour

    Introduced in version 5.7.12-ndb-7.5.2

  • ndb_fully_replicated

    Introduced in version 5.7.12-ndb-7-5-2

  • ndb_read_backup

    Introduced in version 5.7.12-ndb-7.5.2

  • ngram_token_size

    Introduced in version 5.7.6

  • offline_mode

    Introduced in version 5.7.5

  • old_passwords

    Deprecated in version 5.7.6

    Value parameter changes in version 5.7.5:

    • Default is not specified

  • optimizer_switch

    Value parameter changes in version 5.7.5:

    • Default is not specified

    Value parameter changes in version 5.7.6:

    • Default is not specified

    Value parameter changes in version 5.7.8:

    • Default is not specified

  • parser_max_mem_size

    Introduced in version 5.7.12

  • performance_schema_accounts_size

    Value parameter changes in version 5.7.6:

    • Default is -1 (autoscaled), minimum is -1 (autoscaled), maximum is 1048576

  • performance-schema-consumer-events-transactions-current

    Introduced in version 5.7.3

  • performance-schema-consumer-events-transactions-history

    Introduced in version 5.7.3

  • performance-schema-consumer-events-transactions-history-long

    Introduced in version 5.7.3

  • performance_schema_events_transactions_history_long_size

    Introduced in version 5.7.3

  • performance_schema_events_transactions_history_size

    Introduced in version 5.7.3

  • performance_schema_hosts_size

    Value parameter changes in version 5.7.6:

    • Default is -1 (autoscaled), minimum is -1 (autoscaled), maximum is 1048576

  • Performance_schema_index_stat_lost

    Introduced in version 5.7.6

  • performance_schema_max_cond_instances

    Value parameter changes in version 5.7.6:

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

  • performance_schema_max_digest_length

    Introduced in version 5.7.8

  • performance_schema_max_file_classes

    Value parameter changes in version 5.7.9:

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

  • performance_schema_max_file_instances

    Value parameter changes in version 5.7.6:

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

  • performance_schema_max_index_stat

    Introduced in version 5.7.6

  • performance_schema_max_memory_classes

    Introduced in version 5.7.2

    Value parameter changes in version 5.7.5:

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

  • performance_schema_max_metadata_locks

    Introduced in version 5.7.3

    Value parameter changes in version 5.7.6:

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

  • performance_schema_max_mutex_instances

    Value parameter changes in version 5.7.6:

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

  • performance_schema_max_prepared_statements_instances

    Introduced in version 5.7.4

    Value parameter changes in version 5.7.6:

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

  • performance_schema_max_program_instances

    Introduced in version 5.7.2

    Value parameter changes in version 5.7.6:

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

  • performance_schema_max_rwlock_classes

    Value parameter changes in version 5.7.3:

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

  • performance_schema_max_rwlock_instances

    Value parameter changes in version 5.7.6:

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

  • performance_schema_max_socket_instances

    Value parameter changes in version 5.7.6:

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

  • performance_schema_max_sql_text_length

    Introduced in version 5.7.6

  • performance_schema_max_statement_stack

    Introduced in version 5.7.2

  • performance_schema_max_table_handles

    Value parameter changes in version 5.7.6:

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

  • performance_schema_max_table_instances

    Value parameter changes in version 5.7.6:

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

  • performance_schema_max_table_lock_stat

    Introduced in version 5.7.6

  • performance_schema_max_thread_instances

    Value parameter changes in version 5.7.6:

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

  • Performance_schema_memory_classes_lost

    Introduced in version 5.7.2

  • Performance_schema_metadata_lock_lost

    Introduced in version 5.7.3

  • Performance_schema_nested_statement_lost

    Introduced in version 5.7.2

  • Performance_schema_prepared_statements_lost

    Introduced in version 5.7.4

  • Performance_schema_program_lost

    Introduced in version 5.7.2

  • performance_schema_setup_actors_size

    Value parameter changes in version 5.7.6:

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

  • performance_schema_setup_objects_size

    Value parameter changes in version 5.7.6:

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

  • Performance_schema_table_lock_stat_lost

    Introduced in version 5.7.6

  • performance_schema_users_size

    Value parameter changes in version 5.7.6:

    • Default is -1 (autoscaled), minimum is -1 (autoscaled), maximum is 1048576

  • query_alloc_block_size

    Value parameter changes in version 5.7.9:

    • Default is 8192, minimum is 1024, maximum is 4294967295

  • range_alloc_block_size

    Value parameter changes in version 5.7.9:

    • Default is 4096, minimum is 4096, maximum is 4294967295

    Value parameter changes in version 5.7.8:

    • Default is 4096, minimum is 4096, maximum is 18446744073709547520

  • range_optimizer_max_mem_size

    Introduced in version 5.7.9

    Value parameter changes in version 5.7.12:

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

  • rbr_exec_mode

    Introduced in version 5.7.1

  • require_secure_transport

    Introduced in version 5.7.8

  • rewriter_enabled

    Introduced in version 5.7.6

  • Rewriter_number_loaded_rules

    Introduced in version 5.7.6

  • Rewriter_number_reloads

    Introduced in version 5.7.6

  • Rewriter_number_rewritten_queries

    Introduced in version 5.7.6

  • Rewriter_reload_error

    Introduced in version 5.7.6

  • rewriter_verbose

    Introduced in version 5.7.6

  • rpl_semi_sync_master_wait_for_slave_count

    Introduced in version 5.7.3

  • rpl_semi_sync_master_wait_point

    Introduced in version 5.7.2

  • rpl_stop_slave_timeout

    Introduced in version 5.7.2

  • secure-auth

    Deprecated in version 5.7.5

    Value parameter changes in version 5.7.5:

    • Default is ON

  • secure-file-priv

    Value parameter changes in version 5.7.6:

    • Default is platform specific

  • session_track_gtids

    Introduced in version 5.7.6

  • session_track_schema

    Introduced in version 5.7.4

  • session_track_state_change

    Introduced in version 5.7.4

  • session_track_system_variables

    Introduced in version 5.7.4

  • sha256_password_auto_generate_rsa_keys

    Introduced in version 5.7.5

  • sha256_password_proxy_users

    Introduced in version 5.7.7

  • show_compatibility_56

    Introduced in version 5.7.6

    Deprecated in version 5.7.6

    Value parameter changes in version 5.7.8:

    • Default is OFF

  • show_old_temporals

    Introduced in version 5.7.6

    Deprecated in version 5.7.6

  • simplified_binlog_gtid_recovery

    Introduced in version 5.7.5

    Deprecated in version 5.7.6

  • slave-net-timeout

    Value parameter changes in version 5.7.7:

    • Default is 60, minimum is 1, maximum is not specified

  • slave-parallel-type

    Introduced in version 5.7.2

  • slave_parallel_type

    Introduced in version 5.7.2

  • slave_preserve_commit_order

    Introduced in version 5.7.5

  • slave_type_conversions

    Value parameter changes in version 5.7.2:

    • Default is not specified

  • sql-mode

    Value parameter changes in version 5.7.5:

    • Default is ONLY_FULL_GROUP_BY STRICT_TRANS_TABLES NO_ENGINE_SUBSTITUTION

    Value parameter changes in version 5.7.7:

    • Default is ONLY_FULL_GROUP_BY STRICT_TRANS_TABLES NO_AUTO_CREATE_USER NO_ENGINE_SUBSTITUTION

    Value parameter changes in version 5.7.8:

    • Default is ONLY_FULL_GROUP_BY STRICT_TRANS_TABLES NO_ZERO_IN_DATE NO_ZERO_DATE ERROR_FOR_DIVISION_BY_ZERO NO_AUTO_CREATE_USER NO_ENGINE_SUBSTITUTION

  • storage_engine

    Removed in version 5.7.5

  • stored_program_cache

    Value parameter changes in version 5.7.6:

    • Default is 256, minimum is 16, maximum is 524288

  • super_read_only

    Introduced in version 5.7.8

  • sync_binlog

    Value parameter changes in version 5.7.7:

    • Default is 1, minimum is not specified, maximum is 4294967295

  • sync_frm

    Deprecated in version 5.7.6

  • table_open_cache_instances

    Value parameter changes in version 5.7.8:

    • Default is 16, minimum is 1, maximum is 64

  • thread_concurrency

    Removed in version 5.7.2

  • thread_handling

    Value parameter changes in version 5.7.9:

    • Default is one-thread-per-connection

  • timed_mutexes

    Removed in version 5.7.5

  • tls_version

    Introduced in version 5.7.10

  • transaction_alloc_block_size

    Value parameter changes in version 5.7.6:

    • Default is 8192, minimum is 1024, maximum is 131072

  • transaction_prealloc_size

    Value parameter changes in version 5.7.6:

    • Default is 4096, minimum is 1024, maximum is 131072

  • transaction_write_set_extraction

    Introduced in version 5.7.6

  • validate_password_dictionary_file_last_parsed

    Introduced in version 5.7.8

  • validate_password_dictionary_file_words_count

    Introduced in version 5.7.8

  • version_tokens_session

    Introduced in version 5.7.8

  • version_tokens_session_number

    Introduced in version 5.7.8