Questions tagged [mongodb]
All versions of MongoDB - a scalable, high-performance, open-source, document-oriented database.
2,394 questions
0
votes
0
answers
25
views
MongoDB compound index usage to avoid in-memory sorting
This question on MongoDB compound index:
Below is a sample document in a given collection test.
{ a : 5, b : 3, c: 2, d : 1 }
Given a compound index { a: 1, b:1, c:1, d:1}, Which of the below query ...
0
votes
2
answers
9
views
How to debug MongoDB recurring error 314 ObjectIsBusy
On a fresh Mongo DB 8.0 mono instance (no cluster) community edition install on Debian and through the package manager, i have a recurring error message in my logs saying this:
"c":"...
0
votes
1
answer
45
views
Restore MongoDB database having queryable encrypted fields
Using mongodump and mongorestore with in-use encryption, I found out recently that restoring a Mongo database having queryable encrypted fields, regardless the version used (community or entreprise), ...
0
votes
0
answers
31
views
Can I grant read-only access to MongoDB database without creating a user or enabling authentication?
My Questions:
Is it possible to share read-only access to my MongoDB database WITHOUT creating a user? Is it possible to grant read-only permissions WITHOUT authentication being enabled on the server? ...
0
votes
1
answer
45
views
Does MongoDB's ESR (Equality, Sort, Range) guideline apply to SQL databases too?
MongoDB has an Equality, Sort, Range (ESR) guideline that has helped me tune my MongoDB indices in the past.
Now I'm using a SQLite database on a side-project of mine and I'm curious if ESR guidelines ...
1
vote
0
answers
31
views
How to export MongoDB Atlas cluster usage metrics?
I’m using MongoDB Atlas and would like to track my cluster usage metrics (read, write, connections, etc.). In the Atlas dashboard, you can see these metrics in charts like this:
Is there a way to ...
0
votes
0
answers
38
views
MongoDB log rotation only happens on reboot, not daily as expected
I'm trying to use LogRotate to manage my MongoDB logs because they were growing too large. My goal is to:
Create a new log file daily
Compress old logs
Keep logs for only the last 14 days
Delete ...
0
votes
0
answers
25
views
Mongo Prod Migration from Amzon linux 1 to ubuntu 24.04
I am planning to migrate our production database from Amazon Linux 1 to Ubuntu 24.04 to the latest Mongo. How can I migrate without loss of data and low downtime. Tried migrating the demo server ...
1
vote
1
answer
44
views
Im getting 'Not authorized on admin' with MongoDB atlas error even though I made both users Admins
Here is my server.js file
const dotenv = require('dotenv');
dotenv.config({ path: `${__dirname}/config.env` });
const mongoose = require('mongoose');
const db = process.env.DATABASE.replace(
'<...
0
votes
0
answers
32
views
Periodic Oplog Backups to Minimize MongoDB MTTR During Accidental Data Loss
I'm working on improving MTTR (Mean Time To Recovery) in our MongoDB replica set by enabling faster recovery from accidental delete or update operations.
Here's my proposed approach:
Take periodic ...
0
votes
1
answer
39
views
Mongo DB Tree Constant Balance Due High Delete/Chunk Migration/Shard Adding
We have huge collections that are having multiple indexes in mongodb with multiple shards. Since the deletion process is time consuming , and ttl mongo simply does not works, we have switched to semi ...
0
votes
1
answer
78
views
Mongodump of a single collection in replica set slowing down over time
I am executing mongodump to backup a collection with following characteristics:
Document count - about 2.36 billion
Storage Size - 350 GB
Size - 1350 GB
Index Size - 145 GB
The backup is running on ...
0
votes
1
answer
62
views
MongoDB refineShardKey unbalanced chunks
As a start:
Shard key is compounded to: group > user > document_name, was only for group
The cluster is composed of 2 shards
There is about a billion entries
Mongo 6.0 is being used
The ...
1
vote
1
answer
91
views
How can I version my knowledge database?
I have a large number of documents (>= 1 million or more).
I need to implement snapshot-style versioning, but I can't figure it out.
It should be able to take snapshots from anywhere. (like git?)
...
1
vote
1
answer
70
views
Clustered Index vs Secondary Index in MongoDB
I see in mongo doc
Starting in MongoDB 6.0.7, if a usable clustered index exists, the
MongoDB query planner evaluates the clustered index against secondary
indexes in the query planning process. When ...