Improve MongoDB Performance
Summary of my bookmarked videos and Github repositories from Sep 6th, 2016
- Indexing Mongo for Production Peformance - Spacedojo Code Kata
In this video, the host discusses the process of indexing MongoDB for improved production performance. He demonstrates using the QueryPlanner to speed up Mongo queries and optimize data retrieval. By creating indexes and organizing them correctly, he shows how to achieve faster lookup times and reduce the amount of work performed by the database. The video provides step-by-step instructions on using tools like Robo to browse the database and analyze query performance. The host also emphasizes the importance of proper index ordering for efficient sorting. Overall, the video offers valuable insights into optimizing MongoDB queries for better production performance.
Dex is a MongoDB performance tuning tool that analyzes queries and suggests indexes based on simple heuristics. It compares queries to available indexes in the queried collection(s) and generates recommendations. Dex supports log files and the system.profile collection for analysis. It recommends complete indexes and ignores partial indexes, favoring better options. You can filter analysis by specific collections, databases, or query execution time. Dex can run in watch mode for real-time information. It provides query reports with index recommendations and helpful shell commands. Dex is recommended for MongoDB version 2.2.0 or later.