MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W
activate_all_roles_on_login
admin_address
admin_port
audit_log_buffer_size
audit_log_compression
audit_log_connection_policy
audit_log_current_session
audit_log_encryption
audit_log_exclude_accounts
audit_log_file
audit_log_filter_id
audit_log_flush
audit_log_format
audit_log_include_accounts
audit_log_policy
audit_log_read_buffer_size
audit_log_rotate_on_size
audit_log_statement_policy
audit_log_strategy
authentication_ldap_sasl_auth_method_name
authentication_ldap_sasl_bind_base_dn
authentication_ldap_sasl_bind_root_dn
authentication_ldap_sasl_bind_root_pwd
authentication_ldap_sasl_ca_path
authentication_ldap_sasl_group_search_attr
authentication_ldap_sasl_group_search_filter
authentication_ldap_sasl_init_pool_size
authentication_ldap_sasl_log_status
authentication_ldap_sasl_max_pool_size
authentication_ldap_sasl_server_host
authentication_ldap_sasl_server_port
authentication_ldap_sasl_tls
authentication_ldap_sasl_user_search_attr
authentication_ldap_simple_auth_method_name
authentication_ldap_simple_bind_base_dn
authentication_ldap_simple_bind_root_dn
authentication_ldap_simple_bind_root_pwd
authentication_ldap_simple_ca_path
authentication_ldap_simple_group_search_attr
authentication_ldap_simple_group_search_filter
authentication_ldap_simple_init_pool_size
authentication_ldap_simple_log_status
authentication_ldap_simple_max_pool_size
authentication_ldap_simple_server_host
authentication_ldap_simple_server_port
authentication_ldap_simple_tls
authentication_ldap_simple_user_search_attr
authentication_windows_log_level
authentication_windows_use_principal_name
auto_generate_certs
auto_increment_increment
- Section 15.6.1.4, “AUTO_INCREMENT Handling in InnoDB”
- Section 18.10, “Frequently Asked Questions”
- Section 18.8, “Group Replication System Variables”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section A.1, “MySQL 8.0 FAQ: General”
- Section 22.4.13, “ndb_import — Import CSV Data Into NDB”
- Section 17.4.1.38, “Replication and Variables”
- Section 17.1.6.2, “Replication Master Options and Variables”
- Section 3.6.9, “Using AUTO_INCREMENT”
- Section 21.4, “Working with InnoDB Cluster”
auto_increment_offset
- Section 15.6.1.4, “AUTO_INCREMENT Handling in InnoDB”
- Section 18.10, “Frequently Asked Questions”
- Section 18.8, “Group Replication System Variables”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section A.1, “MySQL 8.0 FAQ: General”
- Section 22.4.13, “ndb_import — Import CSV Data Into NDB”
- Section 17.4.1.38, “Replication and Variables”
- Section 17.1.6.2, “Replication Master Options and Variables”
- Section 3.6.9, “Using AUTO_INCREMENT”
- Section 21.4, “Working with InnoDB Cluster”
autocommit
- Section 13.1.10, “ALTER TABLESPACE Syntax”
- Section 15.7.2.2, “autocommit, Commit, and Rollback”
- Section 15.6.1.3, “Converting Tables from MyISAM to InnoDB”
- Section 15.7.5.2, “Deadlock Detection and Rollback”
- Section 13.2.2, “DELETE Syntax”
- Section 15.6.3.3, “General Tablespaces”
- Section 15.7, “InnoDB Locking and Transaction Model”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 15.6.1.6, “Limits on InnoDB Tables”
- Section 13.3.6, “LOCK TABLES and UNLOCK TABLES Syntax”
- Section 15.7.2.4, “Locking Reads”
- Section 15.7.3, “Locks Set by Different SQL Statements in InnoDB”
- Section 28.7.7.69, “mysql_session_track_get_first()”
- Section 22.3.3.9.2, “NDB Cluster System Variables”
- Section 8.5.3, “Optimizing InnoDB Read-Only Transactions”
- Section 26.12.7, “Performance Schema Transaction Tables”
- Section 17.4.1.30, “Replication and Temporary Tables”
- Section 17.4.1.34, “Replication and Transactions”
- Section 17.1.3.6, “Restrictions on Replication with GTIDs”
- Section 5.1.8, “Server System Variables”
- Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
- Section 25.39.29, “The INFORMATION_SCHEMA INNODB_TRX Table”
- Section 5.6.3.3, “Thread Pool Operation”
- Section 15.7.2.1, “Transaction Isolation Levels”
automatic_sp_privileges
avoid_temporal_upgrade
basedir
big_tables
bind_address
- Section B.4.2.2, “Can't connect to [local] MySQL server”
- Section 5.1.12.2, “Configuring the MySQL Server to Permit IPv6 Connections”
- Section 5.1.12.4, “Connecting Using IPv6 Nonlocal Host Addresses”
- Section 5.1.12.3, “Connecting Using the IPv6 Local Host Address”
- Section 18.5.1, “Group Replication IP Address Whitelisting”
- Section 5.1.12, “IPv6 Support”
- Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
- Section 5.1.9.4, “Nonpersistible and Persist-Restricted System Variables”
- Section 5.1.12.5, “Obtaining an IPv6 Address from a Broker”
- Section 5.8, “Running Multiple MySQL Instances on One Machine”
- Section 5.1.8, “Server System Variables”
- Section 18.4.6, “Support For IPv6 And For Mixed IPv6 And IPv4 Groups”
- Section 22.5.10.30, “The ndbinfo processes Table”
- Section 6.2.21, “Troubleshooting Problems Connecting to MySQL”
- Section 20.5.5.2, “X Plugin Options and System Variables”
binlog
binlog_cache_size
binlog_checksum
binlog_direct_non_transactional_updates
binlog_encryption
- Section 13.1.5, “ALTER INSTANCE Syntax”
- Section 17.1.6.4, “Binary Logging Options and Variables”
- Section 17.3.10, “Encrypting Binary Log Files and Relay Log Files”
- Section 6.1.3, “Making MySQL Secure Against Attackers”
- Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
- Section 6.2.2, “Privileges Provided by MySQL”
- Section 13.7.6.1, “SHOW BINARY LOGS Syntax”
- Section 5.4.4, “The Binary Log”
- Section 6.4.4, “The MySQL Keyring”
binlog_error_action
binlog_expire_logs_seconds
binlog_format
- Section 17.1.6.4, “Binary Logging Options and Variables”
- Section 11.7, “Data Type Default Values”
- Section 12.7, “Date and Time Functions”
- Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 17.2.5.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 17.2.5.2, “Evaluation of Table-Level Replication Options”
- Section 17.1.3.2, “GTID Life Cycle”
- Section 12.15, “Information Functions”
- Section 12.14, “Locking Functions”
- Section 5.4.4.4, “Logging Format for Changes to mysql Database Tables”
- Section 12.6.2, “Mathematical Functions”
- Section 12.24, “Miscellaneous Functions”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section A.13, “MySQL 8.0 FAQ: Replication”
- Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
- Section 23.3.5, “Obtaining Information About Partitions”
- Section 6.2.2, “Privileges Provided by MySQL”
- Section 17.4.1.2, “Replication and BLACKHOLE Tables”
- Section 17.4.1.19, “Replication and LOAD DATA”
- Section 17.4.1.21, “Replication and MEMORY Tables”
- Section 17.4.1.30, “Replication and Temporary Tables”
- Section 17.4.1.34, “Replication and Transactions”
- Section 17.2.1, “Replication Formats”
- Section 17.4.1.22, “Replication of the mysql System Schema”
- Section 17.1.3.6, “Restrictions on Replication with GTIDs”
- Section C.6, “Restrictions on XA Transactions”
- Section B.3.1, “Server Error Message Reference”
- Section 5.4.4.2, “Setting The Binary Log Format”
- Section 24.7, “Stored Program Binary Logging”
- Section 5.1.9.1, “System Variable Privileges”
- Section 16.6, “The BLACKHOLE Storage Engine”
- Section 5.4.3, “The General Query Log”
- Section 15.19.7, “The InnoDB memcached Plugin and Replication”
- Section 15.7.2.1, “Transaction Isolation Levels”
- Section 17.4.3, “Upgrading a Replication Setup”
- Section 17.2.1.2, “Usage of Row-Based Logging and Replication”
binlog_group_commit_sync_delay
binlog_group_commit_sync_no_delay_count
binlog_gtid_simple_recovery
binlog_max_flush_queue_time
binlog_order_commits
binlog_rotate_encryption_master_key_at_startup
binlog_row_event_max_size
binlog_row_image
binlog_row_metadata
binlog_row_value_options
binlog_rows_query_log_events
binlog_stmt_cache_size
binlog_transaction_dependency_history_size
binlog_transaction_dependency_tracking
block_encryption_mode
bulk_insert_buffer_size
caching_sha
character_set_client
- Section 28.7.9.1, “C API Prepared Statement Type Codes”
- Section 10.14, “Character Set Configuration”
- Section 10.4, “Connection Character Sets and Collations”
- Section 13.2.7, “LOAD DATA Syntax”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
- Section 28.7.7.69, “mysql_session_track_get_first()”
- Section 17.4.1.38, “Replication and Variables”
- Section 5.1.8, “Server System Variables”
- Section 13.7.5.2, “SET CHARACTER SET Syntax”
- Section 13.7.5.3, “SET NAMES Syntax”
- Section 13.7.6.7, “SHOW CREATE EVENT Syntax”
- Section 13.7.6.9, “SHOW CREATE PROCEDURE Syntax”
- Section 13.7.6.11, “SHOW CREATE TRIGGER Syntax”
- Section 13.7.6.13, “SHOW CREATE VIEW Syntax”
- Section 13.7.6.18, “SHOW EVENTS Syntax”
- Section 13.7.6.28, “SHOW PROCEDURE STATUS Syntax”
- Section 13.7.6.38, “SHOW TRIGGERS Syntax”
- Section 5.4.4, “The Binary Log”
- Section 25.10, “The INFORMATION_SCHEMA EVENTS Table”
- Section 25.23, “The INFORMATION_SCHEMA ROUTINES Table”
- Section 25.34, “The INFORMATION_SCHEMA TRIGGERS Table”
- Section 25.36, “The INFORMATION_SCHEMA VIEWS Table”
- Section 5.6.4.2, “Using the Rewriter Query Rewrite Plugin”
character_set_connection
- Section 12.10, “Cast Functions and Operators”
- Section 12.5.3, “Character Set and Collation of Function Results”
- Section 10.3.8, “Character Set Introducers”
- Section 10.2.1, “Character Set Repertoire”
- Section 10.3.6, “Character String Literal Character Set and Collation”
- Section 10.8.4, “Collation Coercibility in Expressions”
- Section 10.4, “Connection Character Sets and Collations”
- Section 12.7, “Date and Time Functions”
- Section 12.13, “Encryption and Compression Functions”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
- Section 10.15, “MySQL Server Locale Support”
- Section 28.7.7.69, “mysql_session_track_get_first()”
- Section 17.4.1.38, “Replication and Variables”
- Section 5.1.8, “Server System Variables”
- Section 13.7.5.2, “SET CHARACTER SET Syntax”
- Section 13.7.5.3, “SET NAMES Syntax”
- Section 9.1.1, “String Literals”
- Section 12.2, “Type Conversion in Expression Evaluation”
character_set_database
- Section 13.1.9, “ALTER TABLE Syntax”
- Section 2.11.4, “Changes in MySQL 8.0”
- Section 10.4, “Connection Character Sets and Collations”
- Section 13.1.17, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
- Section 10.3.3, “Database Character Set and Collation”
- Section 13.2.7, “LOAD DATA Syntax”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 17.4.1.38, “Replication and Variables”
- Section 5.1.8, “Server System Variables”
- Section 13.7.5.2, “SET CHARACTER SET Syntax”
character_set_filesystem
character_set_results
- Section 28.7.5, “C API Data Structures”
- Section 10.4, “Connection Character Sets and Collations”
- Section 10.6, “Error Message Character Set”
- Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
- Section 28.7.7.69, “mysql_session_track_get_first()”
- Section 5.1.8, “Server System Variables”
- Section 13.7.5.2, “SET CHARACTER SET Syntax”
- Section 13.7.5.3, “SET NAMES Syntax”
- Section 10.2.2, “UTF-8 for Metadata”
character_set_server
- Section 2.11.4, “Changes in MySQL 8.0”
- Section 10.14, “Character Set Configuration”
- Section 10.4, “Connection Character Sets and Collations”
- Section 10.3.3, “Database Character Set and Collation”
- Section 12.9.4, “Full-Text Stopwords”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 17.4.1.3, “Replication and Character Sets”
- Section 17.4.1.38, “Replication and Variables”
- Section 10.3.2, “Server Character Set and Collation”
- Section 5.1.8, “Server System Variables”
character_set_system
character_sets_dir
check_proxy_users
collation_connection
- Section 12.10, “Cast Functions and Operators”
- Section 12.5.3, “Character Set and Collation of Function Results”
- Section 10.3.8, “Character Set Introducers”
- Section 10.3.6, “Character String Literal Character Set and Collation”
- Section 10.8.4, “Collation Coercibility in Expressions”
- Section 10.4, “Connection Character Sets and Collations”
- Section 12.7, “Date and Time Functions”
- Section 12.13, “Encryption and Compression Functions”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 17.4.1.38, “Replication and Variables”
- Section 5.1.8, “Server System Variables”
- Section 13.7.5.3, “SET NAMES Syntax”
- Section 13.7.6.7, “SHOW CREATE EVENT Syntax”
- Section 13.7.6.9, “SHOW CREATE PROCEDURE Syntax”
- Section 13.7.6.11, “SHOW CREATE TRIGGER Syntax”
- Section 13.7.6.13, “SHOW CREATE VIEW Syntax”
- Section 13.7.6.18, “SHOW EVENTS Syntax”
- Section 13.7.6.28, “SHOW PROCEDURE STATUS Syntax”
- Section 13.7.6.38, “SHOW TRIGGERS Syntax”
- Section 5.4.4, “The Binary Log”
- Section 25.10, “The INFORMATION_SCHEMA EVENTS Table”
- Section 25.23, “The INFORMATION_SCHEMA ROUTINES Table”
- Section 25.34, “The INFORMATION_SCHEMA TRIGGERS Table”
- Section 25.36, “The INFORMATION_SCHEMA VIEWS Table”
- Section 12.2, “Type Conversion in Expression Evaluation”
collation_database
- Section 2.11.4, “Changes in MySQL 8.0”
- Section 10.4, “Connection Character Sets and Collations”
- Section 13.1.17, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
- Section 10.3.3, “Database Character Set and Collation”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 17.4.1.38, “Replication and Variables”
- Section 5.1.8, “Server System Variables”
- Section 5.4.4, “The Binary Log”
collation_server
- Section 2.11.4, “Changes in MySQL 8.0”
- Section 10.4, “Connection Character Sets and Collations”
- Section 10.3.3, “Database Character Set and Collation”
- Section 12.9.4, “Full-Text Stopwords”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 17.4.1.38, “Replication and Variables”
- Section 10.3.2, “Server Character Set and Collation”
- Section 5.1.8, “Server System Variables”
- Section 5.4.4, “The Binary Log”
completion_type
concurrent_insert
connect_timeout
connection_control_failed_connections_threshold
connection_control_max_connection_delay
connection_control_min_connection_delay
core_file
create_admin_listener_thread
cte_max_recursion_depth
daemon_memcached_engine_lib_name
daemon_memcached_engine_lib_path
daemon_memcached_option
daemon_memcached_r_batch_size
- Section 15.19.2, “InnoDB memcached Architecture”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 15.19.6.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”
- Section 15.19.3, “Setting Up the InnoDB memcached Plugin”
- Section 15.19.7, “The InnoDB memcached Plugin and Replication”
- Section 15.19.6.3, “Tuning InnoDB memcached Plugin Performance”
daemon_memcached_w_batch_size
- Section 15.19.6.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
- Section 15.19.2, “InnoDB memcached Architecture”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 15.19.6.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”
- Section 15.19.3, “Setting Up the InnoDB memcached Plugin”
- Section 15.19.7, “The InnoDB memcached Plugin and Replication”
- Section 15.19.6.3, “Tuning InnoDB memcached Plugin Performance”
datadir
- Section 18.2.1.2, “Configuring an Instance for Group Replication”
- Section 15.17.2, “InnoDB Recovery”
- Section 15.8.1, “InnoDB Startup Configuration”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 2.4.3, “Installing and Using the MySQL Launch Daemon”
- Section 2.3, “Installing MySQL on Microsoft Windows”
- Section 15.6.3.8, “Moving Tablespace Files While the Server is Offline”
- MySQL Glossary
- Section 5.1.7, “Server Command Options”
- Section 5.1.8, “Server System Variables”
- Section 25.11, “The INFORMATION_SCHEMA FILES Table”
- Section 15.6.3.4, “Undo Tablespaces”
date_format
datetime_format
debug_sync
default_authentication_plugin
- Section 13.7.1.1, “ALTER USER Syntax”
- Section 6.4.1, “Authentication Plugins”
- Section 6.4.1.3, “Caching SHA-2 Pluggable Authentication”
- Section 2.11.4, “Changes in MySQL 8.0”
- Section 13.7.1.3, “CREATE USER Syntax”
- Section 6.2.17, “Pluggable Authentication”
- Section 5.1.8, “Server System Variables”
- Section 6.4.1.2, “SHA-256 Pluggable Authentication”
default_collation_for_utf
default_password_lifetime
default_storage_engine
- Section 13.1.16, “CREATE LOGFILE GROUP Syntax”
- Section 13.1.20, “CREATE TABLE Syntax”
- Section 13.1.21, “CREATE TABLESPACE Syntax”
- Section 13.1.33, “DROP TABLESPACE Syntax”
- Section 15.6.3.3, “General Tablespaces”
- Section 5.6.1, “Installing and Uninstalling Plugins”
- Section 23.2.2, “LIST Partitioning”
- Section 23.1, “Overview of Partitioning in MySQL”
- Section 17.4.1.38, “Replication and Variables”
- Section 5.1.8, “Server System Variables”
- Section 16.1, “Setting the Storage Engine”
- Section 17.3.4, “Using Replication with Different Master and Slave Storage Engines”
default_table_encryption
- Section 13.1.2, “ALTER DATABASE Syntax”
- Section 13.1.10, “ALTER TABLESPACE Syntax”
- Section 13.1.12, “CREATE DATABASE Syntax”
- Section 13.1.21, “CREATE TABLESPACE Syntax”
- Section 18.8, “Group Replication System Variables”
- Section 15.6.3.9, “InnoDB Data-at-Rest Encryption”
- Section 5.1.8, “Server System Variables”
- Section 5.1.9.1, “System Variable Privileges”
- Section 1.4, “What Is New in MySQL 8.0”
default_tmp_storage_engine
default_week_format
delay_key_write
delayed_insert_limit
delayed_insert_timeout
delayed_queue_size
disabled_storage_engines
- Section 18.2.1.2, “Configuring an Instance for Group Replication”
- Section 18.9.1, “Group Replication Requirements”
- Section A.2, “MySQL 8.0 FAQ: Storage Engines”
- Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
- Section 5.1.7, “Server Command Options”
- Section B.3.1, “Server Error Message Reference”
- Section 5.1.8, “Server System Variables”
disconnect_on_expired_password
div_precision_increment
dragnet
- Section 5.5.3, “Error Log Components”
- Section 5.5, “MySQL Server Components”
- Section 5.4.2.5, “Rule-Based Error Log Filtering (log_filter_dragnet)”
- Section 5.1.10, “Server Status Variables”
- Section 5.1.8, “Server System Variables”
- Section 5.4.2.3, “Types of Error Log Filtering”
- Section 5.1.9, “Using System Variables”
end_markers_in_json
enforce_gtid_consistency
- Section 17.1.5.3, “Disabling GTID Transactions Online”
- Section 17.1.6.5, “Global Transaction ID Options and Variables”
- Section 17.4.1.30, “Replication and Temporary Tables”
- Section 17.1.5.1, “Replication Mode Concepts”
- Section 17.1.3.6, “Restrictions on Replication with GTIDs”
- Section 17.1.3.4, “Setting Up Replication Using GTIDs”
eq_range_index_dive_limit
error_count
event_scheduler
expire_logs_days
explicit_defaults_for_timestamp
external_user
foreign_key_checks
- Section 13.1.9, “ALTER TABLE Syntax”
- Section 15.6.3.7, “Copying Tablespaces to Another Instance”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 22.3.3.9.2, “NDB Cluster System Variables”
- Section 15.12.1, “Online DDL Operations”
- Section 17.4.1.38, “Replication and Variables”
- Section 5.1.11, “Server SQL Modes”
- Section 5.1.8, “Server System Variables”
- Section 5.4.4, “The Binary Log”
- Section 13.1.20.6, “Using FOREIGN KEY Constraints”
ft_boolean_syntax
ft_max_word_len
ft_min_word_len
- Section 12.9.2, “Boolean Full-Text Searches”
- Section 17.1.2.5.2, “Creating a Data Snapshot Using Raw Data Files”
- Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
- Section 12.9.9, “MeCab Full-Text Parser Plugin”
- Section 12.9.1, “Natural Language Full-Text Searches”
- Section 12.9.8, “ngram Full-Text Parser”
- Section 5.1.8, “Server System Variables”
- Section 29.2.4.4, “Writing Full-Text Parser Plugins”
ft_query_expansion_limit
ft_stopword_file
general_log
general_log_file
group_concat_max_len
group_replication_allow_local_disjoint_gtids_join
group_replication_allow_local_lower_version_join
group_replication_auto_increment_increment
group_replication_autorejoin_tries
group_replication_bootstrap_group
group_replication_communication_debug_options
group_replication_communication_max_message_size
group_replication_components_stop_timeout
group_replication_compression_threshold
group_replication_consistency
group_replication_enforce_update_everywhere_checks
group_replication_exit_state_action
group_replication_flow_control_applier_threshold
group_replication_flow_control_certifier_threshold
group_replication_flow_control_hold_percent
group_replication_flow_control_max_commit_quota
group_replication_flow_control_member_quota_percent
group_replication_flow_control_min_quota
group_replication_flow_control_min_recovery_quota
group_replication_flow_control_mode
group_replication_flow_control_period
group_replication_flow_control_release_percent
group_replication_force_members
group_replication_group_name
group_replication_group_seeds
group_replication_gtid_assignment_block_size
group_replication_ip_whitelist
group_replication_local_address
- Section 18.2.1.2, “Configuring an Instance for Group Replication”
- Section 18.10, “Frequently Asked Questions”
- Section 18.5.1, “Group Replication IP Address Whitelisting”
- Section 18.8, “Group Replication System Variables”
- Section 18.4.6, “Support For IPv6 And For Mixed IPv6 And IPv4 Groups”
- Section 26.12.11.9, “The replication_group_members Table”
- Section 21.4, “Working with InnoDB Cluster”
group_replication_member_expel_timeout
- Section 18.10, “Frequently Asked Questions”
- Section 18.9.2, “Group Replication Limitations”
- Section 18.8, “Group Replication System Variables”
- Section 18.6.4, “Message Fragmentation”
- Section 21.2.4, “Production Deployment of InnoDB Cluster”
- Section 18.6.6, “Responses to Failure Detection and Network Partitioning”
- Section 18.6.5, “XCom Cache Management”
group_replication_member_weight
group_replication_message_cache_size
group_replication_poll_spin_loops
group_replication_recovery_complete_at
group_replication_recovery_get_public_key
group_replication_recovery_public_key_path
group_replication_recovery_reconnect_interval
group_replication_recovery_retry_count
group_replication_recovery_ssl_ca
group_replication_recovery_ssl_capath
group_replication_recovery_ssl_cert
group_replication_recovery_ssl_cipher
group_replication_recovery_ssl_crl
group_replication_recovery_ssl_crlpath
group_replication_recovery_ssl_key
group_replication_recovery_ssl_verify_server_cert
group_replication_recovery_use_ssl
group_replication_single_primary_mode
group_replication_ssl_mode
group_replication_start_on_boot
group_replication_transaction_size_limit
group_replication_unreachable_majority_timeout
gtid
gtid_executed
- Section 17.1.6.5, “Global Transaction ID Options and Variables”
- Section 17.1.3.3, “GTID Auto-Positioning”
- Section 17.1.3.1, “GTID Format and Storage”
- Section 17.1.3.2, “GTID Life Cycle”
- Section 26.12.11, “Performance Schema Replication Tables”
- Section 17.1.5.1, “Replication Mode Concepts”
- Section 17.1.6.3, “Replication Slave Options and Variables”
- Section 13.4.1.2, “RESET MASTER Syntax”
- Section 17.1.3.6, “Restrictions on Replication with GTIDs”
- Section 13.7.6.23, “SHOW MASTER STATUS Syntax”
- Section 13.7.6.34, “SHOW SLAVE STATUS Syntax”
- Section 17.1.3.7, “Stored Function Examples to Manipulate GTIDs”
- Section 26.12.17.3, “The log_status Table”
- Section 17.1.3.5, “Using GTIDs for Failover and Scaleout”
- Section 18.4.7, “Using MySQL Enterprise Backup with Group Replication”
- Section 21.4, “Working with InnoDB Cluster”
gtid_executed_compression_period
GTID_MODE
gtid_mode
- Section 17.1.4.2.2, “Adding a GTID Based Master to a Multi-Source Replication Slave”
- Section 13.4.2.1, “CHANGE MASTER TO Syntax”
- Section 17.1.5.3, “Disabling GTID Transactions Online”
- Section 17.1.5.2, “Enabling GTID Transactions Online”
- Section 12.18, “Functions Used with Global Transaction Identifiers (GTIDs)”
- Section 17.1.6.5, “Global Transaction ID Options and Variables”
- Section 17.1.3.1, “GTID Format and Storage”
- Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
- Section 4.5.4, “mysqldump — A Database Backup Program”
- Section 17.1.5.1, “Replication Mode Concepts”
- Section 17.1.6.3, “Replication Slave Options and Variables”
- Section 17.1.3.6, “Restrictions on Replication with GTIDs”
- Section 17.1.3.4, “Setting Up Replication Using GTIDs”
- Section 26.12.7.1, “The events_transactions_current Table”
- Section 17.4.3, “Upgrading a Replication Setup”
- Section 2.11.6, “Upgrading MySQL Binary or Package-based Installations on Unix/Linux”
- Section 17.1.3.5, “Using GTIDs for Failover and Scaleout”
gtid_next
- Section 17.1.6.5, “Global Transaction ID Options and Variables”
- Section 17.1.3.1, “GTID Format and Storage”
- Section 17.1.3.2, “GTID Life Cycle”
- Section 17.1.5.1, “Replication Mode Concepts”
- Section 5.1.10, “Server Status Variables”
- Section 13.4.2.6, “START SLAVE Syntax”
- Section 13.4.2.7, “STOP SLAVE Syntax”
- Section 26.12.7.1, “The events_transactions_current Table”
gtid_owned
gtid_purged
- Section 13.4.2.1, “CHANGE MASTER TO Syntax”
- Section 17.1.6.5, “Global Transaction ID Options and Variables”
- Section 17.1.3.3, “GTID Auto-Positioning”
- Section 17.1.3.1, “GTID Format and Storage”
- Section 17.1.3.2, “GTID Life Cycle”
- Section 17.1.5.1, “Replication Mode Concepts”
- Section 13.4.1.2, “RESET MASTER Syntax”
- Section 17.1.3.7, “Stored Function Examples to Manipulate GTIDs”
- Section 17.1.3.5, “Using GTIDs for Failover and Scaleout”
have_compress
have_dynamic_loading
have_geometry
have_openssl
have_profiling
have_query_cache
have_rtree_keys
have_ssl
have_statement_timeout
have_symlink
histogram_generation_max_mem_size
host_cache_size
hostname
identity
ignore_builtin_innodb
immediate_server_version
information_schema_stats_expiry
- Section 13.7.3.1, “ANALYZE TABLE Syntax”
- Section 14.7, “Data Dictionary Usage Differences”
- Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
- Section 5.1.8, “Server System Variables”
- Section 25.26, “The INFORMATION_SCHEMA STATISTICS Table”
- Section 25.30, “The INFORMATION_SCHEMA TABLES Table”
- Section 1.4, “What Is New in MySQL 8.0”
init_connect
init_file
innodb
innodb_adaptive_flushing
innodb_adaptive_flushing_lwm
innodb_adaptive_hash_index
innodb_adaptive_hash_index_parts
innodb_adaptive_max_sleep_delay
innodb_api_bk_commit_interval
innodb_api_disable_rowlock
innodb_api_enable_binlog
innodb_api_enable_mdl
innodb_api_trx_level
innodb_autoextend_increment
innodb_autoinc_lock_mode
innodb_buffer_pool_chunk_size
innodb_buffer_pool_dump_at_shutdown
innodb_buffer_pool_dump_now
innodb_buffer_pool_dump_pct
innodb_buffer_pool_filename
innodb_buffer_pool_in_core_file
innodb_buffer_pool_instances
- Section 15.8.3.1, “Configuring InnoDB Buffer Pool Size”
- Section 15.8.3.2, “Configuring Multiple Buffer Pool Instances”
- Section 8.12.3.1, “How MySQL Uses Memory”
- Section 15.8.1, “InnoDB Startup Configuration”
- Section 15.13, “InnoDB Startup Options and System Variables”
- MySQL Glossary
- Section 15.19.6.3, “Tuning InnoDB memcached Plugin Performance”
innodb_buffer_pool_load_abort
innodb_buffer_pool_load_at_startup
innodb_buffer_pool_load_now
innodb_buffer_pool_size
- Section 15.9.1.6, “Compression for OLTP Workloads”
- Section 15.8.3.1, “Configuring InnoDB Buffer Pool Size”
- Section 15.8.3.2, “Configuring Multiple Buffer Pool Instances”
- Section 15.6.1.3, “Converting Tables from MyISAM to InnoDB”
- Section 15.8.12, “Enabling Automatic Configuration for a Dedicated MySQL Server”
- Section 8.12.3.1, “How MySQL Uses Memory”
- Section 15.19.2, “InnoDB memcached Architecture”
- Section 15.8.1, “InnoDB Startup Configuration”
- Section 15.13, “InnoDB Startup Options and System Variables”
- MySQL Glossary
- Section 8.5.8, “Optimizing InnoDB Disk I/O”
- Section B.3.1, “Server Error Message Reference”
- Section 5.1.10, “Server Status Variables”
- Section 15.19.6.3, “Tuning InnoDB memcached Plugin Performance”
- Section 1.4, “What Is New in MySQL 8.0”
innodb_change_buffer_max_size
innodb_change_buffering
innodb_checksum_algorithm
innodb_checksums
innodb_cmp_per_index_enabled
innodb_compression_failure_threshold_pct
innodb_compression_level
innodb_compression_pad_pct_max
innodb_concurrency_tickets
innodb_data_file_path
- Section 15.11.2, “File Space Management”
- Section 2.10.1, “Initializing the Data Directory”
- Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
- Section 15.8.1, “InnoDB Startup Configuration”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 25.11, “The INFORMATION_SCHEMA FILES Table”
- Section 15.6.3.1, “The System Tablespace”
- Section 15.20.1, “Troubleshooting InnoDB I/O Problems”
innodb_data_home_dir
- Section 2.10.1, “Initializing the Data Directory”
- Section 15.17.2, “InnoDB Recovery”
- Section 15.8.1, “InnoDB Startup Configuration”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 15.6.3.8, “Moving Tablespace Files While the Server is Offline”
- Section 15.6.3.5, “Temporary Tablespaces”
- Section 15.20.1, “Troubleshooting InnoDB I/O Problems”
- Section 15.6.3.4, “Undo Tablespaces”
- Section 18.4.7, “Using MySQL Enterprise Backup with Group Replication”
innodb_deadlock_detect
- Section 15.6.1.3, “Converting Tables from MyISAM to InnoDB”
- Section 15.7.5.2, “Deadlock Detection and Rollback”
- Section 15.7.5, “Deadlocks in InnoDB”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 8.11.1, “Internal Locking Methods”
- MySQL Glossary
- Section 1.4, “What Is New in MySQL 8.0”
innodb_dedicated_server
innodb_default_row_format
innodb_directories
- Section 2.11.4, “Changes in MySQL 8.0”
- Section 13.1.21, “CREATE TABLESPACE Syntax”
- Section 15.6.3.6, “Creating a Tablespace Outside of the Data Directory”
- Section 15.6.3.3, “General Tablespaces”
- Section 15.17.2, “InnoDB Recovery”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 15.6.3.8, “Moving Tablespace Files While the Server is Offline”
- Section 15.6.3.4, “Undo Tablespaces”
- Section 1.4, “What Is New in MySQL 8.0”
innodb_doublewrite
innodb_fast_shutdown
innodb_fil_make_page_dirty_debug
innodb_file_format
innodb_file_per
innodb_file_per_table
- Section 15.1.2, “Best Practices for InnoDB Tables”
- Section 15.6.1.3, “Converting Tables from MyISAM to InnoDB”
- Section 15.6.3.7, “Copying Tablespaces to Another Instance”
- Section 13.1.20.4, “CREATE TABLE ... LIKE Syntax”
- Section 13.1.20, “CREATE TABLE Syntax”
- Section 13.1.21, “CREATE TABLESPACE Syntax”
- Section 15.6.3.6, “Creating a Tablespace Outside of the Data Directory”
- Section 15.9.1.2, “Creating Compressed Tables”
- Section 15.6.1.1, “Creating InnoDB Tables”
- Section 15.11.2, “File Space Management”
- Section 15.6.3.2, “File-Per-Table Tablespaces”
- Section 13.1.20.2, “Files Created by CREATE TABLE”
- Section 13.7.7.3, “FLUSH Syntax”
- Section 15.6.3.3, “General Tablespaces”
- Section 15.9.1.5, “How Compression Works for InnoDB Tables”
- Section 15.2, “InnoDB and the ACID Model”
- Section 15.10, “InnoDB Row Formats”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 15.6.1.2, “Moving or Copying InnoDB Tables”
- MySQL Glossary
- Section 13.7.3.4, “OPTIMIZE TABLE Syntax”
- Section 15.11.5, “Reclaiming Disk Space with TRUNCATE TABLE”
- Section 17.3.6, “Replicating Different Databases to Different Slaves”
- Section 23.6, “Restrictions and Limitations on Partitioning”
- Section 15.9.1.7, “SQL Compression Syntax Warnings and Errors”
- Section 15.20.3, “Troubleshooting InnoDB Data Dictionary Operations”
innodb_fill_factor
innodb_flush_log_at_timeout
innodb_flush_log_at_trx_commit
- Section 13.1.1, “Atomic Data Definition Statement Support”
- Section 17.1.6.4, “Binary Logging Options and Variables”
- Section 15.2, “InnoDB and the ACID Model”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 15.5.4, “Log Buffer”
- Section 8.5.2, “Optimizing InnoDB Transaction Management”
- Section 17.4.1.27, “Replication and Master or Slave Shutdowns”
- Section 15.19.6.3, “Tuning InnoDB memcached Plugin Performance”
innodb_flush_method
- Section 15.6.4, “Doublewrite Buffer”
- Section 15.8.12, “Enabling Automatic Configuration for a Dedicated MySQL Server”
- Section 15.6.3.2, “File-Per-Table Tablespaces”
- Section 15.11.1, “InnoDB Disk I/O”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 8.5.8, “Optimizing InnoDB Disk I/O”
- Section 5.1.10, “Server Status Variables”
- Section 15.19.6.3, “Tuning InnoDB memcached Plugin Performance”
- Section 1.4, “What Is New in MySQL 8.0”
innodb_flush_neighbors
innodb_flush_sync
innodb_flushing_avg_loops
innodb_force_load_corrupted
innodb_force_recovery
innodb_fsync_threshold
innodb_ft_aux_table
- Section 15.14.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 25.39.13, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
- Section 25.39.14, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”
- Section 25.39.16, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
- Section 25.39.17, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”
- Section 25.39.18, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”
innodb_ft_cache_size
innodb_ft_enable_diag_print
innodb_ft_enable_stopword
innodb_ft_max_token_size
innodb_ft_min_token_size
- Section 12.9.2, “Boolean Full-Text Searches”
- Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
- Section 12.9.4, “Full-Text Stopwords”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 12.9.9, “MeCab Full-Text Parser Plugin”
- Section 12.9.1, “Natural Language Full-Text Searches”
- Section 12.9.8, “ngram Full-Text Parser”
- Section 29.2.4.4, “Writing Full-Text Parser Plugins”
innodb_ft_num_word_optimize
innodb_ft_result_cache_limit
innodb_ft_server_stopword_table
- Section 12.9.2, “Boolean Full-Text Searches”
- Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
- Section 12.9.4, “Full-Text Stopwords”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 12.9.1, “Natural Language Full-Text Searches”
- Section 25.39.15, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”
innodb_ft_sort_pll_degree
innodb_ft_total_cache_size
innodb_ft_user_stopword_table
- Section 12.9.2, “Boolean Full-Text Searches”
- Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
- Section 12.9.4, “Full-Text Stopwords”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 12.9.1, “Natural Language Full-Text Searches”
- Section 25.39.15, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”
innodb_io_capacity
innodb_io_capacity_max
innodb_lock_wait_timeout
- Section 15.6.1.3, “Converting Tables from MyISAM to InnoDB”
- Section 15.7.5.2, “Deadlock Detection and Rollback”
- Section 15.7.5, “Deadlocks in InnoDB”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 8.11.1, “Internal Locking Methods”
- MySQL Glossary
- Section 17.4.1.31, “Replication Retries and Timeouts”
- Section 17.1.6.3, “Replication Slave Options and Variables”
- Section B.3.1, “Server Error Message Reference”
- Section 1.4, “What Is New in MySQL 8.0”
innodb_locks_unsafe_for_binlog
innodb_log_buffer_size
innodb_log_compressed_pages
innodb_log_file_size
- Section 15.8.2, “Configuring InnoDB for Read-Only Operation”
- Section 15.8.12, “Enabling Automatic Configuration for a Dedicated MySQL Server”
- Section 15.8.3.6, “Fine-tuning InnoDB Buffer Pool Flushing”
- Section 2.10.1, “Initializing the Data Directory”
- Section 15.8.1, “InnoDB Startup Configuration”
- Section 15.13, “InnoDB Startup Options and System Variables”
- MySQL Glossary
- Section 8.5.8, “Optimizing InnoDB Disk I/O”
- Section 8.5.4, “Optimizing InnoDB Redo Logging”
- Section 15.6.5, “Redo Log”
- Section 5.1.9, “Using System Variables”
- Section 1.4, “What Is New in MySQL 8.0”
innodb_log_files_in_group
innodb_log_group_home_dir
innodb_log_spin_cpu_abs_lwm
innodb_log_spin_cpu_pct_hwm
innodb_log_wait_for_flush_spin_hwm
innodb_log_write_ahead_size
innodb_lru_scan_depth
innodb_max_dirty_pages_pct
innodb_max_dirty_pages_pct_lwm
innodb_max_purge_lag
innodb_max_purge_lag_delay
innodb_max_undo_log_size
innodb_monitor_disable
innodb_monitor_enable
innodb_monitor_reset
innodb_monitor_reset_all
innodb_old_blocks_pct
innodb_old_blocks_time
innodb_online_alter_log_max_size
innodb_open_files
innodb_optimize_fulltext_only
innodb_page_cleaners
innodb_page_size
- Section 15.6.1.3, “Converting Tables from MyISAM to InnoDB”
- Section 13.1.20, “CREATE TABLE Syntax”
- Section 13.1.21, “CREATE TABLESPACE Syntax”
- Section 15.9.1.2, “Creating Compressed Tables”
- Section 15.8.10.3, “Estimating ANALYZE TABLE Complexity for InnoDB Tables”
- Section 15.8.3.8, “Excluding Buffer Pool Pages from Core Files”
- Section 15.11.2, “File Space Management”
- Section 15.6.3.3, “General Tablespaces”
- Section 15.9.1.5, “How Compression Works for InnoDB Tables”
- Section 15.9.2, “InnoDB Page Compression”
- Section 15.8.1, “InnoDB Startup Configuration”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 15.6.1.6, “Limits on InnoDB Tables”
- Section C.10.4, “Limits on Table Column Count and Row Size”
- MySQL Glossary
- Section 8.5.8, “Optimizing InnoDB Disk I/O”
- Section 8.5.4, “Optimizing InnoDB Redo Logging”
- Section 15.9.1.1, “Overview of Table Compression”
- Section 25.11, “The INFORMATION_SCHEMA FILES Table”
- Section 15.6.2.2, “The Physical Structure of an InnoDB Index”
- Section 15.19.9, “Troubleshooting the InnoDB memcached Plugin”
- Section 15.6.3.4, “Undo Tablespaces”
innodb_parallel_read_threads
innodb_print_all_deadlocks
innodb_print_ddl_logs
innodb_purge_batch_size
innodb_purge_rseg_truncate_frequency
innodb_purge_threads
innodb_random_read_ahead
innodb_read_ahead_threshold
innodb_read_io_threads
innodb_read_only
- Section 13.7.3.1, “ANALYZE TABLE Syntax”
- Section 15.8.2, “Configuring InnoDB for Read-Only Operation”
- Section 14.7, “Data Dictionary Usage Differences”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
- Section 5.1.8, “Server System Variables”
- Section 25.26, “The INFORMATION_SCHEMA STATISTICS Table”
- Section 25.30, “The INFORMATION_SCHEMA TABLES Table”
innodb_redo_log_encrypt
innodb_rollback_segments
innodb_saved_page_number_debug
innodb_sort_buffer_size
innodb_spin_wait_delay
innodb_spin_wait_pause_multiplier
innodb_stats_auto_recalc
- Section 15.8.10.1.1, “Configuring Automatic Statistics Calculation for Persistent Optimizer Statistics”
- Section 15.8.10, “Configuring Optimizer Statistics for InnoDB”
- Section 15.8.10.1.2, “Configuring Optimizer Statistics Parameters for Individual Tables”
- Section 13.1.20, “CREATE TABLE Syntax”
- Section 15.8.10.1.6, “InnoDB Persistent Statistics Tables Example”
innodb_stats_include_delete_marked
innodb_stats_method
innodb_stats_on_metadata
innodb_stats_persistent
- Section 13.7.3.1, “ANALYZE TABLE Syntax”
- Section 15.8.10.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
- Section 15.8.10, “Configuring Optimizer Statistics for InnoDB”
- Section 15.8.10.1.2, “Configuring Optimizer Statistics Parameters for Individual Tables”
- Section 15.8.10.1, “Configuring Persistent Optimizer Statistics Parameters”
- Section 13.1.15, “CREATE INDEX Syntax”
- Section 13.1.20, “CREATE TABLE Syntax”
- Section 15.8.10.3, “Estimating ANALYZE TABLE Complexity for InnoDB Tables”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 15.6.1.6, “Limits on InnoDB Tables”
- Section 8.5.10, “Optimizing InnoDB for Systems with Many Tables”
innodb_stats_persistent_sample_pages
- Section 15.8.10.1.2, “Configuring Optimizer Statistics Parameters for Individual Tables”
- Section 15.8.10.1.3, “Configuring the Number of Sampled Pages for InnoDB Optimizer Statistics”
- Section 15.8.10.3, “Estimating ANALYZE TABLE Complexity for InnoDB Tables”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 15.6.1.6, “Limits on InnoDB Tables”
innodb_stats_transient_sample_pages
innodb_status_output
innodb_status_output_locks
innodb_strict_mode
- Section 13.1.20, “CREATE TABLE Syntax”
- Section 13.1.21, “CREATE TABLESPACE Syntax”
- Section 13.1.20.3, “CREATE TEMPORARY TABLE Syntax”
- Section 15.9.1.2, “Creating Compressed Tables”
- Section 15.9.1.5, “How Compression Works for InnoDB Tables”
- Section 15.13, “InnoDB Startup Options and System Variables”
- MySQL Glossary
- Section 5.1.11, “Server SQL Modes”
- Section 15.9.1.7, “SQL Compression Syntax Warnings and Errors”
- Section 1.4, “What Is New in MySQL 8.0”
innodb_support_xa
innodb_sync_debug
innodb_table_locks
innodb_temp_data_file_path
innodb_temp_tablespaces_dir
innodb_thread_concurrency
- Section 15.8.4, “Configuring Thread Concurrency for InnoDB”
- Section 15.16.3, “InnoDB Standard Monitor and Lock Monitor Output”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section A.14, “MySQL 8.0 FAQ: MySQL Enterprise Thread Pool”
- Section 8.5.9, “Optimizing InnoDB Configuration Variables”
innodb_thread_sleep_delay
innodb_tmpdir
innodb_undo_directory
- Section 2.11.4, “Changes in MySQL 8.0”
- Section 15.8.2, “Configuring InnoDB for Read-Only Operation”
- Section 13.1.21, “CREATE TABLESPACE Syntax”
- Section 15.17.2, “InnoDB Recovery”
- Section 15.8.1, “InnoDB Startup Configuration”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 15.6.3.8, “Moving Tablespace Files While the Server is Offline”
- Section 15.6.3.4, “Undo Tablespaces”
- Section 18.4.7, “Using MySQL Enterprise Backup with Group Replication”
innodb_undo_log_encrypt
innodb_undo_log_truncate
innodb_undo_logs
innodb_undo_tablespaces
innodb_use_native_aio
innodb_write_io_threads
insert_id
interactive_timeout
internal_tmp_disk_storage_engine
- Section 8.12.3.1, “How MySQL Uses Memory”
- Section 15.8.1, “InnoDB Startup Configuration”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 8.4.4, “Internal Temporary Table Use in MySQL”
- Section 8.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization”
- Section 5.1.8, “Server System Variables”
- Section 15.6.3.5, “Temporary Tablespaces”
- Section 1.4, “What Is New in MySQL 8.0”
internal_tmp_mem_storage_engine
join_buffer_size
keep_files_on_create
key_buffer_size
- Section 8.6.2, “Bulk Data Loading for MyISAM Tables”
- Section 15.6.1.3, “Converting Tables from MyISAM to InnoDB”
- Section 8.8.5, “Estimating Query Performance”
- Section 8.12.3.1, “How MySQL Uses Memory”
- Section 7.6.3, “How to Repair MyISAM Tables”
- Section 15.8.1, “InnoDB Startup Configuration”
- Section B.4.7, “Known Issues in MySQL”
- Section 8.10.2.2, “Multiple Key Caches”
- Section 8.2.5.3, “Optimizing DELETE Statements”
- Section 8.6.3, “Optimizing REPAIR TABLE Statements”
- Section 8.10.2.6, “Restructuring a Key Cache”
- Section 5.1.10, “Server Status Variables”
- Section 5.1.8, “Server System Variables”
- Section 5.1.9.5, “Structured System Variables”
- Section 8.10.2, “The MyISAM Key Cache”
key_cache_age_threshold
key_cache_block_size
key_cache_division_limit
keyring_aws_cmk_id
keyring_aws_conf_file
keyring_aws_data_file
keyring_aws_region
keyring_encrypted_file_data
keyring_encrypted_file_password
keyring_file_data
- Section 15.6.3.9, “InnoDB Data-at-Rest Encryption”
- Section 2.4.3, “Installing and Using the MySQL Launch Daemon”
- Section 6.4.4.11, “Keyring System Variables”
- Section 6.4.4.6, “Migrating Keys Between Keyring Keystores”
- Section 2.9.4, “MySQL Source-Configuration Options”
- Section 6.4.4.2, “Using the keyring_file File-Based Plugin”
- Section 29.2.4.12, “Writing Keyring Plugins”
keyring_okv_conf_dir
keyring_operations
large_files_support
large_page_size
large_pages
last_insert_id
lc_messages
lc_messages_dir
lc_time_names
local_infile
lock_order
lock_order_debug_loop
lock_order_debug_missing_arc
lock_order_debug_missing_key
lock_order_debug_missing_unlock
lock_order_dependencies
lock_order_extra_dependencies
lock_order_output_directory
lock_order_print_txt
lock_order_trace_loop
lock_order_trace_missing_arc
lock_order_trace_missing_key
lock_order_trace_missing_unlock
lock_wait_timeout
locked_in_memory
log
log_bin
- Section 17.1.6.4, “Binary Logging Options and Variables”
- Section 17.1.6.5, “Global Transaction ID Options and Variables”
- Section 17.4.5, “How to Report Replication Bugs or Problems”
- Section 22.3.3.9.2, “NDB Cluster System Variables”
- Section 17.4.1.33, “Replication and Transaction Inconsistencies”
- Section 17.1.2.1, “Setting the Replication Master Configuration”
- Section 5.4.4, “The Binary Log”
log_bin_basename
log_bin_index
log_bin_trust_function_creators
log_bin_use_v
log_builtin_as_identified_by_password
log_error
- Section 5.4.2.2, “Default Error Log Destination Configuration”
- Section 5.5.3, “Error Log Components”
- Section 5.4.2.6, “Error Logging in JSON Format”
- Section 2.4.3, “Installing and Using the MySQL Launch Daemon”
- Section 2.5.6.2, “More Topics on Deploying MySQL Server with Docker”
- Section 5.1.8, “Server System Variables”
- Section 1.4, “What Is New in MySQL 8.0”
log_error_filter_rules
log_error_services
- Section 5.4.2.2, “Default Error Log Destination Configuration”
- Section 5.4.2.1, “Error Log Component Configuration”
- Section 5.5.3, “Error Log Components”
- Section 5.4.2.6, “Error Logging in JSON Format”
- Section 5.4.2.7, “Error Logging to the System Log”
- Section 5.4.2.5, “Rule-Based Error Log Filtering (log_filter_dragnet)”
- Section 5.1.8, “Server System Variables”
- Section 1.4, “What Is New in MySQL 8.0”
log_error_suppression_list
log_error_verbosity
- Section B.4.2.10, “Communication Errors and Aborted Connections”
- Section 5.4.2.1, “Error Log Component Configuration”
- Section 5.5.3, “Error Log Components”
- Section 5.4.2.8, “Error Log Message Format”
- Section 5.4.2.7, “Error Logging to the System Log”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section B.4.2.8, “MySQL server has gone away”
- Section 26.12.9, “Performance Schema Connection Attribute Tables”
- Section 26.15, “Performance Schema System Variables”
- Section 5.4.2.4, “Priority-Based Error Log Filtering (log_filter_internal)”
- Section 5.4.2.5, “Rule-Based Error Log Filtering (log_filter_dragnet)”
- Section 5.1.7, “Server Command Options”
- Section 5.1.3, “Server Configuration Validation”
- Section 5.1.8, “Server System Variables”
- Section 5.4.2.3, “Types of Error Log Filtering”
- Section 6.4.7.3, “Using MySQL Enterprise Firewall”
- Section 1.4, “What Is New in MySQL 8.0”
log_output
log_queries_not_using_indexes
log_slave_updates
log_slow_admin_statements
log_slow_slave_statements
log_statements_unsafe_for_binlog
log_syslog
log_syslog_facility
log_syslog_include_pid
log_syslog_tag
log_throttle_queries_not_using_indexes
log_timestamps
log_warnings
long_query_time
low_priority_updates
lower_case_file_system
lower_case_table_names
- Section 2.3.3.3.1.7, “Advanced Options”
- Section 2.11.4, “Changes in MySQL 8.0”
- Section 15.6.3.7, “Copying Tablespaces to Another Instance”
- Section 13.7.1.6, “GRANT Syntax”
- Section 17.2.5, “How Servers Evaluate Replication Filtering Rules”
- Section 1.7, “How to Report Bugs or Problems”
- Section 9.2.2, “Identifier Case Sensitivity”
- Section 13.2.5, “IMPORT TABLE Syntax”
- Section 15.6.1.2, “Moving or Copying InnoDB Tables”
- Section 18.7.2.1, “Online Upgrade Considerations”
- Section 17.4.1.38, “Replication and Variables”
- Section 13.7.1.8, “REVOKE Syntax”
- Section 5.1.8, “Server System Variables”
- Section 13.7.6.37, “SHOW TABLES Syntax”
- Section 25.39.8, “The INFORMATION_SCHEMA INNODB_COLUMNS Table”
- Section 25.39.24, “The INFORMATION_SCHEMA INNODB_TABLES Table”
- Section 10.8.7, “Using Collation in INFORMATION_SCHEMA Searches”
- Section 13.1.20.6, “Using FOREIGN KEY Constraints”
mandatory_roles
- Section 6.2.11, “Account Categories”
- Section 13.7.1.4, “DROP ROLE Syntax”
- Section 13.7.1.5, “DROP USER Syntax”
- Section 6.2.2, “Privileges Provided by MySQL”
- Section 13.7.1.8, “REVOKE Syntax”
- Section 5.1.8, “Server System Variables”
- Section 13.7.1.11, “SET ROLE Syntax”
- Section 13.7.6.21, “SHOW GRANTS Syntax”
- Section 5.1.9.1, “System Variable Privileges”
- Section 6.2.10, “Using Roles”
master_info_repository
master_verify_checksum
max_allowed_packet
- Section 12.20.1, “Aggregate (GROUP BY) Function Descriptions”
- Section B.4.2.10, “Communication Errors and Aborted Connections”
- Section 12.3.2, “Comparison Functions and Operators”
- Section 11.8, “Data Type Storage Requirements”
- Section B.4.4.6, “Deleting Rows from Related Tables”
- Section 8.12.3.1, “How MySQL Uses Memory”
- Section B.4.2.3, “Lost connection to MySQL server”
- Section 28.7, “MySQL C API”
- Section B.4.2.8, “MySQL server has gone away”
- Section 28.7.7.50, “mysql_options()”
- Section 28.7.11.26, “mysql_stmt_send_long_data()”
- Section 28.7.7.81, “mysql_use_result()”
- Section 22.6.11, “NDB Cluster Replication Conflict Resolution”
- Section B.4.2.9, “Packet Too Large”
- Section 17.4.1.20, “Replication and max_allowed_packet”
- Section 17.1.6.3, “Replication Slave Options and Variables”
- Section 5.1.8, “Server System Variables”
- Section 12.5, “String Functions”
- Section 11.4.3, “The BLOB and TEXT Types”
- Section 11.6, “The JSON Data Type”
- Section 5.6.6.3, “Using Version Tokens”
- Section 20.5.5.2, “X Plugin Options and System Variables”
max_binlog_cache_size
max_binlog_size
max_binlog_stmt_cache_size
max_connect_errors
max_connections
- Section 29.5.1.4, “Debugging mysqld under gdb”
- Section 14.4, “Dictionary Object Cache”
- Section B.4.2.17, “File Not Found and Similar Errors”
- Section 8.12.4.1, “How MySQL Handles Client Connections”
- Section 8.4.3.1, “How MySQL Opens and Closes Tables”
- Section 26.15, “Performance Schema System Variables”
- Section 6.2.2, “Privileges Provided by MySQL”
- Section 5.1.10, “Server Status Variables”
- Section 5.1.8, “Server System Variables”
- Section 5.6.3.3, “Thread Pool Operation”
- Section B.4.2.6, “Too many connections”
- Section 1.4, “What Is New in MySQL 8.0”
- Section 20.5.5.2, “X Plugin Options and System Variables”
max_delayed_threads
max_digest_length
- Section 12.13, “Encryption and Compression Functions”
- Section 8.12.3.1, “How MySQL Uses Memory”
- Section 26.10, “Performance Schema Statement Digests and Sampling”
- Section 26.15, “Performance Schema System Variables”
- Section 5.1.8, “Server System Variables”
- Section 6.4.7.3, “Using MySQL Enterprise Firewall”
max_error_count
max_execution_time
max_heap_table_size
- Section 8.12.3.1, “How MySQL Uses Memory”
- Section 8.4.4, “Internal Temporary Table Use in MySQL”
- Section C.10.3, “Limits on Table Size”
- Section 17.4.1.21, “Replication and MEMORY Tables”
- Section 17.4.1.38, “Replication and Variables”
- Section C.3, “Restrictions on Server-Side Cursors”
- Section 5.1.10, “Server Status Variables”
- Section 5.1.8, “Server System Variables”
- Section 16.3, “The MEMORY Storage Engine”
max_insert_delayed_threads
max_join_size
max_length_for_sort_data
max_points_in_geometry
max_prepared_stmt_count
max_relay_log_size
max_seeks_for_key
max_sort_length
max_sp_recursion_depth
max_tmp_tables
max_user_connections
max_write_lock_count
mecab_rc_file
metadata_locks_cache_size
metadata_locks_hash_instances
min_examined_row_limit
multi_range_count
myisam_data_pointer_size
myisam_max_sort_file_size
myisam_mmap_size
myisam_recover_options
myisam_repair_threads
myisam_sort_buffer_size
myisam_stats_method
mysql_firewall_mode
mysql_firewall_trace
mysql_native_password_proxy_users
mysqlx_bind_address
mysqlx_connect_timeout
mysqlx_document_id_unique_prefix
mysqlx_enable_hello_notice
mysqlx_idle_worker_thread_timeout
mysqlx_interactive_timeout
mysqlx_max_allowed_packet
mysqlx_max_connections
mysqlx_min_worker_threads
mysqlx_port
mysqlx_port_open_timeout
mysqlx_read_timeout
mysqlx_ssl_capath
mysqlx_ssl_cert
mysqlx_ssl_cipher
mysqlx_ssl_crl
mysqlx_ssl_crlpath
mysqlx_ssl_key
mysqlx_wait_timeout
mysqlx_write_timeout
named_pipe
- Section B.4.2.2, “Can't connect to [local] MySQL server”
- Section 4.2.3, “Command Options for Connecting to the Server”
- Section 4.2.4, “Connecting to the MySQL Server Using Command Options”
- Section 4.5.1.1, “mysql Client Options”
- Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
- Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
- Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
- Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
- Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
- Section 4.5.4, “mysqldump — A Database Backup Program”
- Section 4.5.5, “mysqlimport — A Data Import Program”
- Section 4.5.6, “mysqlpump — A Database Backup Program”
- Section 4.5.7, “mysqlshow — Display Database, Table, and Column Information”
- Section 4.5.8, “mysqlslap — Load Emulation Client”
- Section 2.3.5.3, “Selecting a MySQL Server Type”
- Section 5.1.8, “Server System Variables”
- Section 1.3.2, “The Main Features of MySQL”
- Section 2.3.3.3.1.2, “Type and Networking”
named_pipe_full_access_group
- Section 4.2.3, “Command Options for Connecting to the Server”
- Section 4.2.4, “Connecting to the MySQL Server Using Command Options”
- Section 4.5.1.1, “mysql Client Options”
- Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
- Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
- Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
- Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
- Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
- Section 4.5.4, “mysqldump — A Database Backup Program”
- Section 4.5.5, “mysqlimport — A Data Import Program”
- Section 4.5.6, “mysqlpump — A Database Backup Program”
- Section 4.5.7, “mysqlshow — Display Database, Table, and Column Information”
- Section 4.5.8, “mysqlslap — Load Emulation Client”
- Section 5.1.8, “Server System Variables”
- Section 1.4, “What Is New in MySQL 8.0”
ndb_autoincrement_prefetch_sz
ndb_cache_check_time
ndb_clear_apply_status
ndb_data_node_neighbour
ndb_default_column_format
ndb_deferred_constraints
ndb_distribution
ndb_eventbuffer_free_percent
ndb_eventbuffer_max_alloc
ndb_extra_logging
ndb_force_send
ndb_fully_replicated
ndb_index_stat_enable
ndb_index_stat_option
ndb_join_pushdown
ndb_log_apply_status
ndb_log_bin
ndb_log_binlog_index
ndb_log_empty_epochs
ndb_log_empty_update
ndb_log_exclusive_reads
ndb_log_orig
ndb_log_transaction_id
ndb_metadata_check
ndb_metadata_check_interval
ndb_optimized_node_selection
ndb_read_backup
ndb_recv_thread_activation_threshold
ndb_recv_thread_cpu_mask
ndb_report_thresh_binlog_epoch_slip
ndb_report_thresh_binlog_mem_usage
ndb_row_checksum
ndb_show_foreign_key_mock_tables
ndb_slave_conflict_role
ndb_table_no_logging
ndb_table_temporary
ndb_use_copying_alter_table
ndb_use_exact_count
ndb_use_transactions
ndb_version_string
ndbinfo_database
ndbinfo_max_bytes
ndbinfo_max_rows
ndbinfo_offline
ndbinfo_show_hidden
ndbinfo_table_prefix
ndbinfo_version
net_buffer_length
net_read_timeout
net_retry_count
net_write_timeout
new
ngram_token_size
old_alter_table
- Section 13.1.9, “ALTER TABLE Syntax”
- Section 15.12, “InnoDB and Online DDL”
- Section 23.3.1, “Management of RANGE and LIST Partitions”
- Section 15.12.1, “Online DDL Operations”
- Section 15.12.2, “Online DDL Performance and Concurrency”
- Section 13.7.3.4, “OPTIMIZE TABLE Syntax”
- Section 5.1.8, “Server System Variables”
- Section 15.12.4, “Simplifying DDL Statements with Online DDL”
- Section 1.4, “What Is New in MySQL 8.0”
open_files_limit
- Section B.4.2.17, “File Not Found and Similar Errors”
- Section 8.12.4.1, “How MySQL Handles Client Connections”
- Section 8.4.3.1, “How MySQL Opens and Closes Tables”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 2.5.9, “Managing MySQL Server with systemd”
- Section 26.15, “Performance Schema System Variables”
- Section 23.6, “Restrictions and Limitations on Partitioning”
- Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”
- Section 5.1.8, “Server System Variables”
optimizer_prune_level
optimizer_search_depth
optimizer_switch
- Section 8.2.1.11, “Block Nested-Loop and Batched Key Access Joins”
- Section 8.2.1.12, “Condition Filtering”
- Section 8.2.1.4, “Engine Condition Pushdown Optimization”
- Section 8.2.1.5, “Index Condition Pushdown Optimization”
- Section 8.2.1.3, “Index Merge Optimization”
- Section 8.3.12, “Invisible Indexes”
- Section 8.2.1.10, “Multi-Range Read Optimization”
- Section 8.9.3, “Optimizer Hints”
- Section 8.9.6, “Optimizer Statistics”
- Section 8.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization”
- Section 8.2.2.1, “Optimizing IN and EXISTS Subquery predicates with Semi-Join Transformations”
- Section 8.2.2.2, “Optimizing Subqueries with Materialization”
- Section 8.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
- Section 8.2.1.2, “Range Optimization”
- Section B.3.1, “Server Error Message Reference”
- Section 5.1.8, “Server System Variables”
- Section 8.9.2, “Switchable Optimizations”
- Section 27.4.5.7, “The list_add() Function”
- Section 8.3.10, “Use of Index Extensions”
- Section 24.5.2, “View Processing Algorithms”
optimizer_trace
optimizer_trace_features
optimizer_trace_limit
optimizer_trace_max_mem_size
optimizer_trace_offset
original_commit_timestamp
original_server_version
parser_max_mem_size
partial_revokes
password_history
password_require_current
password_reuse_interval
performance_schema
performance_schema_accounts_size
performance_schema_digests_size
performance_schema_error_size
performance_schema_events_stages_history_long_size
performance_schema_events_stages_history_size
performance_schema_events_statements_history_long_size
performance_schema_events_statements_history_size
performance_schema_events_transactions_history_long_size
performance_schema_events_transactions_history_size
performance_schema_events_waits_history_long_size
performance_schema_events_waits_history_size
performance_schema_hosts_size
performance_schema_max_cond_classes
performance_schema_max_cond_instances
performance_schema_max_digest_length
performance_schema_max_digest_sample_age
performance_schema_max_file_classes
performance_schema_max_file_handles
performance_schema_max_file_instances
performance_schema_max_index_stat
performance_schema_max_memory_classes
performance_schema_max_metadata_locks
performance_schema_max_mutex_classes
performance_schema_max_mutex_instances
performance_schema_max_prepared_statements_instances
performance_schema_max_program_instances
performance_schema_max_rwlock_classes
performance_schema_max_rwlock_instances
performance_schema_max_socket_classes
performance_schema_max_socket_instances
performance_schema_max_sql_text_length
performance_schema_max_stage_classes
performance_schema_max_statement_classes
performance_schema_max_statement_stack
performance_schema_max_table_handles
performance_schema_max_table_instances
performance_schema_max_table_lock_stat
performance_schema_max_thread_classes
performance_schema_max_thread_instances
performance_schema_session_connect_attrs_size
performance_schema_setup_actors_size
performance_schema_setup_objects_size
performance_schema_users_size
persist_only_admin_x
persisted_globals_load
- Section 5.1.9.4, “Nonpersistible and Persist-Restricted System Variables”
- Section 26.12.13.2, “Performance Schema variables_info Table”
- Section 5.1.9.3, “Persisted System Variables”
- Section 21.2.4, “Production Deployment of InnoDB Cluster”
- Section 13.7.7.7, “RESET PERSIST Syntax”
- Section 5.1.8, “Server System Variables”
- Section 4.2.2.2, “Using Option Files”
pid_file
plugin_dir
- Section 6.1.2.2, “Administrator Guidelines for Password Security”
- Section 29.2.4.3, “Compiling and Installing Plugin Libraries”
- Section 6.4.2.1, “Connection-Control Plugin Installation”
- Section 13.7.4.1, “CREATE FUNCTION Syntax for User-Defined Functions”
- Section 13.7.4.3, “INSTALL COMPONENT Syntax”
- Section 13.7.4.4, “INSTALL PLUGIN Syntax”
- Section 5.6.1, “Installing and Uninstalling Plugins”
- Section 2.4.3, “Installing and Using the MySQL Launch Daemon”
- Section 2.5.4, “Installing MySQL on Linux Using RPM Packages from Oracle”
- Section 5.6.5.1, “Installing or Uninstalling ddl_rewriter”
- Section 6.4.4.8.1, “Installing or Uninstalling General-Purpose Keyring Functions”
- Section 6.4.5.2, “Installing or Uninstalling MySQL Enterprise Audit”
- Section 6.4.8.2, “Installing or Uninstalling MySQL Enterprise Data Masking and De-Identification”
- Section 29.3.1.2.1, “Installing or Uninstalling the UDF Locking Interface”
- Section 5.6.6.2, “Installing or Uninstalling Version Tokens”
- Section 6.4.4.10, “Keyring Command Options”
- Section 6.4.4.1, “Keyring Plugin Installation”
- Section 6.4.1.7, “LDAP Pluggable Authentication”
- Section 6.1.3, “Making MySQL Secure Against Attackers”
- Section 12.19.1, “MySQL Enterprise Encryption Installation”
- Section 6.4.1.8, “No-Login Pluggable Authentication”
- Section 6.4.1.5, “PAM Pluggable Authentication”
- Section 6.4.3.1, “Password Validation Component Installation and Uninstallation”
- Section 16.11.1, “Pluggable Storage Engine Architecture”
- Section 29.2.3, “Plugin API Components”
- Section C.9, “Restrictions on Pluggable Authentication”
- Section 17.3.11.2, “Semisynchronous Replication Installation and Configuration”
- Section 5.1.7, “Server Command Options”
- Section 5.1.8, “Server System Variables”
- Section 15.19.3, “Setting Up the InnoDB memcached Plugin”
- Section 13.7.6.25, “SHOW PLUGINS Syntax”
- Section 6.4.1.9, “Socket Peer-Credential Pluggable Authentication”
- Section 6.4.1.10, “Test Pluggable Authentication”
- Section 6.4.6, “The Audit Message Component”
- Section 25.18, “The INFORMATION_SCHEMA PLUGINS Table”
- Section 26.12.17.6, “The user_defined_functions Table”
- Section 5.6.3.2, “Thread Pool Installation”
- Section 29.4.2.5, “UDF Compiling and Installing”
- Section 29.4.2.6, “UDF Security Precautions”
- Section 29.2.4.9.3, “Using the Authentication Plugins”
- Section 29.2.4.11.2, “Using Your Own Protocol Trace Plugins”
- Section 6.4.1.6, “Windows Pluggable Authentication”
- Section 29.2.4.8, “Writing Audit Plugins”
- Section 29.2.4.5, “Writing Daemon Plugins”
- Section 29.2.4.4, “Writing Full-Text Parser Plugins”
- Section 29.2.4.6, “Writing INFORMATION_SCHEMA Plugins”
- Section 29.2.4.12, “Writing Keyring Plugins”
- Section 29.2.4.10, “Writing Password-Validation Plugins”
- Section 29.2.4.7, “Writing Semisynchronous Replication Plugins”
port
- Section B.4.2.2, “Can't connect to [local] MySQL server”
- Section 18.10, “Frequently Asked Questions”
- Section 5.1.8, “Server System Variables”
- Section 26.12.11.9, “The replication_group_members Table”
- Section 21.3, “Using MySQL Router with InnoDB Cluster”
- Section 20.5.5.2, “X Plugin Options and System Variables”
preload_buffer_size
print_identified_with_as_hex
profiling
profiling_history_size
protocol_version
pseudo_slave_mode
pseudo_thread_id
query_alloc_block_size
query_cache_min_res_unit
query_cache_wlock_invalidate
query_prealloc_size
rand_seed
range_alloc_block_size
range_optimizer_max_mem_size
rbr_exec_mode
read_buffer_size
read_only
- Section 13.7.1, “Account Management Statements”
- Section 13.7.1.1, “ALTER USER Syntax”
- Section 6.2.14, “Assigning Account Passwords”
- Section 17.3.1.3, “Backing Up a Master or Slave by Making It Read Only”
- Section 13.7.1.2, “CREATE ROLE Syntax”
- Section 13.7.1.3, “CREATE USER Syntax”
- Section 13.7.1.4, “DROP ROLE Syntax”
- Section 13.7.1.5, “DROP USER Syntax”
- Section 8.14.2, “General Thread States”
- Section 13.7.1.6, “GRANT Syntax”
- Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
- Section 6.2.2, “Privileges Provided by MySQL”
- Section 13.7.1.7, “RENAME USER Syntax”
- Section 17.4.1.38, “Replication and Variables”
- Section 13.7.1.8, “REVOKE Syntax”
- Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”
- Section 5.1.8, “Server System Variables”
- Section 13.7.1.10, “SET PASSWORD Syntax”
- Section 17.1.3.4, “Setting Up Replication Using GTIDs”
- Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
read_rnd_buffer_size
regexp_stack_limit
regexp_time_limit
relay
relay_log
relay_log_basename
relay_log_index
relay_log_info_file
relay_log_info_repository
relay_log_purge
relay_log_recovery
relay_log_space_limit
report_host
report_password
require_secure_transport
resultset_metadata
rewriter_enabled
rewriter_verbose
rpl_read_size
rpl_semi_sync_master_enabled
rpl_semi_sync_master_timeout
rpl_semi_sync_master_trace_level
rpl_semi_sync_master_wait_for_slave_count
rpl_semi_sync_master_wait_no_slave
rpl_semi_sync_master_wait_point
rpl_semi_sync_slave_enabled
rpl_semi_sync_slave_trace_level
rpl_stop_slave_timeout
schema_definition_cache
secondary_engine_cost_threshold
secure_auth
secure_file_priv
- Section 13.2.5, “IMPORT TABLE Syntax”
- Section 2.10.1, “Initializing the Data Directory”
- Section 2.5.4, “Installing MySQL on Linux Using RPM Packages from Oracle”
- Section 13.2.7, “LOAD DATA Syntax”
- Section 6.1.3, “Making MySQL Secure Against Attackers”
- Section 6.4.8.4, “MySQL Enterprise Data Masking and De-Identification User-Defined Function Reference”
- Section 2.9.4, “MySQL Source-Configuration Options”
- Section 6.2.2, “Privileges Provided by MySQL”
- Section 13.2.10.1, “SELECT ... INTO Syntax”
- Section 5.1.7, “Server Command Options”
- Section 5.1.8, “Server System Variables”
- Section 12.5, “String Functions”
- Section 6.4.8.3, “Using MySQL Enterprise Data Masking and De-Identification”
server_id
- Section 18.2.1.5.1, “Adding a Second Instance”
- Section 6.4.5.4, “Audit Log File Formats”
- Section 17.1.6.4, “Binary Logging Options and Variables”
- Section 18.2.1.2, “Configuring an Instance for Group Replication”
- Section 12.24, “Miscellaneous Functions”
- Section 22.3.3.9.1, “MySQL Server Options for NDB Cluster”
- Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
- Section 22.6.11, “NDB Cluster Replication Conflict Resolution”
- Section 22.3.3.9.2, “NDB Cluster System Variables”
- Section 26.12.11, “Performance Schema Replication Tables”
- Section 17.1.6, “Replication and Binary Logging Options and Variables”
- Section 5.1.8, “Server System Variables”
- Section 17.1.2.1, “Setting the Replication Master Configuration”
- Section 17.1.3.4, “Setting Up Replication Using GTIDs”
- Section 13.7.6.34, “SHOW SLAVE STATUS Syntax”
- Section 5.4.4, “The Binary Log”
- Section 17.2.1.2, “Usage of Row-Based Logging and Replication”
- Section 21.4, “Working with InnoDB Cluster”
server_id_bits
server_uuid
- Section 18.4.2.2, “Changing a Group's Mode”
- Section 18.4.2.1, “Changing a Group's Primary Member”
- Section 17.3.10, “Encrypting Binary Log Files and Relay Log Files”
- Section 13.4.3.3, “Function which Configures Group Replication Primary”
- Section 17.1.3.1, “GTID Format and Storage”
- Section 26.12.11, “Performance Schema Replication Tables”
- Section 21.2.4, “Production Deployment of InnoDB Cluster”
- Section 17.1.6, “Replication and Binary Logging Options and Variables”
- Section 13.7.6.34, “SHOW SLAVE STATUS Syntax”
- Section 18.4.1.1, “Single-Primary Mode”
- Section 13.4.2.6, “START SLAVE Syntax”
- Section 17.1.3.7, “Stored Function Examples to Manipulate GTIDs”
- Section 26.12.17.3, “The log_status Table”
- Section 26.12.11.2, “The replication_connection_status Table”
- Section 18.3.2, “The replication_group_members Table”
- Section 18.4.7, “Using MySQL Enterprise Backup with Group Replication”
- Section 21.3, “Using MySQL Router with InnoDB Cluster”
- Section 21.4, “Working with InnoDB Cluster”
session_track_gtids
session_track_schema
session_track_state_change
session_track_system_variables
session_track_transaction_info
sha
shared_memory
- Section 4.2.3, “Command Options for Connecting to the Server”
- Section 4.2.4, “Connecting to the MySQL Server Using Command Options”
- Section 4.5.1.1, “mysql Client Options”
- Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
- Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
- Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
- Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
- Section 4.5.4, “mysqldump — A Database Backup Program”
- Section 4.5.5, “mysqlimport — A Data Import Program”
- Section 4.5.7, “mysqlshow — Display Database, Table, and Column Information”
- Section 4.5.8, “mysqlslap — Load Emulation Client”
- Section B.3.1, “Server Error Message Reference”
- Section 5.1.8, “Server System Variables”
- Section 5.8.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
- Section 2.3.5.5, “Starting the Server for the First Time”
- Section 1.3.2, “The Main Features of MySQL”
- Section 2.3.3.3.1.2, “Type and Networking”
shared_memory_base_name
show_compatibility_
show_create_table_verbosity
show_old_temporals
skip_external_locking
skip_name_resolve
skip_networking
slave
slave_allow_batching
slave_checkpoint_group
slave_checkpoint_period
slave_compressed_protocol
slave_exec_mode
slave_load_tmpdir
slave_max_allowed_packet
slave_net_timeout
- Section 13.4.2.1, “CHANGE MASTER TO Syntax”
- Section 17.1.7.1, “Checking Replication Status”
- Section 17.4.1.27, “Replication and Master or Slave Shutdowns”
- Section 8.14.4, “Replication Slave I/O Thread States”
- Section 17.1.6.3, “Replication Slave Options and Variables”
- Section 5.1.8, “Server System Variables”
slave_parallel_type
slave_parallel_workers
- Section 13.4.2.1, “CHANGE MASTER TO Syntax”
- Section 18.9.1, “Group Replication Requirements”
- Section 17.1.3.2, “GTID Life Cycle”
- Section 22.6.3, “Known Issues in NDB Cluster Replication”
- Section 26.12.11, “Performance Schema Replication Tables”
- Section 17.4.1.20, “Replication and max_allowed_packet”
- Section 17.4.1.33, “Replication and Transaction Inconsistencies”
- Section 17.1.6.3, “Replication Slave Options and Variables”
- Section 8.14.5, “Replication Slave SQL Thread States”
- Section 13.4.2.7, “STOP SLAVE Syntax”
- Section 26.12.11.6, “The replication_applier_status_by_worker Table”
slave_pending_jobs_size_max
slave_preserve_commit_order
- Section 17.1.6.4, “Binary Logging Options and Variables”
- Section 18.9.1, “Group Replication Requirements”
- Section 17.1.3.2, “GTID Life Cycle”
- Section 17.4.1.33, “Replication and Transaction Inconsistencies”
- Section 8.14.4, “Replication Slave I/O Thread States”
- Section 17.1.6.3, “Replication Slave Options and Variables”
slave_rows_search_algorithms
slave_skip_errors
slave_sql_verify_checksum
slave_transaction_retries
slave_type_conversions
slow_query_log
slow_query_log_file
socket
sort_buffer_size
sql_auto_is_null
sql_big_selects
sql_buffer_result
sql_log_bin
- Section 17.1.6.4, “Binary Logging Options and Variables”
- Section 22.1.7.8, “Issues Exclusive to NDB Cluster”
- Section 22.6.3, “Known Issues in NDB Cluster Replication”
- Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
- Section 22.1.7.1, “Noncompliance with SQL Syntax in NDB Cluster”
- Section 6.2.2, “Privileges Provided by MySQL”
- Section 13.4.1.3, “SET sql_log_bin Syntax”
- Section 5.1.9.1, “System Variable Privileges”
- Section 27.4.4.2, “The diagnostics() Procedure”
- Section 27.4.4.12, “The ps_setup_reload_saved() Procedure”
- Section 27.4.4.14, “The ps_setup_save() Procedure”
- Section 27.4.4.22, “The ps_trace_statement_digest() Procedure”
- Section 27.4.4.23, “The ps_trace_thread() Procedure”
- Section 27.4.4.25, “The statement_performance_analyzer() Procedure”
- Section 17.4.3, “Upgrading a Replication Setup”
- Section 1.4, “What Is New in MySQL 8.0”
sql_log_off
sql_mode
- Section 15.1.2, “Best Practices for InnoDB Tables”
- Section 2.11.4, “Changes in MySQL 8.0”
- Section 13.1.13, “CREATE EVENT Syntax”
- Section 13.1.17, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
- Section 13.1.22, “CREATE TRIGGER Syntax”
- Section 12.25.3, “Expression Handling”
- Section 1.7, “How to Report Bugs or Problems”
- Section 13.2.7, “LOAD DATA Syntax”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 1.8, “MySQL Standards Compliance”
- Section 2.11.5, “Preparing Your Installation for Upgrade”
- Section B.4.4.2, “Problems Using DATE Columns”
- Section 17.4.1.38, “Replication and Variables”
- Section 5.1.11, “Server SQL Modes”
- Section 5.1.8, “Server System Variables”
- Section 13.7.6.13, “SHOW CREATE VIEW Syntax”
- Section 13.6.7.5, “SIGNAL Syntax”
- Section 5.4.4, “The Binary Log”
- Section 25.36, “The INFORMATION_SCHEMA VIEWS Table”
- Section 27.4.5.7, “The list_add() Function”
- Section 4.2.2.2, “Using Option Files”
- Section 5.1.9, “Using System Variables”
sql_notes
sql_quote_show_create
sql_require_primary_key
sql_safe_updates
sql_slave_skip_counter
sql_warnings
ssl_ca
ssl_capath
ssl_cert
ssl_cipher
ssl_crl
ssl_crlpath
ssl_fips_mode
ssl_key
storage_engine
stored_program_cache
stored_program_definition_cache
super_read_only
- Section 18.2.1.5.1, “Adding a Second Instance”
- Section 21.2.6, “Adopting a Group Replication Deployment”
- Section 18.7.2.4, “Group Replication Online Upgrade Methods”
- Section 18.3.1, “Group Replication Server States”
- Section 18.8, “Group Replication System Variables”
- Section 18.7.2.1, “Online Upgrade Considerations”
- Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
- Section 21.2.4, “Production Deployment of InnoDB Cluster”
- Section 18.6.6, “Responses to Failure Detection and Network Partitioning”
- Section 21.2.5, “Sandbox Deployment of InnoDB Cluster”
- Section 5.1.8, “Server System Variables”
- Section 13.4.3.1, “START GROUP_REPLICATION Syntax”
- Section 13.4.3.2, “STOP GROUP_REPLICATION Syntax”
- Section 18.7.2.3, “Upgrading a Group Replication Member”
- Section 21.4, “Working with InnoDB Cluster”
sync_binlog
- Section 17.1.6.4, “Binary Logging Options and Variables”
- Section 17.1.3.3, “GTID Auto-Positioning”
- Section 17.3.2, “Handling an Unexpected Halt of a Replication Slave”
- Section 15.2, “InnoDB and the ACID Model”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 17.4.1.27, “Replication and Master or Slave Shutdowns”
- Section 5.4.4, “The Binary Log”
sync_master_info
sync_relay_log
sync_relay_log_info
syseventlog
system_time_zone
table_definition_cache
table_encryption_privilege_check
- Section 13.1.2, “ALTER DATABASE Syntax”
- Section 13.1.9, “ALTER TABLE Syntax”
- Section 13.1.10, “ALTER TABLESPACE Syntax”
- Section 13.1.12, “CREATE DATABASE Syntax”
- Section 13.1.20, “CREATE TABLE Syntax”
- Section 13.1.21, “CREATE TABLESPACE Syntax”
- Section 15.6.3.9, “InnoDB Data-at-Rest Encryption”
- Section 6.2.2, “Privileges Provided by MySQL”
- Section 13.1.36, “RENAME TABLE Syntax”
- Section 5.1.8, “Server System Variables”
- Section 1.4, “What Is New in MySQL 8.0”
table_open_cache
- Section B.4.2.17, “File Not Found and Similar Errors”
- Section 8.14.2, “General Thread States”
- Section 8.4.3.1, “How MySQL Opens and Closes Tables”
- Section 8.12.3.1, “How MySQL Uses Memory”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 5.1.10, “Server Status Variables”
- Section 5.1.8, “Server System Variables”
table_open_cache_instances
tablespace_definition_cache
temptable_max_ram
temptable_use_mmap
thread_cache_size
thread_pool_algorithm
thread_pool_high_priority_connection
thread_pool_max_unused_threads
thread_pool_prio_kickup_timer
thread_pool_size
thread_pool_stall_limit
thread_stack
time_format
time_zone
- Section 13.1.13, “CREATE EVENT Syntax”
- Section 12.7, “Date and Time Functions”
- Section 24.4.4, “Event Metadata”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 5.1.13, “MySQL Server Time Zone Support”
- Section 28.7.7.69, “mysql_session_track_get_first()”
- Section 17.4.1.38, “Replication and Variables”
- Section 5.1.7, “Server Command Options”
- Section 5.1.8, “Server System Variables”
- Section 11.3.1, “The DATE, DATETIME, and TIMESTAMP Types”
- Section 5.4.3, “The General Query Log”
- Section 5.4.5, “The Slow Query Log”
- Section 1.4, “What Is New in MySQL 8.0”
timestamp
tls_ciphersuites
tls_version
- Section 4.2.3, “Command Options for Connecting to the Server”
- Section 6.3.1, “Configuring MySQL to Use Encrypted Connections”
- Section 6.3.5, “Encrypted Connection Protocols and Ciphers”
- Section 5.1.10, “Server Status Variables”
- Section 5.1.8, “Server System Variables”
- Section 17.3.9, “Setting Up Replication to Use Encrypted Connections”
- Section 20.5.3, “Using Secure Connections with X Plugin”
tmp_table_size
tmpdir
- Section 17.3.1.2, “Backing Up Raw Data from a Slave”
- Section B.4.2.12, “Can't create/write to file”
- Section 7.2, “Database Backup Methods”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 8.4.4, “Internal Temporary Table Use in MySQL”
- Section 2.9.4, “MySQL Source-Configuration Options”
- Section 15.12.5, “Online DDL Failure Conditions”
- Section 15.12.3, “Online DDL Space Requirements”
- Section 8.2.1.15, “ORDER BY Optimization”
- Section 17.1.6.3, “Replication Slave Options and Variables”
- Section 5.1.8, “Server System Variables”
transaction
transaction_alloc_block_size
transaction_allow_batching
transaction_isolation
transaction_prealloc_size
transaction_read_only
- Section 28.7.7.69, “mysql_session_track_get_first()”
- Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
- Section 5.1.7, “Server Command Options”
- Section 5.1.8, “Server System Variables”
- Section 5.1.15, “Server Tracking of Client Session State Changes”
- Section 13.3.7, “SET TRANSACTION Syntax”
- Section 1.4, “What Is New in MySQL 8.0”