MySQL Server Version Reference  /  mysqld Options and Variables  /  Option and Variable Changes for MySQL 5.7

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