Performance & Optimization

Showing 15

Allow the ability when NVME cluster to autoscale up based on CPU and Memory

To provide autoscaling capability for MongoDB NVME clusters based on CPU utilization and memory metrics. This feature would automatically provision additional resources when predefined thresholds are reached, ensuring optimal performance during us...

Guest 8 months ago in Performance & Optimization 0 Submitted

9 VOTE

Should be possible to configure profiling output destination

When enabling database profiling the output is sent to both the system.profile collection and system logs. Logging to a capped collection is fine but spamming the logs on disk is not good. We have a need to be able to react to changing query patt...

Guest about 2 years ago in Performance & Optimization 0 Submitted

3 VOTE

Add support for all type of joins like Postgres has and improve performance

$lookup is a performance killer. Joins are crucial parts in every OLTP system. $lookup is the equivalent to join in SQL, however $lookup is slow, doesn't support hash joins or other efficient join algorithm implemented in Postgres for example. Se...

Guest 10 months ago in Performance & Optimization 1 Submitted

6 VOTE

Implement $bucket and $group on indexed values with sub-linear runtime

We noticed that sum $bucket and $group aggregations such as $min, $max, $count are unexpectedly slow even when fully covered by an index, (partially) because the DB scans through the entire index rather than employing optimization approaches such ...

Guest almost 3 years ago in Performance & Optimization 0 Submitted

1 VOTE

Provide a dictionary for matched/modified/deleted counts for bulk writes

Current bulk write operations provide only aggregated counts that look like this: ``` { acknowledged: true, insertedCount: 0, insertedIds: {}, matchedCount: 2, modifiedCount: 2, deletedCount: 0, upsertedCount: 0, upsertedIds: {} } ``` All ...

Guest 7 months ago in Performance & Optimization 0 Submitted

1 VOTE

Execute $group on shardPart instead of mergerPart

Basically what is described here: https://www.mongodb.com/community/forums/t/how-to-enforce-mongodb-to-execute-group-on-shardpart-of-the-execution-plan/267560 When running covered count queries that could be aggregated independently on the shards...

Guest 9 months ago in Performance & Optimization 0 Submitted

1 VOTE

Parallelize unionWith

Today $unionWith aggregation command is executed sequentially. EG first we query collection A and then collection B and then the union occurs. The process should be parallelized so the query part will run in parallel while the union will be done a...

Guest over 1 year ago in Performance & Optimization 0 Submitted

1 VOTE

an aggregation stage to load data to DRAM for the fields that are only requested

When we use $project stage, it loads whole document from disk to memory (if not in working set). Because of this, When we create a data model, We have to create separate collection if the field is not required in frequent access of data. Creating ...

Guest about 2 years ago in Performance & Optimization 0 Submitted

1 VOTE

Avoid truncating the query on the Atlas profiler or system.profile collection

Slow running queries that are captured in system.profile collection or on profiler page of Atlas are truncated if the query is too long. As an Application DBA, it would be difficult to analyse the query without figuring out the actual query. The c...

Guest over 2 years ago in Performance & Optimization 0 Submitted

1 VOTE

throttle sessions which use too much resources

We have different types of applications : 1. Writer - to load data into mongodb from different data sources 2. Reader - to read data and display to end user. Normally, there is strict SLA for reader , but no SLA (or less restricted) for writers. ...

Guest over 2 years ago in Performance & Optimization 0 Submitted

Please enter your email address

FILTER BY CATEGORY