Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Category: MongoDB

How to define shardKey on GridFS collections to achieve Location/Data Centre affinity (MongoDB)

By adminPosted on July 22, 2020

Question : I have set up a mongo cluster as follows: 3 shards, one per global region APAC/EMEA/AMER (in different […]

Disk space problem regarding MongoDB [closed]

By adminPosted on July 22, 2020

Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]

Overview of how MongoDB uses its various threads

By adminPosted on July 19, 2020

Question : On one instance I have MongoDB using ~85 threads. In lieu of having time to investigate directly, I […]

how mongo db does locking for updates/inserts?

By adminPosted on July 18, 2020

Question : I have many data for each user that with write heavy and many for each separate users that […]

MongoDB Not Using All Available RAM

By adminPosted on July 17, 2020

Question : I have something around 200 GB worth data stored in a mongo cluster. The physical memory on one […]

what’s extsort.* (8 – 11 MB) in MongoDB dbpath? Directory _tmp

By adminPosted on July 15, 2020

Question : I never saw this in my dbpath and didn’t found any explanation with a search engine. We run […]

MongoDB deployment best practices

By adminPosted on July 15, 2020

Question : I had a few questions around deployment best practices and how folks are using mongodb today. Feel free […]

Socket recv() timeout on secondary nodes

By adminPosted on July 15, 2020

Question : We started using MongoDB pretty recently. We are on version 2.6.3. We have a replica set of 4 […]

Insert on duplicate key update using MongoDB

By adminPosted on July 14, 2020

Question : Can somebody tell me how I should build MongoDB “updateOne” query to get analog of the following SQL […]

Speeding up MongoBD query { $ne: [] }

By adminPosted on July 14, 2020

Question : I’m currently doing a MongoDB aggregation but then have a query looking for all documents where a certain […]

  • 1
  • …
  • 135
  • 136
  • 137
  • 138
  • 139

Recent Posts

  • What happens when a stored procedure executes one of two different queries based on an input parameter?
  • T-SQL Optimization
  • Why my BEFORE UPDATE trigger takes values from the NEW record? [closed]
  • Split a query results multiple times
  • Improve reading speed of MySQL table storing stock prices (100 Mil. entries)
  • Adding sql users via linked servers
  • Postgres – caching of recently inserted data?
  • Does Oracle randomly switch execution plans to check if there is a better solution?
  • Cannot INSERT into database on a shared server
  • Simple query with a single join very slow
  • How to replicate and sync MongoDB localhost to a remote server using replica set
  • How can I increase performance for select in select statement
  • Optimize UNION query in MySQL
  • Mysql Performance tuning for myisam tables.
  • Get-ClusterParameter Not Returning Expected Results
  • SQL Server Extended Events to Capture Objects access by a User [duplicate]
  • Execution time of triggers fired when a procedure is executed in postgresql
  • Efficient query to get last row group by multiple columns
  • How to use GROUP BY after the Having clause Mysql
  • PGSQL- syntax error at or near “-“

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding