Navigation

Calculate Suggested Indexes

Overview

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

Prerequisites

For Ops 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, Ops Manager cannot suggest indexes.

Procedure

To edit the deployment’s configuration:

1

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

2

(Optional) For sharded clusters, filter which process type is listed.

For any listed process, click a button in its Members column to set which process type is listed.

The four buttons are listed in the following order, left to right: Shards, Configs, Mongos, and BIs.

Process Displays
Shards mongod processes that host your data.
Configs mongod processes that run as config servers to store a sharded cluster’s metadata.
Mongos mongos processes that route data in a sharded cluster.
BIs BI processes that access 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: