Navigation

Calculate Suggested Indexes

Note

Available only with Cloud Manager Premium. This feature is available only with Cloud Manager Premium, which comes with certain MongoDB subscriptions. Contact MongoDB for more information.

Overview

Cloud Manager can analyze the data on query patterns collected by the database profiler and suggest a set of indexes that could improve query performance. Cloud Manager scores each suggested index on its expected benefit.

Prerequisites

For Cloud Manager to suggest indexes, the following must be true:

  • You must enable database profiling for the MongoDB process. See Profile Databases.
  • The profiler must have data. If profiling is enabled, but no profiling data has yet been collected, Cloud Manager cannot suggest indexes.

Procedure

To edit the deployment’s configuration:

1

Click Deployment, then the Processes tab, then the Topology view.

2

If the process is part of a sharded cluster, click the filter button for the type of process.

Click one of the following:

Shards Displays the mongod processes that host your data.
Configs Displays the mongod processes that run as config servers to store a sharded cluster’s metadata.
Mongos Displays the mongos processes that route data in a sharded cluster.
3

On the line listing the process, click Metrics.

4

Click the Profiler tab above the charts.

5
6

Copy the indexes you want to create and add them to the MongoDB process.

For instructions on adding an index to a MongoDB process, see either: