Optimize Database Performance with Click-to-Create Index Suggestions in Performance Advisor

Jenny Liang

#Atlas

You can now create recommended indexes directly in the Performance Advisor in MongoDB Atlas and MongoDB Cloud Manager.

What is the MongoDB Performance Advisor?

The Performance Advisor is one of our most popular optimization tools that analyzes logs for your slow-running queries (operations that take over 100ms to execute) and provides index suggestions on your collections.

Suggestions are ranked by an impact score so you see the most important ones first. Each index recommendation card also offers key statistics and information to help you understand why they were recommended, such as execution count and sample queries improved by the index.

Click-to-Create Index Suggestions

With our latest release, each recommended index now includes a green “Create Index” button.

Create Index

Clicking on it will open the index creation modal and allow you to start building the index instantly. You can specify any additional index build options here, such as collation or building the index in a rolling process.

Collation is used to specify language-specific rules for string comparison, such as rules for letter case and accent marks. Rolling index builds reduce the performance impact of building indexes on replica sets and sharded clusters by building them on nodes one at a time, starting with a secondary.

Once you’re done reviewing the index to be created, simply confirm and you’re all set! You can view the progress of an index build and see all indexes in the Index tab of the Data Explorer, or “Collections” view in MongoDB Atlas (“Data” tab in MongoDB Cloud Manager and Ops Manager).

Sample Index

Easier Database Optimization with Automated Index Creation

With click-to-create indexes in Performance Advisor, you can now build indexes without having to use the mongo shell, another index creation tool, or navigate to the Data Explorer.

If you have feedback or ideas on how to improve the Performance Advisor, you can tell us here.