Document Database Service

Product Introduction

Resource Pool and Feature Overview

List of Resource Pools

Product Features and Supported Resource Pools at a Glance

Architecture

Single-Node System Architecture

Replica Set System Architecture

Cluster System Architecture

Product Advantages

High Availability

High reliability

Product Features

Three Architectures

Elastic Scaling

Key Product Features

Application Scenarios

DDS is applied in the following scenarios

Instance Description

Database Instance Specifications

Database Engine and Version

Terms

Regions and Resource Pools

Availability Zone

Parameter Templates and Parameter Groups

Count of Database Connections

Relationships with Other Cloud Services

Advantages of DDS over Self-built Database

Billing

Billing Description

Charging Standards

Billing Mode

Yearly and Monthly Subscription

Instance Renewal

Constraints and Rules

Instance Unsubscription

Switching the Billing Mode from Pay-as-you-go to Subscription-based

Switching the Billing Mode from Subscription-based to Pay-as-you-go

Getting Started

Overview

Three Specification Types and Application Scenarios

Creating and Connecting Database

Creating a DDS Instance

Connecting a DDS Instance

Introduction to Instance Connection Method

Connecting an Instance Through Intranet

Setting a Security Group

Connecting an Instance Through Mongo Shell in the Intranet

Connecting Instances Through Internet

Binding and Unbinding an EIP

Setting a Security Group

Connecting an Instance Through Mongo Shell in the Internet

Connecting an Instance Using Program Codes

Python Examples

Steps to Use DDS

Using DDS in Intranet

Using DDS in Internet

User Guide

Logging in to DDS

Before You Begin

Logging in to the Console from Control Center

Logging in to the Console from the Product Details Page

Instance Management

Instance Creation

Instance Unsubscription

Instance Restart

Changing Instance Configuration

Changing Configuration Parameters

Database Account Management

Managing Permissions of Master Accounts, Sub-accounts and IAM

Enterprise Project Migration

Modify Instance Name

Upgrade the kernel patch version

Instance Recycle Bin

Instance Change

Instance Disk Expansion

Expanding Instance Specifications

Adding Nodes for Sharded Cluster Instances

Adding Nodes for Replica Set Instances

Active-Standby Switchover of Instances

Set Maintenance Time Window

Enabling or Disabling Instance Release

Backup Management

Data Backup Scheme

Incremental Backup

View Backup Result

Delete a Backup

Recovery Management

Recovery Scheme

Recovering Stand-alone Version Instance Backup

Recovering Replica Set Instance Backup

Recovering Cluster Version Instance Backup

View Restore Records

Parameter Group Management

What is Parameter Group

Create Parameter Group

Modify Parameter Group

Compare Parameter Group

Copy Parameter Group

Restore Parameter Group

Apply Parameter Group

View Parameter History

Delete Parameter Group

Export Parameter

Monitoring Management

View Monitoring Information

Introduction to Monitoring Metrics

Event Management

Log Management

Viewing Error Log Information

Viewing Slow Query Log Information

Viewing Running Log Information

Account Management

Creating Regular Account

Modify Permission of Regular Account

Reset Account Password

Deleting Regular Account

Managing Tags

Binding a Tag to an Instance

Filtering Instances by Tags

Unbinding an Instance from a Tag

Instance Lifecycle Management

Instance Status

Export Instance List

Restarting Instance or Node

Deleting Instance As Needed

Database Management

Modify Instance Port

Creating an Instance Account

Creating a database

Enabling and Disabling SSL

Resetting Administrator Password

Edit Security Group

Supported and Unsupported Commands

Data Migration

Migration Solution Overview

Migrating Data Using mongodump and mongorestore

Disaster Recovery Across Availability Zones

Activating Across-AZ Replica Set Instance

Activating Across-AZ Cluster Instance

Fine-tuning

Adjusting Parameters to Optimize Performance

Improving Read/Write Performance of Database

Troubleshooting of High CPU Usage

Troubleshooting of High Disk Usage

Troubleshooting of High Memory Usage

Troubleshooting of Load Unbalance of Cluster Instance

Methods to Locate Slow Requests

Methods to Optimize Database Query Language

Improving Performance with Sharding

Trustlist Management

Add Trustlist Group

Modify Trustlist Group

Delete Trustlist Group

Usage Suggestions of DDS

Design Specifications of DDS

Development Suggestions of DDS

API Reference

API Overview

Call APIs

Construct a Request

API

Security Group Management

Performance Monitoring

Instance Management

Buy a New MongoDB Instance

Query the Monitoring Metric Collection Granularity of an Instance

View the Cluster Instance List

Set the Monitoring Metric Collection Granularity of an Instance

Expand a MongoDB Instance

Reset the Password of the Root Account in an Instance

Query the Renewal Price of a MongoDB Instance

Unbind the Elastic IP of the instance

Query the Connection Address Information of an Instance

Query Instance SSL Setting Details of an Instance

View the Instance List

Query the Role Information of an Instance

Query Instance Details

Modify Instance Name

Query the overview information of one or more MongoDB instances

Modify the Remark of the Root Account in an Instance

Release an Instance

Query the maintenance time of the instance

Query All Database Account Information of an Instance

Query the O&M task type of the instance and the number of tasks of each type

Restart a Database Instance

Query the Task List Information

Restore a Released Instance

Query the Database Root Account Information of an Instance

Modify the maintainable time of the instance

Destroy a Released Instance

Modify instance SSL configuration

Query the Number of O&M Tasks in an Instance

Unsubscribe from a MongoDB Instance

Renew a MongoDB instance

Query the Price of a Newly Purchased MongoDB Instance

Query the Expansion Price of a MongoDB Instance

Backup and Restoration

Check Whether an Instance Meets the Data Recovery Condition

Modify the Backup Policy of an Instance

Query the Backup List of an Instance

Query the Backup Policy of an Instance

Manually Backing Up an Instance

Manually Restore an Instance

Parameter Management

Query the Parameter Configuration Information of an Instance

Query All Parameter Groups

Query the Default Parameter Template List of an Instance

Delete Parameter Group

Query the Parameter Revision History of an Instance

Create a New Parameter Group

Modify the parameters of a MongoDB instance

Copy Parameter Group

Restore Parameter Group

Compare Parameter Groups

Managing Tags

Query the Binding Relationship Between an Instance and Tags

Bind One or More Tags

Unbind Bound Tags

Query All Tag Data Information

Alarm Center

Query the Server Alarm Rule of an Instance

Query the Database Alarm Configuration of an Instance

Query the Alarm List Information

Query the Alarm History Information

Modify the Server Alarm Rule of an Instance

Modify the Database Alarm Rule of an Instance

Best Practices

Improve Service Performance with Data Sharding

Create sharded table

Configure balancer window

Improve Instance Performance with SQL Optimization

Ways to improve the performance of query operation

Commonly Used DDS Indexes

Slow query locating and processing

Clean up unnecessary indexes

Do not use system library to store business data

Common methods for importing and exporting data

mongoexport/mongoimport method

mongodump/mongorestore method

Improve Performance with read/write Separation

Node role description

Read the specified node by setting readPreference

Improve data security by configuring write parameters

How to Connect to Document Database

Connect using mongo shell

Connect using mongo driver

Allocate user permissions properly to ensure database security

Developer Guide

Specifications on Using DDS

Basic Command Specification for DDS

Specifications on Developing DDS

Specifications on Designing DDS

Use of Database

How to Connect to Database

How to Create and Manage Database

How to Create and Manage Collection

How to Create and Manage Index

Application Development

Development process

Java-based development

Python-based development

Database Permission Management

Default permission mechanism

Role Management

User Management

System collection

Common Operations

FAQs

Purchasing

Resources frozen/released/deleted/unsubscribed

Expansion and Specification Changes

Create and Delete

Operation

Database Version

Resource and Disk Management

Database Performance

Database Connection

Client Installation

Basic Use of Database

Database Migration

Database Parameter

Backup and Restoration

Network security

Monitoring and Alarm

Troubleshooting

Instance Node Troubleshooting

Connection error: Authentication failed

Connection error: Connection failed or service unreachable

Access instance error: no primary node

Connection error: URL without replica set configuration

Connection error: Timeout

Performance Whitepaper

Replica Set Test Data

Sharded Cluster Test Data

Security Whitepaper

Overview of Security Whitepaper

Download

Related Agreements

Related Agreements

Help Center Document Database Service Best Practices Improve Instance Performance with SQL Optimization

Improve Instance Performance with SQL Optimization

2025-07-28 03:31:54

share

Weibo
Copy link

Ways to improve the performance of query operation
Commonly Used DDS Indexes
Slow query locating and processing
Clean up unnecessary indexes

The previous article - Configure balancer window

The next article - Ways to improve the performance of query operation