Course Overview
This training day covers the fundamentals of indexing in theory and practice, how to profile database operations to identify bottlenecks, and how to monitor MongoDB performance in real-time using command-line tooling.
Prerequisites
This course has the following prerequisites:
- OF100: MongoDB Operations Fundamentals
Audience Profile
- Database administrators
Learning Objectives:
On completing this training day, you will know how to identify and rectify missing indexes. You will also be familiar with several essential monitoring and diagnostic tools and how to use them to diagnose other production performance problems.
Content Outline
- What are indexes?
- MongoDB misconceptions
- Single field indexes
- Reading explain plans *
- Indexes and performance
- Limits
- Best practices
- Compression
- Multikey indexes
- Compound index design *
- Covered queries
- Geospatial indexing *
- 2d indexes
- Spherical indexes
- TTL indexes
- Text indexes
- Wildcard indexing
- How indexes are chosen
- Query planner
- Query optimizer
- Hints and tips
- Finding slow operations
- Slow query log
- Enabling the profiler
- Causes of slow operations
- Identifying locking issues
- Listing and killing operations
- mongostat
- mongocacheview *
- Processing logs
- Compass and the real-time panel
FAQs
Indexes are unique data structures that store some information related to the documents, making it easy for MongoDB to find the correct data file. The indexes are ordered by the field value specified in the index.
This course has the following prerequisites:
- OF100: MongoDB Operations Fundamentals
On completing this training day, you will know how to identify and rectify missing indexes. You will also be familiar with several essential monitoring and diagnostic tools and how to use them to diagnose other production performance problems.
To attend the training session, you should have operational Desktops or Laptops with the required specification and a good internet connection to access the labs.
Technical issues are unpredictable and might occur with you as well. Participants must ensure that they have the system with the required configuration and good internet speed to access online labs.
If the problem persists or you face any challenge during the class, you can report it to us or your trainer. In that case, Radiant would provide you with the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption and NOT for distribution or any commercial use
mongostat provides a brief overview of the MongoDB instance's current status, while mongo-top tracks how much time the model spends on read-and-write operations. These tools are run from the command line instead of the MongoDB shell.
Radiant Tech learning has a data center containing a Virtual Training environment for participants hand-on-practice. Participants can easily access these labs over Cloud with the help of a remote desktop connection. Radiant virtual labs allow you to learn from anywhere in the world and any time zone.
The learners will be enthralled as we engage them the real-world and Oriented industry projects during the training program. These projects will improve your skills and knowledge and give you a better experience. These real-time projects will help you a lot in your future tasks and assignments.