MySQL 9.6 Reference Manual Including MySQL NDB Cluster 9.6
The setup_loggers table lists the
registered loggers and their logging level:
mysql> select * from performance_schema.setup_loggers;
+------------------------+-------+-------------------------+
| NAME | LEVEL | DESCRIPTION |
+------------------------+-------+-------------------------+
| logger/sql/error_log | info | MySQL error logger |
| logger/sql/slow_log | info | MySQL slow query logger |
| logger/sql/general_log | info | MySQL general logger |
+------------------------+-------+-------------------------+
NAME: The name of the logger.
This can be one of the following:
logger/sql/error_log
logger/sql/general_log
The General log does not have a log level. All logs
are instrumented using INFO. It is
also independent of the existing configuration. For
example, if
log_output or
general_log is
disabled, general OpenTelemetry logging continues.
logger/sql/slow_log
The Slow Query log does not have a log level. All logs
are instrumented using WARN. It is
also independent of the existing configuration. For
example, if
log_output or
slow_query_log is
disabled, Slow Query OpenTelemetry logging continues.
Similarly, on replicas, if
log_slow_replica_statements
is disabled, Slow query OpenTelemetry logging
continues on the replica.
LEVEL: The log level. This can be set
to one of the following values:
none
error
warn
info
debug
DESCRIPTION: A text description of the
logger.