日志打印级别

日志打印级别

更新时间：2023-07-28 10:45:58

OceanBase 数据库通过设置日志模块的日志打印级别来控制写入日志文件的日志数据。

observer.log、observer.log.wf、election.log election.log.wf、rootservice.log 和 rootservice.log.wf 日志文件的默认打印级别均为 WDIAG 级别，即只有 WDIAG 及以上级别的日志数据才会打印到该日志文件中。

查看当前的日志打印级别

可通过 SHOW PARAMETERS 命令来查看当前的日志打印级别。

obclient> SHOW PARAMETERS LIKE '%syslog_level%';
+-------+----------+-----------------+----------+--------------+-----------+-------+------------------------------------------------------------------------------------------------------------------------+----------+---------+---------+-------------------+
| zone  | svr_type | svr_ip          | svr_port | name         | data_type | value | info                                                                                                                   | section  | scope   | source  | edit_level        |
+-------+----------+-----------------+----------+--------------+-----------+-------+------------------------------------------------------------------------------------------------------------------------+----------+---------+---------+-------------------+
| zone1 | observer | XXX.XXX.XXX.XXX |     2882 | syslog_level | NULL      | WDIAG  | specifies the current level of logging for obesi. There are DEBUG, TRACE, WDIAG, EDIAG, INFO, WARN, ERROR, seven different log levels. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE |
+-------+----------+-----------------+----------+--------------+-----------+-------+------------------------------------------------------------------------------------------------------------------------+----------+---------+---------+-------------------+
1 row in set

说明

通过 KILL 方式设置的日志打印级别不可通过 SHOW PARAMETERS 命令查看。