This section lists server variables, status variables, and options that were added for the first time, have been deprecated, or have been removed in MySQL 8.0.本节列出了MySQL 8.0中首次添加、已弃用或已删除的服务器变量、状态变量和选项。
The following system variables, status variables, and server options have been added in MySQL 8.0.MySQL 8.0中添加了以下系统变量、状态变量和服务器选项。
Acl_cache_items_count
: Number of cached privilege objects. Added in MySQL 8.0.0.:缓存特权对象的数量。在MySQL 8.0.0中添加。
Audit_log_current_size
: Audit log file current size. Added in MySQL 8.0.11.:审核日志文件当前大小。在MySQL 8.0.11中添加。
Audit_log_event_max_drop_size
: Size of largest dropped audited event. :最大丢弃的已审核事件的大小。Added in MySQL 8.0.11.在MySQL 8.0.11中添加。
Audit_log_events
: Number of handled audited events. Added in MySQL 8.0.11.:已处理的已审核事件数。在MySQL 8.0.11中添加。
Audit_log_events_filtered
: Number of filtered audited events. Added in MySQL 8.0.11.:筛选的已审核事件数。在MySQL 8.0.11中添加。
Audit_log_events_lost
: Number of dropped audited events. Added in MySQL 8.0.11.:已删除的已审核事件数。在MySQL 8.0.11中添加。
Audit_log_events_written
: Number of written audited events. Added in MySQL 8.0.11.:已写入的审核事件数。在MySQL 8.0.11中添加。
Audit_log_total_size
: Combined size of written audited events. Added in MySQL 8.0.11.:已写入的审核事件的组合大小。在MySQL 8.0.11中添加。
Audit_log_write_waits
: Number of write-delayed audited events. Added in MySQL 8.0.11.:写入延迟审核事件数。在MySQL 8.0.11中添加。
Authentication_ldap_sasl_supported_methods
: Supported authentication methods for SASL LDAP authentication. Added in MySQL 8.0.21.:支持用于SASL LDAP身份验证的身份验证方法。在MySQL 8.0.21中添加。
Caching_sha2_password_rsa_public_key
: caching_sha2_password authentication plugin RSA public key value. Added in MySQL 8.0.4.:caching_sha2_password
验证插件RSA公钥值。在MySQL 8.0.4中添加。
Com_alter_resource_group
: Count of ALTER RESOURCE GROUP statements. Added in MySQL 8.0.3.:ALTER RESOURCE GROUP
语句的计数。在MySQL 8.0.3中添加。
Com_alter_user_default_role
: Count of ALTER USER ... DEFAULT ROLE statements. ALTER USER ... DEFAULT ROLE
语句的计数。Added in MySQL 8.0.0.在MySQL 8.0.0中添加。
Com_clone
: Count of CLONE statements. :CLONE
语句的计数。Added in MySQL 8.0.2.在MySQL 8.0.2中添加。
Com_create_resource_group
: Count of CREATE RESOURCE GROUP statements. Added in MySQL 8.0.3.:CREATE RESOURCE GROUP
语句的计数。在MySQL 8.0.3中添加。
Com_create_role
: Count of CREATE ROLE statements. Added in MySQL 8.0.0.:CREATE ROLE
语句的计数。在MySQL 8.0.0中添加。
Com_drop_resource_group
: Count of DROP RESOURCE GROUP statements. Added in MySQL 8.0.3.:DROP RESOURCE GROUP
语句的计数。在MySQL 8.0.3中添加。
Com_drop_role
: Count of DROP ROLE statements. Added in MySQL 8.0.0.:DROP ROLE
语句的计数。在MySQL 8.0.0中添加。
Com_grant_roles
: Count of GRANT ROLE statements. Added in MySQL 8.0.0.:GRANT ROLE
语句的计数。在MySQL 8.0.0中添加。
Com_install_component
: Count of INSTALL COMPONENT statements. Added in MySQL 8.0.0.:INSTALL COMPONENT
语句的计数。在MySQL 8.0.0中添加。
Com_replica_start
: Count of START REPLICA and START SLAVE statements. Added in MySQL 8.0.22.:START REPLICA
语句和START SLAVE
语句的计数。在MySQL 8.0.22中添加。
Com_replica_stop
: Count of STOP REPLICA and STOP SLAVE statements. Added in MySQL 8.0.22.:STOP REPLICA
语句和STOP SLAVE
语句的计数。在MySQL 8.0.22中添加。
Com_restart
: Count of RESTART statements. Added in MySQL 8.0.4.:RESTART
语句的计数。在MySQL 8.0.4中添加。
Com_revoke_roles
: Count of REVOKE ROLES statements. Added in MySQL 8.0.0.:REVOKE ROLES
语句的计数。在MySQL 8.0.0中添加。
Com_set_resource_group
: Count of SET RESOURCE GROUP statements. Added in MySQL 8.0.3.:SET RESOURCE GROUP
语句的计数。在MySQL 8.0.3中添加。
Com_set_role
: Count of SET ROLE statements. Added in MySQL 8.0.0.:SET ROLE
语句的计数。在MySQL 8.0.0中添加。
Com_show_replica_status
: Count of SHOW REPLICA STATUS and SHOW SLAVE STATUS statements. Added in MySQL 8.0.22.:SHOW REPLICA STATUS
语句和SHOW SLAVE STATUS
语句的计数。在MySQL 8.0.22中添加。
Com_show_replicas
: Count of SHOW REPLICAS and SHOW SLAVE HOSTS statements. Added in MySQL 8.0.22.:SHOW REPLICAS
语句和SHOW SLAVE HOSTS
语句的计数。在MySQL 8.0.22中添加。
Com_uninstall_component
: Count of UINSTALL COMPONENT statements. Added in MySQL 8.0.0.:UINSTALL COMPONENT
语句的计数。在MySQL 8.0.0中添加。
Compression_algorithm
: Compression algorithm for current connection. Added in MySQL 8.0.18.:当前连接的压缩算法。在MySQL 8.0.18中添加。
Compression_level
: Compression level for current connection. Added in MySQL 8.0.18.:当前连接的压缩级别。在MySQL 8.0.18中添加。
Connection_control_delay_generated
: How many times server delayed connection request. Added in MySQL 8.0.1.:服务器延迟连接请求的次数。在MySQL 8.0.1中添加。
Current_tls_ca
: Current value of ssl_ca system variable. Added in MySQL 8.0.16.:ssl_ca系统变量的当前值。在MySQL 8.0.16中添加。
Current_tls_capath
: Current value of ssl_capath system variable. Added in MySQL 8.0.16.:ssl_capath系统变量的当前值。在MySQL 8.0.16中添加。
Current_tls_cert
: Current value of ssl_cert system variable. Added in MySQL 8.0.16.:ssl_cert系统变量的当前值。在MySQL 8.0.16中添加。
Current_tls_cipher
: Current value of ssl_cipher system variable. Added in MySQL 8.0.16.:ssl_cipher系统变量的当前值。在MySQL 8.0.16中添加。
Current_tls_ciphersuites
: Current value of tsl_ciphersuites system variable. Added in MySQL 8.0.16.:tsl_ciphersuites系统变量的当前值。在MySQL 8.0.16中添加。
Current_tls_crl
: Current value of ssl_crl system variable. Added in MySQL 8.0.16.:ssl_crl系统变量的当前值。在MySQL 8.0.16中添加。
Current_tls_crlpath
: Current value of ssl_crlpath system variable. Added in MySQL 8.0.16.:ssl_crlpath系统变量的当前值。在MySQL 8.0.16中添加。
Current_tls_key
: Current value of ssl_key system variable. Added in MySQL 8.0.16.:ssl_key系统变量的当前值。在MySQL 8.0.16中添加。
Current_tls_version
: Current value of tls_version system variable. Added in MySQL 8.0.16.:tls_version系统变量的当前值。在MySQL 8.0.16中添加。
Error_log_buffered_bytes
: Number of bytes used in error_log table. Added in MySQL 8.0.22.:error_log表中使用的字节数。在MySQL 8.0.22中添加。
Error_log_buffered_events
: Number of events in error_log table. Added in MySQL 8.0.22.:error_log表中的事件数。在MySQL 8.0.22中添加。
Error_log_expired_events
: Number of events discarded from error_log table. Added in MySQL 8.0.22.:从error_log表中丢弃的事件数。在MySQL 8.0.22中添加。
Error_log_latest_write
: Time of last write to error_log table. Added in MySQL 8.0.22.:上次写入error_log表的时间。在MySQL 8.0.22中添加。
Firewall_access_denied
: Number of statements rejected by MySQL Enterprise Firewall. Added in MySQL 8.0.11.:MySQL企业防火墙拒绝的语句数。在MySQL 8.0.11中添加。
Firewall_access_granted
: Number of statements accepted by MySQL Enterprise Firewall. Added in MySQL 8.0.11.:MySQL企业防火墙接受的语句数。在MySQL 8.0.11中添加。
Firewall_cached_entries
: Number of statements recorded by MySQL Enterprise Firewall. Added in MySQL 8.0.11.:MySQL企业防火墙记录的语句数。在MySQL 8.0.11中添加。
Innodb_redo_log_enabled
: InnoDB redo log status. Added in MySQL 8.0.21.:InnoDB
重做日志状态。在MySQL 8.0.21中添加。
Innodb_system_rows_deleted
: Number of rows deleted from system schema tables. Added in MySQL 8.0.19.:从系统架构表中删除的行数。在MySQL 8.0.19中添加。
Innodb_system_rows_inserted
: Number of rows inserted into system schema tables. Added in MySQL 8.0.19.:插入到系统架构表中的行数。在MySQL 8.0.19中添加。
Innodb_system_rows_read
: Number of rows read from system schema tables. Added in MySQL 8.0.19.:从系统架构表读取的行数。在MySQL 8.0.19中添加。
Innodb_undo_tablespaces_active
: Number of active undo tablespaces. Added in MySQL 8.0.14.:活动撤消表空间的数量。在MySQL 8.0.14中添加。
Innodb_undo_tablespaces_explicit
: Number of user-created undo tablespaces. Added in MySQL 8.0.14.:用户创建的撤消表空间数。在MySQL 8.0.14中添加。
Innodb_undo_tablespaces_implicit
: Number of undo tablespaces created by InnoDB. Added in MySQL 8.0.14.:InnoDB
创建的撤消表空间数。在MySQL 8.0.14中添加。
Innodb_undo_tablespaces_total
: Total number of undo tablespaces. Added in MySQL 8.0.14.:撤消表空间的总数。在MySQL 8.0.14中添加。
Mysqlx_bytes_received_compressed_payload
: Number of bytes received as compressed message payloads, measured before decompression. Added in MySQL 8.0.19.:作为压缩消息有效负载接收的字节数,在解压缩之前测量。在MySQL 8.0.19中添加。
Mysqlx_bytes_received_uncompressed_frame
: Number of bytes received as compressed message payloads, measured after decompression. Added in MySQL 8.0.19.:作为压缩消息有效负载接收的字节数,解压缩后测量。在MySQL 8.0.19中添加。
Mysqlx_bytes_sent_compressed_payload
: Number of bytes sent as compressed message payloads, measured after compression. Added in MySQL 8.0.19.:作为压缩消息有效负载发送的字节数,在压缩后测量。在MySQL 8.0.19中添加。
Mysqlx_bytes_sent_uncompressed_frame
: Number of bytes sent as compressed message payloads, measured before compression. Added in MySQL 8.0.19.:作为压缩消息有效负载发送的字节数,在压缩前测量。在MySQL 8.0.19中添加。
Mysqlx_compression_algorithm
: Compression algorithm in use for X Protocol connection for this session. Added in MySQL 8.0.20.:此会话的X协议连接使用的压缩算法。在MySQL 8.0.20中添加。
Mysqlx_compression_level
: Compression level in use for X Protocol connection for this session. Added in MySQL 8.0.20.:此会话的X协议连接使用的压缩级别。在MySQL 8.0.20中添加。
Secondary_engine_execution_count
: Number of queries offloaded to a secondary engine.. Added in MySQL 8.0.13.:卸载到辅助引擎的查询数。。在MySQL 8.0.13中添加。
activate_all_roles_on_login
: Whether to activate all user roles at connect time. Added in MySQL 8.0.2.:是否在连接时激活所有用户角色。在MySQL 8.0.2中添加。
admin-ssl
: Enable connection encryption. Added in MySQL 8.0.21.:启用连接加密。在MySQL 8.0.21中添加。
admin_address
: IP address to bind to for connections on administrative interface. Added in MySQL 8.0.14.:要为管理接口上的连接绑定到的IP地址。在MySQL 8.0.14中添加。
admin_port
: TCP/IP number to use for connections on administrative interface. Added in MySQL 8.0.14.:用于管理接口上的连接的TCP/IP号。在MySQL 8.0.14中添加。
admin_ssl_ca
: File that contains list of trusted SSL Certificate Authorities. Added in MySQL 8.0.21.:包含受信任SSL证书颁发机构列表的文件。在MySQL 8.0.21中添加。
admin_ssl_capath
: Directory that contains trusted SSL Certificate Authority certificate files. Added in MySQL 8.0.21.:包含受信任的SSL证书颁发机构证书文件的目录。在MySQL 8.0.21中添加。
admin_ssl_cert
: File that contains X.509 certificate. Added in MySQL 8.0.21.:包含X.509证书的文件。在MySQL 8.0.21中添加。
admin_ssl_cipher
: Permissible ciphers for connection encryption. Added in MySQL 8.0.21.:连接加密的允许密码。在MySQL 8.0.21中添加。
admin_ssl_crl
: File that contains certificate revocation lists. Added in MySQL 8.0.21.:包含证书吊销列表的文件。在MySQL 8.0.21中添加。
admin_ssl_crlpath
: Directory that contains certificate revocation list files. Added in MySQL 8.0.21.:包含证书吊销列表文件的目录。在MySQL 8.0.21中添加。
admin_ssl_key
: File that contains X.509 key. Added in MySQL 8.0.21.:包含X.509密钥的文件。在MySQL 8.0.21中添加。
admin_tls_ciphersuites
: Permissible TLSv1.3 ciphersuites for encrypted connections. Added in MySQL 8.0.21.:用于加密连接的允许TLSv1.3密码套件。在MySQL 8.0.21中添加。
admin_tls_version
: Permissible TLS protocols for encrypted connections. Added in MySQL 8.0.21.:用于加密连接的允许TLS协议。在MySQL 8.0.21中添加。
audit-log
: Whether to activate audit log plugin. Added in MySQL 8.0.11.:是否激活审核日志插件。在MySQL 8.0.11中添加。
audit_log_buffer_size
: Size of audit log buffer. Added in MySQL 8.0.11.:审核日志缓冲区的大小。在MySQL 8.0.11中添加。
audit_log_compression
: Audit log file compression method. Added in MySQL 8.0.11.:审核日志文件压缩方法。在MySQL 8.0.11中添加。
audit_log_connection_policy
: Audit logging policy for connection-related events. Added in MySQL 8.0.11.:审核连接相关事件的日志记录策略。在MySQL 8.0.11中添加。
audit_log_current_session
: Whether to audit current session. Added in MySQL 8.0.11.:是否审核当前会话。在MySQL 8.0.11中添加。
audit_log_encryption
: Audit log file encryption method. Added in MySQL 8.0.11.:审核日志文件加密方法。在MySQL 8.0.11中添加。
audit_log_exclude_accounts
: Accounts not to audit. Added in MySQL 8.0.11.:不需要审计的帐户。在MySQL 8.0.11中添加。
audit_log_file
: Name of audit log file. Added in MySQL 8.0.11.:审核日志文件的名称。在MySQL 8.0.11中添加。
audit_log_filter_id
: ID of current audit log filter. Added in MySQL 8.0.11.:当前审核日志筛选器的ID。在MySQL 8.0.11中添加。
audit_log_flush
: Close and reopen audit log file. Added in MySQL 8.0.11.:关闭并重新打开审核日志文件。在MySQL 8.0.11中添加。
audit_log_format
: Audit log file format. Added in MySQL 8.0.11.:审核日志文件格式。在MySQL 8.0.11中添加。
audit_log_format_unix_timestamp
: Whether to include Unix timestamp in JSON-format audit log. Added in MySQL 8.0.26.:是否在JSON格式的审核日志中包含Unix时间戳。在MySQL 8.0.26中添加。
audit_log_include_accounts
: Accounts to audit. Added in MySQL 8.0.11.:要审计的帐户。在MySQL 8.0.11中添加。
audit_log_max_size
: Limit on combined size of JSON audit log files. Added in MySQL 8.0.26.:限制JSON审核日志文件的组合大小。在MySQL 8.0.26中添加。
audit_log_password_history_keep_days
: Number of days to retain archived audit log encryption passwords. Added in MySQL 8.0.17.:保留存档审核日志加密密码的天数。在MySQL 8.0.17中添加。
audit_log_policy
: Audit logging policy. Added in MySQL 8.0.11.:审核日志记录策略。在MySQL 8.0.11中添加。
audit_log_prune_seconds
: The number of seconds after which audit log files become subject to pruning. Added in MySQL 8.0.24.:审核日志文件被修剪后的秒数。在MySQL 8.0.24中添加。
audit_log_read_buffer_size
: Audit log file read buffer size. Added in MySQL 8.0.11.:审核日志文件读取缓冲区大小。在MySQL 8.0.11中添加。
audit_log_rotate_on_size
: Close and reopen audit log file at this size. Added in MySQL 8.0.11.:关闭并重新打开此大小的审核日志文件。在MySQL 8.0.11中添加。
audit_log_statement_policy
: Audit logging policy for statement-related events. Added in MySQL 8.0.11.:语句相关事件的审核日志记录策略。在MySQL 8.0.11中添加。
audit_log_strategy
: Audit logging strategy. Added in MySQL 8.0.11.:审核日志策略。在MySQL 8.0.11中添加。
authentication_ldap_sasl_auth_method_name
: Authentication method name. Added in MySQL 8.0.11.:验证方法名称。在MySQL 8.0.11中添加。
authentication_ldap_sasl_bind_base_dn
: LDAP server base distinguished name. Added in MySQL 8.0.11.:LDAP服务器基可分辨名称。在MySQL 8.0.11中添加。
authentication_ldap_sasl_bind_root_dn
: LDAP server root distinguished name. Added in MySQL 8.0.11.:LDAP服务器根可分辨名称。在MySQL 8.0.11中添加。
authentication_ldap_sasl_bind_root_pwd
: LDAP server root bind password. Added in MySQL 8.0.11.:LDAP服务器根绑定密码。在MySQL 8.0.11中添加。
authentication_ldap_sasl_ca_path
: LDAP server certificate authority file name. Added in MySQL 8.0.11.:LDAP服务器证书颁发机构文件名。在MySQL 8.0.11中添加。
authentication_ldap_sasl_group_search_attr
: LDAP server group search attribute. Added in MySQL 8.0.11.:LDAP服务器组搜索属性。在MySQL 8.0.11中添加。
authentication_ldap_sasl_group_search_filter
: LDAP custom group search filter. Added in MySQL 8.0.11.:LDAP自定义组搜索筛选器。在MySQL 8.0.11中添加。
authentication_ldap_sasl_init_pool_size
: LDAP server initial connection pool size. Added in MySQL 8.0.11.:LDAP服务器初始连接池大小。在MySQL 8.0.11中添加。
authentication_ldap_sasl_log_status
: LDAP server log level. Added in MySQL 8.0.11.:LDAP服务器日志级别。在MySQL 8.0.11中添加。
authentication_ldap_sasl_max_pool_size
: LDAP server maximum connection pool size. Added in MySQL 8.0.11.:LDAP服务器最大连接池大小。在MySQL 8.0.11中添加。
authentication_ldap_sasl_referral
: Whether to enable LDAP search referral. Added in MySQL 8.0.20.:是否启用LDAP搜索引用。在MySQL 8.0.20中添加。
authentication_ldap_sasl_server_host
: LDAP server host name or IP address. Added in MySQL 8.0.11.:LDAP服务器主机名或IP地址。在MySQL 8.0.11中添加。
authentication_ldap_sasl_server_port
: LDAP server port number. Added in MySQL 8.0.11.:LDAP服务器端口号。在MySQL 8.0.11中添加。
authentication_ldap_sasl_tls
: Whether to use encrypted connections to LDAP server. Added in MySQL 8.0.11.:是否使用到LDAP服务器的加密连接。在MySQL 8.0.11中添加。
authentication_ldap_sasl_user_search_attr
: LDAP server user search attribute. Added in MySQL 8.0.11.:LDAP服务器用户搜索属性。在MySQL 8.0.11中添加。
authentication_ldap_simple_auth_method_name
: Authentication method name. Added in MySQL 8.0.11.:验证方法名称。在MySQL 8.0.11中添加。
authentication_ldap_simple_bind_base_dn
: LDAP server base distinguished name. Added in MySQL 8.0.11.:LDAP服务器基可分辨名称。在MySQL 8.0.11中添加。
authentication_ldap_simple_bind_root_dn
: LDAP server root distinguished name. Added in MySQL 8.0.11.:LDAP服务器根可分辨名称。在MySQL 8.0.11中添加。
authentication_ldap_simple_bind_root_pwd
: LDAP server root bind password. Added in MySQL 8.0.11.:LDAP服务器根绑定密码。在MySQL 8.0.11中添加。
authentication_ldap_simple_ca_path
: LDAP server certificate authority file name. Added in MySQL 8.0.11.:LDAP服务器证书颁发机构文件名。在MySQL 8.0.11中添加。
authentication_ldap_simple_group_search_attr
: LDAP server group search attribute. Added in MySQL 8.0.11.:LDAP服务器组搜索属性。在MySQL 8.0.11中添加。
authentication_ldap_simple_group_search_filter
: LDAP custom group search filter. Added in MySQL 8.0.11.:LDAP自定义组搜索筛选器。在MySQL 8.0.11中添加。
authentication_ldap_simple_init_pool_size
: LDAP server initial connection pool size. Added in MySQL 8.0.11.:LDAP服务器初始连接池大小。在MySQL 8.0.11中添加。
authentication_ldap_simple_log_status
: LDAP server log level. Added in MySQL 8.0.11.:LDAP服务器日志级别。在MySQL 8.0.11中添加。
authentication_ldap_simple_max_pool_size
: LDAP server maximum connection pool size. Added in MySQL 8.0.11.:LDAP服务器最大连接池大小。在MySQL 8.0.11中添加。
authentication_ldap_simple_referral
: Whether to enable LDAP search referral. Added in MySQL 8.0.20.:是否启用LDAP搜索引用。在MySQL 8.0.20中添加。
authentication_ldap_simple_server_host
: LDAP server host name or IP address. Added in MySQL 8.0.11.:LDAP服务器主机名或IP地址。在MySQL 8.0.11中添加。
authentication_ldap_simple_server_port
: LDAP server port number. Added in MySQL 8.0.11.:LDAP服务器端口号。在MySQL 8.0.11中添加。
authentication_ldap_simple_tls
: Whether to use encrypted connections to LDAP server. Added in MySQL 8.0.11.:是否使用到LDAP服务器的加密连接。在MySQL 8.0.11中添加。
authentication_ldap_simple_user_search_attr
: LDAP server user search attribute. Added in MySQL 8.0.11.:LDAP服务器用户搜索属性。在MySQL 8.0.11中添加。
authentication_windows_log_level
: Windows authentication plugin logging level. Added in MySQL 8.0.11.:Windows身份验证插件日志记录级别。在MySQL 8.0.11中添加。
authentication_windows_use_principal_name
: Whether to use Windows authentication plugin principal name. Added in MySQL 8.0.11.:是否使用Windows身份验证插件主体名称。在MySQL 8.0.11中添加。
binlog_encryption
: Enable encryption for binary log files and relay log files on this server. Added in MySQL 8.0.14.:启用此服务器上二进制日志文件和中继日志文件的加密。在MySQL 8.0.14中添加。
binlog_expire_logs_seconds
: Purge binary logs after this many seconds. Added in MySQL 8.0.1.:在这几秒钟后清除二进制日志。在MySQL 8.0.1中添加。
binlog_rotate_encryption_master_key_at_startup
: Rotate binary log master key at server startup. Added in MySQL 8.0.14.:在服务器启动时旋转二进制日志主密钥。在MySQL 8.0.14中添加。
binlog_row_metadata
: Whether to record all or only minimal table related metadata to binary log when using row-based logging. Added in MySQL 8.0.1.:使用基于行的日志记录时,是将所有表相关元数据记录到二进制日志中,还是仅将最小的表相关元数据记录到二进制日志中。在MySQL 8.0.1中添加。
binlog_row_value_options
: Enables binary logging of partial JSON updates for row-based replication. Added in MySQL 8.0.3.:为基于行的复制启用部分JSON更新的二进制日志记录。在MySQL 8.0.3中添加。
binlog_transaction_compression
: Enable compression for transaction payloads in binary log files. Added in MySQL 8.0.20.:启用二进制日志文件中事务有效负载的压缩。在MySQL 8.0.20中添加。
binlog_transaction_compression_level_zstd
: Compression level for transaction payloads in binary log files. Added in MySQL 8.0.20.:二进制日志文件中事务有效负载的压缩级别。在MySQL 8.0.20中添加。
binlog_transaction_dependency_history_size
: Number of row hashes kept for looking up transaction that last updated some row. Added in MySQL 8.0.1.:为查找上次更新某行的事务而保留的行哈希数。在MySQL 8.0.1中添加。
binlog_transaction_dependency_tracking
: Source of dependency information (commit timestamps or transaction write sets) from which to assess which transactions can be executed in parallel by replica's multithreaded applier. Added in MySQL 8.0.1.:依赖项信息的来源(提交时间戳或事务写入集),从中评估复制副本的多线程应用程序可以并行执行哪些事务。在MySQL 8.0.1中添加。
caching_sha2_password_auto_generate_rsa_keys
: Whether to autogenerate RSA key-pair files. Added in MySQL 8.0.4.:是否自动生成RSA密钥对文件。在MySQL 8.0.4中添加。
caching_sha2_password_digest_rounds
: Number of hash rounds for caching_sha2_password authentication plugin. Added in MySQL 8.0.24.:缓存_sha2\u密码验证插件的哈希轮数。在MySQL 8.0.24中添加。
caching_sha2_password_private_key_path
: SHA2 authentication plugin private key path name. Added in MySQL 8.0.3.:SHA2身份验证插件私钥路径名。在MySQL 8.0.3中添加。
caching_sha2_password_public_key_path
: SHA2 authentication plugin public key path name. Added in MySQL 8.0.3.:SHA2身份验证插件公钥路径名。在MySQL 8.0.3中添加。
clone_autotune_concurrency
: Enables dynamic spawning of threads for remote cloning operations. Added in MySQL 8.0.17.:为远程克隆操作启用线程的动态繁殖。在MySQL 8.0.17中添加。
clone_buffer_size
: Defines size of intermediate buffer on donor MySQL server instance. Added in MySQL 8.0.17.:定义MySQL服务器实例上中间缓冲区的大小。在MySQL 8.0.17中添加。
clone_ddl_timeout
: Number of seconds cloning operation waits for backup lock. Added in MySQL 8.0.17.:克隆操作等待备份锁定的秒数。在MySQL 8.0.17中添加。
clone_donor_timeout_after_network_failure
: The time allowed to restart a cloning operation after a network failure. Added in MySQL 8.0.24.:网络故障后重新启动克隆操作所允许的时间。在MySQL 8.0.24中添加。
clone_enable_compression
: Enables compression of data at network layer during cloning. Added in MySQL 8.0.17.:在克隆期间启用网络层的数据压缩。在MySQL 8.0.17中添加。
clone_max_concurrency
: Maximum number of concurrent threads used to perform cloning operation. Added in MySQL 8.0.17.:用于执行克隆操作的最大并发线程数。在MySQL 8.0.17中添加。
clone_max_data_bandwidth
: Maximum data transfer rate in MiB per second for remote cloning operation. Added in MySQL 8.0.17.:远程克隆操作的最大数据传输速率(以MiB/秒为单位)。在MySQL 8.0.17中添加。
clone_max_network_bandwidth
: Maximum network transfer rate in MiB per second for remote cloning operation. Added in MySQL 8.0.17.:远程克隆操作的最大网络传输速率(以MiB/秒为单位)。在MySQL 8.0.17中添加。
clone_ssl_ca
: Specifies path to certificate authority (CA) file. Added in MySQL 8.0.14.:指定证书颁发机构(CA)文件的路径。在MySQL 8.0.14中添加。
clone_ssl_cert
: Specifies path to public key certificate file. Added in MySQL 8.0.14.:指定公钥证书文件的路径。在MySQL 8.0.14中添加。
clone_ssl_key
: Specifies path to private key file. Added in MySQL 8.0.14.:指定私钥文件的路径。在MySQL 8.0.14中添加。
clone_valid_donor_list
: Defines donor host addresses for remote cloning operations. Added in MySQL 8.0.17.:定义远程克隆操作的施主主机地址。在MySQL 8.0.17中添加。
connection_control_failed_connections_threshold
: Consecutive failed connection attempts before delays occur. Added in MySQL 8.0.1.:延迟发生前连续失败的连接尝试。在MySQL 8.0.1中添加。
connection_control_max_connection_delay
: Maximum delay (milliseconds) for server response to failed connection attempts. Added in MySQL 8.0.1.:服务器响应失败连接尝试的最大延迟(毫秒)。在MySQL 8.0.1中添加。
connection_control_min_connection_delay
: Minimum delay (milliseconds) for server response to failed connection attempts. Added in MySQL 8.0.1.:服务器响应失败连接尝试的最小延迟(毫秒)。在MySQL 8.0.1中添加。
create_admin_listener_thread
: Whether to use dedicated listening thread for connections on administrative interface. Added in MySQL 8.0.14.:是否对管理接口上的连接使用专用侦听线程。在MySQL 8.0.14中添加。
cte_max_recursion_depth
: Common table expression maximum recursion depth. Added in MySQL 8.0.3.:公共表表达式最大递归深度。在MySQL 8.0.3中添加。
ddl-rewriter
: Whether to activate ddl_rewriter plugin. Added in MySQL 8.0.16.:是否激活ddl_重写器插件。在MySQL 8.0.16中添加。
default_collation_for_utf8mb4
: Default collation for utf8mb4 character set. Added in MySQL 8.0.11.:utf8mb4字符集的默认排序规则。在MySQL 8.0.11中添加。
default_table_encryption
: Default schema and tablespace encryption setting. Added in MySQL 8.0.16.:默认架构和表空间加密设置。在MySQL 8.0.16中添加。
dragnet.Status
: Result of most recent assignment to dragnet.log_error_filter_rules. Added in MySQL 8.0.12.:最近分配到dragnet.log\u错误\u过滤器\u规则的结果。在MySQL 8.0.12中添加。
dragnet.log_error_filter_rules
: Filter rules for error logging. Added in MySQL 8.0.4.:错误日志记录的筛选规则。在MySQL 8.0.4中添加。
early-plugin-load
: Specify plugins to load before loading mandatory built-in plugins and before storage engine initialization. Added in MySQL 8.0.0.:在加载强制内置插件和存储引擎初始化之前,指定要加载的插件。在MySQL 8.0.0中添加。
generated_random_password_length
: Maximum length of generated passwords. Added in MySQL 8.0.18.:生成的密码的最大长度。在MySQL 8.0.18中添加。
group_replication_advertise_recovery_endpoints
: Connections offered for distributed recovery. Added in MySQL 8.0.21.:为分布式恢复提供连接。在MySQL 8.0.21中添加。
group_replication_autorejoin_tries
: Number of tries that member makes to rejoin group automatically. Added in MySQL 8.0.16.:成员尝试自动重新加入组的次数。在MySQL 8.0.16中添加。
group_replication_clone_threshold
: Transaction number gap between donor and recipient above which remote cloning operation is used for state transfer. Added in MySQL 8.0.17.:提供方和接收方之间的事务号差距,超过该差距时,将使用远程克隆操作进行状态传输。在MySQL 8.0.17中添加。
group_replication_communication_debug_options
: Level of debugging messages for Group Replication components. Added in MySQL 8.0.3.:组复制组件的调试消息级别。在MySQL 8.0.3中添加。
group_replication_communication_max_message_size
: Maximum message size for Group Replication communications, larger messages are fragmented. Added in MySQL 8.0.16.:组复制通信的最大消息大小,较大的消息被分段。在MySQL 8.0.16中添加。
group_replication_consistency
: Type of transaction consistency guarantee which group provides. Added in MySQL 8.0.14.:组提供的事务一致性保证的类型。在MySQL 8.0.14中添加。
group_replication_exit_state_action
: How instance behaves when it leaves group involuntarily. Added in MySQL 8.0.12.:实例非自愿离开组时的行为。在MySQL 8.0.12中添加。
group_replication_flow_control_hold_percent
: Percentage of group quota to remain unused. Added in MySQL 8.0.2.:保留未使用的组配额的百分比。在MySQL 8.0.2中添加。
group_replication_flow_control_max_commit_quota
: Maximum flow control quota for group. Added in MySQL 8.0.2.:组的最大流量控制配额。在MySQL 8.0.2中添加。
group_replication_flow_control_member_quota_percent
: Percentage of quota which member should assume is available for itself when calculating quotas. Added in MySQL 8.0.2.:计算配额时,成员应假定其自身可用的配额百分比。在MySQL 8.0.2中添加。
group_replication_flow_control_min_quota
: Lowest flow control quota which can be assigned per member. Added in MySQL 8.0.2.:可为每个成员分配的最低流量控制配额。在MySQL 8.0.2中添加。
group_replication_flow_control_min_recovery_quota
: Lowest quota which can be assigned per member because another group member is recovering. Added in MySQL 8.0.2.:由于另一个组成员正在恢复,因此可以为每个成员分配的最低配额。在MySQL 8.0.2中添加。
group_replication_flow_control_period
: Defines how many seconds to wait between flow control iterations. Added in MySQL 8.0.2.:定义流控制迭代之间等待的秒数。在MySQL 8.0.2中添加。
group_replication_flow_control_release_percent
: How group quota should be released when flow control no longer needs to throttle writer members. Added in MySQL 8.0.2.:当流控制不再需要限制写入程序成员时,应如何释放组配额。在MySQL 8.0.2中添加。
group_replication_ip_allowlist
: List of hosts permitted to connect to group (MySQL 8.0.22 and later). Added in MySQL 8.0.22.:允许连接到组的主机列表(MySQL 8.0.22及更高版本)。在MySQL 8.0.22中添加。
group_replication_member_expel_timeout
: Time between suspected failure of group member and expelling it from group, causing group membership reconfiguration. Added in MySQL 8.0.13.:从怀疑组成员出现故障到将其从组中驱逐,导致组成员身份重新配置之间的时间。在MySQL 8.0.13中添加。
group_replication_member_weight
: Chance of this member being elected as primary. Added in MySQL 8.0.2.:此成员当选为主要成员的机会。在MySQL 8.0.2中添加。
group_replication_message_cache_size
: Maximum memory for group communication engine message cache (XCom). Added in MySQL 8.0.16.:组通信引擎消息缓存(XCom)的最大内存。在MySQL 8.0.16中添加。
group_replication_recovery_compression_algorithms
: Permitted compression algorithms for outgoing recovery connections. Added in MySQL 8.0.18.:传出恢复连接允许的压缩算法。在MySQL 8.0.18中添加。
group_replication_recovery_get_public_key
: Whether to accept preference about fetching public key from donor. Added in MySQL 8.0.4.:是否接受有关从捐赠者获取公钥的首选项。在MySQL 8.0.4中添加。
group_replication_recovery_public_key_path
: To accept public key information. Added in MySQL 8.0.4.:接受公钥信息。在MySQL 8.0.4中添加。
group_replication_recovery_tls_ciphersuites
: Permitted cipher suites when TLSv1.3 is used for connection encryption with this instance as client (joining member). Added in MySQL 8.0.19.:当TLSv1.3用于将此实例作为客户端(加入成员)进行连接加密时,允许的密码套件。在MySQL 8.0.19中添加。
group_replication_recovery_tls_version
: Permitted TLS protocols for connection encryption as client (joining member). Added in MySQL 8.0.19.:作为客户端(加入成员)进行连接加密的允许TLS协议。在MySQL 8.0.19中添加。
group_replication_recovery_zstd_compression_level
: Compression level for recovery connections that use zstd compression. Added in MySQL 8.0.18.:使用zstd压缩的恢复连接的压缩级别。在MySQL 8.0.18中添加。
group_replication_tls_source
: Source of TLS material for Group Replication. Added in MySQL 8.0.21.:用于组复制的TLS材料的来源。在MySQL 8.0.21中添加。
group_replication_unreachable_majority_timeout
: How long to wait for network partitions that result in minority to leave group. Added in MySQL 8.0.2.:导致少数用户离开组的网络分区等待多长时间。在MySQL 8.0.2中添加。
group_replication_view_change_uuid
: UUID for view change event GTIDs. Added in MySQL 8.0.26.:视图更改事件GTID的UUID。在MySQL 8.0.26中添加。
histogram_generation_max_mem_size
: Maximum memory for creating histogram statistics. Added in MySQL 8.0.2.:用于创建直方图统计信息的最大内存。在MySQL 8.0.2中添加。
immediate_server_version
: MySQL Server release number of server which is immediate replication source. Added in MySQL 8.0.14.:MySQL服务器是即时复制源的服务器版本号。在MySQL 8.0.14中添加。
information_schema_stats_expiry
: Expiration setting for cached table statistics. Added in MySQL 8.0.3.:缓存表统计信息的过期设置。在MySQL 8.0.3中添加。
init_replica
: Statements that are executed when replica connects to source. Added in MySQL 8.0.26.:复制副本连接到源时执行的语句。在MySQL 8.0.26中添加。
innodb_buffer_pool_debug
: Permits multiple buffer pool instances when buffer pool is less than 1GB in size. Added in MySQL 8.0.0.:当缓冲池大小小于1GB时,允许多个缓冲池实例。在MySQL 8.0.0中添加。
innodb_buffer_pool_in_core_file
: Controls writing of buffer pool pages to core files. Added in MySQL 8.0.14.:控制将缓冲池页写入核心文件。在MySQL 8.0.14中添加。
innodb_checkpoint_disabled
: Disables checkpoints so that deliberate server exit always initiates recovery. Added in MySQL 8.0.2.:禁用检查点,以便故意退出服务器始终启动恢复。在MySQL 8.0.2中添加。
innodb_ddl_log_crash_reset_debug
: Debug option that resets DDL log crash injection counters. Added in MySQL 8.0.3.:重置DDL日志崩溃注入计数器的调试选项。在MySQL 8.0.3中添加。
innodb_deadlock_detect
: Enables or disables deadlock detection. Added in MySQL 8.0.0.:启用或禁用死锁检测。在MySQL 8.0.0中添加。
innodb_dedicated_server
: Enables automatic configuration of buffer pool size, log file size, and flush method. Added in MySQL 8.0.3.:启用缓冲池大小、日志文件大小和刷新方法的自动配置。在MySQL 8.0.3中添加。
innodb_directories
: Defines directories to scan at startup for tablespace data files. Added in MySQL 8.0.4.:定义启动时扫描表空间数据文件的目录。在MySQL 8.0.4中添加。
innodb_doublewrite_batch_size
: Number of doublewrite pages to write per batch. Added in MySQL 8.0.20.:每批要写入的双写页面数。在MySQL 8.0.20中添加。
innodb_doublewrite_dir
: Doublewrite buffer file directory. Added in MySQL 8.0.20.:Doublewrite缓冲区文件目录。在MySQL 8.0.20中添加。
innodb_doublewrite_files
: Number of doublewrite files. Added in MySQL 8.0.20.:双写文件数。在MySQL 8.0.20中添加。
innodb_doublewrite_pages
: Number of doublewrite pages per thread. Added in MySQL 8.0.20.:每个线程的双写页数。在MySQL 8.0.20中添加。
innodb_extend_and_initialize
: Controls how new tablespace pages are allocated on Linux. Added in MySQL 8.0.22.:控制如何在Linux上分配新表空间页。在MySQL 8.0.22中添加。
innodb_fsync_threshold
: Controls how often InnoDB calls fsync when creating new file. Added in MySQL 8.0.13.:控制创建新文件时InnoDB
调用fsync的频率。在MySQL 8.0.13中添加。
innodb_idle_flush_pct
: Limits I/0 operations when InnoDB is idle. Added in MySQL 8.0.18.:限制InnoDB
空闲时的I/0操作。在MySQL 8.0.18中添加。
innodb_log_checkpoint_fuzzy_now
: Debug option that forces InnoDB to write fuzzy checkpoint. Added in MySQL 8.0.13.:调试选项,强制InnoDB
写入模糊检查点。在MySQL 8.0.13中添加。
innodb_log_spin_cpu_abs_lwm
: Minimum amount of CPU usage below which user threads no longer spin while waiting for flushed redo. Added in MySQL 8.0.11.:在等待刷新重做时,用户线程不再旋转的最小CPU使用量。在MySQL 8.0.11中添加。
innodb_log_spin_cpu_pct_hwm
: Maximum amount of CPU usage above which user threads no longer spin while waiting for flushed redo. Added in MySQL 8.0.11.:在等待刷新重做时,用户线程不再旋转的最大CPU使用量。在MySQL 8.0.11中添加。
innodb_log_wait_for_flush_spin_hwm
: Maximum average log flush time beyond which user threads no longer spin while waiting for flushed redo. Added in MySQL 8.0.11.:等待刷新重做时用户线程不再旋转的最大平均日志刷新时间。在MySQL 8.0.11中添加。
innodb_log_writer_threads
: Enables dedicated log writer threads for writing and flushing redo logs. Added in MySQL 8.0.22.:启用用于写入和刷新重做日志的专用日志写入程序线程。在MySQL 8.0.22中添加。
innodb_parallel_read_threads
: Number of threads for parallel index reads. Added in MySQL 8.0.14.:并行索引读取的线程数。在MySQL 8.0.14中添加。
innodb_print_ddl_logs
: Whether or not to print DDL logs to error log. Added in MySQL 8.0.3.:是否将DDL日志打印到错误日志。在MySQL 8.0.3中添加。
innodb_redo_log_archive_dirs
: Labeled redo log archive directories. Added in MySQL 8.0.17.:标记为重做日志存档目录。在MySQL 8.0.17中添加。
innodb_redo_log_encrypt
: Controls encryption of redo log data for encrypted tablespaces. Added in MySQL 8.0.1.:控制加密表空间的重做日志数据的加密。在MySQL 8.0.1中添加。
innodb_scan_directories
: Defines directories to scan for tablespace files during InnoDB recovery. :定义在InnoDB
恢复期间扫描表空间文件的目录。Added in MySQL 8.0.2.在MySQL 8.0.2中添加。
innodb_segment_reserve_factor
: The percentage of tablespace file segment pages reserved as empty pages. Added in MySQL 8.0.26.:保留为空页的表空间文件段页的百分比。在MySQL 8.0.26中添加。
innodb_spin_wait_pause_multiplier
: Multiplier value used to determine number of PAUSE instructions in spin-wait loops. Added in MySQL 8.0.16.:用于确定旋转等待循环中暂停指令数的乘数值。在MySQL 8.0.16中添加。
innodb_stats_include_delete_marked
: Include delete-marked records when calculating persistent InnoDB statistics. Added in MySQL 8.0.1.:计算永久InnoDB
统计信息时包括删除标记的记录。在MySQL 8.0.1中添加。
innodb_temp_tablespaces_dir
: Session temporary tablespaces path. Added in MySQL 8.0.13.:会话临时表空间路径。在MySQL 8.0.13中添加。
innodb_tmpdir
: Directory location for temporary table files created during online ALTER TABLE operations. Added in MySQL 8.0.0.:联机ALTER table
操作期间创建的临时表文件的目录位置。在MySQL 8.0.0中添加。
innodb_undo_log_encrypt
: Controls encryption of undo log data for encrypted tablespaces. Added in MySQL 8.0.1.:控制加密表空间的撤消日志数据的加密。在MySQL 8.0.1中添加。
innodb_use_fdatasync
: Whether InnoDB uses fdatasync() instead of fsync() when flushing data to the operating system. Added in MySQL 8.0.26.:InnoDB
在将数据刷新到操作系统时是否使用fdatasync()
而不是fsync()
。在MySQL 8.0.26中添加。
innodb_validate_tablespace_paths
: Enables tablespace path validation at startup. Added in MySQL 8.0.21.:启用启动时的表空间路径验证。在MySQL 8.0.21中添加。
internal_tmp_mem_storage_engine
: Storage engine to use for internal in-memory temporary tables. Added in MySQL 8.0.2.:用于内存内临时表的存储引擎。在MySQL 8.0.2中添加。
keyring-migration-destination
: Key migration destination keyring plugin. Added in MySQL 8.0.4.:密钥迁移目标keyring插件。在MySQL 8.0.4中添加。
keyring-migration-host
: Host name for connecting to running server for key migration. Added in MySQL 8.0.4.:用于连接到正在运行的服务器以进行密钥迁移的主机名。在MySQL 8.0.4中添加。
keyring-migration-password
: Password for connecting to running server for key migration. Added in MySQL 8.0.4.:用于连接到正在运行的服务器以进行密钥迁移的密码。在MySQL 8.0.4中添加。
keyring-migration-port
: TCP/IP port number for connecting to running server for key migration. Added in MySQL 8.0.4.:用于连接到正在运行的服务器以进行密钥迁移的TCP/IP端口号。在MySQL 8.0.4中添加。
keyring-migration-socket
: Unix socket file or Windows named pipe for connecting to running server for key migration. Added in MySQL 8.0.4.:Unix套接字文件或Windows命名管道,用于连接到正在运行的服务器进行密钥迁移。在MySQL 8.0.4中添加。
keyring-migration-source
: Key migration source keyring plugin. Added in MySQL 8.0.4.:密钥迁移源keyring插件。在MySQL 8.0.4中添加。
keyring-migration-to-component
: Keyring migration is from plugin to component. Added in MySQL 8.0.24.:Keyring从插件迁移到组件。在MySQL 8.0.24中添加。
keyring-migration-user
: User name for connecting to running server for key migration. Added in MySQL 8.0.4.:用于连接到正在运行的服务器以进行密钥迁移的用户名。在MySQL 8.0.4中添加。
keyring_aws_cmk_id
: AWS keyring plugin customer master key ID value. Added in MySQL 8.0.11.:AWS密钥环插件客户主密钥ID值。在MySQL 8.0.11中添加。
keyring_aws_conf_file
: AWS keyring plugin configuration file location. Added in MySQL 8.0.11.:AWS keyring插件配置文件位置。在MySQL 8.0.11中添加。
keyring_aws_data_file
: AWS keyring plugin storage file location. Added in MySQL 8.0.11.:AWS keyring插件存储文件位置。在MySQL 8.0.11中添加。
keyring_aws_region
: AWS keyring plugin region. Added in MySQL 8.0.11.:AWS keyring插件区域。在MySQL 8.0.11中添加。
keyring_encrypted_file_data
: keyring_encrypted_file plugin data file. Added in MySQL 8.0.11.:keyring\u加密的\u文件插件数据文件。在MySQL 8.0.11中添加。
keyring_encrypted_file_password
: keyring_encrypted_file plugin password. Added in MySQL 8.0.11.:keyring\u加密的\u文件插件密码。在MySQL 8.0.11中添加。
keyring_hashicorp_auth_path
: HashiCorp Vault AppRole authentication path. Added in MySQL 8.0.18.:HashiCorp Vault许可验证路径。在MySQL 8.0.18中添加。
keyring_hashicorp_ca_path
: Path to keyring_hashicorp CA file. Added in MySQL 8.0.18.:keyring_hashicorp CA文件的路径。在MySQL 8.0.18中添加。
keyring_hashicorp_caching
: Whether to enable keyring_hashicorp caching. Added in MySQL 8.0.18.:是否启用keyring_hashicorp缓存。在MySQL 8.0.18中添加。
keyring_hashicorp_commit_auth_path
: keyring_hashicorp_auth_path value in use. Added in MySQL 8.0.18.:正在使用的keyring_hashicorp_auth_path值。在MySQL 8.0.18中添加。
keyring_hashicorp_commit_ca_path
: keyring_hashicorp_ca_path value in use. Added in MySQL 8.0.18.:正在使用的keyring_hashicorp_ca_path值。在MySQL 8.0.18中添加。
keyring_hashicorp_commit_caching
: keyring_hashicorp_caching value in use. Added in MySQL 8.0.18.:正在使用的keyring_hashicorp_caching值。在MySQL 8.0.18中添加。
keyring_hashicorp_commit_role_id
: keyring_hashicorp_role_id value in use. Added in MySQL 8.0.18.:正在使用的keyring_hashicorp_role_id值。在MySQL 8.0.18中添加。
keyring_hashicorp_commit_server_url
: keyring_hashicorp_server_url value in use. Added in MySQL 8.0.18.:正在使用的keyring_hashicorp_server_url值。在MySQL 8.0.18中添加。
keyring_hashicorp_commit_store_path
: keyring_hashicorp_store_path value in use. Added in MySQL 8.0.18.正在使用的keyring_hashicorp_store_path值。在MySQL 8.0.18中添加
keyring_hashicorp_role_id
: HashiCorp Vault AppRole authentication role ID. Added in MySQL 8.0.18.:HashiCorp Vault AppRole身份验证角色ID。在MySQL 8.0.18中添加。
keyring_hashicorp_secret_id
: HashiCorp Vault AppRole authentication secret ID. Added in MySQL 8.0.18.:HashiCorp Vault AppRole身份验证机密ID。在MySQL 8.0.18中添加。
keyring_hashicorp_server_url
: HashiCorp Vault server URL. Added in MySQL 8.0.18.:HashiCorp Vault服务器URL。在MySQL 8.0.18中添加。
keyring_hashicorp_store_path
: HashiCorp Vault store path. Added in MySQL 8.0.18.:HashiCorp Vault存储路径。在MySQL 8.0.18中添加。
keyring_oci_ca_certificate
: CA certificate file for peer authentication. Added in MySQL 8.0.22.:用于对等身份验证的CA证书文件。在MySQL 8.0.22中添加。
keyring_oci_compartment
: OCI compartment OCID. Added in MySQL 8.0.22.:OCI隔间OCID。在MySQL 8.0.22中添加。
keyring_oci_encryption_endpoint
: OCI encryption server endpoint. Added in MySQL 8.0.22.:OCI加密服务器终结点。在MySQL 8.0.22中添加。
keyring_oci_key_file
: OCI RSA private key file. Added in MySQL 8.0.22.:OCI RSA私钥文件。在MySQL 8.0.22中添加。
keyring_oci_key_fingerprint
: OCI RSA private key file fingerprint. Added in MySQL 8.0.22.:OCI RSA私钥文件指纹。在MySQL 8.0.22中添加。
keyring_oci_management_endpoint
: OCI management server endpoint. Added in MySQL 8.0.22.:OCI管理服务器终结点。在MySQL 8.0.22中添加。
keyring_oci_master_key
: OCI master key OCID. Added in MySQL 8.0.22.:OCI主密钥OCID。在MySQL 8.0.22中添加。
keyring_oci_secrets_endpoint
: OCI secrets server endpoint. Added in MySQL 8.0.22.:OCI机密服务器终结点。在MySQL 8.0.22中添加。
keyring_oci_tenancy
: OCI tenancy OCID. Added in MySQL 8.0.22.:OCI-OCID。在MySQL 8.0.22中添加。
keyring_oci_user
: OCI user OCID. Added in MySQL 8.0.22.:OCI用户OCID。在MySQL 8.0.22中添加。
keyring_oci_vaults_endpoint
: OCI vaults server endpoint. Added in MySQL 8.0.22.:OCI保险存储服务器终结点。在MySQL 8.0.22中添加。
keyring_oci_virtual_vault
: OCI vault OCID. Added in MySQL 8.0.22.:OCI保险库OCID。在MySQL 8.0.22中添加。
keyring_okv_conf_dir
: Oracle Key Vault keyring plugin configuration directory. Added in MySQL 8.0.11.:Oracle密钥库密钥环插件配置目录。在MySQL 8.0.11中添加。
keyring_operations
: Whether keyring operations are enabled. Added in MySQL 8.0.4.:是否启用钥匙扣操作。在MySQL 8.0.4中添加。
lock_order
: Whether to enable LOCK_ORDER tool at runtime. Added in MySQL 8.0.17.:是否在运行时启用锁定顺序工具。在MySQL 8.0.17中添加。
lock_order_debug_loop
: Whether to cause debug assert when LOCK_ORDER tool encounters dependency flagged as loop. Added in MySQL 8.0.17.:当锁定顺序工具遇到标记为循环的依赖项时,是否导致调试断言。在MySQL 8.0.17中添加。
lock_order_debug_missing_arc
: Whether to cause debug assert when LOCK_ORDER tool encounters undeclared dependency. Added in MySQL 8.0.17.:当锁顺序工具遇到未声明的依赖项时,是否导致调试断言。在MySQL 8.0.17中添加。
lock_order_debug_missing_key
: Whether to cause debug assert when LOCK_ORDER tool encounters object not properly instrumented with Performance Schema. Added in MySQL 8.0.17.:当锁定顺序工具遇到未使用性能架构正确检测的对象时,是否导致调试断言。在MySQL 8.0.17中添加。
lock_order_debug_missing_unlock
: Whether to cause debug assert when LOCK_ORDER tool encounters lock that is destroyed while still held. Added in MySQL 8.0.17.:当锁顺序工具遇到仍保持的锁被破坏时,是否导致调试断言。在MySQL 8.0.17中添加。
lock_order_dependencies
: Path to lock_order_dependencies.txt file. Added in MySQL 8.0.17.:锁定_order_dependencies.txt文件的路径。在MySQL 8.0.17中添加。
lock_order_extra_dependencies
: Path to second dependency file. Added in MySQL 8.0.17.:第二个依赖项文件的路径。在MySQL 8.0.17中添加。
lock_order_output_directory
: Directory where LOCK_ORDER tool writes logs. Added in MySQL 8.0.17.:锁定顺序工具写入日志的目录。在MySQL 8.0.17中添加。
lock_order_print_txt
: Whether to perform lock-order graph analysis and print textual report. Added in MySQL 8.0.17.:是否执行锁顺序图分析和打印文本报告。在MySQL 8.0.17中添加。
lock_order_trace_loop
: Whether to print log file trace when LOCK_ORDER tool encounters dependency flagged as loop. Added in MySQL 8.0.17.:当锁定顺序工具遇到标记为循环的依赖项时,是否打印日志文件跟踪。在MySQL 8.0.17中添加。
lock_order_trace_missing_arc
: Whether to print log file trace when LOCK_ORDER tool encounters undeclared dependency. Added in MySQL 8.0.17.:锁定顺序工具遇到未声明的依赖项时是否打印日志文件跟踪。在MySQL 8.0.17中添加。
lock_order_trace_missing_key
: Whether to print log file trace when LOCK_ORDER tool encounters object not properly instrumented with Performance Schema. Added in MySQL 8.0.17.:当锁定顺序工具遇到未使用性能架构正确检测的对象时,是否打印日志文件跟踪。在MySQL 8.0.17中添加。
lock_order_trace_missing_unlock
: Whether to print log file trace when LOCK_ORDER tool encounters lock that is destroyed while still held. Added in MySQL 8.0.17.:当锁定顺序工具遇到在仍保持时被破坏的锁时,是否打印日志文件跟踪。在MySQL 8.0.17中添加。
log_error_filter_rules
: Filter rules for error logging. Added in MySQL 8.0.2.:错误日志记录的筛选规则。在MySQL 8.0.2中添加。
log_error_services
: Components to use for error logging. Added in MySQL 8.0.2.:用于错误日志记录的组件。在MySQL 8.0.2中添加。
log_error_suppression_list
: Warning/information error log messages to suppress. Added in MySQL 8.0.13.:要抑制的警告/信息错误日志消息。在MySQL 8.0.13中添加。
log_slow_extra
: Whether to write extra information to slow query log file. Added in MySQL 8.0.14.:是否将额外信息写入慢速查询日志文件。在MySQL 8.0.14中添加。
log_slow_replica_statements
: Cause slow statements as executed by replica to be written to slow query log. Added in MySQL 8.0.26.:导致副本执行的慢速语句写入慢速查询日志。在MySQL 8.0.26中添加。
mandatory_roles
: Automatically granted roles for all users. Added in MySQL 8.0.2.:自动为所有用户授予角色。在MySQL 8.0.2中添加。
mysql_firewall_mode
: Whether MySQL Enterprise Firewall is operational. Added in MySQL 8.0.11.:MySQL企业防火墙是否运行。在MySQL 8.0.11中添加。
mysql_firewall_trace
: Whether to enable firewall trace. Added in MySQL 8.0.11.:是否启用防火墙跟踪。在MySQL 8.0.11中添加。
mysqlx
: Whether X Plugin is initialized. Added in MySQL 8.0.11.:X插件是否初始化。在MySQL 8.0.11中添加。
mysqlx_compression_algorithms
: Compression algorithms permitted for X Protocol connections. Added in MySQL 8.0.19.:X协议连接允许的压缩算法。在MySQL 8.0.19中添加。
mysqlx_deflate_default_compression_level
: Default compression level for Deflate algorithm on X Protocol connections. Added in MySQL 8.0.20.:X协议连接上Deflate算法的默认压缩级别。在MySQL 8.0.20中添加。
mysqlx_deflate_max_client_compression_level
: Maximum permitted compression level for Deflate algorithm on X Protocol connections. Added in MySQL 8.0.20.:X协议连接上Deflate算法允许的最大压缩级别。在MySQL 8.0.20中添加。
mysqlx_interactive_timeout
: Number of seconds to wait for interactive clients to timeout. Added in MySQL 8.0.4.:等待交互式客户端超时的秒数。在MySQL 8.0.4中添加。
mysqlx_lz4_default_compression_level
: Default compression level for LZ4 algorithm on X Protocol connections. Added in MySQL 8.0.20.:X协议连接上LZ4算法的默认压缩级别。在MySQL 8.0.20中添加。
mysqlx_lz4_max_client_compression_level
: Maximum permitted compression level for LZ4 algorithm on X Protocol connections. Added in MySQL 8.0.20.:X协议连接上LZ4算法允许的最大压缩级别。在MySQL 8.0.20中添加。
mysqlx_read_timeout
: Number of seconds to wait for blocking read operations to complete. Added in MySQL 8.0.4.:等待阻止读取操作完成的秒数。在MySQL 8.0.4中添加。
mysqlx_wait_timeout
: Number of seconds to wait for activity from connection. Added in MySQL 8.0.4.:等待来自连接的活动的秒数。在MySQL 8.0.4中添加。
mysqlx_write_timeout
: Number of seconds to wait for blocking write operations to complete. Added in MySQL 8.0.4.:等待阻止写入操作完成的秒数。在MySQL 8.0.4中添加。
mysqlx_zstd_default_compression_level
: Default compression level for zstd algorithm on X Protocol connections. Added in MySQL 8.0.20.:X协议连接上zstd算法的默认压缩级别。在MySQL 8.0.20中添加。
mysqlx_zstd_max_client_compression_level
: Maximum permitted compression level for zstd algorithm on X Protocol connections. Added in MySQL 8.0.20.:X协议连接上zstd算法允许的最大压缩级别。在MySQL 8.0.20中添加。
named_pipe_full_access_group
: Name of Windows group granted full access to named pipe. Added in MySQL 8.0.14.:已授予对命名管道的完全访问权限的Windows组的名称。在MySQL 8.0.14中添加。
no-dd-upgrade
: Prevent automatic upgrade of data dictionary tables at startup. Added in MySQL 8.0.4.:防止在启动时自动升级数据字典表。在MySQL 8.0.4中添加。
no-monitor
: Do not fork monitor process required for RESTART. Added in MySQL 8.0.12.:不要监视重新启动所需的进程。在MySQL 8.0.12中添加。
original_commit_timestamp
: Time when transaction was committed on original source. Added in MySQL 8.0.1.:在原始源上提交事务的时间。在MySQL 8.0.1中添加。
original_server_version
: MySQL Server release number of server on which transaction was originally committed. Added in MySQL 8.0.14.:MySQL服务器最初提交事务的服务器版本号。在MySQL 8.0.14中添加。
partial_revokes
: Whether partial revocation is enabled. Added in MySQL 8.0.16.:是否启用部分吊销。在MySQL 8.0.16中添加。
password_history
: Number of password changes required before password reuse. Added in MySQL 8.0.3.:重新使用密码前所需的密码更改次数。在MySQL 8.0.3中添加。
password_require_current
: Whether password changes require current password verification. Added in MySQL 8.0.13.:密码更改是否需要当前密码验证。在MySQL 8.0.13中添加。
password_reuse_interval
: Number of days elapsed required before password reuse. Added in MySQL 8.0.3.:重新使用密码前所需的天数。在MySQL 8.0.3中添加。
performance_schema_max_digest_sample_age
: Query resample age in seconds. Added in MySQL 8.0.3.:以秒为单位查询重采样年龄。在MySQL 8.0.3中添加。
performance_schema_show_processlist
: Select SHOW PROCESSLIST implementation. Added in MySQL 8.0.22.:选择ShowProcessList实现。在MySQL 8.0.22中添加。
persist_only_admin_x509_subject
: SSL certificate X.509 Subject that enables persisting persist-restricted system variables. Added in MySQL 8.0.14.:SSL证书X.509主题,用于启用持久化受限系统变量。在MySQL 8.0.14中添加。
persisted_globals_load
: Whether to load persisted configuration settings. Added in MySQL 8.0.0.:是否加载持久化配置设置。在MySQL 8.0.0中添加。
print_identified_with_as_hex
: For SHOW CREATE USER, print hash values containing unprintable characters in hex. Added in MySQL 8.0.17.:对于“显示创建用户”,以十六进制打印包含不可打印字符的哈希值。在MySQL 8.0.17中添加。
protocol_compression_algorithms
: Permitted compression algorithms for incoming connections. Added in MySQL 8.0.18.:传入连接允许的压缩算法。在MySQL 8.0.18中添加。
regexp_stack_limit
: Regular expression match stack size limit. Added in MySQL 8.0.4.:正则表达式匹配堆栈大小限制。在MySQL 8.0.4中添加。
regexp_time_limit
: Regular expression match timeout. Added in MySQL 8.0.4.:正则表达式匹配超时。在MySQL 8.0.4中添加。
replica_max_allowed_packet
: Maximum size, in bytes, of packet that can be sent from replication source server to replica; overrides max_allowed_packet. Added in MySQL 8.0.26.:可从复制源服务器发送到复制副本的数据包的最大大小(字节);覆盖允许的最大数据包。在MySQL 8.0.26中添加。
replication_optimize_for_static_plugin_config
: Shared locks for semisynchronous replication. Added in MySQL 8.0.23.:用于半同步复制的共享锁。在MySQL 8.0.23中添加。
replication_sender_observe_commit_only
: Limited callbacks for semisynchronous replication. Added in MySQL 8.0.23.:半同步复制的有限回调。在MySQL 8.0.23中添加。
require_row_format
: For internal server use. Added in MySQL 8.0.19.:供内部服务器使用。在MySQL 8.0.19中添加。
resultset_metadata
: Whether server returns result set metadata. Added in MySQL 8.0.3.:服务器是否返回结果集元数据。在MySQL 8.0.3中添加。
rpl_read_size
: Set minimum amount of data in bytes which is read from binary log files and relay log files. Added in MySQL 8.0.11.:设置从二进制日志文件和中继日志文件读取的最小数据量(字节)。在MySQL 8.0.11中添加。
rpl_stop_replica_timeout
: Number of seconds that STOP REPLICA waits before timing out. Added in MySQL 8.0.26.:超时前停止复制副本等待的秒数。在MySQL 8.0.26中添加。
secondary_engine_cost_threshold
: Optimizer cost threshold for query offload to a secondary engine.. Added in MySQL 8.0.16.:查询卸载到辅助引擎的优化器成本阈值。在MySQL 8.0.16中添加。
select_into_buffer_size
: Size of buffer used for OUTFILE or DUMPFILE export file; overrides read_buffer_size. Added in MySQL 8.0.22.:用于输出文件或转储文件导出文件的缓冲区大小;覆盖读取缓冲区大小。在MySQL 8.0.22中添加。
select_into_disk_sync
: Synchronize data with storage device after flushing buffer for OUTFILE or DUMPFILE export file; OFF disables synchronization and is default value. Added in MySQL 8.0.22.:刷新OUTFILE或DUMPFILE导出文件的缓冲区后,与存储设备同步数据;关闭将禁用同步,并为默认值。在MySQL 8.0.22中添加。
select_into_disk_sync_delay
: When select_into_sync_disk = ON, sets delay in milliseconds after each synchronization of OUTFILE or DUMPFILE export file buffer, no effect otherwise. Added in MySQL 8.0.22.:当select_into_sync_disk = ON时,设置每次同步OUTFILE或DUMPFILE导出文件缓冲区后的延迟(毫秒),否则无效。在MySQL 8.0.22中添加。
show_create_table_skip_secondary_engine
: Whether to exclude the SECONDARY ENGINE clause from SHOW CREATE TABLE output. Added in MySQL 8.0.18.:是否从显示创建表输出中排除辅助引擎子句。在MySQL 8.0.18中添加。
show_create_table_verbosity
: Whether to display ROW_FORMAT in SHOW CREATE TABLE even if it has default value. Added in MySQL 8.0.11.:即使有默认值,是否在“显示创建表”中显示行\格式。在MySQL 8.0.11中添加。
source_verify_checksum
: Cause source to examine checksums when reading from binary log. Added in MySQL 8.0.26.:使源在读取二进制日志时检查校验和。在MySQL 8.0.26中添加。
sql_require_primary_key
: Whether tables must have primary key. Added in MySQL 8.0.13.:表是否必须具有主键。在MySQL 8.0.13中添加。
ssl_fips_mode
: Whether to enable FIPS mode on server side. Added in MySQL 8.0.11.:是否在服务器端启用FIPS模式。在MySQL 8.0.11中添加。
sync_source_info
: Synchronize source information after every #th event. Added in MySQL 8.0.26.:在每个第#个事件后同步源信息。在MySQL 8.0.26中添加。
syseventlog.facility
: Facility for syslog messages. Added in MySQL 8.0.13.:系统日志消息的功能。在MySQL 8.0.13中添加。
syseventlog.include_pid
: Whether to include server PID in syslog messages. Added in MySQL 8.0.13.:是否在系统日志消息中包括服务器PID。在MySQL 8.0.13中添加。
syseventlog.tag
: Tag for server identifier in syslog messages. Added in MySQL 8.0.13.:syslog消息中服务器标识符的标记。在MySQL 8.0.13中添加。
table_encryption_privilege_check
: Enables TABLE_ENCRYPTION_ADMIN privilege check. Added in MySQL 8.0.16.:启用TABLE_ENCRYPTION_ADMIN权限检查。在MySQL 8.0.16中添加。
temptable_max_mmap
: The maximum amount of memory the TempTable storage engine can allocate from memory-mapped temporary files. Added in MySQL 8.0.23.:诱惑存储引擎可以从内存映射的临时文件分配的最大内存量。在MySQL 8.0.23中添加。
temptable_max_ram
: Defines maximum amount of memory that can occupied by TempTable storage engine before data is stored on disk. Added in MySQL 8.0.2.:定义数据存储在磁盘上之前,可诱惑存储引擎可占用的最大内存量。在MySQL 8.0.2中添加。
temptable_use_mmap
: Defines whether TempTable storage engine allocates memory-mapped files when the temptable_max_ram threshold is reached. Added in MySQL 8.0.16.:定义当达到可诱惑的_max_ram阈值时,可诱惑存储引擎是否分配内存映射文件。在MySQL 8.0.16中添加。
thread_pool_algorithm
: Thread pool algorithm. Added in MySQL 8.0.11.:线程池算法。在MySQL 8.0.11中添加。
thread_pool_high_priority_connection
: Whether current session is high priority. Added in MySQL 8.0.11.:当前会话是否具有高优先级。在MySQL 8.0.11中添加。
thread_pool_max_active_query_threads
: Maximum permissible number of active query threads per group. Added in MySQL 8.0.19.:每个组允许的最大活动查询线程数。在MySQL 8.0.19中添加。
thread_pool_max_unused_threads
: Maximum permissible number of unused threads. Added in MySQL 8.0.11.:未使用螺纹的最大允许数量。在MySQL 8.0.11中添加。
thread_pool_prio_kickup_timer
: How long before statement is moved to high-priority execution. Added in MySQL 8.0.11.:语句移动到高优先级执行之前的时间。在MySQL 8.0.11中添加。
thread_pool_size
: Number of thread groups in thread pool. Added in MySQL 8.0.11.:线程池中的线程组数。在MySQL 8.0.11中添加。
thread_pool_stall_limit
: How long before statement is defined as stalled. Added in MySQL 8.0.11.:语句定义为暂停之前的时间。在MySQL 8.0.11中添加。
tls_ciphersuites
: Permissible TLSv1.3 ciphersuites for encrypted connections. Added in MySQL 8.0.16.:用于加密连接的允许TLSv1.3密码套件。在MySQL 8.0.16中添加。
upgrade
: Control automatic upgrade at startup. Added in MySQL 8.0.16.:控制启动时的自动升级。在MySQL 8.0.16中添加。
use_secondary_engine
: Whether to execute queries using a secondary engine. Added in MySQL 8.0.13.:是否使用辅助引擎执行查询。在MySQL 8.0.13中添加。
validate-config
: Validate server configuration. Added in MySQL 8.0.16.:验证服务器配置。在MySQL 8.0.16中添加。
validate_password.check_user_name
: Whether to check passwords against user name. Added in MySQL 8.0.4.:是否根据用户名检查密码。在MySQL 8.0.4中添加。
validate_password.dictionary_file
: validate_password dictionary file. Added in MySQL 8.0.4.:验证密码字典文件。在MySQL 8.0.4中添加。
validate_password.dictionary_file_last_parsed
: When dictionary file was last parsed. Added in MySQL 8.0.4.:上次解析字典文件的时间。在MySQL 8.0.4中添加。
validate_password.dictionary_file_words_count
: Number of words in dictionary file. Added in MySQL 8.0.4.:字典文件中的字数。在MySQL 8.0.4中添加。
validate_password.length
: validate_password required password length. Added in MySQL 8.0.4.:验证密码所需的密码长度。在MySQL 8.0.4中添加。
validate_password.mixed_case_count
: validate_password required number of uppercase/lowercase characters. Added in MySQL 8.0.4.:验证密码所需的大小写字符数。在MySQL 8.0.4中添加。
validate_password.number_count
: validate_password required number of digit characters. Added in MySQL 8.0.4.:验证密码所需的数字字符数。在MySQL 8.0.4中添加。
validate_password.policy
: validate_password password policy. Added in MySQL 8.0.4.:验证密码策略。在MySQL 8.0.4中添加。
validate_password.special_char_count
: validate_password required number of special characters. Added in MySQL 8.0.4.:验证密码所需的特殊字符数。在MySQL 8.0.4中添加。
version_compile_zlib
: Version of compiled-in zlib library. Added in MySQL 8.0.11.:在zlib库中编译的版本。在MySQL 8.0.11中添加。
windowing_use_high_precision
: Whether to compute window functions to high precision. Added in MySQL 8.0.2.:是否高精度计算窗口函数。在MySQL 8.0.2中添加。
The following system variables, status variables, and options have been deprecated in MySQL 8.0.以下系统变量、状态变量和选项在MySQL 8.0中已被弃用。
Compression
: Whether client connection uses compression in client/server protocol. Deprecated in MySQL 8.0.18.:客户端连接是否在客户端/服务器协议中使用压缩。MySQL 8.0.18中已弃用。
admin-ssl
: Enable connection encryption. Deprecated in MySQL 8.0.26.:启用连接加密。MySQL 8.0.26中已弃用。
expire_logs_days
: Purge binary logs after this many days. Deprecated in MySQL 8.0.3.:在这许多天后清除二进制日志。MySQL 8.0.3中已弃用。
group_replication_ip_whitelist
: List of hosts permitted to connect to group. Deprecated in MySQL 8.0.22.:允许连接到组的主机列表。MySQL 8.0.22中已弃用。
have_openssl
: Whether mysqld supports SSL connections. Deprecated in MySQL 8.0.26.:mysqld是否支持SSL连接。MySQL 8.0.26中已弃用。
have_ssl
: Whether mysqld supports SSL connections. Deprecated in MySQL 8.0.26.:mysqld是否支持SSL连接。MySQL 8.0.26中已弃用。
init_slave
: Statements that are executed when replica connects to source. Deprecated in MySQL 8.0.26.:复制副本连接到源时执行的语句。MySQL 8.0.26中已弃用。
innodb_undo_tablespaces
: Number of tablespace files that rollback segments are divided between. Deprecated in MySQL 8.0.4.:分为回滚段的表空间文件数。MySQL 8.0.4中已弃用。
log_bin_use_v1_row_events
: Whether server is using version 1 binary log row events. Deprecated in MySQL 8.0.18.:服务器是否正在使用版本1二进制日志行事件。MySQL 8.0.18中已弃用。
log_slow_slave_statements
: Cause slow statements as executed by replica to be written to slow query log. Deprecated in MySQL 8.0.26.:导致副本执行的慢速语句写入慢速查询日志。MySQL 8.0.26中已弃用。
log_syslog
: Whether to write error log to syslog. Deprecated in MySQL 8.0.2.:是否将错误日志写入syslog。MySQL 8.0.2中已弃用。
master-info-file
: Location and name of file that remembers source and where I/O replication thread is in source's binary log. Deprecated in MySQL 8.0.18.:记住源以及I/O复制线程在源二进制日志中的位置的文件的位置和名称。MySQL 8.0.18中已弃用。
master_info_repository
: Whether to write connection metadata repository, containing source information and replication I/O thread location in source's binary log, to file or table. Deprecated in MySQL 8.0.23.:是否将包含源二进制日志中的源信息和复制I/O线程位置的连接元数据存储库写入文件或表。MySQL 8.0.23中已弃用。
master_verify_checksum
: Cause source to examine checksums when reading from binary log. Deprecated in MySQL 8.0.26.:使源在读取二进制日志时检查校验和。MySQL 8.0.26中已弃用。
max_length_for_sort_data
: Max number of bytes in sorted records. Deprecated in MySQL 8.0.20.:已排序记录中的最大字节数。MySQL 8.0.20中已弃用。
no-dd-upgrade
: Prevent automatic upgrade of data dictionary tables at startup. Deprecated in MySQL 8.0.16.:防止在启动时自动升级数据字典表。MySQL 8.0.16中已弃用。
relay_log_info_file
: File name for applier metadata repository in which replica records information about relay logs. Deprecated in MySQL 8.0.18.:applier元数据存储库的文件名,其中副本记录有关中继日志的信息。MySQL 8.0.18中已弃用。
relay_log_info_repository
: Whether to write location of replication SQL thread in relay logs to file or table. Deprecated in MySQL 8.0.23.:是否将中继日志中复制SQL线程的位置写入文件或表。MySQL 8.0.23中已弃用。
rpl_stop_slave_timeout
: Number of seconds that STOP REPLICA or STOP SLAVE waits before timing out. Deprecated in MySQL 8.0.26.:超时前停止复制副本或停止从机等待的秒数。MySQL 8.0.26中已弃用。
slave_compressed_protocol
: Use compression of source/replica protocol. Deprecated in MySQL 8.0.18.:使用源/副本协议的压缩。MySQL 8.0.18中已弃用。
slave_max_allowed_packet
: Maximum size, in bytes, of packet that can be sent from replication source server to replica; overrides max_allowed_packet. Deprecated in MySQL 8.0.26.:可从复制源服务器发送到复制副本的数据包的最大大小(字节);覆盖允许的最大数据包。MySQL 8.0.26中已弃用。
slave_rows_search_algorithms
: Determines search algorithms used for replica update batching. Any 2 or 3 from this list: INDEX_SEARCH, TABLE_SCAN, HASH_SCAN. Deprecated in MySQL 8.0.18.:确定用于副本更新批处理的搜索算法。此列表中的任意2或3:索引搜索、表扫描、哈希扫描。MySQL 8.0.18中已弃用。
ssl
: Enable connection encryption. Deprecated in MySQL 8.0.26.:启用连接加密。MySQL 8.0.26中已弃用。
symbolic-links
: Permit symbolic links for MyISAM tables. Deprecated in MySQL 8.0.2.:允许MyISAM
表的符号链接。MySQL 8.0.2中已弃用。
sync_master_info
: Synchronize source information after every #th event. Deprecated in MySQL 8.0.26.:在每个第#个事件后同步源信息。MySQL 8.0.26中已弃用。
temptable_use_mmap
: Defines whether TempTable storage engine allocates memory-mapped files when the temptable_max_ram threshold is reached. Deprecated in MySQL 8.0.26.:定义当达到可诱惑的_max_ram阈值时,可诱惑存储引擎是否分配内存映射文件。MySQL 8.0.26中已弃用。
transaction_write_set_extraction
: Defines algorithm used to hash writes extracted during transaction. Deprecated in MySQL 8.0.26.:定义用于哈希事务期间提取的写入的算法。MySQL 8.0.26中已弃用。
The following system variables, status variables, and options have been removed in MySQL 8.0.MySQL 8.0中删除了以下系统变量、状态变量和选项。
Com_alter_db_upgrade
: Count of ALTER DATABASE ... UPGRADE DATA DIRECTORY NAME statements. Removed in MySQL 8.0.0.:ALTER DATABASE ... UPGRADE DATA DIRECTORY NAME
的计数。在MySQL 8.0.0中删除。
Innodb_available_undo_logs
: Total number of InnoDB rollback segments; different from innodb_rollback_segments, which displays number of active rollback segments. Removed in MySQL 8.0.2.:InnoDB
回滚段的总数;与innodb_rollback_segments不同,innodb_rollback_段显示活动回滚段的数量。在MySQL 8.0.2中删除。
Qcache_free_blocks
: Number of free memory blocks in query cache. Removed in MySQL 8.0.3.:查询缓存中的可用内存块数。在MySQL 8.0.3中删除。
Qcache_free_memory
: Amount of free memory for query cache. Removed in MySQL 8.0.3.:查询缓存的可用内存量。在MySQL 8.0.3中删除。
Qcache_hits
: Number of query cache hits. Removed in MySQL 8.0.3.:查询缓存命中数。在MySQL 8.0.3中删除。
Qcache_inserts
: Number of query cache inserts. Removed in MySQL 8.0.3.:查询缓存插入数。在MySQL 8.0.3中删除。
Qcache_lowmem_prunes
: Number of queries which were deleted from query cache due to lack of free memory in cache. Removed in MySQL 8.0.3.:由于缓存中缺少可用内存而从查询缓存中删除的查询数。在MySQL 8.0.3中删除。
Qcache_not_cached
: Number of noncached queries (not cacheable, or not cached due to query_cache_type setting). Removed in MySQL 8.0.3.:未缓存的查询数(不可缓存,或由于query_cache_type设置而未缓存)。在MySQL 8.0.3中删除。
Qcache_queries_in_cache
: Number of queries registered in query cache. Removed in MySQL 8.0.3.:在查询缓存中注册的查询数。在MySQL 8.0.3中删除。
Qcache_total_blocks
: Total number of blocks in query cache. Removed in MySQL 8.0.3.:查询缓存中的块总数。在MySQL 8.0.3中删除。
Slave_heartbeat_period
: Replica's replication heartbeat interval, in seconds. Removed in MySQL 8.0.1.:复制副本的复制检测信号间隔,以秒为单位。在MySQL 8.0.1中删除。
Slave_last_heartbeat
: Shows when latest heartbeat signal was received, in TIMESTAMP format. Removed in MySQL 8.0.1.:以时间戳格式显示接收到最新心跳信号的时间。在MySQL 8.0.1中删除。
Slave_received_heartbeats
: Number of heartbeats received by replica since previous reset. Removed in MySQL 8.0.1.:自上次重置后复制副本接收的心跳数。在MySQL 8.0.1中删除。
Slave_retried_transactions
: Total number of times since startup that replication SQL thread has retried transactions. Removed in MySQL 8.0.1.:自启动以来,复制SQL线程重试事务的总次数。在MySQL 8.0.1中删除。
Slave_running
: State of this server as replica (replication I/O thread status). Removed in MySQL 8.0.1.:此服务器作为副本的状态(复制I/O线程状态)。在MySQL 8.0.1中删除。
bootstrap
: Used by mysql installation scripts. Removed in MySQL 8.0.0.:由mysql安装脚本使用。在MySQL 8.0.0中删除。
date_format
: DATE format (unused). Removed in MySQL 8.0.3.:日期格式(未使用)。在MySQL 8.0.3中删除。
datetime_format
: DATETIME/TIMESTAMP format (unused). Removed in MySQL 8.0.3.:日期时间/时间戳格式(未使用)。在MySQL 8.0.3中删除。
des-key-file
: Load keys for des_encrypt() and des_encrypt from given file. Removed in MySQL 8.0.3.:从给定文件加载des_encrypt()
和des_encrypt的密钥。在MySQL 8.0.3中删除。
group_replication_allow_local_disjoint_gtids_join
: Allow current server to join group even if it has transactions not present in group. Removed in MySQL 8.0.4.:允许当前服务器加入组,即使组中不存在事务。在MySQL 8.0.4中删除。
have_crypt
: Availability of crypt() system call. Removed in MySQL 8.0.3.:crypt()
系统调用的可用性。在MySQL 8.0.3中删除。
ignore-db-dir
: Treat directory as nondatabase directory. Removed in MySQL 8.0.0.:将目录视为非数据库目录。在MySQL 8.0.0中删除。
ignore_builtin_innodb
: Ignore built-in InnoDB. Removed in MySQL 8.0.3.:忽略内置的InnoDB
。在MySQL 8.0.3中删除。
ignore_db_dirs
: Directories treated as nondatabase directories. Removed in MySQL 8.0.0.:被视为非数据库目录的目录。在MySQL 8.0.0中删除。
innodb_checksums
: Enable InnoDB checksums validation. Removed in MySQL 8.0.0.:启用InnoDB
校验和验证。在MySQL 8.0.0中删除。
innodb_disable_resize_buffer_pool_debug
: Disables resizing of InnoDB buffer pool. Removed in MySQL 8.0.0.:禁用InnoDB
缓冲池的大小调整。在MySQL 8.0.0中删除。
innodb_file_format
: Format for new InnoDB tables. Removed in MySQL 8.0.0.:新InnoDB
表的格式。在MySQL 8.0.0中删除。
innodb_file_format_check
: Whether InnoDB performs file format compatibility checking. Removed in MySQL 8.0.0.:InnoDB
是否执行文件格式兼容性检查。在MySQL 8.0.0中删除。
innodb_file_format_max
: File format tag in shared tablespace. Removed in MySQL 8.0.0.:共享表空间中的文件格式标记。在MySQL 8.0.0中删除。
innodb_large_prefix
: Enables longer keys for column prefix indexes. Removed in MySQL 8.0.0.:为列前缀索引启用更长的键。在MySQL 8.0.0中删除。
innodb_locks_unsafe_for_binlog
: Force InnoDB not to use next-key locking. Instead use only row-level locking. Removed in MySQL 8.0.0.:强制InnoDB
不使用下一个键锁定。相反,只使用行级锁定。在MySQL 8.0.0中删除。
innodb_scan_directories
: Defines directories to scan for tablespace files during InnoDB recovery. Removed in MySQL 8.0.4.:定义在InnoDB
恢复期间扫描表空间文件的目录。在MySQL 8.0.4中删除。
innodb_stats_sample_pages
: Number of index pages to sample for index distribution statistics. Removed in MySQL 8.0.0.:用于索引分布统计的要采样的索引页数。在MySQL 8.0.0中删除。
innodb_support_xa
: Enable InnoDB support for XA two-phase commit. Removed in MySQL 8.0.0.:为XA两阶段提交启用InnoDB
支持。在MySQL 8.0.0中删除。
innodb_undo_logs
: Number of undo logs (rollback segments) used by InnoDB; alias for innodb_rollback_segments. Removed in MySQL 8.0.2.:InnoDB
使用的撤消日志(回滚段)数;innodb_回滚_段的别名。在MySQL 8.0.2中删除。
internal_tmp_disk_storage_engine
: Storage engine for internal temporary tables. Removed in MySQL 8.0.16.:内部临时表的存储引擎。在MySQL 8.0.16中删除。
log-warnings
: Write some noncritical warnings to log file. Removed in MySQL 8.0.3.:将一些非关键警告写入日志文件。在MySQL 8.0.3中删除。
log_builtin_as_identified_by_password
: Whether to log CREATE/ALTER USER, GRANT in backward-compatible fashion. Removed in MySQL 8.0.11.:是否记录创建/更改用户,以向后兼容的方式授予。在MySQL 8.0.11中删除。
log_error_filter_rules
: Filter rules for error logging. Removed in MySQL 8.0.4.:错误日志记录的筛选规则。在MySQL 8.0.4中删除。
log_syslog
: Whether to write error log to syslog. Removed in MySQL 8.0.13.:是否将错误日志写入syslog。在MySQL 8.0.13中删除。
log_syslog_facility
: Facility for syslog messages. Removed in MySQL 8.0.13.:系统日志消息的功能。在MySQL 8.0.13中删除。
log_syslog_include_pid
: Whether to include server PID in syslog messages. Removed in MySQL 8.0.13.:是否在系统日志消息中包括服务器PID。在MySQL 8.0.13中删除。
log_syslog_tag
: Tag for server identifier in syslog messages. Removed in MySQL 8.0.13.:syslog消息中服务器标识符的标记。在MySQL 8.0.13中删除。
max_tmp_tables
: Unused. Removed in MySQL 8.0.3.
metadata_locks_cache_size
: Size of metadata locks cache. Removed in MySQL 8.0.13.:元数据锁缓存的大小。在MySQL 8.0.13中删除。
metadata_locks_hash_instances
: Number of metadata lock hashes. Removed in MySQL 8.0.13.:元数据锁哈希数。在MySQL 8.0.13中删除。
multi_range_count
: Maximum number of ranges to send to table handler at once during range selects. Removed in MySQL 8.0.3.:范围选择期间一次发送到表处理程序的最大范围数。在MySQL 8.0.3中删除。
old_passwords
: Selects password hashing method for PASSWORD(). Removed in MySQL 8.0.11.:为password()
选择密码哈希方法。在MySQL 8.0.11中删除。
partition
: Enable (or disable) partitioning support. Removed in MySQL 8.0.0.:启用(或禁用)分区支持。在MySQL 8.0.0中删除。
query_cache_limit
: Do not cache results that are bigger than this. Removed in MySQL 8.0.3.:不要缓存大于此值的结果。在MySQL 8.0.3中删除。
query_cache_min_res_unit
: Minimal size of unit in which space for results is allocated (last unit is trimmed after writing all result data). Removed in MySQL 8.0.3.:分配结果空间的最小单元大小(写入所有结果数据后,最后一个单元将被修剪)。在MySQL 8.0.3中删除。
query_cache_size
: Memory allocated to store results from old queries. Removed in MySQL 8.0.3.:分配用于存储旧查询结果的内存。在MySQL 8.0.3中删除。
query_cache_type
: Query cache type. Removed in MySQL 8.0.3.:查询缓存类型。在MySQL 8.0.3中删除。
query_cache_wlock_invalidate
: Invalidate queries in query cache on LOCK for write. Removed in MySQL 8.0.3.:在写锁定时使查询缓存中的查询无效。在MySQL 8.0.3中删除。
secure_auth
: Disallow authentication for accounts that have old (pre-4.1) passwords. Removed in MySQL 8.0.3.:不允许对具有旧(4.1之前)密码的帐户进行身份验证。在MySQL 8.0.3中删除。
show_compatibility_56
: Compatibility for SHOW STATUS/VARIABLES. Removed in MySQL 8.0.1.:显示状态/变量的兼容性。在MySQL 8.0.1中删除。
skip-partition
: Do not enable user-defined partitioning. Removed in MySQL 8.0.0.:不启用用户定义的分区。在MySQL 8.0.0中删除。
sync_frm
: Sync .frm to disk on create. Enabled by default. Removed in MySQL 8.0.0.:创建时将.frm同步到磁盘。默认情况下启用。在MySQL 8.0.0中删除。
temp-pool
: Using this option causes most temporary files created to use small set of names, rather than unique name for each new file. Removed in MySQL 8.0.1.:使用此选项会导致创建的大多数临时文件使用一小组名称,而不是每个新文件的唯一名称。在MySQL 8.0.1中删除。
time_format
: TIME format (unused). Removed in MySQL 8.0.3.:时间格式(未使用)。在MySQL 8.0.3中删除。
tx_isolation
: Default transaction isolation level. Removed in MySQL 8.0.3.:默认事务隔离级别。在MySQL 8.0.3中删除。
tx_read_only
: Default transaction access mode. Removed in MySQL 8.0.3.:默认事务访问模式。在MySQL 8.0.3中删除。