Cache only high-usage keys in MongoDB

Question

Suppose we have a simple blog with many posts. And we regularly execute a query to get list of post's title and date from the posts collection.

So, What will cache inside of the Ram in this scenario(except indexes)? the whole document or only _ids, titles and dates?

The documentation doesn't clear this:

MongoDB keeps most recently used data in RAM. If you have created indexes for your queries and your working data set fits in RAM, MongoDB serves all queries from memory

DB version is 4.2.8.

score 3 · Accepted Answer · answered Jun 27 '20 at 10:37

3

It works as below:

Let's say you have 4 collections. Each contains 2Gig data. And each collection contain 500Mb of data in the index.

Totally: 8Gb data, 2Gb index. You query on one collection frequently and one particular query on that collection. You can assume that it keeps the data related to the query which you execute frequently in the cache. It includes data in the index and actual data related to it from the desk.

It doesn't keep the result in the index. So it keeps the whole document and the index data for the frequent query in the cache.

answered Jun 27 '20 at 10:37

Gibbs

21,904
13
74
138

So it's document-level caching? not key-level? – Amin Shojaei Jun 27 '20 at 10:57
1

Yes, Cache contains not only document information but also information from the index which used frequently. – Gibbs Jun 27 '20 at 11:12
Moreover, it keeps if that working set fits in your memory. – Gibbs Jun 27 '20 at 11:36

Cache only high-usage keys in MongoDB

1 Answers1