MongoDB – Managing Virtual Memory Usage

mongodbtop

I'm testing MongoDB for archives data. We have a collection with 160M rows.
MongoDB instance takes 76.2 Gb virtual memory on a 12 Gb physical memory box 😉
The swap in null.

I read that virtual memory = physical + swap.

What's wrong in my case ? It this a problem for mongoDB itself ?

Thanks

Best Answer

MongoDB uses memory mapped files - which can be much larger then the actual physical (or swap) available on your machine. The total virtual memory used will usually be the size of all the data on disk at the time as a result.

The resident memory will be the stat that represents the actual working set used, though depending on your resources on the box and the usage pattern this will tend to grow over time and approach the total physical RAM on the host. Basically, unless the OS sees a need to page out old data (memory pressure) it will stay in RAM.

When you restart MongoDB this basically starts again from scratch. So if you have a known time frame for your actual working data set (say you only ever use the last 7 days), then the set size after that time period (assuming regular, predictable use) will represent your approximate working set size in terms of RAM.

More info to be found in the Docs here:

http://www.mongodb.org/display/DOCS/Caching

http://www.mongodb.org/display/DOCS/Checking+Server+Memory+Usage

Finally, MMS (which is free) does a good job of mapping this out for you over time - Mapped, Virtual, Resident and non-Mapped as well as plenty of other stats (look for "i" over each graph for an explanation).

http://mms.10gen.com

Related Topic