8.4 中文镜像

MySQL 8.4 参考手册 · 中文镜像

正文为中文,英文原文默认隐藏。点击任意中文段落即可展开 / 收起对应英文原文。

打开官方英文原文 ↗

译文由机器翻译生成,仅供理解参考;有疑问请以官方英文原文为准。

MySQL 8.4 参考手册 / 1 一般信息 / 1.5 自 8.0 以来 MySQL 8.4 中添加、弃用或删除的服务器和状态变量及选项
中文点击中文段落可显示 / 隐藏英文原文本页译文覆盖 100%

1.5 服务器和状态自 8.0 起,MySQL 8.4 中添加、弃用或删除的变量和选项1.5 Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.4 since 8.0

本节列出了 MySQL 8.4 自 8.0 以来首次添加、已弃用或删除的服务器变量、状态变量和选项。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.4 since 8.0.

MySQL 8.4 中引入的选项和变量Options and Variables Introduced in MySQL 8.4

MySQL 中添加了以下系统变量、状态变量和服务器选项 8.4.The following system variables, status variables, and server options have been added in MySQL 8.4.

在 MySQL 8.4 中弃用的选项和变量Options and Variables Deprecated in MySQL 8.4

以下系统变量、状态变量和选项在 MySQL 8.4 中已弃用。The following system variables, status variables, and options have been deprecated in MySQL 8.4.

  • Com_show_master_status:SHOW MASTER STATUS 语句的计数。在 MySQL 8.2.0 中已弃用。Com_show_master_status: Count of SHOW MASTER STATUS statements. Deprecated in MySQL 8.2.0.

  • authentication_fido_rp_id:FIDO 多重身份验证的依赖方 ID。在 MySQL 8.2.0 中已弃用。authentication_fido_rp_id: Relying party ID for FIDO multifactor authentication. Deprecated in MySQL 8.2.0.

  • binlog_transaction_dependency_tracking:依赖信息源(提交时间戳或事务写入集),用于评估副本的多线程应用程序可以并行执行哪些事务。在 MySQL 8.2.0 中已弃用。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. Deprecated in MySQL 8.2.0.

  • character-set-client-handshake:不忽略客户端字符设置握手期间发送的值。在 MySQL 8.2.0 中已弃用。character-set-client-handshake: Do not ignore client side character set value sent during handshake. Deprecated in MySQL 8.2.0.

  • group_replication_allow_local_lower_version_join:允许当前服务器加入组,即使它的插件版本低于组。在 MySQL 8.4.0 中已弃用。group_replication_allow_local_lower_version_join: Allow current server to join group even if it has lower plugin version than group. Deprecated in MySQL 8.4.0.

  • group_replication_view_change_uuid:视图更改事件 GTID 的 UUID。在 MySQL 8.3.0 中已弃用。group_replication_view_change_uuid: UUID for view change event GTIDs. Deprecated in MySQL 8.3.0.

  • mysql-native-password:启用 mysql_native_password 身份验证插件。在 MySQL 8.4.0 中已弃用。mysql-native-password: Enable mysql_native_password authentication plugin. Deprecated in MySQL 8.4.0.

  • new:使用非常新的、可能“不安全”的函数。在 MySQL 8.2.0 中已弃用。new: Use very new, possibly 'unsafe' functions. Deprecated in MySQL 8.2.0.

  • old:导致服务器恢复到旧版本中存在的某些行为。在 MySQL 8.2.0 中已弃用。old: Cause server to revert to certain behaviors present in older versions. Deprecated in MySQL 8.2.0.

  • performance_schema_show_processlist:选择 SHOW PROCESSLIST 实现。在 MySQL 8.2.0 中已弃用。performance_schema_show_processlist: Select SHOW PROCESSLIST implementation. Deprecated in MySQL 8.2.0.

  • restrict_fk_on_non_standard_key:禁止在非唯一键或部分键上创建外键。在 MySQL 8.4.0 中已弃用。restrict_fk_on_non_standard_key: Disallow creation of foreign keys on non-unique or partial keys. Deprecated in MySQL 8.4.0.

  • skip-character-set-client-handshake:忽略握手期间发送的客户端字符集值。在 MySQL 8.2.0 中已弃用。skip-character-set-client-handshake: Ignore client side character set value sent during handshake. Deprecated in MySQL 8.2.0.

  • skip-new:不要使用新的、可能错误的例程。在 MySQL 8.2.0 中已弃用。skip-new: Do not use new, possibly wrong routines. Deprecated in MySQL 8.2.0.

在 MySQL 8.4 中删除的选项和变量Options and Variables Removed in MySQL 8.4

以下系统变量、状态变量和选项已在 MySQL 8.4 中删除。The following system variables, status variables, and options have been removed in MySQL 8.4.

  • Com_change_master:CHANGE REPLICATION SOURCE TO 和 CHANGE MASTER TO 的计数声明。在 MySQL 8.4.0 中删除。Com_change_master: Count of CHANGE REPLICATION SOURCE TO and CHANGE MASTER TO statements. Removed in MySQL 8.4.0.

  • Com_show_master_status:SHOW MASTER STATUS 语句的计数。 MySQL 8.4.0 中已删除。Com_show_master_status: Count of SHOW MASTER STATUS statements. Removed in MySQL 8.4.0.

  • Com_show_slave_hosts:SHOW REPLICAS 和 SHOW SLAVE HOSTS 语句的计数。 MySQL 8.4.0 中已删除。Com_show_slave_hosts: Count of SHOW REPLICAS and SHOW SLAVE HOSTS statements. Removed in MySQL 8.4.0.

  • Com_show_slave_status:SHOW REPLICA STATUS 和 SHOW SLAVE STATUS 语句的计数。在 MySQL 8.4.0 中删除。Com_show_slave_status: Count of SHOW REPLICA STATUS and SHOW SLAVE STATUS statements. Removed in MySQL 8.4.0.

  • Com_slave_start:START REPLICA 和 START SLAVE 语句的计数。在 MySQL 8.4.0 中删除。Com_slave_start: Count of START REPLICA and START SLAVE statements. Removed in MySQL 8.4.0.

  • Com_slave_stop:STOP REPLICA 和 STOP SLAVE 语句的计数。在 MySQL 8.4.0 中已删除。Com_slave_stop: Count of STOP REPLICA and STOP SLAVE statements. Removed in MySQL 8.4.0.

  • Replica_rows_last_search_algorithm_used:此副本最近使用的搜索算法,用于定位基于行的复制(索引、表或哈希扫描)的行。在 MySQL 8.3.0 中删除。Replica_rows_last_search_algorithm_used: Search algorithm most recently used by this replica to locate rows for row-based replication (index, table, or hash scan). Removed in MySQL 8.3.0.

  • abort-slave-event-count:mysql-test 用于调试和测试复制的选项。在 MySQL 8.2.0 中删除。abort-slave-event-count: Option used by mysql-test for debugging and testing of replication. Removed in MySQL 8.2.0.

  • admin-ssl:启用连接加密。在 MySQL 8.4.0 中已删除。admin-ssl: Enable connection encryption. Removed in MySQL 8.4.0.

  • authentication_fido_rp_id:FIDO 多重身份验证的依赖方 ID。在 MySQL 8.4.0 中已删除。authentication_fido_rp_id: Relying party ID for FIDO multifactor authentication. Removed in MySQL 8.4.0.

  • avoid_temporal_upgrade:ALTER TABLE 是否应升级 5.6.4 之前的时间列。在 MySQL 8.4.0 中已删除。avoid_temporal_upgrade: Whether ALTER TABLE should upgrade pre-5.6.4 temporal columns. Removed in MySQL 8.4.0.

  • binlog_transaction_dependency_tracking:依赖信息源(提交时间戳或事务写入集),用于评估副本的多线程应用程序可以并行执行哪些事务。 MySQL 8.4.0 中已删除。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. Removed in MySQL 8.4.0.

  • character-set-client-handshake:不要忽略握手期间发送的客户端字符集值。在 MySQL 8.3.0 中已删除。character-set-client-handshake: Do not ignore client side character set value sent during handshake. Removed in MySQL 8.3.0.

  • daemon_memcached_enable_binlog:。在 MySQL 8.3.0 中删除。daemon_memcached_enable_binlog: . Removed in MySQL 8.3.0.

  • daemon_memcached_engine_lib_name:实现 InnoDB memcached 插件的共享库。在 MySQL 8.3.0 中删除。daemon_memcached_engine_lib_name: Shared library implementing InnoDB memcached plugin. Removed in MySQL 8.3.0.

  • daemon_memcached_engine_lib_path:包含实现 InnoDB memcached 插件的共享库的目录。在 MySQL 8.3.0 中已删除。daemon_memcached_engine_lib_path: Directory which contains shared library implementing InnoDB memcached plugin. Removed in MySQL 8.3.0.

  • daemon_memcached_option:以空格分隔的选项,在启动时传递给底层 memcached 守护进程。 MySQL 8.3.0 中已删除。daemon_memcached_option: Space-separated options which are passed to underlying memcached daemon on startup. Removed in MySQL 8.3.0.

  • daemon_memcached_r_batch_size:指定在执行 COMMIT 启动新事务之前要执行多少个 memcached 读取操作。在 MySQL 8.3.0 中已删除。daemon_memcached_r_batch_size: Specifies how many memcached read operations to perform before doing COMMIT to start new transaction. Removed in MySQL 8.3.0.

  • daemon_memcached_w_batch_size:指定在执行 COMMIT 启动新事务之前要执行多少个 memcached 写入操作。 MySQL 8.3.0 中已删除。daemon_memcached_w_batch_size: Specifies how many memcached write operations to perform before doing COMMIT to start new transaction. Removed in MySQL 8.3.0.

  • default_authentication_plugin:默认身份验证插件。在 MySQL 8.4.0 中删除。default_authentication_plugin: Default authentication plugin. Removed in MySQL 8.4.0.

  • disconnect-slave-event-count:mysql-test 用于调试和测试复制的选项。在 MySQL 8.2.0 中已删除。disconnect-slave-event-count: Option used by mysql-test for debugging and testing of replication. Removed in MySQL 8.2.0.

  • expire_logs_days:在这么多天后清除二进制日志。 MySQL 8.2.0 中已删除。expire_logs_days: Purge binary logs after this many days. Removed in MySQL 8.2.0.

  • group_replication_ip_whitelist:允许连接到组的主机列表。 MySQL 8.3.0 中已删除。group_replication_ip_whitelist: List of hosts permitted to connect to group. Removed in MySQL 8.3.0.

  • group_replication_primary_member:组在单主模式下运行时的主成员 UUID。如果组在多主模式下运行,则为空字符串。 MySQL 8.3.0 中已删除。group_replication_primary_member: Primary member UUID when group operates in single-primary mode. Empty string if group is operating in multi-primary mode. Removed in MySQL 8.3.0.

  • group_replication_recovery_complete_at:状态转移后处理缓存事务时的恢复策略。 MySQL 8.4.0 中删除。group_replication_recovery_complete_at: Recovery policies when handling cached transactions after state transfer. Removed in MySQL 8.4.0.

  • have_openssl:mysqld 是否支持 SSL 连接。 MySQL 8.4.0 中删除。have_openssl: Whether mysqld supports SSL connections. Removed in MySQL 8.4.0.

  • have_ssl:mysqld 是否支持 SSL 连接。 MySQL 8.4.0 中已删除。have_ssl: Whether mysqld supports SSL connections. Removed in MySQL 8.4.0.

  • innodb:启用 InnoDB(如果该版本的 MySQL 支持)。在 MySQL 8.3.0 中删除。innodb: Enable InnoDB (if this version of MySQL supports it). Removed in MySQL 8.3.0.

  • innodb_api_bk_commit_interval:自动提交使用 InnoDB memcached 接口的空闲连接的频率,以秒为单位。在 MySQL 8.3.0 中已删除。innodb_api_bk_commit_interval: How often to auto-commit idle connections which use InnoDB memcached interface, in seconds. Removed in MySQL 8.3.0.

  • innodb_api_disable_rowlock:。在 MySQL 8.3.0 中删除。innodb_api_disable_rowlock: . Removed in MySQL 8.3.0.

  • innodb_api_enable_binlog:允许将 InnoDB memcached 插件与 MySQL 二进制日志一起使用。在 MySQL 8.3.0 中删除。innodb_api_enable_binlog: Allows use of InnoDB memcached plugin with MySQL binary log. Removed in MySQL 8.3.0.

  • innodb_api_enable_mdl:锁定 InnoDB memcached 插件使用的表,以便不能通过 SQL 接口通过 DDL 删除或更改它。在 MySQL 8.3.0 中删除。innodb_api_enable_mdl: Locks table used by InnoDB memcached plugin, so that it cannot be dropped or altered by DDL through SQL interface. Removed in MySQL 8.3.0.

  • innodb_api_trx_level:允许控制 memcached 接口处理的查询的事务隔离级别。 MySQL 8.3.0 中已删除。innodb_api_trx_level: Allows control of transaction isolation level on queries processed by memcached interface. Removed in MySQL 8.3.0.

  • keyring_encrypted_file_data:keyring_encrypted_file 插件数据文件。 MySQL 8.4.0 中已删除。keyring_encrypted_file_data: keyring_encrypted_file plugin data file. Removed in MySQL 8.4.0.

  • keyring_encrypted_file_password:keyring_encrypted_file 插件密码。 MySQL 8.4.0 中已删除。keyring_encrypted_file_password: keyring_encrypted_file plugin password. Removed in MySQL 8.4.0.

  • keyring_file_data:keyring_file 插件数据文件。在 MySQL 8.4.0 中已删除。keyring_file_data: keyring_file plugin data file. Removed in MySQL 8.4.0.

  • keyring_oci_ca_certificate:用于对等身份验证的 CA 证书文件。 MySQL 8.4.0 中已删除。keyring_oci_ca_certificate: CA certificate file for peer authentication. Removed in MySQL 8.4.0.

  • keyring_oci_compartment:OCI 分区 OCID。在 MySQL 8.4.0 中已删除。keyring_oci_compartment: OCI compartment OCID. Removed in MySQL 8.4.0.

  • keyring_oci_encryption_endpoint:OCI 加密服务器端点。 MySQL 8.4.0 中已删除。keyring_oci_encryption_endpoint: OCI encryption server endpoint. Removed in MySQL 8.4.0.

  • keyring_oci_key_file:OCI RSA 私钥文件。 MySQL 8.4.0 中已删除。keyring_oci_key_file: OCI RSA private key file. Removed in MySQL 8.4.0.

  • keyring_oci_key_fingerprint:OCI RSA 私钥文件指纹。在 MySQL 8.4.0 中已删除。keyring_oci_key_fingerprint: OCI RSA private key file fingerprint. Removed in MySQL 8.4.0.

  • keyring_oci_management_endpoint:OCI 管理服务器端点。 MySQL 8.4.0 中已删除。keyring_oci_management_endpoint: OCI management server endpoint. Removed in MySQL 8.4.0.

  • keyring_oci_master_key:OCI 主密钥 OCID。在 MySQL 8.4.0 中已删除。keyring_oci_master_key: OCI master key OCID. Removed in MySQL 8.4.0.

  • keyring_oci_secrets_endpoint:OCI 机密服务器端点。 MySQL 8.4.0 中已删除。keyring_oci_secrets_endpoint: OCI secrets server endpoint. Removed in MySQL 8.4.0.

  • keyring_oci_tenancy:OCI 租户 OCID。 MySQL 8.4.0 中已删除。keyring_oci_tenancy: OCI tenancy OCID. Removed in MySQL 8.4.0.

  • keyring_oci_user:OCI 用户 OCID。在 MySQL 8.4.0 中已删除。keyring_oci_user: OCI user OCID. Removed in MySQL 8.4.0.

  • keyring_oci_vaults_endpoint:OCI 保管库服务器端点。在 MySQL 8.4.0 中已删除。keyring_oci_vaults_endpoint: OCI vaults server endpoint. Removed in MySQL 8.4.0.

  • keyring_oci_virtual_vault:OCI 保管库 OCID。在 MySQL 8.4.0 中删除。keyring_oci_virtual_vault: OCI vault OCID. Removed in MySQL 8.4.0.

  • language:给定语言的客户端错误消息。可以作为完整路径给出。在 MySQL 8.4.0 中删除。language: Client error messages in given language. May be given as full path. Removed in MySQL 8.4.0.

  • log_bin_use_v1_row_events:服务器是否正在使用版本 1 二进制日志行事件。在 MySQL 8.3.0 中已删除。log_bin_use_v1_row_events: Whether server is using version 1 binary log row events. Removed in MySQL 8.3.0.

  • master-info-file:记住源以及 I/O 复制线程在源二进制日志中的位置的文件的位置和名称。 MySQL 8.3.0 中已删除。master-info-file: Location and name of file that remembers source and where I/O replication thread is in source's binary log. Removed in MySQL 8.3.0.

  • master_info_repository:是否将连接元数据存储库(包含源二进制日志中的源信息和复制 I/O 线程位置)写入文件或表。在 MySQL 8.3.0 中删除。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. Removed in MySQL 8.3.0.

  • new:使用非常新的、可能“不安全”的函数。 MySQL 8.4.0 中已删除。new: Use very new, possibly 'unsafe' functions. Removed in MySQL 8.4.0.

  • no-dd-upgrade:防止启动时自动升级数据字典表。在 MySQL 8.4.0 中已删除。no-dd-upgrade: Prevent automatic upgrade of data dictionary tables at startup. Removed in MySQL 8.4.0.

  • old:导致服务器恢复到旧版本中存在的某些行为。在 MySQL 8.4.0 中删除。old: Cause server to revert to certain behaviors present in older versions. Removed in MySQL 8.4.0.

  • old-style-user-limits:启用旧式用户限制(在 5.0.3 之前,用户资源按每个用户+主机与每个帐户进行计数)。在 MySQL 8.3.0 中删除。old-style-user-limits: Enable old-style user limits (before 5.0.3, user resources were counted per each user+host vs. per account). Removed in MySQL 8.3.0.

  • relay_log_info_file:应用程序元数据存储库的文件名,副本在其中记录有关中继日志的信息。 MySQL 8.3.0 中删除。relay_log_info_file: File name for applier metadata repository in which replica records information about relay logs. Removed in MySQL 8.3.0.

  • relay_log_info_repository:是否将中继日志中复制 SQL 线程的位置写入文件或表。在 MySQL 8.3.0 中删除。relay_log_info_repository: Whether to write location of replication SQL thread in relay logs to file or table. Removed in MySQL 8.3.0.

  • show_old_temporals:SHOW CREATE TABLE 是否应指示 5.6.4 之前的时间列。 MySQL 8.4.0 中已删除。show_old_temporals: Whether SHOW CREATE TABLE should indicate pre-5.6.4 temporal columns. Removed in MySQL 8.4.0.

  • skip-character-set-client-handshake:忽略握手期间发送的客户端字符集值。 MySQL 8.3.0 中已删除。skip-character-set-client-handshake: Ignore client side character set value sent during handshake. Removed in MySQL 8.3.0.

  • skip-host-cache:不缓存主机名。 MySQL 8.3.0 中已删除。skip-host-cache: Do not cache host names. Removed in MySQL 8.3.0.

  • skip-ssl:禁用连接加密。在 MySQL 8.4.0 中已删除。skip-ssl: Disable connection encryption. Removed in MySQL 8.4.0.

  • slave_rows_search_algorithms:确定用于副本更新批处理的搜索算法。此列表中的任意 2 或 3 个:INDEX_SEARCH、TABLE_SCAN、HASH_SCAN。 MySQL 8.3.0 中已删除。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. Removed in MySQL 8.3.0.

  • ssl:启用连接加密。在 MySQL 8.4.0 中已删除。ssl: Enable connection encryption. Removed in MySQL 8.4.0.

  • transaction_write_set_extraction:定义用于对事务期间提取的写入进行哈希处理的算法。在 MySQL 8.3.0 中已删除。transaction_write_set_extraction: Defines algorithm used to hash writes extracted during transaction. Removed in MySQL 8.3.0.