tencent cloud

All product documents
TencentDB for MongoDB
DocumentationTencentDB for MongoDBTroubleshootingIncreased Slow Queries
Increased Slow Queries
Download PDF
Last updated: 2024-01-15 14:49:55
Increased Slow Queries
Last updated: 2024-01-15 14:49:55
Download PDF

Error Description

Slow query is the most common performance problem of MongoDB. You can use the slow query management and slow log query features in the console for troubleshooting.

Cause

The query is performed with the $lookup operator but doesn't use indexes or uses indexes that don't support the query; therefore, it is necessary to traverse the entire database for a complete scan, which eventually leads to a very low search efficiency.
Some documents in your collection have many large array fields that are time-consuming to search and index, causing a high system load.

Troubleshooting Procedure

Log in to the TencentDB for MongoDB console and click an instance ID to enter the instance management page.
Method 1: select Database Management > Slow Query Management, and the list will display the requests being executed by the current instance (including requests of secondary nodes). You can click Batch Kill to kill slow query statements.

Method 2: select the Slow Log Query tab to view and analyze slow logs. The system logs operations executed for more than 100 milliseconds and retains slow logs for 7 days. Currently, slow logs cannot be exported. If needed, contact the aftersales service or submit a ticket for assistance. If slow queries are heaping too fast, you are recommended to optimize your business based on the slow query analysis result. If the problem persists, contact the aftersales service or submit a ticket for assistance.

Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon