1.1 Option and Variable Changes for MySQL 5.7

The following list details the changes to specific options and 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_compression

  Introduced in version 5.7.21

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

  Introduced in version 5.7.37

• audit_log_encryption

  Introduced in version 5.7.21

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

  Introduced in version 5.7.13

• audit_log_flush

  Introduced in version 5.7.9

• audit_log_format

  Introduced in version 5.7.9

  Value parameter changes in version 5.7.21:

  • Default is NEW

• audit_log_format_unix_timestamp

  Introduced in version 5.7.35

• audit_log_include_accounts

  Introduced in version 5.7.9

• audit_log_policy

  Introduced in version 5.7.9

• audit_log_read_buffer_size

  Introduced in version 5.7.21

  Value parameter changes in version 5.7.23:

  • Default is 32768, minimum is 32768, maximum is 4194304

• 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

• authentication_ldap_sasl_auth_method_name

  Introduced in version 5.7.19

• authentication_ldap_sasl_bind_base_dn

  Introduced in version 5.7.19

• authentication_ldap_sasl_bind_root_dn

  Introduced in version 5.7.19

• authentication_ldap_sasl_bind_root_pwd

  Introduced in version 5.7.19

• authentication_ldap_sasl_ca_path

  Introduced in version 5.7.19

• authentication_ldap_sasl_group_search_attr

  Introduced in version 5.7.19

• authentication_ldap_sasl_group_search_filter

  Introduced in version 5.7.21

• authentication_ldap_sasl_init_pool_size

  Introduced in version 5.7.19

• authentication_ldap_sasl_log_status

  Introduced in version 5.7.19

• authentication_ldap_sasl_max_pool_size

  Introduced in version 5.7.19

• authentication_ldap_sasl_server_host

  Introduced in version 5.7.19

• authentication_ldap_sasl_server_port

  Introduced in version 5.7.19

• authentication_ldap_sasl_tls

  Introduced in version 5.7.19

• authentication_ldap_sasl_user_search_attr

  Introduced in version 5.7.19

• authentication_ldap_simple_auth_method_name

  Introduced in version 5.7.19

• authentication_ldap_simple_bind_base_dn

  Introduced in version 5.7.19

• authentication_ldap_simple_bind_root_dn

  Introduced in version 5.7.19

• authentication_ldap_simple_bind_root_pwd

  Introduced in version 5.7.19

• authentication_ldap_simple_ca_path

  Introduced in version 5.7.19

• authentication_ldap_simple_group_search_attr

  Introduced in version 5.7.19

• authentication_ldap_simple_group_search_filter

  Introduced in version 5.7.21

• authentication_ldap_simple_init_pool_size

  Introduced in version 5.7.19

• authentication_ldap_simple_log_status

  Introduced in version 5.7.19

• authentication_ldap_simple_max_pool_size

  Introduced in version 5.7.19

• authentication_ldap_simple_server_host

  Introduced in version 5.7.19

• authentication_ldap_simple_server_port

  Introduced in version 5.7.19

• authentication_ldap_simple_tls

  Introduced in version 5.7.19

• authentication_ldap_simple_user_search_attr

  Introduced in version 5.7.19

• authentication_windows_log_level

  Introduced in version 5.7.9

• authentication_windows_use_principal_name

  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 ON

• binlog_max_flush_queue_time

  Deprecated in version 5.7.9

• binlog_transaction_dependency_history_size

  Introduced in version 5.7.22

• binlog_transaction_dependency_tracking

  Introduced in version 5.7.22

• binlogging_impossible_mode

  Introduced in version 5.7.5

  Removed 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_group_replication_start

  Introduced in version 5.7.6

• Com_group_replication_stop

  Introduced in version 5.7.6

• Com_show_create_user

  Introduced in version 5.7.6

• Com_show_slave_status_nonblocking

  Introduced in version 5.7.0

  Removed in version 5.7.6

• Com_shutdown

  Introduced in version 5.7.9

• Connection_control_delay_generated

  Introduced in version 5.7.17

• connection_control_failed_connections_threshold

  Introduced in version 5.7.17

• connection_control_max_connection_delay

  Introduced in version 5.7.17

• connection_control_min_connection_delay

  Introduced in version 5.7.17

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

• des-key-file

  Deprecated in version 5.7.6

• disable-partition-engine-check

  Introduced in version 5.7.17

  Deprecated in version 5.7.17

  Value parameter changes in version 5.7.21:

  • Default is ON

• 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

• eq_range_index_dive_limit

  Value parameter changes in version 5.7.4:

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

• executed_gtids_compression_period

  Introduced in version 5.7.5

  Removed in version 5.7.6

• Firewall_access_denied

  Introduced in version 5.7.9

• Firewall_access_granted

  Introduced in version 5.7.9

• Firewall_access_suspicious

  Introduced in version 5.7.9

• Firewall_cached_entries

  Introduced in version 5.7.9

• group_replication_allow_local_disjoint_gtids_join

  Introduced in version 5.7.17

  Deprecated in version 5.7.21

• group_replication_allow_local_lower_version_join

  Introduced in version 5.7.17

• group_replication_auto_increment_increment

  Introduced in version 5.7.17

• group_replication_bootstrap_group

  Introduced in version 5.7.17

• group_replication_components_stop_timeout

  Introduced in version 5.7.17

• group_replication_compression_threshold

  Introduced in version 5.7.17

• group_replication_enforce_update_everywhere_checks

  Introduced in version 5.7.17

• group_replication_exit_state_action

  Introduced in version 5.7.24

• group_replication_flow_control_applier_threshold

  Introduced in version 5.7.17

• group_replication_flow_control_certifier_threshold

  Introduced in version 5.7.17

• group_replication_flow_control_mode

  Introduced in version 5.7.17

• group_replication_force_members

  Introduced in version 5.7.17

• group_replication_group_name

  Introduced in version 5.7.17

• group_replication_group_seeds

  Introduced in version 5.7.17

• group_replication_gtid_assignment_block_size

  Introduced in version 5.7.17

• group_replication_ip_whitelist

  Introduced in version 5.7.17

• group_replication_local_address

  Introduced in version 5.7.17

• group_replication_member_weight

  Introduced in version 5.7.20

• group_replication_poll_spin_loops

  Introduced in version 5.7.17

• group_replication_recovery_complete_at

  Introduced in version 5.7.17

• group_replication_recovery_reconnect_interval

  Introduced in version 5.7.17

• group_replication_recovery_retry_count

  Introduced in version 5.7.17

• group_replication_recovery_ssl_ca

  Introduced in version 5.7.17

• group_replication_recovery_ssl_capath

  Introduced in version 5.7.17

• group_replication_recovery_ssl_cert

  Introduced in version 5.7.17

• group_replication_recovery_ssl_cipher

  Introduced in version 5.7.17

• group_replication_recovery_ssl_crl

  Introduced in version 5.7.17

• group_replication_recovery_ssl_crlpath

  Introduced in version 5.7.17

• group_replication_recovery_ssl_key

  Introduced in version 5.7.17

• group_replication_recovery_ssl_verify_server_cert

  Introduced in version 5.7.17

• group_replication_recovery_use_ssl

  Introduced in version 5.7.17

• group_replication_single_primary_mode

  Introduced in version 5.7.17

• group_replication_ssl_mode

  Introduced in version 5.7.17

• group_replication_start_on_boot

  Introduced in version 5.7.17

• group_replication_transaction_size_limit

  Introduced in version 5.7.19

  Value parameter changes in version 5.7.38:

  • Default is 150000000, minimum is 0, maximum is 2147483647

• group_replication_unreachable_majority_timeout

  Introduced in version 5.7.19

• gtid_executed_compression_period

  Introduced in version 5.7.6

• gtid_mode

  Value parameter changes in version 5.7.6:

  • Default is OFF

• have_crypt

  Deprecated in version 5.7.6

• have_query_cache

  Deprecated in version 5.7.20

• have_statement_timeout

  Introduced in version 5.7.4

• ignore-db-dir

  Deprecated in version 5.7.16

• ignore_db_dirs

  Deprecated in version 5.7.16

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

  Deprecated in version 5.7.19

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

  Introduced in version 5.7.15

• 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

  Value parameter changes in version 5.7.9:

  • Default is Barracuda

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

  Introduced in version 5.7.2

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

• innodb_max_dirty_pages_pct_lwm

  Value parameter changes in version 5.7.5:

  • Default is 0, minimum is 0, maximum is 99.999

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

  Introduced in version 5.7.17

• 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 0, 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_logs

  Deprecated in version 5.7.19

• innodb_undo_tablespaces

  Deprecated in version 5.7.21

  Value parameter changes in version 5.7.8:

  • Default is 0, minimum is 0, 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_aws_cmk_id

  Introduced in version 5.7.19

• keyring_aws_conf_file

  Introduced in version 5.7.19

• keyring_aws_data_file

  Introduced in version 5.7.19

• keyring_aws_region

  Introduced in version 5.7.19

  Value parameter changes in version 5.7.27:

  • Default is us-east-1

  Value parameter changes in version 5.7.39:

  • Default is us-east-1

• keyring_encrypted_file_data

  Introduced in version 5.7.21

• keyring_encrypted_file_password

  Introduced in version 5.7.21

• keyring_file_data

  Introduced in version 5.7.11

• keyring-migration-destination

  Introduced in version 5.7.21

• keyring-migration-host

  Introduced in version 5.7.21

• keyring-migration-password

  Introduced in version 5.7.21

• keyring-migration-port

  Introduced in version 5.7.21

• keyring-migration-socket

  Introduced in version 5.7.21

• keyring-migration-source

  Introduced in version 5.7.21

• keyring-migration-user

  Introduced in version 5.7.21

• keyring_okv_conf_dir

  Introduced in version 5.7.12

• keyring_operations

  Introduced in version 5.7.21

• 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-tc-size

  Value parameter changes in version 5.7.21 (bitsize=64):

  • Default is 6 * page size, minimum is 6 * page size, maximum is 18446744073709551615

  Value parameter changes in version 5.7.21 (bitsize=32):

  • Default is 6 * page size, minimum is 6 * page size, maximum is 4294967295

• log_timestamps

  Introduced in version 5.7.2

• log-warnings

  Deprecated in version 5.7.2

  Value parameter changes in version 5.7.2 (bitsize=64):

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

  Value parameter changes in version 5.7.2 (bitsize=32):

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

• 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

• myisam_repair_threads

  Removed in version 5.7.39

  Deprecated in version 5.7.38

• 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

• mysqlx

  Introduced in version 5.7.12

• mysqlx_bind_address

  Introduced in version 5.7.17

• mysqlx_connect_timeout

  Introduced in version 5.7.12

• mysqlx_idle_worker_thread_timeout

  Introduced in version 5.7.12

• mysqlx_max_allowed_packet

  Introduced in version 5.7.12

• mysqlx_max_connections

  Introduced in version 5.7.12

• mysqlx_min_worker_threads

  Introduced in version 5.7.12

• mysqlx_port

  Introduced in version 5.7.12

• mysqlx_port_open_timeout

  Introduced in version 5.7.17

• mysqlx_socket

  Introduced in version 5.7.15

• mysqlx_ssl_ca

  Introduced in version 5.7.12

• mysqlx_ssl_capath

  Introduced in version 5.7.12

• mysqlx_ssl_cert

  Introduced in version 5.7.12

• mysqlx_ssl_cipher

  Introduced in version 5.7.12

• mysqlx_ssl_crl

  Introduced in version 5.7.12

• mysqlx_ssl_crlpath

  Introduced in version 5.7.12

• mysqlx_ssl_key

  Introduced in version 5.7.12

• named_pipe_full_access_group

  Introduced in version 5.7.25

• ndb-allow-copying-alter-table

  Introduced in version 5.7.10-ndb-7.5.0

• ndb-batch-size

  Value parameter changes in version 5.7.37-ndb-7.5.26:

  • Default is 32768, minimum is 0, maximum is 2147483648

  Value parameter changes in version 5.7.37-ndb-7.6.22:

  • Default is 32768, minimum is 0, maximum is 2147483648

• ndb_cache_check_time

  Deprecated in version 5.7.20

• 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-default-column-format

  Introduced in version 5.7.11-ndb-7.5.1

  Value parameter changes in version 5.7.16-ndb-7.5.4:

  • Default is FIXED

• ndb_default_column_format

  Introduced in version 5.7.11-ndb-7.5.1

  Value parameter changes in version 5.7.16-ndb-7.5.4:

  • Default is FIXED

• ndb_eventbuffer_max_alloc

  Value parameter changes in version 5.7.35-ndb-7.5.23:

  • Default is 0, minimum is 0, maximum is 9223372036854775807

  Value parameter changes in version 5.7.35-ndb-7.6.19:

  • Default is 0, minimum is 0, maximum is 9223372036854775807

• ndb_fully_replicated

  Introduced in version 5.7.12-ndb-7.5.2

• ndb-log-fail-terminate

  Introduced in version 5.7.29-ndb-7.6.14

• ndb-log-update-minimal

  Introduced in version 5.7.18-ndb-7.6.3

• ndb_read_backup

  Introduced in version 5.7.12-ndb-7.5.2

• ndb_report_thresh_binlog_epoch_slip

  Value parameter changes in version 5.7.16-ndb-7.5.4:

  • Default is 10, minimum is 0, maximum is 256

• ndb_row_checksum

  Introduced in version 5.7.23-ndb-7.6.8

• Ndb_system_name

  Introduced in version 5.7.18-ndb-7.6.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 0

• 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

  Value parameter changes in version 5.7.33:

  • Default is not specified

• parser_max_mem_size

  Introduced in version 5.7.12

• partition

  Deprecated in version 5.7.16

• performance_schema_accounts_size

  Value parameter changes in version 5.7.6:

  • Default is -1 (signifies autoscaling; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 1048576

• performance-schema-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 (signifies autoscaling; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), 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 (signifies autoscaling; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 1048576

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

• performance_schema_max_file_instances

  Value parameter changes in version 5.7.6:

  • Default is -1 (signifies autoscaling; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 1048576

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

• performance_schema_max_metadata_locks

  Introduced in version 5.7.3

  Value parameter changes in version 5.7.6:

  • Default is -1 (signifies autoscaling; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 10485760

• performance_schema_max_mutex_instances

  Value parameter changes in version 5.7.6:

  • Default is -1 (signifies autoscaling; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 104857600

• performance_schema_max_prepared_statements_instances

  Introduced in version 5.7.4

  Value parameter changes in version 5.7.6:

  • Default is -1 (signifies autoscaling; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 4194304

• performance_schema_max_program_instances

  Introduced in version 5.7.2

  Value parameter changes in version 5.7.6:

  • Default is -1 (signifies autoscaling; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 1048576

• performance_schema_max_rwlock_classes

  Value parameter changes in version 5.7.3:

  • Default is 40, minimum is 0, maximum is 256

  Value parameter changes in version 5.7.25:

  • Default is 50, minimum is 0, maximum is 256

• performance_schema_max_socket_instances

  Value parameter changes in version 5.7.6:

  • Default is -1 (signifies autoscaling; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 1048576

• performance_schema_max_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 (signifies autoscaling; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 1048576

• performance_schema_max_table_lock_stat

  Introduced in version 5.7.6

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

• performance_schema_setup_objects_size

  Value parameter changes in version 5.7.6:

  • Default is -1 (signifies autoscaling; do not assign this literal value), minimum is -1 (signifies autoscaling; do not assign this literal value), maximum is 1048576

• performance_schema_show_processlist

  Introduced in version 5.7.39

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

• Qcache_free_blocks

  Deprecated in version 5.7.20

• Qcache_free_memory

  Deprecated in version 5.7.20

• Qcache_hits

  Deprecated in version 5.7.20

• Qcache_inserts

  Deprecated in version 5.7.20

• Qcache_lowmem_prunes

  Deprecated in version 5.7.20

• Qcache_not_cached

  Deprecated in version 5.7.20

• Qcache_queries_in_cache

  Deprecated in version 5.7.20

• Qcache_total_blocks

  Deprecated in version 5.7.20

• query_alloc_block_size

  Value parameter changes in version 5.7.9:

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

• query_cache_limit

  Deprecated in version 5.7.20

• query_cache_min_res_unit

  Deprecated in version 5.7.20

• query_cache_size

  Deprecated in version 5.7.20

• query_cache_type

  Deprecated in version 5.7.20

• query_cache_wlock_invalidate

  Deprecated in version 5.7.20

• range_alloc_block_size

  Value parameter changes in version 5.7.8 (bitsize=64):

  • Default is 4096, minimum is 4096, maximum is 18446744073709550592

  Value parameter changes in version 5.7.9:

  • Default is 4096, minimum is 4096, maximum is 4294966272

• range_optimizer_max_mem_size

  Introduced in version 5.7.9

  Value parameter changes in version 5.7.12:

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

• rbr_exec_mode

  Introduced in version 5.7.1

• replication_optimize_for_static_plugin_config

  Introduced in version 5.7.33

• replication_sender_observe_commit_only

  Introduced in version 5.7.33

• 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

• session_track_transaction_info

  Introduced in version 5.7.8

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

  Introduced in version 5.7.22

• 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

  Removed in version 5.7.6

• skip-partition

  Deprecated in version 5.7.16

• Slave_heartbeat_period

  Deprecated in version 5.7.6

• Slave_last_heartbeat

  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 31536000

• slave_parallel_type

  Introduced in version 5.7.2

• slave_preserve_commit_order

  Introduced in version 5.7.5

• Slave_received_heartbeats

  Deprecated in version 5.7.6

• Slave_retried_transactions

  Deprecated in version 5.7.6

• Slave_running

  Deprecated in version 5.7.6

  Value parameter changes in version 5.7.99:

  • Default is not specified

• slave_type_conversions

  Value parameter changes in version 5.7.2:

  • Default is

• 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

• ssl

  Value parameter changes in version 5.7.5:

  • Default is ON

• 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 0, 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

• temp-pool

  Deprecated in version 5.7.18

• thread_concurrency

  Removed in version 5.7.2

• thread_handling

  Value parameter changes in version 5.7.9:

  • Default is one-thread-per-connection

• thread_pool_algorithm

  Introduced in version 5.7.9

• thread_pool_high_priority_connection

  Introduced in version 5.7.9

• thread_pool_max_unused_threads

  Introduced in version 5.7.9

• thread_pool_prio_kickup_timer

  Introduced in version 5.7.9

• thread_pool_size

  Introduced in version 5.7.9

• thread_pool_stall_limit

  Introduced in version 5.7.9

• timed_mutexes

  Removed in version 5.7.5

• tls_version

  Introduced in version 5.7.10

  Value parameter changes in version 5.7.28:

  • Default is TLSv1,TLSv1.1,TLSv1.2

• 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

  Value parameter changes in version 5.7.14:

  • Default is OFF

• tx_isolation

  Deprecated in version 5.7.20

• tx_read_only

  Deprecated in version 5.7.20

• validate_password_check_user_name

  Introduced in version 5.7.15

• 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