Tuesday, May 28, 2013

MongoDB performance tuning, indexes, explain plan, hints and profiler

PROBLEM:
What you need to know for MongoDB performance tuning?

SOLUTION:
The following links will cover performance tuning, obviously a key aspect of database administration. You can find there how to optimize the performance of operations against a MongoDB database, including both queries and write operations. Indexes of course play a key component in many cases; thus you can find also a talk about MongoDB indexes in detail. You can find there also other performance related features including the explain plan and hint commands and the profiler.

Indexes in MongoDB
https://www.youtube.com/watch?v=a7TrHP1C6qQ

Indexes types
https://www.youtube.com/watch?v=pyoOGhGDoj8

Covered Indexes
https://www.youtube.com/watch?v=boAkBnMUBnw

Hints
https://www.youtube.com/watch?v=oaTm0Kftit8

Read vs. Writes
https://www.youtube.com/watch?v=USDbDotmums

Current Operations and Kill Operations
https://www.youtube.com/watch?v=i7XEKAtRS_M

Profiler
https://www.youtube.com/watch?v=MzLmI8FNB94

Mongostat & Mongotop
https://www.youtube.com/watch?v=fEgl1DT_lDA


If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!