Events intended for the error log have a priority of ERROR, WARNING, or INFORMATION. The log_error_verbosity system variable controls verbosity based on which priorities to permit for messages written to the log, as shown in the following table.用于错误日志的事件具ERROR、WARNING或INFORMATION的优先级。log_error_verbosity系统变量根据允许写入日志的消息的优先级控制详细信息，如下表所示。

If log_error_verbosity is 2 or greater, the server logs messages about statements that are unsafe for statement-based logging. 如果log_error_verbosity为2或更大，则服务器会记录关于对基于语句的日志记录不安全的语句的消息。If the value is 3, the server logs aborted connections and access-denied errors for new connection attempts. 如果值为3，则服务器会记录新连接尝试的中止连接和拒绝访问错误。See Section B.3.2.9, “Communication Errors and Aborted Connections”.请参阅第B.3.2.9节，“通信错误和中止的连接”。

If you use replication, a log_error_verbosity value of 2 or greater is recommended, to obtain more information about what is happening, such as messages about network failures and reconnections.如果使用复制，建议log_error_verbosity值为2或更大，以获取有关正在发生的情况的更多信息，例如有关网络故障和重新连接的消息。

If log_error_verbosity is 2 or greater on a replica, the replica prints messages to the error log to provide information about its status, such as the binary log and relay log coordinates where it starts its job, when it is switching to another relay log, when it reconnects after a disconnect, and so forth.如果复制副本上的log_error_verbosity为2或更大，则复制副本会向错误日志打印消息，以提供有关其状态的信息，例如二进制日志和中继日志坐标，它在哪里开始作业，何时切换到另一个中继日志，何时断开连接后重新连接，等等。

There is also a message priority of SYSTEM that is not subject to verbosity filtering. 还有一个SYSTEM的消息优先级不受详细信息筛选的约束。System messages about non-error situations are printed to the error log regardless of the log_error_verbosity value. 无论log_error_verbosity值是多少，有关非错误情况的系统消息都会打印到错误日志中。These messages include startup and shutdown messages, and some significant changes to settings.这些消息包括启动和关闭消息，以及对设置的一些重要更改。

In the MySQL error log, system messages are labeled as “System”. Other log sinks might or might not follow the same convention, and in the resulting logs, system messages might be assigned the label used for the information priority level, such as “Note” or “Information”. 在MySQL错误日志中，系统消息被标记为“系统”。其他日志接收器可能遵循也可能不遵循相同的约定，并且在生成的日志中，系统消息可能会被分配用于信息优先级的标签，例如“注释”或“信息”。If you apply any additional filtering or redirection for logging based on the labeling of messages, system messages do not override your filter, but are handled by it in the same way as other messages.如果根据消息标签对日志记录应用任何其他筛选或重定向，则系统消息不会覆盖您的筛选器，而是以与其他消息相同的方式处理。

The log_error_suppression_list system variable applies to events intended for the error log and specifies which events to suppress when they occur with a priority of WARNING or INFORMATION. log_error_suppression_list系统变量适用于用于错误日志的事件，并指定在优先级为WARNING或INFORMATION的情况下要抑制哪些事件。For example, if a particular type of warning is considered undesirable “noise” in the error log because it occurs frequently but is not of interest, it can be suppressed. log_error_suppression_list does not suppress messages with a priority of ERROR or SYSTEM.例如，如果特定类型的警告在错误日志中被认为是不希望的“噪音”，因为它经常发生，但不感兴趣，则可以抑制它。log_error_suppression_list不会抑制优先级为ERROR或SYSTEM的消息。

The log_error_suppression_list value may be the empty string for no suppression, or a list of one or more comma-separated values indicating the error codes to suppress. log_error_suppression_list值可以是不进行抑制的空字符串，也可以是指示要抑制的错误代码的一个或多个逗号分隔值的列表。Error codes may be specified in symbolic or numeric form. A numeric code may be specified with or without the MY- prefix. 错误代码可以以符号或数字形式指定。数字代码可以指定带有或不带有MY-前缀。Leading zeros in the numeric part are not significant. Examples of permitted code formats:数字部分的前导零无效。允许的代码格式示例：

ER_SERVER_SHUTDOWN_COMPLETE
MY-000031
000031
MY-31
31

For readability and portability, symbolic values are preferable to numeric values.为了可读性和可移植性，符号值比数值更可取。

Although codes to be suppressed can be expressed in symbolic or numeric form, the numeric value of each code must be in a permitted range:尽管要抑制的代码可以用符号或数字形式表示，但每个代码的数值必须在允许的范围内：

In addition, each error code specified must actually be used by MySQL. 此外，指定的每个错误代码实际上都必须由MySQL使用。Attempts to specify a code not within a permitted range or within a permitted range but not used by MySQL produce an error and the log_error_suppression_list value remains unchanged.试图指定一个不在允许范围内或在允许范围但MySQL未使用的代码会产生错误，并且log_error_pression_list值保持不变。

For information about error code ranges and the error symbols and numbers defined within each range, see Section B.1, “Error Message Sources and Elements”, and MySQL 8.0 Error Message Reference.有关错误代码范围以及每个范围内定义的错误符号和数字的信息，请参阅第B.1节，“错误消息源和元素”和MySQL 8.0错误消息参考。

The server can generate messages for a given error code at differing priorities, so suppression of a message associated with an error code listed in log_error_suppression_list depends on its priority. 服务器可以以不同的优先级为给定的错误代码生成消息，因此对与log_error_pression_list中列出的错误代码相关联的消息的抑制取决于其优先级。Suppose that the variable has a value of 'ER_PARSER_TRACE,MY-010001,10002'. 假设变量的值为'ER_PARSER_TRACE,MY-010001,10002'。Then log_error_suppression_list has these effects on messages for those codes:那么log_error_pression_list会对这些代码的消息产生以下影响：

The effect of log_error_verbosity combines with that of log_error_suppression_list. Consider a server started with these settings:log_error_verbosity的效果与log_error_pression_list的效果相结合。考虑使用以下设置启动的服务器：

[mysqld]
log_error_verbosity=2     # error and warning messages only
log_error_suppression_list='ER_PARSER_TRACE,MY-010001,10002'

In this case, log_error_verbosity permits messages with ERROR or WARNING priority and discards messages with INFORMATION priority. 在这种情况下，log_error_verbosity允许具有ERROR或WARNING优先级的消息，并丢弃具有INFORMATION优先级的消息。Of the nondiscarded messages, log_error_suppression_list discards messages with WARNING priority and any of the named error codes.在未丢弃的消息中，log_error_pression_list将丢弃具有WARNING优先级的消息和任何命名的错误代码。

Consider a server started with this setting:考虑使用此设置启动的服务器：

[mysqld]
log_error_verbosity=1     # error messages only

In this case, log_error_verbosity permits messages with ERROR priority and discards messages with WARNING or INFORMATION priority. 在这种情况下，log_error_verbosity允许具有ERROR优先级的消息，并丢弃具有WARNING或INFORMATION优先级的消息。Setting log_error_suppression_list has no effect because all error codes it might suppress are already discarded due to the log_error_verbosity setting.设置log_error_oppression_list无效，因为它可能抑制的所有错误代码都已由于log_error_verbosity设置而被丢弃。