Slow Database Statement

Slow Database statements are crucial for you to identify bottlenecks of a system which relies on databases.

Slow DB statements are based on sampling. Right now, the core samples are the top 50 slowest every 10 minutes. Note that the duration of these statements must be slower than the threshold.

Here’s the format of the settings (in milliseconds):

database-type:thresholdValue,database-type2:thresholdValue2

The default settings are default:200,mongodb:100. Reserved DB type is default, which is the default threshold for all database types, unless set explicitly.

Note:

  1. The threshold should not be set too small, like 1ms. Although it works in theory, OAP performance issues may arise if your system statement access time is usually more than 1ms.
  2. The OAP server would run statistic per service and only persistent the top 50 every 10(controlled by topNReportPeriod: ${SW_CORE_TOPN_REPORT_PERIOD:10}) minutes by default.