Archive: indexes RSS feed for this section

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

Telemetry Series: Page Faults

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

A Primer on Geospatial Data and MongoDB

MongoDB offers new geospatial features in versions 2.4 and 2.6.  The core of these features is the introduction of GeoJSON, an open-source format for rich geospatial types that go beyond what MongoDB has supported in previous versions. This post is a primer for developers new to geospatial data in MongoDB. We aim to familiarize you […]

Full Article

Experiment with MongoDB 2.4 on MongoLab!

Hello to all our friends and users! We’re happy to announce that free, experimental databases running MongoDB 2.4 are now available at MongoLab! To get started quickly, follow our step-by-step guide. Please note: This release is not ready for production yet and should not be used for any production applications. Release Highlights Here are the […]

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

MongoDB Users Group Events July 2012

Silicon Valley July 17, 2012: Dex and Fluentd http://www.meetup.com/MongoDB-SV-User-Group/events/72760092/ 10gen Palo Alto 555 University Avenue Palo Alto, CA 94301 Query performance is critical for most applications.  Proper MongoDB index creation can mean over two orders of magnitude in latency improvement.   At the Silicon Valley MongoDB Users Group (SVMUG), MongoLab Engineer Eric Sedor will be […]

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

Cardinal $ins: MongoDB Query Performance over Ranges

Greetings adventurers! If you’ve been travelling through MongoDB indexing territory for any amount of time, you may have heard or derived the following maxim: If your queries contain a sort/orderby clause, add the sorted field to the end of the index servicing the query. In many cases when querying for documents containing equivalent values, the above […]

Full Article