How to find unused indexes and drop them safely in MongoDB

Indexes increase read performance and allow queries to access data faster. But they also need to be updated when the indexed keys are created or modified, which consumes additional time to complete C*UD operations. In this blog post, we will…

Read More >

Choosing best index for your MongoDB query

Indexing plays a quintessential role in database query performance and MongoDB is no exception. Choosing the best index for a query will improve its performance, while a bad one could lead to huge execution times and high memory utilization. In…

Read More >

Text index usage within MongoDB

Recently a client came to me asking “How do we verify if a full text search index is being used on MongoDB?” The db.showIndexes() command shows an index on a text field, but explain() shows COLLSCAN and the query is…

Read More >

Priority in MongoDB replica sets

I had interesting use case with a MongoDB replica set I’d like to share. When the replica set consists of four nodes and the Primary goes down, no new node is elected to become the new Primary. The replica set…

Read More >

MongoDB Europe 2017 recap

It’s November, time for MongoDB Europe event. For the second consecutive year, London hosted all the MongoDB experts to share what is new and exciting about the most popular NoSQL database in the world. After I missed the event last…

Read More >

An introduction to the MongoDB database profiler

MongoDB’s database profiler lets us collect some performance data about operations happening on a MongoDB instance. In this post, I will show you how we can enable the profiler, what kind of information it can store for us, how to query this…

Read More >

Customizing pt-stalk to capture the diagnostics data you really need

Valeriy Kravchuk’s great recent post on using oprofile to profile MySQL mentioned how pt-stalk, the script from Percona Toolkit to capture diagnostics data based on a detected condition, currently does not support the new operf comand, and relies instead on the deprecated and soon…

Read More >

GoldenGate 12.2 big data adapters: part 5 – MongoDB

In part five of his series on GoldenGate 12.2 Big Data Adapters, Gleb Otochkin, Principal Consultant and Certified Oracle Expert at Pythian, tests the Oracle GoldenGate Adapter for MongoDB taken from the Oracle Data Integration project.

Read More >

Exploring the operations log in MongoDB

Igor Donchovski, Database Consultant at Pythian, explains the MongoDB Operations log. Discover how the replication window compares to MySQL, how to change the oplog size, and what is improved in MongoDB 3.0 wiredTiger engine.

Read More >

How to set up flashback for MongoDB testing

Ping Yan, MongoDB/MySQL Database Consultant at Pythian, explains how to set up Flashback for MongoDB Testing.

Read More >
Page 1 of 212