OceanBase系统架构日志与监控

ODP 运行过程中会把各类请求信息和错误信息打印到对应的日志文件中,便于您进行针对性的分析。此外,OCP 也提供了ODP 的各类监控信息。

obproxy_digest.log 日志

大于参数 query_digest_time_threshold 设置值(默认 100ms,主站是 2ms)的请求、错误响应请求会打到 obproxy_digest.log 日志中。

说明

query_digest_time_threshold 参数用于设置请求执行时间阈值,超过阈值即打印一条日志到 obproxy_digest.log 文件。有关该参数的详细介绍,参见 ODP 支持动态修改的参数。

日志示例

2020-03-18 21:26:54.871053,postmen,,,,postmen40:postmen_new0497_3279:postmen_r497,OB_MYSQL,,postmen_push_msg_4977,COM_QUERY,SELECT,success,,SELECT id%2C gmt_create%2C gmt_modified%2C msg_id%2C principal_id%2C app_name%2C target_utdid%2C biz_id%2C host%2C status%2C expire_time%2C msg_data FROM postmen_push_msg_4977 WHERE principal_id = 'W/jEKoLOxnwDABWmhzjgmK1V' AND app_name = 'KOUBEI' AND expire_time > 1584538014858 AND status = 1,11765us,52us,0us,11632us,Y0-7F16DD5BEBC0,,