本节列出了 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.The following system variables, status variables, and server options have been added in MySQL 8.4.
Audit_log_direct_writes:直接写入审核日志文件的次数。 MySQL 8.1.0 中添加。Audit_log_direct_writes: Number of direct writes to the audit log file. Added in MySQL 8.1.0.Com_show_binary_log_status:SHOW BINARY LOG STATUS 语句的计数;使用而不是 Com_show_master_status。 MySQL 8.2.0 中添加。Com_show_binary_log_status: Count of SHOW BINARY LOG STATUS statements; use instead of Com_show_master_status. Added in MySQL 8.2.0.Deprecated_use_i_s_processlist_count:信息架构进程列表表被访问的次数。 MySQL 8.3.0 中添加。Deprecated_use_i_s_processlist_count: Number of times Information Schema processlist table has been accessed. Added in MySQL 8.3.0.Deprecated_use_i_s_processlist_last_timestamp:最近访问信息模式进程列表表的时间(时间戳)。 MySQL 8.3.0 中添加。Deprecated_use_i_s_processlist_last_timestamp: Time of most recent access to Information Schema processlist table (timestamp). Added in MySQL 8.3.0.Gr_all_consensus_proposals_count:在此节点中发起和终止的所有提案的总和。 MySQL 8.1.0 新增。Gr_all_consensus_proposals_count: Sum of all proposals that were initiated and terminated in this node. Added in MySQL 8.1.0.Gr_all_consensus_time_sum:在此节点开始和结束的所有共识轮次的运行时间总和。结合 count_all_consensus_proposals,我们可以确定单个共识时间是否有上升趋势,从而表明可能存在问题。 MySQL 8.1.0 中添加。Gr_all_consensus_time_sum: The sum of elapsed time of all consensus rounds started and finished in this node. Togheter with count_all_consensus_proposals, we can identify if the individual consensus time has a trend of going up, thus signaling a possible problem. Added in MySQL 8.1.0.Gr_certification_garbage_collector_count:认证垃圾收集运行的次数。 MySQL 8.1.0 中添加。Gr_certification_garbage_collector_count: Number of times certification garbage collection did run. Added in MySQL 8.1.0.Gr_certification_garbage_collector_time_sum:认证垃圾收集运行所花费的时间总和(以微秒为单位)。 MySQL 8.1.0 中添加。Gr_certification_garbage_collector_time_sum: Sum of the time in micro-seconds that certification garbage collection runs took. Added in MySQL 8.1.0.Gr_consensus_bytes_received_sum:从以该节点为目标的组节点接收到的所有套接字级字节的总和。 MySQL 8.1.0 中添加。Gr_consensus_bytes_received_sum: The sum of all socket-level bytes that were received to from group nodes having as a destination this node. Added in MySQL 8.1.0.Gr_consensus_bytes_sent_sum:发送到源自此节点的所有组节点的所有套接字级字节的总和。套接字级字节意味着我们将在这里报告比发送的消息更多的数据,因为它们被复用并发送到每个成员。例如,如果我们有一个包含 3 个成员的组,并且我们发送一条 100 字节的消息,则该值将占 300 字节,因为我们向每个节点发送 100 字节。 MySQL 8.1.0 中添加。Gr_consensus_bytes_sent_sum: Sum of all socket-level bytes that were sent to all group nodes originating on this node. Socket-level bytes mean that we will report more data here than in the sent messages, because they are multiplexed and sent to each member. As an example, if we have a group with 3 members and we send a 100 bytes message, this value will account for 300 bytes, since we send 100 bytes to each node. Added in MySQL 8.1.0.Gr_control_messages_sent_bytes_sum:该成员发送的控制消息的字节总和。尺寸是在线尺寸。 MySQL 8.1.0 中添加。Gr_control_messages_sent_bytes_sum: Sum of bytes of control messages sent by this member. The size is the on-the-wire size. Added in MySQL 8.1.0.Gr_control_messages_sent_count:该成员发送的控制消息数。 MySQL 8.1.0 中添加。Gr_control_messages_sent_count: Number of control messages sent by this member. Added in MySQL 8.1.0.Gr_control_messages_sent_roundtrip_time_sum:此成员发送的控制消息的往返时间总和(以微秒为单位)。时间是在发送者成员上发送消息和传递消息之间测量的。该时间将测量组中大多数成员(包括发件人)发送消息和传递消息之间的时间。 MySQL 8.1.0 中添加。Gr_control_messages_sent_roundtrip_time_sum: Sum of the roundtrip time in micro-seconds of control messages sent by this member. The time is measured between the send and the delivery of the message on the sender member. This time will measure the time between the send and the delivery of the message on the majority of the members of the group (that includes the sender). Added in MySQL 8.1.0.Gr_data_messages_sent_bytes_sum:该成员发送的数据消息的字节总和。尺寸是在线尺寸。 MySQL 8.1.0 中新增。Gr_data_messages_sent_bytes_sum: Sum of bytes of data messages sent by this member. The size is the on-the-wire size. Added in MySQL 8.1.0.Gr_data_messages_sent_count:该成员发送的数据消息数。计算发送的事务数据消息的数量。 MySQL 8.1.0 中添加。Gr_data_messages_sent_count: Number of data messages sent by this member. Counts the number of transaction data messages sent. Added in MySQL 8.1.0.Gr_data_messages_sent_roundtrip_time_sum:此成员发送的数据消息的往返时间总和(以微秒为单位)。时间是在发送者成员上发送消息和传递消息之间测量的。该时间将测量组中大多数成员(包括发件人)发送消息和传递消息之间的时间。 MySQL 8.1.0 中添加。Gr_data_messages_sent_roundtrip_time_sum: Sum of the roundtrip time in micro-seconds of data messages sent by this member. The time is measured between the send and the delivery of the message on the sender member. This time will measure the time between the send and the delivery of the message on the majority of the members of the group (that includes the sender). Added in MySQL 8.1.0.Gr_empty_consensus_proposals_count:在此节点中发起和终止的所有空提案轮次的总和。 MySQL 8.1.0 中添加。Gr_empty_consensus_proposals_count: Sum of all empty proposal rounds that were initiated and terminated in this node. Added in MySQL 8.1.0.Gr_extended_consensus_count:该节点启动的完整 3-Phase PAXOS 数量。如果这个数字增长,则意味着至少有一个节点在响应提案时遇到问题,要么是速度缓慢,要么是网络问题。与 count_member_failure_suspicions 一起使用来尝试进行一些诊断。 MySQL 8.1.0 中添加。Gr_extended_consensus_count: The number of full 3-Phase PAXOS that this node initiated. If this number grows, it means that at least of the node is having issues answering to Proposals, either by slowliness or network issues. Use togheter with count_member_failure_suspicions to try and do some diagnose. Added in MySQL 8.1.0.Gr_last_consensus_end_timestamp:我们上次共识提案获得批准的时间。以时间戳格式报告。这是该小组是否停止或进展缓慢的一个指标。 MySQL 8.1.0 中添加。Gr_last_consensus_end_timestamp: The time in which our last consensus proposal was approved. Reported in a timestamp format. This is an indicator if the group is halted or making slow progress. Added in MySQL 8.1.0.Gr_total_messages_sent_count:此节点发送到组的高级消息数。这些消息是我们通过 API 收到并建议给小组的消息。 XCom 有一个批处理机制,它将收集这些消息并将它们一起提出。这将在批量处理之前计算消息的数量。 MySQL 8.1.0 中添加。Gr_total_messages_sent_count: The number of high-level messages that this node sent to the group. These messages are the ones the we receive via the API to be proposed to the group. XCom has a batching mechanism, that will gather these messages and propose them all togheter. This will acocunt the number of message before being batched. Added in MySQL 8.1.0.Gr_transactions_consistency_after_sync_count:在等待来自主节点且 group_replication_consistency= 的事务时,辅助节点上等待启动的事务数 AFTER 和 BEFORE_AND_AFTER 被提交。 MySQL 8.1.0 中添加。Gr_transactions_consistency_after_sync_count: Number of transactions on secondaries that waited to start, while waiting for transactions from the primary with group_replication_consistency= AFTER and BEFORE_AND_AFTER to be committed. Added in MySQL 8.1.0.Gr_transactions_consistency_after_sync_time_sum:辅助节点上的事务在等待来自辅助节点的事务时等待启动的时间总和(以微秒为单位)主数据库的 group_replication_consistency= AFTER 和 BEFORE_AND_AFTER 被提交。 MySQL 8.1.0 中添加。Gr_transactions_consistency_after_sync_time_sum: Sum of the time in micro-seconds that transactions on secondaries waited to start, while waiting for transactions from the primary with group_replication_consistency= AFTER and BEFORE_AND_AFTER to be committed. Added in MySQL 8.1.0.Gr_transactions_consistency_after_termination_count:使用 group_replication_consistency= AFTER 和 BEFORE_AND_AFTER 执行的事务数。 MySQL 8.1.0 中添加。Gr_transactions_consistency_after_termination_count: Number of transactions executed with group_replication_consistency= AFTER and BEFORE_AND_AFTER. Added in MySQL 8.1.0.Gr_transactions_consistency_after_termination_time_sum:执行的事务交付之间所花费的时间总和(以微秒为单位) group_replication_consistency=AFTER 和 BEFORE_AND_AFTER,以及其他组成员确认事务已准备就绪。它不包括事务发送往返时间。 MySQL 8.1.0 中添加。Gr_transactions_consistency_after_termination_time_sum: Sum of the time in micro-seconds spent between the delivery of the transaction executed with group_replication_consistency=AFTER and BEFORE_AND_AFTER, and the acknowledge of the other group members that the transaction is prepared. It does not include the transaction send roundtrip time. Added in MySQL 8.1.0.Gr_transactions_consistency_before_begin_count:使用 group_replication_consistency= BEFORE 和 执行的事务数之前和之后。 MySQL 8.1.0 中添加。Gr_transactions_consistency_before_begin_count: Number of transactions executed with group_replication_consistency= BEFORE and BEFORE_AND_AFTER. Added in MySQL 8.1.0.Gr_transactions_consistency_before_begin_time_sum:成员等待的时间总和(以微秒为单位) group_replication_applier 通道在执行 group_replication_consistency= BEFORE 和 BEFORE_AND_AFTER 的事务之前被消耗。 MySQL 8.1.0 新增。Gr_transactions_consistency_before_begin_time_sum: Sum of the time in micro-seconds that the member waited until its group_replication_applier channel was consumed before execute the transaction with group_replication_consistency= BEFORE and BEFORE_AND_AFTER. Added in MySQL 8.1.0.Performance_schema_meter_lost:创建失败的仪表数量。 MySQL 8.2.0 中添加。Performance_schema_meter_lost: Number of meter instruments that failed to be created. Added in MySQL 8.2.0.Performance_schema_metric_lost:创建失败的指标工具数量。 MySQL 8.2.0 中添加。Performance_schema_metric_lost: Number of metric instruments that failed to be created. Added in MySQL 8.2.0.Telemetry_metrics_supported:是否支持服务器遥测指标。 MySQL 8.2.0 中添加。Telemetry_metrics_supported: Whether server telemetry metrics is supported. Added in MySQL 8.2.0.Tls_sni_server_name:客户端提供的服务器名称。 MySQL 8.1.0 中添加。Tls_sni_server_name: Server name supplied by the client. Added in MySQL 8.1.0.authentication_ldap_sasl_connect_timeout:基于 SASL 的 LDAP 服务器连接超时。 MySQL 8.1.0 中添加。authentication_ldap_sasl_connect_timeout: SASL-Based LDAP server connection timeout. Added in MySQL 8.1.0.authentication_ldap_sasl_response_timeout:简单 LDAP 服务器响应超时。 MySQL 8.1.0 中添加。authentication_ldap_sasl_response_timeout: Simple LDAP server response timeout. Added in MySQL 8.1.0.authentication_ldap_simple_connect_timeout:简单 LDAP 服务器连接超时。 MySQL 8.1.0 中添加。authentication_ldap_simple_connect_timeout: Simple LDAP server connection timeout. Added in MySQL 8.1.0.authentication_ldap_simple_response_timeout:简单 LDAP 服务器响应超时。 MySQL 8.1.0 中添加。authentication_ldap_simple_response_timeout: Simple LDAP server response timeout. Added in MySQL 8.1.0.authentication_webauthn_rp_id:多因素身份验证的依赖方 ID。 MySQL 8.2.0 中添加。authentication_webauthn_rp_id: Relying party ID for multifactor authentication. Added in MySQL 8.2.0.check-table-functions:扫描数据字典中用于表约束和其他表达式的函数时如何进行,并且此类函数会导致错误。使用 WARN 记录警告; ABORT(默认)还会记录警告,并停止任何正在进行的升级。 MySQL 8.4.5 中添加。check-table-functions: How to proceed when scanning data dictionary for functions used in table constraints and other expressions, and such a function causes an error. Use WARN to log warnings; ABORT (default) also logs warnings, and halts any upgrade in progress. Added in MySQL 8.4.5.component_masking.dictionaries_flush_interval_seconds:调度程序在尝试安排下一次执行之前等待的时间(以秒为单位)。 MySQL 8.3.0 中添加。component_masking.dictionaries_flush_interval_seconds: How long for scheduler to wait until attempting to schedule next execution, in seconds. Added in MySQL 8.3.0.component_masking.masking_database:用于屏蔽字典的数据库。 MySQL 8.3.0 中新增。component_masking.masking_database: Database to use for masking dictionaries. Added in MySQL 8.3.0.group_replication_preemptive_garbage_collection:在单主模式下启用抢占式垃圾收集;在多主模式下没有影响。 MySQL 8.4.0 中添加。group_replication_preemptive_garbage_collection: Enable preemptive garbage collection in single-primary mode; no effect in multi-primary mode. Added in MySQL 8.4.0.group_replication_preemptive_garbage_collection_rows_threshold:启用时,在单主模式下触发抢占式垃圾收集所需的认证信息行数 group_replication_preemptive_garbage_collection。 MySQL 8.4.0 中添加。group_replication_preemptive_garbage_collection_rows_threshold: Number of rows of certification information required to trigger preemptive garbage collection in single-primary mode when enabled by group_replication_preemptive_garbage_collection. Added in MySQL 8.4.0.keyring-migration-from-component:密钥环迁移是从组件到插件。 MySQL 8.4.0 中添加。keyring-migration-from-component: Keyring migration is from component to plugin. Added in MySQL 8.4.0.mysql-native-password:启用 mysql_native_password 身份验证插件。在 MySQL 8.4.0 中添加。mysql-native-password: Enable mysql_native_password authentication plugin. Added in MySQL 8.4.0.mysql_firewall_database:MySQL 企业防火墙插件从中获取表和存储过程的数据库。 MySQL 8.2.0 中添加。mysql_firewall_database: Database from which MySQL Enterprise Firewall plugin sources its tables and stored procedures. Added in MySQL 8.2.0.mysql_firewall_reload_interval_seconds:按指定时间间隔重新加载 MySQL 企业防火墙插件数据。 MySQL 8.2.0 中添加。mysql_firewall_reload_interval_seconds: Reload MySQL Enterprise Firewall plugin data at specified intervals. Added in MySQL 8.2.0.performance_schema_max_meter_classes:可以创建的仪表仪器的最大数量。 MySQL 8.2.0 中添加。performance_schema_max_meter_classes: Maximum number of meter instruments which can be created. Added in MySQL 8.2.0.performance_schema_max_metric_classes:可以创建的度量工具的最大数量。 MySQL 8.2.0 中添加。performance_schema_max_metric_classes: Maximum number of metric instruments which can be created. Added 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. Added in MySQL 8.4.0.set_operations_buffer_size:可用于散列集合操作的内存量。 MySQL 8.2.0 中添加。set_operations_buffer_size: Amount of memory available for hashing of set operations. Added in MySQL 8.2.0.telemetry.live_sessions:显示使用遥测技术检测的当前会话数。 MySQL 8.1.0 中添加。telemetry.live_sessions: Displays the current number of sessions instrumented with telemetry. Added in MySQL 8.1.0.telemetry.metrics_enabled:控制是否收集遥测指标。 MySQL 8.3.0 中添加。telemetry.metrics_enabled: Controls whether telemetry metrics are collected or not. Added in MySQL 8.3.0.telemetry.metrics_reader_frequency_1:。 MySQL 8.3.0 中添加。telemetry.metrics_reader_frequency_1: . Added in MySQL 8.3.0.telemetry.metrics_reader_frequency_2:。 MySQL 8.3.0 中添加。telemetry.metrics_reader_frequency_2: . Added in MySQL 8.3.0.telemetry.metrics_reader_frequency_3: . MySQL 8.3.0 中添加。telemetry.metrics_reader_frequency_3: . Added in MySQL 8.3.0.telemetry.otel_bsp_max_export_batch_size:最大批量大小。 MySQL 8.1.0 中添加。telemetry.otel_bsp_max_export_batch_size: Maximum batch size. Added in MySQL 8.1.0.telemetry.otel_bsp_max_queue_size:最大队列大小。 MySQL 8.1.0 中添加。telemetry.otel_bsp_max_queue_size: Maximum queue size. Added in MySQL 8.1.0.telemetry.otel_bsp_schedule_delay:两次连续导出之间的延迟间隔(以毫秒为单位)。 MySQL 8.1.0 中添加。telemetry.otel_bsp_schedule_delay: Delay interval between two consecutive exports in milliseconds. Added in MySQL 8.1.0.telemetry.otel_exporter_otlp_metrics_certificates:验证服务器的 TLS 凭据时使用的受信任证书。 MySQL 8.3.0 中添加。telemetry.otel_exporter_otlp_metrics_certificates: The trusted certificate to use when verifying a server's TLS credentials. Added in MySQL 8.3.0.telemetry.otel_exporter_otlp_metrics_cipher:用于指标的 TLS 密码 (TLS 1.2)。在 MySQL 8.3.0 中添加。telemetry.otel_exporter_otlp_metrics_cipher: TLS cipher to use for metrics (TLS 1.2). Added in MySQL 8.3.0.telemetry.otel_exporter_otlp_metrics_cipher_suite:用于指标的 TLS 密码 (TLS 1.3)。 MySQL 8.3.0 中添加。telemetry.otel_exporter_otlp_metrics_cipher_suite: TLS cipher to use for metrics (TLS 1.3). Added in MySQL 8.3.0.telemetry.otel_exporter_otlp_metrics_client_certificates:PEM 格式的客户端私钥的客户端证书/链信任。 MySQL 8.3.0 中添加。telemetry.otel_exporter_otlp_metrics_client_certificates: Client certificate/chain trust for clients private key in PEM format. Added in MySQL 8.3.0.telemetry.otel_exporter_otlp_metrics_client_key:PEM 格式的客户端私钥。 MySQL 8.3.0 中添加。telemetry.otel_exporter_otlp_metrics_client_key: Client's private key in PEM format. Added in MySQL 8.3.0.telemetry.otel_exporter_otlp_metrics_compression:导出器使用的压缩。 MySQL 8.3.0 中添加。telemetry.otel_exporter_otlp_metrics_compression: Compression used by exporter. Added in MySQL 8.3.0.telemetry.otel_exporter_otlp_metrics_endpoint:指标端点 URL。 MySQL 8.3.0 中添加。telemetry.otel_exporter_otlp_metrics_endpoint: Metrics endpoint URL. Added in MySQL 8.3.0.telemetry.otel_exporter_otlp_metrics_headers:用作与 HTTP 请求关联的标头的键值对。 MySQL 8.3.0 中已添加。telemetry.otel_exporter_otlp_metrics_headers: Key-value pairs to be used as headers associated with HTTP requests. Added in MySQL 8.3.0.telemetry.otel_exporter_otlp_metrics_max_tls:用于指标的最大 TLS 版本。 MySQL 8.3.0 中添加。telemetry.otel_exporter_otlp_metrics_max_tls: Maximum TLS version to use for metrics. Added in MySQL 8.3.0.telemetry.otel_exporter_otlp_metrics_min_tls:用于指标的最低 TLS 版本。 MySQL 8.3.0 中添加。telemetry.otel_exporter_otlp_metrics_min_tls: Minimum TLS version to use for metrics. Added in MySQL 8.3.0.telemetry.otel_exporter_otlp_metrics_protocol:指定 OTLP 传输协议。 MySQL 8.3.0 中添加。telemetry.otel_exporter_otlp_metrics_protocol: Specifies the OTLP transport protocol. Added in MySQL 8.3.0.telemetry.otel_exporter_otlp_metrics_timeout:OLTP 导出器等待每个批量导出的时间。在 MySQL 8.3.0 中添加。telemetry.otel_exporter_otlp_metrics_timeout: Time OLTP exporter waits for each batch export. Added in MySQL 8.3.0.telemetry.otel_exporter_otlp_traces_certificates:验证服务器的 TLS 凭据时使用的可信证书。在 MySQL 中添加 8.1.0.telemetry.otel_exporter_otlp_traces_certificates: The trusted certificate to use when verifying a server's TLS credentials.. Added in MySQL 8.1.0.telemetry.otel_exporter_otlp_traces_cipher:用于跟踪的 TLS 密码 (TLS 1.2)。在 MySQL 8.3.0 中添加。telemetry.otel_exporter_otlp_traces_cipher: TLS cipher to use for traces (TLS 1.2). Added in MySQL 8.3.0.telemetry.otel_exporter_otlp_traces_cipher_suite:用于跟踪的 TLS 密码 (TLS 1.3)。 MySQL 8.3.0 中添加。telemetry.otel_exporter_otlp_traces_cipher_suite: TLS cipher to use for traces (TLS 1.3). Added in MySQL 8.3.0.telemetry.otel_exporter_otlp_traces_client_certificates:PEM 格式的客户端私钥的客户端证书/链信任。. MySQL 中添加 8.1.0.telemetry.otel_exporter_otlp_traces_client_certificates: Client certificate/chain trust for clients private key in PEM format.. Added in MySQL 8.1.0.telemetry.otel_exporter_otlp_traces_client_key:PEM 格式的客户端私钥。添加到 MySQL 中 8.1.0.telemetry.otel_exporter_otlp_traces_client_key: Client's private key in PEM format.. Added in MySQL 8.1.0.telemetry.otel_exporter_otlp_traces_compression:导出器使用的压缩。在 MySQL 8.1.0 中添加。telemetry.otel_exporter_otlp_traces_compression: Compression used by exporter. Added in MySQL 8.1.0.telemetry.otel_exporter_otlp_traces_endpoint:导出器向其发送跟踪的目标 URL。 MySQL 8.1.0 中添加。telemetry.otel_exporter_otlp_traces_endpoint: Target URL to which the exporter sends traces. Added in MySQL 8.1.0.telemetry.otel_exporter_otlp_traces_headers:用作与 HTTP 请求关联的标头的键值对。 MySQL 8.1.0 中添加。telemetry.otel_exporter_otlp_traces_headers: Key-value pairs to be used as headers associated with HTTP requests. Added in MySQL 8.1.0.telemetry.otel_exporter_otlp_traces_max_tls:用于跟踪的最大 TLS 版本。 MySQL 8.3.0 中添加。telemetry.otel_exporter_otlp_traces_max_tls: Maximum TLS version to use for traces. Added in MySQL 8.3.0.telemetry.otel_exporter_otlp_traces_min_tls:用于跟踪的最低 TLS 版本。 MySQL 8.3.0 中添加。telemetry.otel_exporter_otlp_traces_min_tls: Minimum TLS version to use for traces. Added in MySQL 8.3.0.telemetry.otel_exporter_otlp_traces_protocol:OTLP 传输协议。 MySQL 8.1.0 中添加。telemetry.otel_exporter_otlp_traces_protocol: OTLP transport protocol. Added in MySQL 8.1.0.telemetry.otel_exporter_otlp_traces_timeout:OLTP 导出器等待每个批量导出的时间。 MySQL 8.1.0 中添加。telemetry.otel_exporter_otlp_traces_timeout: Time OLTP exporter waits for each batch export. Added in MySQL 8.1.0.telemetry.otel_log_level:控制在服务器日志中打印哪些 opentelemetry 日志(仅限 Linux)。 MySQL 8.1.0 中添加。telemetry.otel_log_level: Controls which opentelemetry logs are printed in the server logs (Linux only). Added in MySQL 8.1.0.telemetry.otel_resource_attributes:查看相应的 OpenTelemetry 变量 OTEL_RESOURCE_ATTRIBUTES。 MySQL 中添加 8.1.0.telemetry.otel_resource_attributes: See corresponding OpenTelemetry variable OTEL_RESOURCE_ATTRIBUTES.. Added in MySQL 8.1.0.telemetry.query_text_enabled:控制 SQL 查询文本是否包含在跟踪中(仅限 Linux)。 MySQL 8.1.0 中添加。telemetry.query_text_enabled: Controls whether the SQL query text is included in the trace (Linux only). Added in MySQL 8.1.0.telemetry.trace_enabled:控制是否收集遥测跟踪(仅限 Linux)。 MySQL 8.1.0 中添加。telemetry.trace_enabled: Controls whether telemetry traces are collected or not (Linux only). Added in MySQL 8.1.0.thread_pool_longrun_trx_limit:当所有使用 thread_pool_max_transactions_limit 的线程执行时间超过此毫秒数时,组的限制将暂停。 MySQL 8.4.0 中添加。thread_pool_longrun_trx_limit: When all threads using thread_pool_max_transactions_limit have been executing longer than this number of milliseconds, limit for group is suspended. Added in MySQL 8.4.0.tls_certificates_enforced_validation:是否验证服务器和 CA 证书。在 MySQL 8.1.0 中添加。tls_certificates_enforced_validation: Whether to validate server and CA certificates. Added in MySQL 8.1.0.
以下系统变量、状态变量和选项在 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 中删除。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.