Monitoring MongoDB query performance

Core cpu utilisation of primary instance
executionStats matrix of a lookup

Factors Influencing DB performance

  1. Lots of reads happening on the primary instance:- In most of the cases, we can use partially consistent data in DB. In those cases, we should always do a .find({}) operation from the secondary instance of DB. That helps in reducing the load on primary instance, saving our CPU % utilization.
  2. Inefficient Queries:- If the query is taking too long to execute, it is an inefficient query. But why does the query takes a long time to execute?
Query Optimisation Plan
Scan % in groups of 5
scan% of queries
read preference share

--

--

--

Senior Software Engineer, TravelTech

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

The W3F Grant is completed and our Curve implementation to be launched on Genshiro first, our…

Phenom Enters Into a Technical Partnership With Identity for Phenom Metaverse Development

AWS Lambda Functions written in Rust

Commure Joins Postman API Network to Improve Healthcare Development

Service Mesh Testing — Tools & Frameworks (Open Source)

How To Create API With Golang (GIN) And MySQL- Part 1

Do Repeat Yourself

My Goals for the HNGi8 x 14G internship

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Rishabh Jindal

Rishabh Jindal

Senior Software Engineer, TravelTech

More from Medium

Validating data flow from your MinIo s3 object storage modules.

REST API Projection — GraphQL like approach to solve Overfetching.

Matching PostgreSQL Data Types into Java

Serverless — What? Why? How?