Slow Database Statement

Slow Database statements are crucial in order for you to identify bottlenecks of a system which relies on the database.

Slow DB statements are based on sampling. Right now, the core samples 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: 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.