content_image/741830.jpg content_image/741833.jpg content_image/741837.jpg
31 

Symbolic values are preferable to numeric values for readability and portability. For information about the permitted error symbols and numbers, see MySQL 8.0 Error Message Reference. 

The effect of log_error_suppression_list  combines with that of log_error_verbosity . For additional information, see Section 5.4.2.5, “Priority-Based Error Log Filtering (log_filter_internal)” . 

• log_error_verbosity 

<img src='content_image/741830.jpg'>

The log_error_verbosity  system variable specifies the verbosity for handling events intended for the error log. This variable affects filtering performed by the log_filter_internal  error log filter component, which is enabled by default (see Section 5.5.3, “Error Log Components” ). If log_filter_internal  is disabled, log_error_verbosity  has no effect. 

Events intended for the error log have a priority of ERROR , WARNING , or INFORMATION . log_error_verbosity  controls verbosity based on which priorities to permit for messages written to the log, as shown in the following table. 

<img src='content_image/741833.jpg'>

There is also a priority of SYSTEM . System messages about non-error situations are printed to the error log regardless of the log_error_verbosity  value. These messages include startup and shutdown messages, and some significant changes to settings. 

The effect of log_error_verbosity  combines with that of log_error_suppression_list . For additional information, see Section 5.4.2.5, “Priority-Based Error Log Filtering (log_filter_internal)” . 

• log_output 

<img src='content_image/741837.jpg'>

