Tag Archives: index

Using MongoDB $indexStats to identify and remove unused indexes

Proper indexing is critical to database performance. A single unindexed query is enough to cause significant performance degradation. It is relatively easy to spot a missing index using mLab’s Slow Query Analyzer, but the tool doesn’t provide an obvious way to identify and remove indexes that aren’t actually being used…

Full Article

Telemetry Series: Queues and Effective Lock Percent

A key component of optimizing application performance is tuning the performance of the database that supports it. Each post in our Telemetry series discusses an important metric used by developers and database administrators to tune the database and describes how MongoLab users can leverage Telemetry, MongoLab’s monitoring interface, to effectively review and take action on […]

Full Article

How big is your MongoDB?

Update 11/10/14: The next blog post in this series is on managing disk space in MongoDB. As your MongoDB grows in size, information from the db.stats() diagnostic command (or the database “Stats” tab in our management portal) becomes increasingly helpful for evaluating hardware requirements. We frequently get questions about the dataSize, storageSize and fileSize metrics, so […]

Full Article

Are you ready for production?

Updated article on 03/24/15 Transitioning your application from development to production is a monumental step. Over the years, we at MongoLab have acquired a lot of valuable experience helping our customers successfully manage their production-grade MongoDB deployments. What follows is a checklist of action items that we’ve found imperative for successfully taking your application to […]

Full Article

Remote Dex: Index Analysis Using the Profile Collection

(also posted to the 10gen blog: here) Greetings Adventurers! I’m excited to report that Dex (github) is now equipped with his first planned upgrade. For those of you who haven’t met him, Dex is an open-source python tool that suggests indexes for your MongoDB database. The initial release of Dex supported logfile-based analysis only. Now, Dex […]

Full Article

Introducing Dex: the Index Bot

(update 2012-07-19: A new remote feature detailed here.) (update 2012-10-09: Version 0.5 detailed here.) Greetings adventurers! MongoLab is pleased to introduce Dex! We hope he assists you on your quests. Dex is a MongoDB performance tuning tool, open-sourced under the MIT license, that compares logged queries to available indexes in the queried collection(s) and generates index […]

Full Article