[SERVER-2145] Unique queries when missing in cache Created: 24/Nov/10  Updated: 30/Jun/17  Resolved: 30/Jun/17

Status: Closed
Project: Core Server
Component/s: Performance
Affects Version/s: None
Fix Version/s: None

Type: New Feature Priority: Major - P3
Reporter: ppalka Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:

 Description   

Welcome
Problem
Applications are cached query. Some queries are common and relatively long time. When the cache expires, they get to the base. In the same time many customers in cache misses, and asks the same query directly to the database.
During this time the database gets a big load, and performs the same query to multiple clients in several threads simultaneously causing a decrease database performance.

Solution
Useful to a flag (perhaps might get for queries with the flag slaveOK) which allowed the connection to the server queue which performed the same query to the query execution time. Data from this question were to be returned to all customers.

Place of Implementation
Mongos sharding or mongod for the replica set



 Comments   
Comment by Eliot Horowitz (Inactive) [ 25/Nov/10 ]

This is generally something we think is better for the app layer to do - possibly storing the data in mongo, but controlled by app.
If people really want this (votes) then perhaps something to look at.

Generated at Thu Feb 08 02:59:07 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.