Slow Query Log

Scenarios

Slow query logs record statements whose execution period exceeds the value of operationProfiling.slowOpThresholdMs (100 ms by default). With slow query logs, you can identify and optimize slowly executed statements.

Note

If the user would like to change this, they can do this in Section Modifying a Parameter Template.

Procedure

1. Log in to the DDS console.

2. On the Instance Management page, click the target DB instance.

3. In the navigation pane on the left, click Slow Query Logs.

4. On the Slow Query Logs page, set search criteria and click Search to view log information.

   • Log records of all shards or a shard-specific node of a cluster instance

   • Log records of all nodes of a replica set instance

   • Slow query statements of the following level

     • All statements

     • INSERT

     • QUERY

     • UPDATE

     • REMOVE

     • GETMORE

     • COMMAND

   • You can view up to 2,000 slow query logs of a specified node type, of a specified statement type, and within a specified period.

last updated: 2024-04-26 00:51