ILT: OF200: Diagnostics and Performance Tuning
This training day covers the fundamentals of indexing in theory and in practice, how to profile database operations to identify bottlenecks, and how to monitor MongoDB performance in real time using command-line tooling.
Training: Diagnostics and Performance Tuning (OF200)
Overview
On completion of this training day you will know how to identify and rectify missing indexes. You will also be familiar with several basic monitoring and diagnostic tools and how to use them diagnose other production performance problems.
Agenda:
Indexes and Optimization
- 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
Database Profiling
- Finding slow operations
- Slow query log
- Enabling the profiler
- Causes of slow operations
- Identifying locking issues
- Listing and killing operations
Basic Monitoring for Diagnosis
- mongostat
- mongocacheview *
- Processing logs
- Compass and the real-time panel
End of day test
* includes hands-on exercise
Duration
1 day
Learning Paths
Please see the MongoDB Learning Paths here!
Program Datasheets
Course prerequisites
This course has the following prerequisites:
- OF100: MongoDB Operations Fundamentals
Language
This course is offered in multiple languages. Check the session title to see which language your selected session will be offered in.
Course access
This course is entirely virtual, and will be conducted over Zoom video conferencing and Strigo hands-on lab environments.
