proposalbot
264dadb4c1
this PR Repla Reviewed-by: Székely, Ond <ond.szekely@t-systems.com> Co-authored-by: proposalbot <proposalbot@otc-service.com> Co-committed-by: proposalbot <proposalbot@otc-service.com>
38 lines
1.2 KiB
ReStructuredText
38 lines
1.2 KiB
ReStructuredText
:original_name: en-us_topic_slow_query_log.html
|
|
|
|
.. _en-us_topic_slow_query_log:
|
|
|
|
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 :ref:`Modifying a Parameter Template <en-us_topic_configuration>`.
|
|
|
|
Procedure
|
|
---------
|
|
|
|
#. :ref:`Log in to the DDS console. <dds_02_0043>`
|
|
#. On the **Instance Management** page, click the target DB instance.
|
|
#. In the navigation pane on the left, click **Slow Query Logs**.
|
|
#. 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.
|